CREATE TABLE IF NOT EXISTS ATTENDANCE_DAY
(
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 '企业名称',
GROUP_NAME VARCHAR(32) NULL COMMENT '分组名称',
SHOULD_WORK_DURATION BIGINT NULL COMMENT '应工作时长',
ACTUAL_WORK_DURATION BIGINT NULL COMMENT '实际工作时长',
TOTAL_MILE DOUBLE NULL COMMENT '总里程',
WORK_MILE DOUBLE NULL COMMENT '工作时间段里程',
ACTUAL_WORK_MILE DOUBLE NULL COMMENT '实际工作里程',
WORK_ABSENT_NUM INTEGER NULL COMMENT '上班未到岗次数',
WORK_ABSENT_DURATION BIGINT NULL COMMENT '上班未到岗时长',
WORK_LEAVE_NUM INTEGER NULL COMMENT '上班离岗次数',
WORK_LEAVE_DURATION BIGINT NULL COMMENT '上班离岗时长',
CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '出勤日表'