CREATE TABLE IF NOT EXISTS PLAT_CONNECT_STATS_DAY
(
 DAY BIGINT NOT NULL COMMENT '当天0点秒值',
 PLATFORM_ID VARCHAR(40) NOT NULL COMMENT '平台id',
 LINK_TYPE INTEGER NOT NULL COMMENT '链路连接类型 1：主链路 2：从链路',
 PLATFORM_NAME VARCHAR(32) NULL COMMENT '平台名称',
 CREATE_TIME BIGINT NULL COMMENT '平台创建时间',
 ONLINE_DURATION INTEGER NULL COMMENT '在线时长',
 INTERRUPT_NUM INTEGER NULL COMMENT '中断次数',
 INTERRUPT_DURATION INTEGER NULL COMMENT '中断时长',
 ONLINE_RATE DOUBLE NULL COMMENT '在线率',
 CONSTRAINT PK PRIMARY KEY (DAY,PLATFORM_ID,LINK_TYPE)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '平台连接统计日表'