FRBR
Tables (8)
Untitled (Manifestation)
- Key (ISBN) — int(13) — Primary key — NOT NULL
- Field (title) — varchar(20)
- Key (expCode) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Field (publisher) — varchar(10)
- Field (pubDate) — date
Untitled (Expression)
- Key (expCode) — char(5) — Primary key — NOT NULL
- Field (language) — char(3)
- Field (format) — char(3)
- Field (date) — date
- Key (workCode) — int(7) — Foreign key → Work.Key — NOT NULL
Untitled (Item)
- Key (itemCode) — char(5) — Primary key — NOT NULL
- Field (itemTitle) — varchar(20)
- Key (manifcode) — char(7) — Foreign key → Untitled.Key — NOT NULL
- Field (callNumber) — char(9)
Untitled (Author)
- Key (authorCode) — char(6) — Primary key — NOT NULL
- Field (authorName) — varchar(20)
- Field (birthDate) — date
Untitled (Work_Author)
- Key (workCode) — int(7) — Foreign key → Work.Key — NOT NULL
- Key (authorCode) — char(6) — Foreign key → Untitled.Key — NOT NULL
Untitled (Expression_Person)
- Key (expCode) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Key (personId) — char(7) — Foreign key → Untitled.Key — NOT NULL
- Field (role) — char(7)
Untitled (Person)
- Key (personId) — char(7) — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (birthDate) — date
Work
- Key (workCode) — int(7) — Primary key — NOT NULL
- Field (workTitle) — varchar(30)