CREATE TABLE IF NOT EXISTS INTEGRATED_STATISTICS
(
   MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
   DAY BIGINT NOT NULL COMMENT '当天0点秒值',
   PLATE_NUMBER VARCHAR(32) NULL COMMENT '监控对象名称',
   GPS_MILE DOUBLE NULL COMMENT '终端里程',
   TRAVEL_TIME BIGINT NULL COMMENT '行驶时长',
   DOWN_TIME BIGINT NULL COMMENT '怠速时长',
   OVER_SPEED_TIMES BIGINT NULL COMMENT '超速时长',
   TRAVEL_TIMES BIGINT NULL COMMENT '行驶次数',
   ALARM_TIMES BIGINT NULL COMMENT '报警次数',
   NIGHT_TRAVEL_MILE DOUBLE NULL COMMENT '夜间行驶里程',
   FIRST_DATA_TIME VARCHAR(10000) NULL COMMENT '第一上线时间',
   ONLINE_DURATION BIGINT NULL COMMENT '在线时长',
   ONLINE_COUNT INTEGER NULL COMMENT '在线次数',
   TRAVEL_MILE DOUBLE NULL COMMENT '行驶里程',
   DOWN_MILE DOUBLE NULL COMMENT '怠速里程',
   DOWN_TIMES BIGINT NULL COMMENT '怠速次数',

   SENSOR_FLAG INTEGER NULL COMMENT '是否绑定传感器标识 0：终端 1：里程传感器',
   DEVICE_MILE DOUBLE NULL COMMENT '终端里程',
   DEVICE_TRAVEL_MILE DOUBLE NULL COMMENT '终端行驶里程',
   DEVICE_TRAVEL_TIME BIGINT NULL COMMENT '终端行驶时长',
   DEVICE_TRAVEL_TIMES BIGINT NULL COMMENT '终端行驶次数',
   DEVICE_DOWN_MILE DOUBLE NULL COMMENT '终端怠速里程',
   DEVICE_DOWN_TIME BIGINT NULL COMMENT '终端怠速时长',
   DEVICE_DOWN_TIMES BIGINT NULL COMMENT '终端怠速次数',
   SENSOR_MILE DOUBLE NULL COMMENT '传感器里程',
   SENSOR_TRAVEL_MILE DOUBLE NULL COMMENT '传感器行驶里程',
   SENSOR_TRAVEL_TIME BIGINT NULL COMMENT '传感器行驶时长',
   SENSOR_TRAVEL_TIMES BIGINT NULL COMMENT '传感器行驶次数',
   SENSOR_DOWN_MILE DOUBLE NULL COMMENT '传感器怠速里程',
   SENSOR_DOWN_TIME BIGINT NULL COMMENT '传感器怠速时长',
   SENSOR_DOWN_TIMES BIGINT NULL COMMENT '传感器怠速次数',

   CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '监控对象ACC统计日表'
