ㅅㄷㄴㅅ

테이블 (12)

Chat

  • id — BIGINT
  • match_id — BIGINT
  • sender_id — BIGINT
  • message — TEXT
  • sent_at — DATETIME

FavoriteTheater

  • member_id — BIGINT
  • theater_id — BIGINT

Match

  • id — BIGINT
  • member_a_id — BIGINT
  • member_b_id — BIGINT
  • matched_at — DATETIME
  • evaluated — BOOLEAN

MatchEvaluation

  • id — BIGINT
  • match_id — BIGINT
  • evaluator_id — BIGINT
  • score — INT
  • comment — TEXT — EX
  • created_at — DATETIME

Member

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(50)
  • gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
  • age — INT
  • profile_image_url — VARCHAR(512)
  • intro — TEXT
  • rating_avg — FLOAT
  • created_at — DATETIME
  • is_social — BOOLEAN
  • deleted — BOOLEAN

Movie

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • genre — VARCHAR(255)
  • nation — VARCHAR(100)
  • year — INT
  • image_url — String
  • description — TEXT

MovieGenre

  • movie_id — BIGINT — 기본 키 — NOT NULL
  • genre_id — BIGINT

Review

  • id — BIGINT
  • member_id — BIGINT
  • movie_id — BIGINT
  • content — TEXT
  • rating — INT
  • created_at — DATETIME

게시글 (Post)

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • Field

선호 영화 (FavoriteMovie)

  • member_id — BIGINT — 기본 키 — NOT NULL
  • movie_id — BIGINT
  • category — ENUM('LIFETIME', 'WATCHED', 'WISHLIST')

선호장르 (MemberGenrePreference)

  • preference_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → Member.id — NOT NULL
  • movie_id — BIGINT — 외래 키 → Movie.id — NOT NULL
  • genre_id — BIGINT — 외래 키 → 장르.id — NOT NULL

장르 (Genre)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100)