2023_0328_EX04
Tables (9)
Untitled (DVD_RENT)
- Key (dvdrentID) — int(1000) — Primary key — NOT NULL
- Field (dvdrentDate) — test
- Key (dvditemId) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Key (customersID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (CUSTOMERS)
- Key (customersID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(30)
- Field (phone) — char(11)
- Field (email) — char(30)
Untitled (DVD_ITEM)
- Key (dvditemId) — int(100) — Primary key — NOT NULL
- Field (buyingdate) — date
- Field (price) — int(10)
- Field (statusLevel) — char(30)
Untitled (GENRE)
- Key (generId) — int(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description)
Untitled (PERSON)
- Key (personId) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — LONGTEXT
- Field (award) — test
Untitled (MOVIE)
- Key (movieId) — int(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (pubTear) — int(4)
- Field (pubMonth) — int(2)
- Field (description) — LONGTEST
- Field (award) — test
Untitled (MOVIE_GENRE)
- Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (generId) — int(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (CASTING)
- Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (personId) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (roleId) — int(3) — Foreign key → Untitled.Key — NOT NULL
Untitled (ROLE)
- Key (roleId) — int(3) — Primary key — NOT NULL
- Field (roletitle) — char(30)
- Field (description) — LONGTEXT