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