movie
Tables (4)
genre (장르)
- genre_id (장르ID) — BIGINT — Primary key — NOT NULL
- naem (장르명) — CARCHAR(50)
member (회원)
- member_id (회원 고유번호) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(100)
- nickname (닉네임) — VARCHAR(50)
- created_at (가입일) — DATE
movie (영화)
- movie_id (영화ID) — BIGINT — Primary key — NOT NULL
- title (영화제목) — VARCHAR(255)
- release_date (개봉일) — DATE
- summary (줄거리) — TEXT
- poster_url (포스터URL) — VARCHAR(2083)
- rating (평점) — DECIMAL(3,2)
movie_genre (영화_장르)
- movie_genre_id (매핑고유번호) — BIGINT — Primary key — NOT NULL
- movie_id (영화ID) — INT — Foreign key → movie.movie_id — NOT NULL
- genre_id (Key) — Foreign key → genre.genre_id — NOT NULL