iailab-module-data/iailab-module-data-biz/db/mysql/tenant.sql

@@ -402,10 +402,10 @@

CREATE TABLE t_da_point_collect_status(
                           `id` VARCHAR(36) NOT NULL  COMMENT 'ID' ,
                           `point_id` VARCHAR(36) NOT NULL   COMMENT '测点ID',
                           `collect_value` VARCHAR(36)   COMMENT '采集值',
                           `collect_quality` VARCHAR(36)   COMMENT '采集质量',
                           `point_no` VARCHAR(36) NOT NULL   COMMENT '测点编码',
                           `collect_value` VARCHAR(24)   COMMENT '采集值',
                           `collect_quality` VARCHAR(5)   COMMENT '采集质量',
                           `collect_time` DATETIME   COMMENT '采集时间' ,
                           PRIMARY KEY (id) USING BTREE,
                           UNIQUE KEY `uk_point_id` (`point_id`) USING BTREE
                           UNIQUE KEY `uk_point_no` (`point_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT = '测点采集状态表';