exe4006

Tables (7)

Untitled (DVD_LIST)

  • Key2 (dvdID) — char(20) — Primary key — NOT NULL
  • Field (title) — char(20)
  • Field (rent-cost) — char(7)
  • Field (date of purchase) — char(8)
  • Field2 (times) — char(20)

Untitled (RENT-RECORD)

  • Key2 (dvdID) — char(20) — Foreign key → Untitled.Key2 — NOT NULL
  • Key (c-ID) — char(20) — Foreign key → Untitled3.Key — NOT NULL
  • Field (rent-date) — char(10)
  • Field2 (return-date) — char(10)
  • Field (overdue-date) — char(10)

Untitled (MOVIE-INFOR)

  • Key2 (dvdID) — char(20) — Foreign key → Untitled.Key2 — NOT NULL
  • Field (title) — char(30)
  • Field (the year made) — char(15)
  • Field (description) — text

Untitled (DIRECTOR-INF)

  • Key (directorID) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (biography) — text
  • Key2 (dvdID) — char(20) — Foreign key → Untitled.Key2 — NOT NULL

Untitled2 (COPY-DVD_LIST)

  • Key (c-dID) — char(20) — Primary key — NOT NULL
  • Key2 (dvdID) — char(20) — Foreign key → Untitled.Key2 — NOT NULL
  • Field (description) — text
  • Field (rent-cost) — int(10)
  • Field (date of purchase) — char(8)
  • Field (times) — int(10)

Untitled2 (ACTOR-INF)

  • Key (actorID) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (biography) — char(20)
  • Key2 (dvdID) — char(20) — Foreign key → Untitled.Key2 — NOT NULL

Untitled3 (CUSTOMERS)

  • Key (c-ID) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — char(11)