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