FRBR

Tables (5)

item (Untitled3)

  • ISBN (Key) — Foreign key → manifestation.ISBN — NOT NULL
  • workID (Key2) — Foreign key → manifestation.workID — NOT NULL
  • ISBN (Field)
  • workID (Field2)
  • buyDate (Field3)
  • price (Field4)
  • callnumber (Field5)

manifestation (Untitled2)

  • ISBN (Key) — Primary key — NOT NULL
  • workID (Key2) — Foreign key → work.workID — NOT NULL
  • workID (Field)
  • bookTitle (Field2)
  • author (Field3)
  • size (Field4)
  • page (Field5)
  • publID (Key3) — Foreign key → publisher.publID — NOT NULL

publisher (Untitled4)

  • publID (Key) — Primary key — NOT NULL
  • publname (Field)
  • address (Field2)

work (Untitled)

  • workID (Key) — Primary key — NOT NULL
  • workTitle (Field)
  • description (Field2)

work_subject (Untitled7)

  • workID (Field)
  • subID (Field2)
  • workID (Key) — Foreign key → work.workID — NOT NULL