CREATE TABLE IF NOT EXISTS LEAVE_AREA_TIME_REPORT
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
IS_OUT INTEGER NULL COMMENT '0:表示该日期出区域 1:表示该日期未出区域',
LEAVE_AREA_TIME BIGINT NULL COMMENT '出区域时间（秒）',
CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '出区划累计时长统计表'
