04

Tables (6)

Untitled (CUSTOME)

  • Key (customerNo) — int(10) — Primary key — NOT NULL
  • Field (name) — char(4)
  • Field2 (address) — char(10)
  • Field (phoneNo) — int(11)

Untitled (DVD)

  • Key (dvdNo) — int(7) — Primary key — NOT NULL
  • Field (date) — int(4)
  • Field (time) — int(3)
  • Key (customerNo) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movieNo) — int(10) — Primary key — NOT NULL
  • Field (titlle) — char(10)
  • Field (create year) — int(4)
  • Field (type) — char(9)
  • Key (dvdNo) — int(7) — Foreign key → Untitled.Key — NOT NULL

Untitled (DIRETOR)

  • Key (idenNo) — int(10) — Primary key — NOT NULL
  • Field (name) — char(3)
  • Field (phoneNo) — int(11)

Untitled (ACTOR)

  • Key (idenNo) — int(10) — Primary key — NOT NULL
  • Field (name) — char(3)
  • Field (phoneNo) — int(11)

Untitled (?)

  • Key (idenNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (movieNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (idenNo2) — int(10) — Foreign key → Untitled.Key — NOT NULL