bemac_alarm_system

Tables (7)

alarm

  • id (Key) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — DATETIME
  • end_at — DATETIME — NOT NULL
  • created_by — BIGINT — NOT NULL
  • update_at — DATETIME
  • delete_status — CHAR

alarm_department

  • id (Key) — BIGINT — Primary key — NOT NULL
  • department_id (Key3) — BIGINT — Foreign key → department.id — NOT NULL
  • alarm_id (Key2) — BIGINT — Foreign key → alarm.id — NOT NULL
  • created_at — DATETIME

alarm_log

  • id (Key2) — Primary key — NOT NULL
  • alarm_id — BIGINT — Foreign key → alarm.id — NOT NULL
  • alarm_type — ENUM('ONE_DAY', 'THREE_DAYS', 'SEVEN_DAYS', 'ONE_MONTH') — NOT NULL
  • sent_status — ENUM('SUCCESS', 'FAILED') — NOT NULL
  • error_message — TEXT
  • sent_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

alarm_responsible

  • id (Key) — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(100)
  • created_at — DATETIME
  • user_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
  • alarm_id (Key3) — BIGINT — Foreign key → alarm.id — NOT NULL

alarm_user

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
  • alarm_id (Key2) — BIGINT — Foreign key → alarm.id — NOT NULL
  • read_flag — BOOLEAN
  • read_at — DATETIME
  • sent_at — DATETIME

department

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME

user

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • department_id — BIGINT — Foreign key → department.id — NOT NULL
  • created_at — DATETIME
  • delete_status — CHAR