Movie
Tables (4)
genre (장르)
- genre_id (장르ID) — BIGIMT — Primary key
- name (장르명) — VARCHAR(50)
member (회원)
- member_id (회원 고유번호) — BINGINT — Primary key
- email (이메일) — VARCHAR(100)
- nickname (닉네임) — VARCHAR(50)
- create_at (가입일) — DATE
movie (영화)
- movie_id (영화ID) — BIGINT — Primary key
- overview (줄거리) — TEXT
- poster_url (포그터URL) — VARCHAR(1000)
- title (영화 제목) — VARCHAR(200
- rating (평점) — DECIMAL(3,1)
- release_date (개봉일) — DATE
movie_genre (영화_장르)
- movie_genre_id (매핑고유번호) — BIGINT — Primary key
- genre_id (장르ID) — BIGIMT — Foreign key → genre.genre_id
- movie_id (영화ID2) — BIGINT — Foreign key → movie.movie_id