CREATE TABLE IF NOT EXISTS WORKING_DETAIL
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
START_TIME BIGINT NOT NULL COMMENT '状态开始时间(秒)',
SENSOR_SEQ INTEGER NOT NULL COMMENT '传感器顺序',
WORK_STATUS INTEGER NOT NULL COMMENT '工作状态',
MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
END_TIME BIGINT NULL COMMENT '状态结束时间(秒)',
DURATION BIGINT NULL COMMENT '状态持续时长(秒)',
CONSTRAINT PK PRIMARY KEY (MONITOR_ID,START_TIME,SENSOR_SEQ,WORK_STATUS)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '工时报表'
