FRBR
Tables (6)
Untitled (WORK)
- Key (workid) — int(20) — Primary key — NOT NULL
- Field (title) — char(30)
- Field2 (creatdate) — date
- Field3 (subject) — chat(50)
- Field (author) — char(30)
- Key — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (EXPRESSION)
- Key (expressid) — int(20) — Primary key — NOT NULL
- Field (title) — chat(30)
- Field (Language) — char(20)
- Field (format) — char(20)
- Field (expressiondate) — date
- Key (workid) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (MANIFESTATION)
- Key (ManId) — int(20) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (statementofresp) — char(30)
- Field (edition) — int(3)
- Field (imprint) — char(10)
- Field (form/extent carrier) — char(10)
- Field (terms of availability) — char(20)
- Field (Mode of Access) — char(10)
- Key (expressid) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (ITEM)
- Key (ID) — int(20) — Primary key — NOT NULL
- Field (provenance) — char(20)
- Field (location) — char(20)
- Field (annotation) — text
- Key (ManId) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (ID2) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (ID3) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (PERSON)
- Key (ID) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (language) — char(10)
- Field (address) — char(10)
Untitled (CORPORATE BODY)
- Key — char(30) — Primary key — NOT NULL
- Field (est date) — date
- Field (language) — char(10)
- Field (address) — char(10)