학생 민원/고충 관리 시스템
테이블 (5)
Admin
- admin_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — ENUM('학생회','선생님') — NOT NULL
- password — VARCHAR(255) — NOT NULL
AdminResponse
- response_id — INT — 기본 키 — NOT NULL
- admin_id — INT — NOT NULL
- complaint_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
Complaint
- complaint_id — INT — 기본 키 — NOT NULL
- student_id (student_id2) — INT — 외래 키 → Student.student_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- category — ENUM('생활','시설','학사') — NOT NULL
- is_anonymous — BOOLEAN — NOT NULL
- status — ENUM('등록','처리중','완료','삭제') — NOT NULL
- upvote_count — INT — NOT NULL
- downvote_count — INT — NOT NULL
- score — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Student
- student_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- student_number — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
Vote
- vote_id — INT — 기본 키 — NOT NULL
- complaint_id — INT — NOT NULL
- student_id — INT — NOT NULL
- vote_type — ENUM('추천','비추') — NOT NULL
- created_at — DATETIME — NOT NULL