4问题

Tables (8)

Actor

  • ActorID — INT
  • Name — VARCHAR(255)
  • Biography — TEXT

Customer

  • Key (Customer_ID) — char(30) — Primary key — NOT NULL
  • Name (Customer_Name) — char(30)
  • Address (Customer_Address) — char(30)

DVD

  • Key (DVD_ID) — char(30) — Primary key — NOT NULL
  • DVDCode — VARCHAR(10)
  • Title — VARCHAR(255)
  • Year — INT

DVDCopy

  • Key (DVDCopy_ID) — char(30) — Primary key — NOT NULL
  • CopyID — INT
  • DVDCode — VARCHAR(10)
  • PurchaseDate — DATE
  • RentalCount — INT

Director

  • DirectorID — INT
  • Name — VARCHAR(255)
  • Biography — TEXT

MovieActor

  • MovieActorID — INT
  • DVDCode — VARCHAR(10)
  • ActorID — INT

MovieDirector

  • MovieDirectorID — INT
  • DVDCode — VARCHAR(10)
  • DirectorID — INT

RentalRecord

  • RentalID — INT
  • CustomerID — INT
  • CopyID — INT
  • RentalDate — DATETIME