12 lines
809 B
SQL
12 lines
809 B
SQL
|
|
CREATE TABLE `ec_archive_enginedata` (
|
|
`DrawingPublishID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
|
`EngineDataID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工程数据ID',
|
|
`TagNumber` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '位号',
|
|
`ObjectTypeID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '对象类型ID',
|
|
`DataStatus` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据状态',
|
|
`SerialNumber` int NULL DEFAULT NULL COMMENT '流水号'
|
|
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工程数据表' ROW_FORMAT = DYNAMIC;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|