CREATE TABLE IF NOT EXISTS MONITOR_INFO_STATS
(
 DAY BIGINT NOT NULL COMMENT '当天0点秒值',
 MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
 MONITOR_NAME VARCHAR(32) COMMENT '监控对象名称',
 PLATE_COLOR INTEGER COMMENT '车牌颜色',
 GROUP_ID VARCHAR(40) COMMENT '企业id',
 GROUP_NAME VARCHAR(32) COMMENT '企业名称',
 ACCESS_STATUS INTEGER COMMENT '入网状态 0：否 1：是',
 OPERATION INTEGER COMMENT '营运状态 0：停运 1：营运',
 UPLINE_STATUS INTEGER COMMENT '上线状态 0：不在线 1：正常',
 TRACK_TOTAL_MILE DOUBLE COMMENT '轨迹总里程',
 TRACK_TOTAL_MILE_FULL DOUBLE COMMENT '轨迹完整总里程',
 TRACK_FULL_RATE DOUBLE COMMENT '轨迹完整率',
 POSITIONAL_NUM INTEGER COMMENT '定位总数',
 POSITIONAL_PASS_NUM INTEGER COMMENT '有效定位数',
 POSITIONAL_PASS_RATE DOUBLE COMMENT '数据合格率',
 DRIFT_NUM INTEGER COMMENT '定位漂移数',
 OVER_SPEED_NUM INTEGER COMMENT '超速次数',
 FATIGUE_DURATION BIGINT COMMENT '疲劳驾驶时长（秒）',
 CONSTRAINT PK PRIMARY KEY (DAY,MONITOR_ID)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '监控对象信息统计表'