CREATE TABLE IF NOT EXISTS TERMINAL_FAILURE_STATS(
 DAY BIGINT NOT NULL,
 MONITOR_ID VARCHAR(40) NOT NULL,
 MONITOR_NAME VARCHAR(32) NULL,
 DEVICE_NUMBER VARCHAR(32) NULL,
 TERMINAL_MANUFACTURER VARCHAR(20) NULL,
 ORG_NAME VARCHAR(32) NULL,
 DEVICE_TYPE INTEGER NULL,
 TERMINAL_TYPE VARCHAR(32) NULL,
 FAILURE_NUM INTEGER NULL,
 CONSTRAINT PK PRIMARY KEY (DAY,MONITOR_ID)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '终端失效统计报表'