mapbackend_ERD
Tables (4)
genre (Untitled)
- id — INT — Primary key — NOT NULL
- 장르이름 (name) — VARCHAR(50)
member
- id — INT — Primary key — NOT NULL
- 이메일 (email) — VARCHAR(255)
- 닉네임 (name) — VARCHAR(255)
- 가입일 (join_date) — DATETIME
movie
- id — INT — Primary key — NOT NULL
- 제목 (title) — VARCHAR(255)
- 개봉일 (release_year) — INT
- 줄거리 (summary) — DATE
- 포스터 URL (poster_url) — VARCHAR(255)
- 평점 (rating) — DOUBLE
movie_genre (Untitled2)
- id (movie_id) — INT — Foreign key → movie.id — NOT NULL
- id (genre_id) — INT — Foreign key → genre.id — NOT NULL