4

Tables (7)

Untitled (actor)

  • Key (actorCode) — int(3) — Primary key — NOT NULL
  • Key (moviecode) — char(6) — Foreign key → movie.Key — NOT NULL
  • Field (movieCode) — char(6)
  • Field (name) — char(20)
  • Field (biography) — longtext

Untitled (director)

  • Key (directorCode) — int(3) — Primary key — NOT NULL
  • Key (moviecode) — char(6) — Foreign key → movie.Key — NOT NULL
  • Field (movieCode) — char(6)
  • Field (name) — char(20)
  • Field (biography) — longtext

Untitled (dvd)

  • Key (dvID) — int(1000) — Primary key — NOT NULL
  • Field (dvdcopycode) — int(1000)
  • Field (purchasedate) — date
  • Field (renttimenumber) — int(100)
  • Key (moviecode) — char(6) — Foreign key → movie.Key — NOT NULL

Untitled (customer)

  • Key (custID) — char(15) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field (phone) — char(15)

Untitled (rent)

  • Key (rentdate) — date — Primary key — NOT NULL
  • Field (renttime) — int(5)
  • Key (dvID) — int(1000) — Foreign key → Untitled.Key — NOT NULL
  • Key (custID) — char(15) — Foreign key → Untitled.Key — NOT NULL
  • Key (managerID) — char(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (manager)

  • Key (managerID) — char(5) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (phone) — int(12)

movie

  • Key (moviecode) — char(6) — Primary key — NOT NULL
  • Field (title) — char(20)
  • Field (yearmade) — char(4)