CREATE TABLE IF NOT EXISTS WORKING_REPORT
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
ORG_NAME VARCHAR(32) NULL COMMENT '所属企业名称',
WORK_TIME_ONE BIGINT NULL COMMENT '1#工作时长（秒）',
STOP_TIME_ONE BIGINT NULL COMMENT '1#待机时长（秒）',
AWAIT_TIME_ONE BIGINT NULL COMMENT '1#停机时长（秒）',
STOP_MOVE_TIME_ONE BIGINT NULL COMMENT '1#熄火移动时长（秒）',
WORK_TIME_TWO BIGINT NULL COMMENT '2#工作时长（秒）',
STOP_TIME_TWO BIGINT NULL COMMENT '2#待机时长（秒）',
AWAIT_TIME_TWO BIGINT NULL COMMENT '2#停机时长（秒）',
STOP_MOVE_TIME_TWO BIGINT NULL COMMENT '2#熄火移动时长（秒）',
CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '工时报表'
