DATABASE
Tables (5)
Untitled (BOOK)
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Key (workID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — char(50)
- Field (pubYear) — char(4)
- Field (type) — char(12)
Untitled (WORK)
- Key (workID) — char(20) — Primary key — NOT NULL
- Field
Untitled (WORK_AUTHOR)
- Key (workID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (authorID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (AUTHOR)
- Key (authorID) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (majerWork) — text
Untitled2 (AWARDS)
- Key (awardID) — int(10) — Primary key — NOT NULL
- Key (workID) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — char(50)
- Field (awardYear) — char(4)
- Field (descript) — text