2023_0328_EX04

Tables (9)

Untitled (DVD_RENT)

  • Key (dvdrentID) — int(1000) — Primary key — NOT NULL
  • Field (dvdrentDate) — test
  • Key (dvditemId) — int(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (customersID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (CUSTOMERS)

  • Key (customersID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(11)
  • Field (email) — char(30)

Untitled (DVD_ITEM)

  • Key (dvditemId) — int(100) — Primary key — NOT NULL
  • Field (buyingdate) — date
  • Field (price) — int(10)
  • Field (statusLevel) — char(30)

Untitled (GENRE)

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

Untitled (PERSON)

  • Key (personId) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — LONGTEXT
  • Field (award) — test

Untitled (MOVIE)

  • Key (movieId) — int(10) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (pubTear) — int(4)
  • Field (pubMonth) — int(2)
  • Field (description) — LONGTEST
  • Field (award) — test

Untitled (MOVIE_GENRE)

  • Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (generId) — int(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (CASTING)

  • Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (personId) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (roleId) — int(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (ROLE)

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