ZRJ

Tables (6)

Author (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • address (Field2)
  • works (Field3)
  • ID (Key2) — Foreign key → Publisher.ID — NOT NULL

Book (Untitled)

  • ISBN (Key) — Primary key — NOT NULL
  • title (Field)
  • publish date (Field2)
  • signature (Field3)
  • KDC code (Field4)

Publisher (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • address (Field2)
  • ISBN (Key2) — Foreign key → Book.ISBN — NOT NULL

Relatedentity (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • Type (Field2)
  • ID (Key2) — Foreign key → Author.ID — NOT NULL

keyword (Untitled5)

  • ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • ID (Key2) — Foreign key → Relatedentity.ID — NOT NULL
  • ID (Key3) — Foreign key → keyword.ID — NOT NULL

keyword (Untitled6)

  • ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • ISBN (Key2) — Foreign key → Book.ISBN — NOT NULL