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