PickFlo

Tables (3)

movies

  • movie_id — INT — NOT NULL
  • movie_code — INT — NOT NULL
  • movie_title — VARCHAR(100) — NOT NULL
  • movie_overview — VARCHAR(3000)
  • movie_rating — DECIMAL(4, 2) — NOT NULL
  • movie_release_date — DATE — NOT NULL
  • movie_runtime — INT — NOT NULL
  • movie_img — VARCHAR(1000)

movies_people

  • movie_person_job — VARCHAR(10) — Primary key — NOT NULL
  • movie_id — INT — Foreign key → movies.movie_id — NOT NULL
  • person_id — INT — Foreign key → people.person_id — NOT NULL

people

  • person_id — INT
  • person_name — VARCHAR(30) — NOT NULL