CREATE TABLE IF NOT EXISTS MILEAGE_STATISTIC
(
   MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
   DAY BIGINT NOT NULL COMMENT '当天0点秒值',
   MILEAGE DOUBLE NULL COMMENT '传感器里程',
   SENSOR_FLAG INTEGER NULL COMMENT '是否绑定传感器标识 0：终端 1：里程传感器',
   MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
   GROUP_NAME VARCHAR(32) NULL COMMENT '企业名称',
   GPS_MILE DOUBLE NULL COMMENT '终端里程',
   OIL_TANK DOUBLE NULL COMMENT '油量',
   FUEL_AMOUNT DOUBLE NULL COMMENT '加油量',
   FUEL_SPILL DOUBLE NULL COMMENT '漏油量',
   START_TIME BIGINT COMMENT '开始时间（秒）',
   START_LON DOUBLE COMMENT '开始经度',
   START_LAT DOUBLE COMMENT '开始纬度',
   END_TIME BIGINT COMMENT '结束时间（秒）',
   END_LON DOUBLE COMMENT '结束经度',
   END_LAT DOUBLE COMMENT '结束纬度',

   CONSTRAINT PK PRIMARY KEY(MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '里程统计报表'
