선장과 기사

테이블 (6)

admin_replies

  • id — BIGINT
  • complaint_id — BIGINT — NOT NULL
  • admin_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

categories

  • id — INT
  • code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(50) — NOT NULL

complaints

  • id — BIGINT
  • submitter_id — BIGINT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • category_id — INT — NOT NULL
  • target_scope — ENUM('PERSONAL','ALL') — NOT NULL
  • status — ENUM('REGISTERED','IN_PROGRESS','RESOLVED','DELETED') — NOT NULL
  • votes_up — INT — NOT NULL
  • votes_down — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_category_status
  • INDEX — idx_created

lost_item_details

  • complaint_id — BIGINT
  • place — VARCHAR(100)
  • lost_at — DATETIME
  • found_status — ENUM('NOT_FOUND','FOUND') — NOT NULL

users

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • id — BIGINT
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — ENUM('STUDENT','ADMIN') — NOT NULL
  • class_name — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

votes

  • id — BIGINT
  • complaint_id — BIGINT — NOT NULL
  • voter_id — BIGINT — NOT NULL
  • value — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL