movie
Tables (4)
genre (Untitled3)
- genre_id (Field) — BIGINT — Primary key
- genre_name (Field2) — VARCHAR
member (Untitled2)
- member_id (Field) — BIGINT — Primary key
- member_name (Field2) — VARCHAR
- email (Field3) — VARCHAR
- joined_at (Field4) — DATETIME
movie (Untitled)
- movie_id (Field) — BIGINT — Primary key
- member_id (Field5) — BIGINT — Foreign key → member.member_id
- movie_title (Field2) — VARCHAR(200)
- movie_genre (Field3) — VARCHAR
- movie_release_date (Field4) — DATE
- overview (Field6) — TEXT
- poster_url (Field7) — VARCHAR(500)
- rating (Field8) — DECIMAL
movie_genre (Untitled4)
- genre_id (Field2) — BIGINT — Foreign key → genre.genre_id
- movie_id (Field) — BIGINT — Foreign key → movie.movie_id
- member_id (Field5) — BIGINT — Foreign key → movie.member_id