CREATE TABLE IF NOT EXISTS SCHEDULED_REPORT
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
SCHEDULED_INFO_ID VARCHAR(40) NOT NULL COMMENT '排班id',
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
MONITOR_NAME VARCHAR(64) NULL COMMENT '监控对象名称',
GROUP_NAME VARCHAR(64) NULL COMMENT '企业名称',
ASSIGNMENT_NAME VARCHAR(1000) NULL COMMENT '分组名称',
ACTUAL_WORKING_PERIOD VARCHAR(2000) NULL COMMENT '',
ACTUAL_WORKING_DURATION BIGINT NULL COMMENT '',
SHOULD_WORK_DURATION BIGINT NULL COMMENT '',
DAY_EFFECTIVE_MILEAGE DOUBLE NULL COMMENT '',
CONSTRAINT PK PRIMARY KEY (MONITOR_ID,SCHEDULED_INFO_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '排班报表'