erd 22

Tables (5)

Untitled (VISITOR)

  • Key (visitorID) — int(20) — Primary key — NOT NULL
  • Field (name) — char(50)
  • Field2 (address) — char(50)
  • Field3 (phoneNumber) — int(11)
  • Field (email) — char(30)

Untitled (MOVIE)

  • Key (movieID) — int(30) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field2 (volume) — int(2)
  • Field3 (subTitle) — char(50)
  • Field4 (pubYear) — int(4)
  • Field (runTime) — int(3)
  • Key (artistID) — int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (ARTIST)

  • Key (artistID) — int(20) — Primary key — NOT NULL
  • Field2 (artistName) — char(50)
  • Field3 (nationality) — char(20)
  • Field (dateOfBirth) — int(8)
  • Field (dateOfDeath) — int(8)

Untitled (VISITOR_ARTIST_INT)

  • Key (visitorID) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (artistID) — int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (TRANSACTION)

  • Key (transactionID) — int(20) — Primary key — NOT NULL
  • Field (returnDate) — int(8)
  • Field2 (loanDate) — int(8)
  • Key (movieID) — int(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (visitorID) — int(20) — Foreign key → Untitled.Key — NOT NULL