alarm.ddl.sql 846 B

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