FRBR(2024)
Tables (9)
Untitled (WORK)
- Key (workID) — char(11) — Primary key — NOT NULL
- Field (workTitle) — char(50)
- Field (description) — text
Untitled (Item)
- Key (itemId) — char — Primary key — NOT NULL
- inbn (isbn) — char(13) — Foreign key → Untitled2.inbn — NOT NULL
- Key (workID) — char(11) — Foreign key → Untitled2.Key — NOT NULL
- Field (buyDate) — date
- Field (price) — int(8)
Untitled (author)
- Key (authID) — char(11) — Primary key — NOT NULL
- Field (authName) — char(50)
- Field (alterName) — char(100)
- Field (description) — text
- Field (majorWork) — char(100)
Untitled (publisher)
- Key (pubID) — char(13) — Primary key — NOT NULL
- Field (pubName) — char(30)
- Field (address) — char(50)
- Field (description) — text
Untitled (work_auth)
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key (authID) — 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
Untitled (work_subject)
- Key (subID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (manifestation)
- inbn (isbn) — char(13) — Primary key — NOT NULL
- Key (workID) — char(11) — Foreign key → Untitled.Key — NOT NULL
- Field (bookTitle) — char(30)
- Field (author) — char(30)
- Field (pubYear) — int(4)
- Field (size) — int(2)
- Field (page) — int(4)
- Field (listprice) — int(8)
- Field (language) — char(3)
- Key (pubID) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (expression(언어))
- Key (expressionID) — int — Primary key — NOT NULL
- Field (language) — char(3)