2023_SLI_EX4

Tables (9)

Customers (CLIENT)

  • Key (custromeID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(50)
  • Field (phone) — int(11)
  • Field (ssn) — char(13)

Untitled (DVD)

  • Key (code) — char(100) — Primary key — NOT NULL
  • Field (buyingDate) — date
  • Field (price) — int(10)
  • Key (moviedID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (RENT)

  • Key (rentID) — int(100) — Primary key — NOT NULL
  • Field (rentDate) — date
  • Field (returnDate) — date
  • Key (code) — char(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (custromeID) — char(10) — Foreign key → Customers.Key — NOT NULL

Untitled (MOVIE)

  • Key (moviedID) — int(10) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (pubYear) — int(4)
  • Field (pubMonth) — int(2)
  • Field (description) — text

Untitled (CASTING)

  • Key (roleID) — int(3) — Foreign key → Untitled.Key — NOT NULL
  • Key (personID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (moviedID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (ROLE)

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

Untitled (PERSON)

  • Key (personID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (minit) — char(1)
  • Field (description) — text
  • Field (award) — text

Untitled (MOVIE GELRE)

  • Key (moviedID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (genreID) — int(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (GELRE)

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