2023_webDB_ex4

Tables (6)

Untitled (CUSTOMER)

  • Key (customerNo) — char(20) — Primary key — NOT NULL
  • Field (customerName) — char(20)
  • Field (cutomerAddress) — char(50)
  • Field (cutomerPhone) — char(20)

Untitled (DVD)

  • Key (dvdNo) — char(30) — Primary key — NOT NULL
  • Field (copy) — int
  • Field (borrowingTime) — time
  • Field (borrowingPeriod) — date
  • Field (borrowingNumber) — int
  • Key (movieNo) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (customerNo) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movieNo) — char(20) — Primary key — NOT NULL
  • Field (movieTitle) — char(50)
  • Field (movieProduction) — int(4)
  • Field (movieRelease) — date

Untitled (MOVIE_DIRECTOR)

  • Key (directorNo) — char(20) — Primary key — NOT NULL
  • Field (directorName) — char(30)
  • Field (directorBio) — text

Untitled (MOVIE_ACTOR)

  • Key (actorNo) — char(20) — Primary key — NOT NULL
  • Field (actorName) — char(30)
  • Field (actorBio) — text

Untitled (MOVIE_WORK)

  • Key (directorNo) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (actorNo) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (movieNo) — char(20) — Foreign key → Untitled.Key — NOT NULL