FRBR

Tables (9)

Expression (Untitled2)

  • expression_id (Key) — Primary key — NOT NULL
  • manifestation_id (Key2) — Foreign key → Manifestation.manifestation_id — NOT NULL
  • work_id (Field)
  • language (Field2)
  • format (Field3)

Item (Untitled6)

  • ID (Key) — Primary key — NOT NULL
  • item_id (Key2) — Foreign key → author.item_id — NOT NULL
  • auth no (Key22) — Foreign key → author.auth no — NOT NULL
  • work_id (PK) ((PK)) — Foreign key → author.work_id (PK) — NOT NULL
  • manifestation_id (Key222) — Foreign key → author.manifestation_id — NOT NULL
  • ISBN (Field)
  • work ID (Field2)
  • buy date (Field3)
  • price (Field4)
  • call No (Field5)

Manifestation (Untitled4)

  • manifestation_id (Key) — Primary key — NOT NULL
  • expression_id (Field)
  • publisher (Field2)
  • publication_date (Field3)
  • isbn (Field4)
  • book title (Field5)
  • auther (Field6)
  • pub year (Field7)
  • size (Field8)
  • page (Field9)
  • pub ID (Field10)
  • price (Field11)

Work (Untitled)

  • work_id (PK) ((PK)) — Primary key — NOT NULL
  • manifestation_id (Key) — Foreign key → Manifestation.manifestation_id — NOT NULL
  • title (Field)
  • author (Field2)

Work subject (Untitled8)

  • Key — Primary key — NOT NULL
  • auth no (Key2) — Foreign key → auth ID.auth no — NOT NULL
  • work_id (PK) ((PK)) — Foreign key → auth ID.work_id (PK) — NOT NULL
  • manifestation_id (Key22) — Foreign key → auth ID.manifestation_id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

auth ID (Untitled7)

  • auth no (Key) — Primary key — NOT NULL
  • work_id (PK) ((PK)) — Foreign key → Work.work_id (PK) — NOT NULL
  • manifestation_id (Key2) — Foreign key → Work.manifestation_id — NOT NULL
  • auth name (Field)
  • desciption (Field2)
  • major work (Field3)

author (Untitled5)

  • item_id (Key) — Primary key — NOT NULL
  • auth no (Key2) — Foreign key → auth ID.auth no — NOT NULL
  • work_id (PK) ((PK)) — Foreign key → auth ID.work_id (PK) — NOT NULL
  • manifestation_id (Key22) — Foreign key → auth ID.manifestation_id — NOT NULL
  • manifestation_id (Field)
  • location (Field2)
  • barcode (Field3)

publisher (Untitled9)

  • pub id (Key) — Primary key — NOT NULL
  • work_id (PK) ((PK)) — Foreign key → Work.work_id (PK) — NOT NULL
  • manifestation_id (Key2) — Foreign key → Work.manifestation_id — NOT NULL
  • pub name (Field)
  • address (Field2)
  • decription (Field3)

subject (Untitled3)

  • Key — Primary key — NOT NULL
  • item_id (Key2) — Foreign key → author.item_id — NOT NULL
  • auth no (Key22) — Foreign key → author.auth no — NOT NULL
  • work_id (PK) ((PK)) — Foreign key → author.work_id (PK) — NOT NULL
  • manifestation_id (Key222) — Foreign key → author.manifestation_id — NOT NULL
  • Key (Key3) — Foreign key → Work subject.Key — NOT NULL
  • auth no (Key23) — Foreign key → Work subject.auth no — NOT NULL
  • work_id (PK) ((PK)2) — Foreign key → Work subject.work_id (PK) — NOT NULL
  • manifestation_id (Key223) — Foreign key → Work subject.manifestation_id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4