2023_webDB_week4_ex4
Tables (6)
Untitled (CUSTOMER)
- Key (cusNo) — int — Primary key — NOT NULL
- Field (cusName) — char(30)
- Field (address) — char(70)
Untitled (DVD)
- Key (dvdCode) — int — Primary key — NOT NULL
- Field (copyCode) — char(13)
- Field (purchaseDate) — date
- Field (rentalNo) — int
- Key (movieCode) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENTAL)
- Key (rentalDate) — date — Primary key — NOT NULL
- Field (rentalTime) — time
- Key (cusNo) — int — Foreign key → Untitled.Key — NOT NULL
- Key (movieCode) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieCode) — char(13) — Primary key — NOT NULL
- Field (title) — char(40)
- Field (movieDate) — date
- Key (actorCode) — char(13) — Foreign key → Untitled.Key — NOT NULL
- Key (directorCode) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (ACTOR)
- Key (actorCode) — char(13) — Primary key — NOT NULL
- Field (actorName) — char(30)
- Field (biography) — char(100)
Untitled (DIRECTOR)
- Key (directorCode) — char(13) — Primary key — NOT NULL
- Field (directorName) — char(30)
- Field (biography) — char(100)