2023_SLI_EX4

Tables (10)

Untitled (MOVIE)

  • Key (movieID) — int(10) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (year) — int(4)
  • Field (month) — int(2)
  • Field (award) — text
  • Field (description) — text

Untitled (COPYS)

  • Key (copysCode) — Primary key — NOT NULL
  • Field (purchaseDate)
  • Field (rentedTime)
  • Field
  • Key (videoCode) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (RENT)

  • Key (rentID) — int(100) — Primary key — NOT NULL
  • Key (customerID) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Field (rentDate) — date
  • Field (returnDate) — date
  • Key (videoCode) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (VIDEOCASSETTE)

  • Key (videoCode) — char(10) — Primary key — NOT NULL
  • Field (description) — text
  • Field (price) — int(10)
  • Field (stateusLevel) — char(1)
  • Field (buyingDate) — date
  • Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE_GENRE)

  • Key (movieID2) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (genreCode2) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (movieID) — int(10)
  • Field (genreCode) — int(5)

Untitled (GENRE)

  • Key (genreCode) — int(5) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text

Untitled (CASTING)

  • Key (movieID2) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (movieID) — INT(10)
  • Field (personID) — INT(10)
  • Field (roleID) — int(3)
  • Field (description) — text
  • Key (personID2) — int(10) — Foreign key → Untitled2.Key — NOT NULL
  • Key (roleID2) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (ROLE)

  • Key (roleID) — int(10) — Primary key — NOT NULL
  • Field (roleTitle) — char(30)
  • Field (description) — text

Untitled2 (CUSTOMER)

  • Key (customerID) — int(100) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (adress) — char(30)
  • Field2 (phone) — int(11)
  • Field (email) — char(3)

Untitled2 (PERSON)

  • Key (personID) — int(10) — Primary key — NOT NULL
  • Field (fname) — char(3)
  • Field (award) — text
  • Field (description) — text