example4
Tables (8)
Untitled (DVD Information)
- Key (DVDcode) — int(10) — Primary key — NOT NULL
- Field (purchaseDate) — date
- Field (rentalCount) — int(3)
- Key (movieID) — int6) — Foreign key → Untitled.Key — NOT NULL
Untitled (Movie)
- Key (movieID) — int6) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (title_en) — char(30)
- Field (productionYear) — char(4)
- Field (description) — text
- Field (ageClassification) — char(3)
- Field (genre) — char(3)
Untitled (Actor)
- Key (actorID) — int(6) — Primary key — NOT NULL
- Field (name) — int(30)
- Field (biography) — text
Untitled (Director)
- Key (diretorID) — int(6) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (biography) — text
Untitled (Production)
- Key (actorID) — int(6) — Foreign key → Untitled.Key — NOT NULL
- Key (movieID) — int6) — Foreign key → Untitled.Key — NOT NULL
Untitled (DirectorProduction)
- Key (diretorID) — int(6) — Foreign key → Untitled.Key — NOT NULL
- Key (movieID) — int6) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (Rental)
- Key (rentalNo) — int(10) — Primary key — NOT NULL
- Key (ID) — int(10) — Foreign key → client.Key — NOT NULL
- Key (DVDcode) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (date) — date
- Field (time) — char(5)
client (Client)
- Key (ID) — int(10) — Primary key — NOT NULL
- Field (name) — char(5)
- Field (address) — char(30)
- Field (tel) — int(9)