ex4-DVDshop
Tables (9)
Untitled (MOVIE)
- Key (mivie id) — int(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (pub Year) — int4)
- Field (pubMonth) — int(2)
- Field (description) — LONGTEXT
- Field (award) — LONGTEXT
Untitled (MOVIE GENRE)
- Key (mivie id) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (genreid) — int(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (DVDITEM)
- Key (itemid) — int(100) — Primary key — NOT NULL
- Field (buyingdate) — date
- Field (price) — int(10)
- Field (statuslevel) — char(1)
- Key (mivie id) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (casting)
- Key (mivie id) — INT(10) — Foreign key → Untitled.Key — NOT NULL
- Key (personid) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (roleid) — int(3) — Foreign key → Untitled.Key — NOT NULL
- Field (description) — text
Untitled (rent)
- Key (rentid) — int(1000) — Primary key — NOT NULL
- Field (rentdate) — date
- Field (returndate) — date
- Key (clientid) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Key (itemid) — int(100) — Foreign key → Untitled.Key — NOT NULL
Untitled (genre)
- Key (genreid) — int(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — LONGTEXT
Untitled (role)
- Key (roleid) — int(3) — Primary key — NOT NULL
- Field (roletitle) — char(30)
- Field (description) — LONGTEXT
Untitled (client)
- Key (clientid) — int(100) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (phone) — int(11)
- Field (email) — char(30)
- Field (address) — char(30)
Untitled (person)
- Key (personid) — int(10) — Primary key — NOT NULL
- Field (fname) — char(30)
- Field (minit) — char(1)
- Field (lname) — char(30)
- Field (description) — LONGTEXT
- Field (award) — text