example4

Tables (8)

Untitled (DVD Information)

  • Key (DVDcode) — int(10) — Primary key — NOT NULL
  • Field (purchaseDate) — date
  • Field (rentalCount) — int(3)
  • Key (movieID) — int6) — Foreign key → Untitled.Key — NOT NULL

Untitled (Movie)

  • Key (movieID) — int6) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (title_en) — char(30)
  • Field (productionYear) — char(4)
  • Field (description) — text
  • Field (ageClassification) — char(3)
  • Field (genre) — char(3)

Untitled (Actor)

  • Key (actorID) — int(6) — Primary key — NOT NULL
  • Field (name) — int(30)
  • Field (biography) — text

Untitled (Director)

  • Key (diretorID) — int(6) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (biography) — text

Untitled (Production)

  • Key (actorID) — int(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (movieID) — int6) — Foreign key → Untitled.Key — NOT NULL

Untitled (DirectorProduction)

  • Key (diretorID) — int(6) — Foreign key → Untitled.Key — NOT NULL
  • Key (movieID) — int6) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (Rental)

  • Key (rentalNo) — int(10) — Primary key — NOT NULL
  • Key (ID) — int(10) — Foreign key → client.Key — NOT NULL
  • Key (DVDcode) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — date
  • Field (time) — char(5)

client (Client)

  • Key (ID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(5)
  • Field (address) — char(30)
  • Field (tel) — int(9)