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