CREATE TABLE IF NOT EXISTS TRAVLLED_DISTANCE_REPORT
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
PLATE_COLOR VARCHAR(10) NULL COMMENT '车牌颜色',
MILEAGE DOUBLE NULL COMMENT '里程',
OIL_WEAR DOUBLE NULL COMMENT '油耗',
TRAVEL_TIME BIGINT NULL COMMENT '行驶时长（秒）',
TRAVEL_NUM INTEGER NULL COMMENT '行驶次数',
GROUP_NAME VARCHAR(32) NULL COMMENT '企业名称',
ASSIGNMENT_NAME VARCHAR(1000) NULL COMMENT '分组名称',
VEHICLE_TYPE VARCHAR(20) NULL COMMENT '车辆类型',

SENSOR_FLAG INTEGER NULL COMMENT '是否绑定传感器标识 0：终端 1：里程传感器',
DEVICE_MILE DOUBLE NULL COMMENT '终端里程',
DEVICE_TRAVEL_TIME BIGINT NULL COMMENT '终端行驶时长（秒）',
DEVICE_TRAVEL_NUM INTEGER NULL COMMENT '终端行驶粗俗',
SENSOR_MILE DOUBLE NULL COMMENT '传感器里程',
SENSOR_TRAVEL_TIME BIGINT NULL COMMENT '传感器行驶时长（秒）',
SENSOR_TRAVEL_NUM INTEGER NULL COMMENT '传感器行驶次数',

CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '行驶报表'
