ERD Exercise 4
Tables (12)
Copy Of Untitled (DVDITEM)
- Key (itemID) — char(10) — Primary key — NOT NULL
- Field (subject) — date
- Field (price) — imt(10)
- Field (statusLevel) — char(1)
- Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Copy Of Untitled2 (GENRE)
- Key (genreID) — int(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — LONGTEXT
Copy Of Untitled3 (MOVIE_AWARD)
- Key (awardID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (description) — text
- Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (CLIENT)
- Key (clientID) — char(10) — Primary key — NOT NULL
- Field (clientName) — char(10)
- Field (adress) — char(30)
- Field (phone) — char(13)
- Field (email) — char(30)
Untitled (MOVIE)
- Key (movieID) — char(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (pubYear) — imt(4)
- Field (pubmonth) — int(2)
- Field (description) — text
- Field (award) — text
Untitled (CASTING)
- Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (roleID) — int(3) — Foreign key → Untitled2.Key — NOT NULL
- Field (description) — LONGTEXT
- Key (actorID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (rentID) — char(10) — Primary key — NOT NULL
- Key (itemID) — char(10) — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (tentdate) — date
- Field (returndate) — date
- Key (clientID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (ACTOR)
- Key (actorID) — int(10) — Primary key — NOT NULL
- Field (Name) — char(30)
- Field (minit) — char(1)
- Field (lname) — char(30)
- Field (description) — LONGTEXT
Untitled (MOVIE_GENRE)
- Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (genreID) — int(5) — Foreign key → Copy Of Untitled2.Key — NOT NULL
Untitled (AWARD)
- Key (awardID) — char(10) — Primary key — NOT NULL
- Field (awardName) — char(30)
- Field (year) — int(4)
Untitled (ACTOR_AWARD)
- Key (actorID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (awardID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (description) — text
Untitled2 (ROLE)
- Key (roleID) — int(3) — Primary key — NOT NULL
- Field (roletitle) — char(30)
- Field (description) — LONGTEXT