CREATE TABLE IF NOT EXISTS LINE_DEVIATE_MONITOR_DAY
(
 MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
 DAY BIGINT NOT NULL COMMENT '当天0点秒值',
 MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
 ORG_ID VARCHAR(40) NULL COMMENT '企业id',
 ORG_NAME VARCHAR(32) NULL COMMENT '企业名称',
 PLATE_COLOR INTEGER NULL COMMENT '车牌颜色',
 VEHICLE_TYPE VARCHAR(20) NULL COMMENT '车辆类型',
 CNT_DEVIATE INTEGER NULL COMMENT '路线偏离报警数',
 CNT_FOLLOW INTEGER NULL COMMENT '不按规定线路运行报警数',
 CNT_SUM INTEGER NULL COMMENT '报警总数',
 CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '监控对象路线偏离统计日表'