curation model
Tables (9)
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)
- Key (work_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
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 (KDC) — char(10)
- 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 (Curation_work)
- Key (curation_id) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (manifestation_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (work_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (loanquantity) — int(5)
Untitled (Tsumada_Category)
- Key (Tcategory_id) — int(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (subject) — text
Untitled (Curation)
- Key (curation_id) — int(10) — Primary key — NOT NULL
- Field (title) — text
- Field (description) — text
- Field (startDate) — date
- Field (endDate) — date
- Field (agent) — char(20)
Untitled (New_Category)
- Key (manifestation_id) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (Tcategory_id) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (description) — text
- Key (curation_id) — int(10) — Foreign key → Untitled.Key — NOT NULL