frbr(2024)
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
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Field (bookTitle) — char(50)
- Field (author) — char(50)
- Field (pubYear) — int(4)
- Field (size) — int(2)
- Field (listPrice) — int(8)
- Field (language) — char(3)
- Key (pubID) — char(11) — Foreign key → Untitled.Key — 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 (price) — int(8)
- Field
- Key (buyDate) — date — NOT NULL
Untitled (author)
- Key (aautID) — char(11) — Primary key — NOT NULL
- Field (autName) — char(50)
- Field (alterName) — char(100)
- Field (description) — text
- Field
Untitled (publisher)
- Key (pubID) — char(11) — Primary key — NOT NULL
- Field (pubName) — char(20)
- Field (address) — char(50)
- Field (description)
Untitled (work_auth)
- Key — Primary key — NOT NULL
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key (aautID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Field
Untitled (work_subject)
- Key (subID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key (aautID) — char(11) — Foreign key → Untitled.Key — NOT NULL
Untitled (subject)
- Key (subID) — char(11) — Primary key — NOT NULL
- Field (subTitle) — char(20)
- Field (description) — text