work4

Tables (8)

Role (Untitled)

  • Key (roleID) — int(3) — Primary key — NOT NULL
  • Field (roletitle) — char(10)
  • Field (description) — text

Untitled (movie)

  • Key (movieID) — int(10) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (PubYear) — int(4)
  • Field (PubMonth) — int(2)
  • Field — longtext
  • Field2 (award) — longtext

Untitled (DVDITEM)

  • Key (itemID) — nt(100) — Primary key — NOT NULL
  • Field (buydate) — date
  • Field2 (price) — int(10)
  • Field (statulevel)
  • Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (moviegenre)

  • Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (grnreID) — int(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (Genre)

  • Key (grnreID) — int(5) — Primary key — NOT NULL
  • Field (name) — int(10)
  • Field (descrption) — longtext

Untitled (casting)

  • Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (roleID) — int(3) — Foreign key → Role.Key — NOT NULL
  • Key (personIDKey) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (descrption) — text

Untitled (CIIENT)

  • Key (clientID) — int(100) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field

Untitled (Person)

  • Key (personIDKey) — int(10) — Primary key — NOT NULL
  • Field (fname) — char(30)
  • Field (minit) — char(1)
  • Field (Iname) — char(30)
  • Field (descrption) — longtext
  • Field (award) — text