과제용 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