FRBR

Tables (6)

Untitled (WORK)

  • Key (workid) — int(20) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field2 (creatdate) — date
  • Field3 (subject) — chat(50)
  • Field (author) — char(30)
  • Key — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (EXPRESSION)

  • Key (expressid) — int(20) — Primary key — NOT NULL
  • Field (title) — chat(30)
  • Field (Language) — char(20)
  • Field (format) — char(20)
  • Field (expressiondate) — date
  • Key (workid) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (MANIFESTATION)

  • Key (ManId) — int(20) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (statementofresp) — char(30)
  • Field (edition) — int(3)
  • Field (imprint) — char(10)
  • Field (form/extent carrier) — char(10)
  • Field (terms of availability) — char(20)
  • Field (Mode of Access) — char(10)
  • Key (expressid) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (ITEM)

  • Key (ID) — int(20) — Primary key — NOT NULL
  • Field (provenance) — char(20)
  • Field (location) — char(20)
  • Field (annotation) — text
  • Key (ManId) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID2) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (ID3) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (PERSON)

  • Key (ID) — char(30) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (language) — char(10)
  • Field (address) — char(10)

Untitled (CORPORATE BODY)

  • Key — char(30) — Primary key — NOT NULL
  • Field (est date) — date
  • Field (language) — char(10)
  • Field (address) — char(10)