alarm.ddl.sql 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  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 '报警记录表';
  31. # 报警状态表(放数据字典)
  32. -- create table alarm_status
  33. -- (
  34. -- id varchar(40) not null primary key,
  35. -- status_code varchar(40) not null ,
  36. -- recover_time timestamp ,
  37. -- remark varchar(500)
  38. -- );