4
Tables (7)
Untitled (actor)
- Key (actorCode) — int(3) — Primary key — NOT NULL
- Key (moviecode) — char(6) — Foreign key → movie.Key — NOT NULL
- Field (movieCode) — char(6)
- Field (name) — char(20)
- Field (biography) — longtext
Untitled (director)
- Key (directorCode) — int(3) — Primary key — NOT NULL
- Key (moviecode) — char(6) — Foreign key → movie.Key — NOT NULL
- Field (movieCode) — char(6)
- Field (name) — char(20)
- Field (biography) — longtext
Untitled (dvd)
- Key (dvID) — int(1000) — Primary key — NOT NULL
- Field (dvdcopycode) — int(1000)
- Field (purchasedate) — date
- Field (renttimenumber) — int(100)
- Key (moviecode) — char(6) — Foreign key → movie.Key — NOT NULL
Untitled (customer)
- Key (custID) — char(15) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(20)
- Field (phone) — char(15)
Untitled (rent)
- Key (rentdate) — date — Primary key — NOT NULL
- Field (renttime) — int(5)
- Key (dvID) — int(1000) — Foreign key → Untitled.Key — NOT NULL
- Key (custID) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Key (managerID) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (manager)
- Key (managerID) — char(5) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (phone) — int(12)
movie
- Key (moviecode) — char(6) — Primary key — NOT NULL
- Field (title) — char(20)
- Field (yearmade) — char(4)