moviemates

Tables (4)

movies

  • id (Key) — Long — Primary key — NOT NULL
  • title — VARCHAR(40)
  • release_date — DATE
  • genre — VARCHAR(40)
  • duration — int
  • review_rating — VARCHAR(40)
  • director — VARCHAR(40)

posters

  • id — Long — Primary key — NOT NULL
  • movie_id — Long
  • image_url — VARCHAR(200)
  • upload_date — DATE

schedules

  • id — Long — Primary key — NOT NULL
  • movie_Id (movie_id) — Long
  • theater_id — Long
  • show_date — DATE
  • show_time — TIME

theaters

  • id — Long — Primary key — NOT NULL
  • name — VARCHAR(40)
  • location — VARCHAR(40)
  • capacity — int