Ex4

Tables (9)

Untitled (Movie)

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

Untitled (Dvditem)

  • Key (itemId) — int(100) — Primary key — NOT NULL
  • Field (buyingDate) — date
  • Field (price) — int(10)
  • Field (Level) — char(1)
  • Key (movieId) — unt(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Rent)

  • Key (rentID) — int(1000) — Primary key — NOT NULL
  • Field (rentDate) — date
  • Field (retunDate) — date
  • Field — date
  • Key (itemId) — int(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (clientId) — int(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (Movie_Genre)

  • Key (movieId) — unt(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (genreIdKey) — unt(5) — Foreign key → Untitled.Key — NOT NULL

Untitled (Casting)

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

Untitled (Genre)

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

Untitled (Person)

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

Untitled (Role)

  • Key (roleId) — int(3) — Primary key — NOT NULL
  • Field (roleTitle) — char(30)

Untitled (Client)

  • Key (clientId) — int(100) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (phone) — char(11)