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