final task database
Tables (7)
Untitled (work)
- Key (workID) — int(10) — Primary key — NOT NULL
- Field (workTitle) — char(70)
Untitled (book)
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Field (title) — char(70)
- Field (originalTitle) — char(70)
- Field (nameOfAuthor) — char(50)
- Field (kdc_6th) — char(20)
- Field (pubYear) — int(4)
- Field (type) — char(10)
- Field (expression) — char(3)
- Key (workID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (movie)
- Key (movieID) — int(30) — Primary key — NOT NULL
- Field (title) — char(70)
- Field (originalTitle) — char(70)
- Field (releasedYear) — int(4)
- Field (expression) — char(3)
- Field (description) — text
- Field (runTime) — int(3)
- Key (workID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (person)
- Key (personID) — int(10) — Primary key — NOT NULL
- Field (name) — char(50)
- Field (birthDate) — char(20)
- Field (nationality) — charr(20)
- Field (repRole) — char(20)
- Field (description) — text
- Field (majorWorks) — text
Untitled (movie_persom)
- Key (role) — char(20) — Primary key — NOT NULL
- Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (personID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (hero)
- Key (heroID) — int(10) — Primary key — NOT NULL
- Field (name) — char(50)
- Field (gender) — char(10)
- Field (job) — char(50)
- Field (nationality) — char(20)
- Field (description) — text
Untitled (work_detective)
- Key (workID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (heroID) — int(10) — Foreign key → Untitled.Key — NOT NULL