use `clbs`;
--能耗统计月表
CREATE TABLE IF NOT EXISTS OBD_MILE_OIL_MONTH
(
 MONTH BIGINT NOT NULL,
 MONITOR_ID VARCHAR(40) NOT NULL,
 MONITOR_NAME VARCHAR(32) NULL,
 ORG_NAME VARCHAR(32) NULL,
 MILE DOUBLE NULL,
 OIL_WEAR DOUBLE NULL,
 OIL_WEAR_HUNDRED DOUBLE NULL,
 UREA_WEAR DOUBLE NULL,
 UREA_OIL_WEAR DOUBLE NULL,
 TRAVEL_DAY INTEGER NULL,
 MAX_MILE DOUBLE NULL,
 CONSTRAINT PK PRIMARY KEY (MONTH,MONITOR_ID)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT 'OBD里程油耗统计月表';
