FRBR

Tables (8)

Untitled (Manifestation)

  • Key (ISBN) — int(13) — Primary key — NOT NULL
  • Field (title) — varchar(20)
  • Key (expCode) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (publisher) — varchar(10)
  • Field (pubDate) — date

Untitled (Expression)

  • Key (expCode) — char(5) — Primary key — NOT NULL
  • Field (language) — char(3)
  • Field (format) — char(3)
  • Field (date) — date
  • Key (workCode) — int(7) — Foreign key → Work.Key — NOT NULL

Untitled (Item)

  • Key (itemCode) — char(5) — Primary key — NOT NULL
  • Field (itemTitle) — varchar(20)
  • Key (manifcode) — char(7) — Foreign key → Untitled.Key — NOT NULL
  • Field (callNumber) — char(9)

Untitled (Author)

  • Key (authorCode) — char(6) — Primary key — NOT NULL
  • Field (authorName) — varchar(20)
  • Field (birthDate) — date

Untitled (Work_Author)

  • Key (workCode) — int(7) — Foreign key → Work.Key — NOT NULL
  • Key (authorCode) — char(6) — Foreign key → Untitled.Key — NOT NULL

Untitled (Expression_Person)

  • Key (expCode) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (personId) — char(7) — Foreign key → Untitled.Key — NOT NULL
  • Field (role) — char(7)

Untitled (Person)

  • Key (personId) — char(7) — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (birthDate) — date

Work

  • Key (workCode) — int(7) — Primary key — NOT NULL
  • Field (workTitle) — varchar(30)