movie 4안(장르테이블추가)
테이블 (5)
Genre
- genre_id — INT — 기본 키
- genre_name — VARCHAR(100) — NOT NULL
Member
- user_id — INT — 기본 키
- username — VARCHAR(100) — NOT NULL
- role — VARCHAR(50)
- created_at — TIMESTAMP
- last_login — TIMESTAMP
- email — VARCHAR(255)
Movie
- movie_id — INT — 기본 키
- title — VARCHAR(255) — NOT NULL
- release_date — DATE
- director — VARCHAR(255)
- duration — INT
Movie_Genre
- movie_genre_id — INT — 기본 키
- movie_id — INT — 외래 키 → Movie.movie_id
- genre_id — INT — 외래 키 → Genre.genre_id
Review
- review_id — INT — 기본 키
- movie_id — INT — 외래 키 → Movie.movie_id
- user_id — INT — 외래 키 → Member.user_id
- rating — DECIMAL(2, 1)
- comment — TEXT — EX
- review_date — TIMESTAMP