d

Tables (7)

AUTHOR

  • authorID — INT(10)
  • name — CHAR(30)
  • alternativeName — CHAR(50)
  • description — TEXT
  • majorWork — TEXT

BOOK

  • ISBN — CHAR(13) — Primary key
  • title — CHAR(50)
  • originalTitle — CHAR(50)
  • kdc_6th — CHAR(20)
  • pubYear — INT(4)
  • type — CHAR(10)
  • expression — CHAR(3)
  • workID — INT(30)

MOVIE

  • movieID — INT(10)
  • title — CHAR(50)
  • originalTitle — CHAR(50)
  • releasedYear — INT(4)
  • expression — CHAR(3)
  • description — TEXT
  • runTime — INT(30)
  • workID — INT(30)

MOVIE_PERSON

  • role — CHAR(10)
  • personID — INT(10)
  • movieID — INT(10)

PERSON

  • personID — INT(10)
  • name — CHAR(30)
  • description — TEXT
  • nationality — CHAR(10)
  • repRole — CHAR(10)
  • majorWorks — TEXT

WORK

  • workID — INT(30)
  • workTitle — CHAR(50)

WORK_AUTHOR

  • workID — INT(30)
  • authorID — INT(10)
  • roll — CHAR(20)