report_ddl_sql.md 806 B

报警信息报表 report_alarm_record

CREATE TABLE `report_alarm_record` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `item_code` varchar(40) NOT NULL COMMENT '报警条目编码',
  `project_id` varchar(50) NOT NULL DEFAULT '' COMMENT '项目id',
  `category` varchar(80) NOT NULL COMMENT '报警分类',
  `obj_id` varchar(50) NOT NULL DEFAULT '' COMMENT '对象id',
  `class_code` varchar(50) NOT NULL COMMENT '对象类型编码',
  `level` varchar(10) NOT NULL COMMENT '严重程度',
  `state` int NOT NULL COMMENT '报警状态',
  `create_time` varchar(8) NOT NULL COMMENT '创建时间',
  `count` int DEFAULT '0' COMMENT '数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4096 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='报警信息报表';