FRBR model
Tables (6)
Untitled (Contributor)
- Key (contributor_id) — char(20) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (email) — char(20)
- Field (organizaition) — char(10)
Untitled (Work)
- Key (work_id) — char(20) — Primary key — NOT NULL
- Field (original_language) — char(3)
- Field (title) — char(30)
- Field (description) — test
- Field (classfication_code) — int(6)
Untitled (WorkContributor)
- Key (manifestation_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (contributor_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (role) — char(3)
- Field (sequence) — char(10)
Untitled (Manifestation)
- Key (manifestation_id) — char(20) — Primary key — NOT NULL
- Key (work_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (publisher-id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field2 (pub_year) — int(4)
- Field (isbn) — char(17)
- Field (format) — char(4)
- Field (language) — char(2)
- Field (edition) — char(3)
- Field (pages) — int(4)
- Field (printing) — char(3)
Untitled (Publisher)
- Key (publisher-id) — char(20) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (country) — char(10)
Untitled (Item)
- Key (item_id) — char(20) — Primary key — NOT NULL
- Key (manifestation_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (accssion_no) — char(20)
- Field (barcode) — int(20)
- Field (location) — char(10)
- Field (status) — char(4)
- Field (acquisition_year) — int(4)