BOOK
Tables (8)
Untitled (WORK)
- Key (workID) — int(20) — Primary key — NOT NULL
- Field (workTitle) — char(50)
Untitled (BOOK)
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Field (title) — char(50)
- Field (pubDate) — date
- Field (type) — char(10)
- Field (kdc) — char(20)
- Field (price) — int(10)
- Key (pubID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (workID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (PUBLISHER)
- Key (pubID) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (address) — char(50)
- Field (phone) — char(20)
Untitled (AUTHOR)
- Key (authID) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
- Field (majorWorks) — text
Untitled (ITEM)
- Key (itemEM) — char(30) — Primary key — NOT NULL
- Field (callNum) — char(30)
- Field (purchasedDate) — date
- Field (price) — integer
- Key (ISBN) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (SUBJECT)
- Key (subID) — int(20) — Primary key — NOT NULL
- Field (subjectHeading) — char(30)
- Field (description) — text
Untitled (WORK_SUBJECT)
- Key (workID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (subID) — int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (WORK_AUTHOR)
- Key (workID) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (authID) — int(10) — Foreign key → Untitled.Key — NOT NULL