과제용 model
테이블 (9)
Untitled (Contributor)
- Key (contributor_id) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — char(10)
- Field (alternativeName) — char(30)
Untitled (Work)
- Key (work_id) — char(20) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (description) — text
Untitled (WorkContributor)
- Key (manifestation_id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (contributor_id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (role) — char(3)
- Field (sequence) — char(2)
- Key (work_id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Manifestation)
- Key (manifestation_id) — char(20) — 기본 키 — NOT NULL
- Key (work_id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — char(50)
- Field2 (pub_year) — int(4)
- Field (isbn) — char(17)
- Field (format) — char(4)
- Field (language) — char(2)
- Field (edition) — char(3)
- Field (KDC) — char(10)
- Field (DDC) — char(10)
- Key (publisher-id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Publisher)
- Key (publisher-id) — char(20) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (country) — char(10)
Untitled (Curation_work)
- Key (curation_id) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (manifestation_id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (work_id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (loanquantity) — int(5)
Untitled (Tsumada_Category)
- Key (TsumadaCat_id) — char(5) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (description) — text
Untitled (Curation)
- Key (curation_id) — char(5) — 기본 키 — NOT NULL
- Field (title) — char(50)
- Field (description) — text
- Field (startDate) — date
- Field (durationMonth) — int(3)
- Field (agent) — char(20)
Untitled (New_Category)
- Key (manifestation_id) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (TsumadaCat_id) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Field (description) — text
- Key (curation_id) — char(5) — 외래 키 → Untitled.Key — NOT NULL