CREATE TABLE IF NOT EXISTS TIRE_ORG_DAY
(
ORG_ID VARCHAR(40) NOT NULL COMMENT '企业id',
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
ORG_NAME VARCHAR(32) COMMENT '企业名称',
CNT_SUM INTEGER COMMENT '疲劳驾驶报警总数',
CNT_DAY INTEGER COMMENT '白天疲劳驾驶报警总数',
CNT_NIGHT INTEGER COMMENT '夜晚疲劳驾驶报警总数',
CNT_ACC INTEGER COMMENT '24小时累计疲劳驾驶报警总数',
CNT_MONITOR INTEGER COMMENT '报警监控对象数量',
TIRE_TIME BIGINT COMMENT '疲劳驾驶时长（毫秒）',
CONSTRAINT PK PRIMARY KEY (ORG_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '企业疲劳驾驶统计日表'