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)