CREATE TABLE IF NOT EXISTS GROUP_INFO_STATS
(
 DAY BIGINT NOT NULL COMMENT '当天0点秒值',
 GROUP_ID VARCHAR(40) NOT NULL COMMENT '企业id',
 MONITOR_NUM INTEGER COMMENT '监控对象数量',
 GROUP_NAME VARCHAR(32) COMMENT '企业名称',
 ACCESS_NUM INTEGER COMMENT '入网车辆数',
 UPLINE_NUM INTEGER COMMENT '上线车辆数',
 ACCESS_RATE DOUBLE COMMENT '入网率',
 UPLINE_RATE DOUBLE COMMENT '上线率',
 TRACK_FULL_RATE DOUBLE COMMENT '轨迹完整率',
 POSITIONAL_PASS_RATE DOUBLE COMMENT '数据合格率',
 DRIFT_RATE DOUBLE COMMENT '定位漂移率',
 OVER_SPEED_NUM INTEGER COMMENT '超速次数',
 FATIGUE_DURATION BIGINT COMMENT '疲劳驾驶时长（秒）',
 CONSTRAINT PK PRIMARY KEY (DAY,GROUP_ID)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '企业信息统计表'