DVD_rental
Tables (9)
Actor (Untitled8)
- actorCode (Key) — char(15) — Primary key — NOT NULL
- biography (Field) — char(30)
CopyDVD (Untitled4)
- copyCode (Key) — char(15) — Primary key — NOT NULL
- amount (Field) — int(3)
- condition (Field2) — char(10)
- location (Field3) — char(10)
Customer (Untitled)
- cusCode (Key) — char(15) — Primary key — NOT NULL
- cusName (Field) — char(15)
- cusAdr (Field2) — char(30)
- numRental (Field3) — int(5)
- overdueRecord (Field4) — char(30)
- accumMoney (Field5) — int(10)
- Phone (Field6) — char(12)
DVD (Untitled3)
- dvdCode (Key) — char(15) — Primary key — NOT NULL
- buyDate (Field) — date
- numRent (Field2) — int(5)
- location (Field3) — char(10)
- Field4
- copyCode (Key2) — char(15) — Foreign key → CopyDVD.copyCode — NOT NULL
- movieCode (Key3) — char(15) — Foreign key → Movie.movieCode — NOT NULL
- actorCode (Key22) — char(15) — Foreign key → Movie.actorCode — NOT NULL
- directorCode (Key32) — char(15) — Foreign key → Movie.directorCode — NOT NULL
Director (Untitled9)
- directorCode (Key) — char(15) — Primary key — NOT NULL
- biography (Field) — char(30)
Movie (Untitled5)
- movieCode (Key) — char(15) — Primary key — NOT NULL
- actorCode (Key2) — char(15) — Foreign key → Movie_Actor.actorCode — NOT NULL
- directorCode (Key3) — char(15) — Foreign key → Movie_Director.directorCode — NOT NULL
- name (Field) — char(20)
- year (Field2) — int(4)
- genre (Field3) — char(10)
Movie_Actor (Untitled6)
- actorCode (Key) — char(15) — Foreign key → Actor.actorCode — NOT NULL
Movie_Director (Untitled7)
- directorCode (Key) — char(15) — Foreign key → Director.directorCode — NOT NULL
Rental (Untitled2)
- rentCode (Key) — char(15) — Primary key — NOT NULL
- date (Field) — date
- time (Field2) — char(10)
- returnDate (Field3) — date
- fee (Field4) — int(5)
- dvdCode (Key3) — char(15) — Foreign key → DVD.dvdCode — NOT NULL
- cusCode (Key2) — char(15) — Foreign key → Customer.cusCode — NOT NULL
- actorCode (Key22) — char(15) — Foreign key → DVD.actorCode — NOT NULL
- directorCode (Key32) — char(15) — Foreign key → DVD.directorCode — NOT NULL