CREATE TABLE IF NOT EXISTS ACC_STATS_MONITOR_DAY
(
 MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
 DAY BIGINT NOT NULL COMMENT '当天0点秒值',
 MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
 ORG_NAME VARCHAR(32) NULL COMMENT '企业名称',
 GROUP_NAME VARCHAR(1000) NULL COMMENT '分组名称',
 OPEN_NUM INTEGER NULL COMMENT 'ACC开启次数',
 DURATION BIGINT NULL COMMENT '持续时长（秒）',
 MILE DOUBLE NULL COMMENT '行驶公里数（km）',
 CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '监控对象ACC统计日表'

