DB_FRBR_ERD

Tables (5)

Untitled (author)

  • Key (authorID) — char(13) — Primary key — NOT NULL
  • Field (authorName) — char(50)
  • Field (alterName) — char(100)
  • Field (description) — text
  • Field (majorWork) — char(100)

Untitled (subject)

  • Key (subID) — char(13) — Primary key — NOT NULL
  • Field (subTitle) — char(20)
  • Field (description) — text

Untitled (work_sub)

  • Key (workID) — char(13) — Foreign key → work.Key — NOT NULL
  • Key (subID) — char(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (work_author)

  • Key (authorID) — char(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (workID) — char(13) — Foreign key → work.Key — NOT NULL

work

  • Key (workID) — char(13) — Primary key — NOT NULL
  • Field (workTitle) — char(50)
  • Field (description) — text