ERD4
Tables (8)
Untitled (MOVIE)
- Key (moviled) — int(10) — Primary key — NOT NULL
- Field2 (char(30)) — char(30)
- Field3 (PubYear) — int(4)
- Field4 (pubMonth) — int(2)
- Field5 (description) — LONGTEXT
- Field (award) — LONGTEXT
Untitled (MOVIE_GENRE)
- Key (moviled) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (genreld) — int(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (GENRE)
- Key (genreld) — int(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — LONGTEXT
Untitled (DVDITEM)
- Key (itemld) — int(100) — Primary key — NOT NULL
- Field (buyingdate) — date
- Field (price) — int(10)
- Field (statusLevel) — char(1)
- Field
- Key (moviled) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (itemld) — int(100) — Foreign key → Untitled.Key — NOT NULL
Untitled (CASTING)
- Key (moviled) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (PersonID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (roldID) — int(3) — Foreign key → Untitled.Key — NOT NULL
- Field (dsecription) — text
Untitled (PERSON)
- Key (PersonID) — int(10) — Primary key — NOT NULL
- Field (fname) — char(30)
- Field (minit) — char(30)
- Field (Iname) — char(30)
- Field (description) — LONGTEXT
- Field (award) — LONGTEXT
Untitled (RENT1)
- Key (roldID) — int(3) — Primary key — NOT NULL