movie 3안(시청여부삭제)
테이블 (3)
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
- genre — VARCHAR(100)
- release_date — DATE
- director — VARCHAR(255)
- duration — INT
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