2024_10_15_2

Tables (6)

Untitled (MEMBER)

  • Key (memID) — char(20) — Primary key — NOT NULL
  • Field (memName) — char(30)
  • Field (address) — char(30)
  • Field

Untitled (DVD)

  • Key (dvdID) — char(20) — Primary key — NOT NULL
  • Field (buyDate) — date
  • Key (movID) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movID) — char(20) — Primary key — NOT NULL
  • Field (movName) — char(30)
  • Field (movDate) — date
  • Key (dirID) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (actID) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (ACTOR)

  • Key (actID) — char(20) — Primary key — NOT NULL
  • Field (actName) — char(30)
  • Field (actBiog) — text

Untitled (DIRECTOR)

  • Key (dirID) — char(20) — Primary key — NOT NULL
  • Field (dirName) — char(30)
  • Field (dirBiog) — text

Untitled (RENT)

  • Key (dvdID) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (memID) — char(20) — Foreign key → Untitled.Key — NOT NULL