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