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