CREATE TABLE IF NOT EXISTS ISSUE_MESSAGE_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 '企业名称',
SUCCESS BIGINT NULL COMMENT '成功条数',
FAIL BIGINT NULL COMMENT '失败条数',
MANUAL_ISSUE_SUCCESS BIGINT NULL COMMENT '人工成功条数',
MANUAL_ISSUE_FAIL BIGINT NULL COMMENT '人工失败条数',
SYSTEM_ISSUE_SUCCESS BIGINT NULL COMMENT '系统成功条数',
SYSTEM_ISSUE_FAIL BIGINT NULL COMMENT '系统失败天搜狐',
TOTAL BIGINT NULL COMMENT '总数',
CONSTRAINT PK PRIMARY KEY (DAY,MONITOR_ID)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '消息下发统计表'
