CREATE TABLE IF NOT EXISTS VIDEO_POLLING_STATS
(
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
MONITOR_NAME VARCHAR(32) NULL COMMENT '监控对象名称',
PLATE_COLOR INTEGER NULL COMMENT '车牌颜色',
MONITOR_TYPE VARCHAR(10) NULL COMMENT '监控对象类型',
GROUP_NAME VARCHAR(32) NULL COMMENT '企业名称',
TOTAL BIGINT NULL COMMENT '巡检总数',
SUCCESS BIGINT NULL COMMENT '成功总数',
CONSTRAINT PK PRIMARY KEY (DAY,MONITOR_ID)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '视频巡检统计表'