exercise 6

Tables (7)

AUTHOR

  • authorID — int(10) — Primary key — NOT NULL
  • name — char(30)
  • alternativeName — char(50)
  • description — text
  • majorWork — text

BOOK

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

MOVIE

  • movieID — int(10) — Primary key — NOT NULL
  • title — char(50)
  • originalTitle — char(50)
  • releasedYear — int(4)
  • expression — char(3)
  • description — text
  • runtime — int(3)
  • workID — int(30 — Foreign key → WORK.workID — NOT NULL

MOVIE_PERSON

  • role — char(10) — Primary key — NOT NULL
  • movieID (presonalID) — int(10) — Foreign key → MOVIE.movieID — NOT NULL
  • personID (movieID) — int(10) — Foreign key → PERSON.personID — NOT NULL

PERSON

  • personID (personalID) — int(10) — Primary key — NOT NULL
  • name — char(30)
  • description — text

WORK

  • workID — int(30 — Primary key — NOT NULL
  • workTitle — char(50)

WORK_AUTHOR

  • workID — int(30 — Foreign key → WORK.workID — NOT NULL
  • authorID — int(10) — Foreign key → AUTHOR.authorID — NOT NULL
  • roll — char(20)