frbr
Tables (8)
Untitled (work)
- Key (workID) — char(11) — Primary key — NOT NULL
- Field (workTitle) — char(50)
- Field (description) — text
Untitled (manifestation)
- Key (ISBN) — char(13) — Primary key — NOT NULL
- Key2 (bookTitle) — char(30) — Primary key — NOT NULL
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Field (author) — char(50)
- Field (pubYear) — int(4)
- Field (page) — int(4)
- Field (listPrice) — int(8)
- Field (size) — int(2)
- Field (language) — char(3)
- Key (pubID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key2 (pubName) — char(20) — Foreign key → Untitled.Key2 — NOT NULL
Untitled (work_auth)
- Key (workID) — char(11) — Primary key — NOT NULL
- Key2 (authID) — char(11) — Primary key — NOT NULL
- Key (workID2) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key (authID2) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key2 (authName) — char(50) — Foreign key → Untitled.Key2 — NOT NULL
Untitled (author)
- Key (authID) — char(11) — Primary key — NOT NULL
- Key2 (authName) — char(50) — Primary key — NOT NULL
- Field (alterName) — char(100)
- Field2 (description) — text
- Field (majorWork) — char(100)
Untitled (publisher)
- Key (pubID) — char(11) — Primary key — NOT NULL
- Key2 (pubName) — char(20) — Primary key — NOT NULL
- Field (address) — char(50)
- Field (description) — text
Untitled (subject)
- Key (subID) — char(11) — Primary key — NOT NULL
- Key2 (subTitle) — char(20) — Primary key — NOT NULL
- Field (description) — text
Untitled (work-subject)
- Key (workID) — char(11) — Primary key — NOT NULL
- Key2 (subID) — char(11) — Primary key — NOT NULL
- Key (subID2) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key2 (subTitle) — char(20) — Foreign key → Untitled.Key2 — NOT NULL
Untitled (item)
- Key (itemID) — char(10) — Primary key — NOT NULL
- Key (ISBN) — char(13) — Foreign key → Untitled.Key — NOT NULL
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Field (buyDate) — date
- Field (price) — int(8)