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)