CREATE TABLE IF NOT EXISTS ALARM_INFO_REPORT
(
MONITOR_ID VARCHAR(40) NOT NULL COMMENT '监控对象id',
DAY BIGINT NOT NULL COMMENT '当天0点秒值',
ALARM_TYPE INTEGER NOT NULL COMMENT '报警类型',
MONITOR_NAME VARCHAR(32) NOT NULL COMMENT '监控对象名称',
GROUP_NAME VARCHAR(1000) NULL COMMENT '分组名称',
EMPLOYEE VARCHAR(64) NULL COMMENT '从业人员名称',
PLATE_COLOR VARCHAR(10) NULL COMMENT '车牌颜色',
MONITOR_TYPE VARCHAR(10) NULL COMMENT '监控对象类型',
ALARM_NUM INTEGER NULL COMMENT '报警数量',
MIN_SPEED DOUBLE NULL COMMENT '最小速度',
MAX_SPEED DOUBLE NULL COMMENT '最大速度',
TOTAL_SPEED DOUBLE NULL COMMENT '总速度',
TOTAL_NUM INTEGER NULL COMMENT '设置总记录数',
ALARM_START_TIME BIGINT NULL COMMENT '报警开始时间',
ALARM_START_LOCATION VARCHAR(64) NULL COMMENT '报警开始位置',
ALARM_START_SPEED DOUBLE NULL COMMENT '报警开始速度',
ALARM_END_TIME BIGINT NULL COMMENT '报警结束时间',
ALARM_END_LOCATION VARCHAR(64) NULL COMMENT '报警结束位置',
ALARM_END_SPEED DOUBLE NULL COMMENT '报警结束速度',
DURATION BIGINT NULL COMMENT '报警持续时长（毫秒）',
ALARM_SOURCE VARCHAR(20) NULL COMMENT '报警来源',
PART_NUM INTEGER NULL COMMENT '局部报警数量',
GLOBAL_NUM INTEGER NULL COMMENT '全局报警数量',
PROCESSED_NUM INTEGER NULL COMMENT '已处理报警数量',
CONSTRAINT PK PRIMARY KEY (MONITOR_ID,DAY,ALARM_TYPE,MONITOR_NAME)
)
ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci
ROW_FORMAT = Dynamic
COMMENT '报警信息统计表'

