2024_10_15_2
Tables (6)
Untitled (MEMBER)
- Key (memID) — char(20) — Primary key — NOT NULL
- Field (memName) — char(30)
- Field (address) — char(30)
- Field
Untitled (DVD)
- Key (dvdID) — char(20) — Primary key — NOT NULL
- Field (buyDate) — date
- Key (movID) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movID) — char(20) — Primary key — NOT NULL
- Field (movName) — char(30)
- Field (movDate) — date
- Key (dirID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (actID) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (ACTOR)
- Key (actID) — char(20) — Primary key — NOT NULL
- Field (actName) — char(30)
- Field (actBiog) — text
Untitled (DIRECTOR)
- Key (dirID) — char(20) — Primary key — NOT NULL
- Field (dirName) — char(30)
- Field (dirBiog) — text
Untitled (RENT)
- Key (dvdID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (memID) — char(20) — Foreign key → Untitled.Key — NOT NULL