학생 민원/고충 관리 시스템

테이블 (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