alarm.ddl.sql 922 B

123456789101112131415161718192021222324252627282930313233
  1. ## 报警系统数据表
  2. # 报警条目表
  3. DROP TABLE IF EXISTS `alarm_item`;
  4. create table alarm_item
  5. (
  6. id varchar(40) not null primary key,
  7. code varchar(40) not null,
  8. name varchar(255) null,
  9. project_id varchar(40) null,
  10. alarm_category varchar(100) null,
  11. level varchar(40) null,
  12. valid int null,
  13. create_user varchar(40) null,
  14. create_time timestamp null,
  15. update_user varchar(40) null,
  16. update_time timestamp null,
  17. remark varchar(500) null
  18. ) comment '报警条目表';
  19. # 报警记录表
  20. DROP TABLE IF EXISTS `alarm_record`;
  21. create table alarm_record
  22. (
  23. id varchar(40) not null primary key,
  24. code varchar(40) null,
  25. project_id varchar(50) null,
  26. object_id varchar(50) null,
  27. level varchar(10) null,
  28. status varchar(50) null,
  29. create_time varchar(14) null,
  30. recover_time varchar(14) null,
  31. remark varchar(500) null
  32. ) comment '报警记录表';