FRBR in class
Tables (8)
Untitled (work)
- Key (workID) — char(11) — Primary key — NOT NULL
- Field (workTitle) — char(50)
- Field2 (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(30)
- 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
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)
Untitled (author)
- Field (authID) — char(11) — Primary key
- Field (authName) — char(50)
- Field (alterName) — char(100)
- Field (description) — text
- Field (majorWork) — char(100)
Untitled (Publisher)
- Key (pubID) — char(11) — Primary key — NOT NULL
- Field (pubName) — char(20)
- Field (address) — char(50)
- Field (description) — text
Untitled (work_auth)
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Field (authID) — char(11) — Foreign key → Untitled.Field
Untitled (Subject)
- Key (subID) — char(11) — Primary key — NOT NULL
- Field (subTitle) — char(20)
- Field (description) — text
Untitled (work_subject)
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key (subID) — char(11) — Foreign key → Untitled.Key — NOT NULL