final task database

Tables (7)

Untitled (work)

  • Key (workID) — int(10) — Primary key — NOT NULL
  • Field (workTitle) — char(70)

Untitled (book)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Field (title) — char(70)
  • Field (originalTitle) — char(70)
  • Field (nameOfAuthor) — char(50)
  • Field (kdc_6th) — char(20)
  • Field (pubYear) — int(4)
  • Field (type) — char(10)
  • Field (expression) — char(3)
  • Key (workID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (movie)

  • Key (movieID) — int(30) — Primary key — NOT NULL
  • Field (title) — char(70)
  • Field (originalTitle) — char(70)
  • Field (releasedYear) — int(4)
  • Field (expression) — char(3)
  • Field (description) — text
  • Field (runTime) — int(3)
  • Key (workID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (person)

  • Key (personID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(50)
  • Field (birthDate) — char(20)
  • Field (nationality) — charr(20)
  • Field (repRole) — char(20)
  • Field (description) — text
  • Field (majorWorks) — text

Untitled (movie_persom)

  • Key (role) — char(20) — Primary key — NOT NULL
  • Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (personID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (hero)

  • Key (heroID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(50)
  • Field (gender) — char(10)
  • Field (job) — char(50)
  • Field (nationality) — char(20)
  • Field (description) — text

Untitled (work_detective)

  • Key (workID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (heroID) — int(10) — Foreign key → Untitled.Key — NOT NULL