ㅅㄷㄴㅅ
테이블 (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)