fdfdfdf
Tables (5)
ApprovalLine
- approval_line_id — INT
- complaint_id — INT — NOT NULL
- approver_id — INT — NOT NULL
- step_order — INT — NOT NULL
- status — ENUM('대기', '반려', '승인')
- comment — TEXT — EX
- updated_at — DATETIME
Complaint
- complaint_id — INT
- user_id — INT — NOT NULL
- department_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- status — ENUM('접수전', '처리중', '반려', '처리완료')
- created_at — DATETIME
- updated_at — DATETIME
ComplaintHistory
- history_id — INT
- complaint_id — INT — NOT NULL
- handler_id — INT — NOT NULL
- action — ENUM('접수', '상신', '반려', '결재') — NOT NULL
- timestamp — DATETIME
- note — TEXT
Department
- department_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
User
- user_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('민원인', '1차담당자', '2차담당자', '최종결재자', '직원') — NOT NULL