2023_webDB_ex4
Tables (6)
Untitled (CUSTOMER)
- Key (customerNo) — char(20) — Primary key — NOT NULL
- Field (customerName) — char(20)
- Field (cutomerAddress) — char(50)
- Field (cutomerPhone) — char(20)
Untitled (DVD)
- Key (dvdNo) — char(30) — Primary key — NOT NULL
- Field (copy) — int
- Field (borrowingTime) — time
- Field (borrowingPeriod) — date
- Field (borrowingNumber) — int
- Key (movieNo) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (customerNo) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieNo) — char(20) — Primary key — NOT NULL
- Field (movieTitle) — char(50)
- Field (movieProduction) — int(4)
- Field (movieRelease) — date
Untitled (MOVIE_DIRECTOR)
- Key (directorNo) — char(20) — Primary key — NOT NULL
- Field (directorName) — char(30)
- Field (directorBio) — text
Untitled (MOVIE_ACTOR)
- Key (actorNo) — char(20) — Primary key — NOT NULL
- Field (actorName) — char(30)
- Field (actorBio) — text
Untitled (MOVIE_WORK)
- Key (directorNo) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (actorNo) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (movieNo) — char(20) — Foreign key → Untitled.Key — NOT NULL