movie

Tables (6)

Actor

  • actor_id — INT — Primary key — NOT NULL
  • fname — VARCHAR(100)
  • lname — VARCHAR(100)
  • dob — VARCHAR(100)
  • gender — VARCHAR(100)
  • award_id — VARCHAR(100) — Foreign key → Award.award_id

Award

  • award_id — INT — Primary key — NOT NULL
  • award_name — VARCHAR(100)

Movie

  • movie_id — INT — Primary key — NOT NULL
  • producer_id — INT — Foreign key → Producer.producer_id — NOT NULL
  • actor_id — INT — Foreign key → Actor.actor_id — NOT NULL
  • title — VARCHAR(100)
  • award_id — VARCHAR(100) — Foreign key → Award.award_id

Producer

  • producer_id — INT — Primary key — NOT NULL
  • producer_name — VARCHAR(100)

Sequel

  • sequel_id — INT — Primary key — NOT NULL
  • movie_id — INT — Foreign key → Movie.movie_id — NOT NULL
  • sequel_state — INT

Studio

  • studio_id — INT — Primary key — NOT NULL
  • producer_id — VARCHAR(100) — Foreign key → Producer.producer_id — NOT NULL
  • name — VARCHAR(100)
  • phone — VARCHAR(100)