hw2
Tables (7)
LINK (Untitled3)
- moID (Key) — int(10 — Foreign key → movie.moID — NOT NULL
- personID (Key2) — int(10) — Foreign key → person.personID — NOT NULL
LINK (Untitled7)
- workID (Key) — int(30) — Foreign key → work.workID — NOT NULL
- authorID (Key2) — int(10) — Foreign key → author.authorID — NOT NULL
author (Untitled6)
- authorID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(30)
- alternativeName (Field2) — char(50)
- description (Field3) — text
- majorWork (Field4) — text
book (Untitled)
- ISBN (Key) — char(13) — Primary key — NOT NULL
- title (Field) — char(30)
- originalTitle (Field2) — char(50)
- pubyear (Field3) — int(4)
- type (Field4) — char(10)
- expression (Field5) — char(3)
movie (Untitled2)
- moID (Key) — int(10 — Primary key — NOT NULL
- title (Field) — char(50)
- originalTitle (Field2) — char(50)
- year (Field3) — int(4)
- expression (Field4) — char(3)
- description (Field5) — text
- runTime (Field6) — int(3)
- workID (Key2) — int(30) — Foreign key → work.workID — NOT NULL
person (Untitled5)
- personID (Key) — int(10) — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- nationality (Field3) — text
- repRole (Field4) — char(10)
- majorWorks (Field5) — text
work (Untitled4)
- workID (Key) — int(30) — Primary key — NOT NULL
- workTitlt (Field) — char(50)