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