CREATE TABLE IF NOT EXISTS ATTENDANCE_DETAIL
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
START_WORK_TIME BIGINT NOT NULL COMMENT '开始工作时间',
END_WORK_TIME BIGINT NULL COMMENT '结束工作时间',
MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
ORG_NAME VARCHAR(32) NULL COMMENT '企业名称',
GROUP_NAME VARCHAR(32) NULL COMMENT '分组名称',
ACTUAL_WORK_DURATION BIGINT NULL COMMENT '实际工作时长',
ACTUAL_WORK_MILE DOUBLE NULL COMMENT '实际工作里程',
CONSTRAINT PK PRIMARY KEY (MONITOR_ID,START_WORK_TIME)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '出勤明细'