complaint
Tables (6)
complaints
- complaint_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('PENDING', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
- assigned_admin_id — INT
- created_at — DATETIME — NOT NULL
notices
- notice_id — INT
- admin_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
password_resets
- reset_id — INT
- user_id — INT — NOT NULL
- reset_token — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
satisfaction_surveys
- survey_id — INT
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- created_by — INT — NOT NULL
- created_at — DATETIME — NOT NULL
survey_responses
- response_id — INT
- user_id — INT — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
- submitted_at — DATETIME — NOT NULL
users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- user_type — ENUM('USER', 'ADMIN') — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL