CREATE SERVER fedlink_entry
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'xxx', PASSWORD 'xxx',HOST 'xxx', PORT 3306, DATABASE 'dcim4_xhbx');
DROP TABLE IF EXISTS om_on_inspection_entry;
CREATE TABLE om_on_inspection_entry (
ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
ENTRY_NAME varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工单名称',
PLAN_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '巡检计划主键',
TEMP_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '模板主键',
ROOM_ID_S json NULL COMMENT '机房主键',
USER_CONSULT json NULL COMMENT '可查看人',
ENTRY_USER_CONSULT json NULL COMMENT '可巡检人',
ENTRY_USER_ID varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实际巡检人',
PLAN_START_DATE datetime NULL DEFAULT NULL COMMENT '计划开始日期',
PLAN_END_DATE datetime NULL DEFAULT NULL COMMENT '计划结束日期',
ENTRY_START_DATE datetime NULL DEFAULT NULL COMMENT '工单开始日期',
ENTRY_END_DATE datetime NULL DEFAULT NULL COMMENT '工单结束时间',
ENTRY_STATUS char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工单状态 0未巡检 1 巡检中 2已完成 3 逾期完成 4 逾期',
RESULT_ALL int(11) NULL DEFAULT NULL COMMENT '所有内容数量',
RESULT_ABNORMAL int(11) NULL DEFAULT NULL COMMENT '异常内容数量',
RESULT_NORMAL int(11) NULL DEFAULT NULL COMMENT '正常内容数量',
RESULT_HANDLE int(11) NULL DEFAULT NULL COMMENT '已处理内容数量',
CREATE_BY varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
ACTIVE_FLAG int(11) NOT NULL,
UPDATE_BY varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
CREATE_DATE datetime NOT NULL,
UPDATE_DATE datetime NULL DEFAULT NULL,
PRIMARY KEY (ID) USING BTREE
)
ENGINE=FEDERATED
CONNECTION='fedlink_entry/om_on_inspection_entry';
创建成功后表打不开
