exercise4
Tables (8)
Actors
- ActorID — INT — Primary key
- Name — VARCHAR(255) — NOT NULL
- Biography — TEXT
Customers
- CustomerID — INT — Primary key
- Name — VARCHAR(255) — NOT NULL
- Address — TEXT
Directors
- DirectorID — INT — Primary key
- Name — VARCHAR(255) — NOT NULL
- Biography — TEXT
MovieActors
- MovieID (MovieID2) — INT — Foreign key → Movies.MovieID
- ActorID (ActorID2) — INT — Foreign key → Actors.ActorID
MovieCopies
- CopyID — INT — Primary key
- MovieID (MovieID2) — INT — Foreign key → Movies.MovieID
- PurchaseDate — DATE
- RentalCount — INT
MovieDirectors
- MovieID (MovieID2) — INT — Foreign key → Movies.MovieID
- DirectorID (DirectorID2) — INT — Foreign key → Directors.DirectorID
Movies
- MovieID — INT — Primary key
- Title — VARCHAR(255) — NOT NULL
- ProductionYear — INT
Rentals
- RentalID — INT — Primary key
- CustomerID (CustomerID2) — INT — Foreign key → Customers.CustomerID
- CopyID (CopyID2) — INT — Foreign key → MovieCopies.CopyID
- MovieID (MovieID2) — INT — Foreign key → MovieCopies.MovieID
- RentalDateTime — DATETIME