FRBR 한경희

테이블 (7)

Untitled (Item)

  • Key (itemID) — char(20) — 기본 키 — NOT NULL
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (purchaseDate) — date
  • Field

Untitled (Work)

  • Key (workID) — int(30) — 기본 키 — NOT NULL
  • Key (authorID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (workTitle) — char(30)

Untitled (Author)

  • Key (authorID) — int(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (alterName) — char(50)
  • Field (biography) — text

Untitled (Subject)

  • Key (subjectID) — int(30) — 기본 키 — NOT NULL
  • Field (description) — text

Untitled (Manifestation)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — int(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (bookTitle) — char(30)
  • Field (publishedYear) — int(4)
  • Field (size) — int(2)
  • Field (page) — int(4)
  • Field (language) — char(3)
  • Key (pubID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Publisher)

  • Key (pubID) — char(20) — 기본 키 — NOT NULL
  • Field (pubName) — char(30)
  • Field (address) — char(30)
  • Field (description) — text

Untitled (Work_Subject)

  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (subjectID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — int(20) — 외래 키 → Untitled.Key — NOT NULL