gaia/资源文件/sql/pro_econ_testing_point.sql

create table pro_econ_testing_point
(
    id                    varchar(20)
        constraint pro_econ_testing_point_pk
            primary key,
    code                  varchar(60),
    name                  varchar(250),
    model                 varchar(30),
    type_id               varchar(30),
    original_uniform_code varchar(30),
    uniform_code          varchar(30),
    ucv1                  varchar(30),
    ucv2                  varchar(30),
    ucv3                  varchar(30),
    thing_id              varchar(30),
    thing_type            varchar(30),
    data_type             varchar(30),
    station_id            varchar(30),
    logical_unit_id       varchar(30),
    is_display            boolean,
    spare                 varchar(60)
);

comment on table pro_econ_testing_point is '逻辑测点';

comment on column pro_econ_testing_point.code is '测点';

comment on column pro_econ_testing_point.name is '描述';

comment on column pro_econ_testing_point.model is '机型';

comment on column pro_econ_testing_point.original_uniform_code is '原始统一编码';

comment on column pro_econ_testing_point.uniform_code is '统一编码';

comment on column pro_econ_testing_point.ucv1 is '统一编码备用';

comment on column pro_econ_testing_point.thing_id is '设备id';

comment on column pro_econ_testing_point.thing_type is '场站，风机，部件';

comment on column pro_econ_testing_point.data_type is '数据类型';

comment on column pro_econ_testing_point.station_id is '场站';

comment on column pro_econ_testing_point.logical_unit_id is '部件编号';