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