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)