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)