DVD Store
Tables (9)
Cast (Untitled6)
- castID (Key) — int — Primary key — NOT NULL
- biography (Field) — char(200)
Copy Of DVD (CopyOfUntitled2)
- dvdID (Key2) — int — Foreign key → DVD.dvdID — NOT NULL
Customer (Untitled)
- customerID (Key) — int — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(100)
DVD (Untitled2)
- dvdID (Key) — int — Primary key — NOT NULL
- movieID (Field) — int
- boughtDate (Field2) — date
- amountRental (Field3) — int
Director (CopyOfUntitled6)
- directorID (Key) — int — Primary key — NOT NULL
- biography (Field) — char(200)
Movie (Untitled3)
- moiveID (Key) — int — Primary key — NOT NULL
- dvdID (Key2) — int — Foreign key → DVD.dvdID — NOT NULL
- title (Field2) — char(10)
- published (Field) — int
- casts (Field3) — int
- directors (Field4) — int
MovieCast (Untitled4)
- castID (Key) — int — Foreign key → Cast.castID — NOT NULL
- moiveID (Key2) — int — Foreign key → Movie.moiveID — NOT NULL
- dvdID (Key22) — int — Foreign key → Movie.dvdID — NOT NULL
MovieDirector (CopyOfUntitled4)
- directorID (Key3) — int — Foreign key → Director.directorID — NOT NULL
- moiveID (Key) — int — Foreign key → Movie.moiveID — NOT NULL
- dvdID (Key2) — int — Foreign key → Movie.dvdID — NOT NULL
Rental (Untitled5)
- rentID (Key3) — int — Primary key — NOT NULL
- customerID (Key) — int — Foreign key → Customer.customerID — NOT NULL
- dvdID (Key2) — int — Foreign key → DVD.dvdID — NOT NULL
- rentalDate (Field) — date
- time (Field2) — date