13

Tables (10)

AUTHORS (Untitled)

  • AuthorID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • representative (Field2) — char(10)
  • Representative Work (Field3) — char(50)

BOOK

  • ISBN (Key) — int(10) — Primary key — NOT NULL
  • title (Field) — char(10)
  • PublicationDate (Field2) — int(10)
  • Publisher ID (Key2) — int(10) — Foreign key → PUBISHERS.Publisher ID — NOT NULL

Books_Authors (Untitled3)

  • ISBN (Key) — int(10) — Foreign key → BOOK.ISBN — NOT NULL
  • AuthorID (Key2) — int(10) — Foreign key → AUTHORS.AuthorID — NOT NULL

Books_Keywords (Untitled9)

  • ISBN (Key) — int(10) — Foreign key → BOOK.ISBN — NOT NULL
  • Keyword ID (Key2) — int(10) — Foreign key → KEYSWORD.Keyword ID — NOT NULL

Books_RelatedEntities (Untitled8)

  • ISBN (Key) — int(10) — Foreign key → BOOK.ISBN — NOT NULL
  • Entity ID (Key2) — int(10) — Foreign key → Related Entities.Entity ID — NOT NULL

CONTRACTS (Untitled5)

  • contractsID (Key) — int(10) — Primary key — NOT NULL
  • Print Quantity (Field) — int(10)
  • Print Deadline (Field2) — int(10)
  • Printing House ID (Key2) — int(10) — Foreign key → PRINTING HOUSES.Printing House ID — NOT NULL
  • ISBN (Key3) — int(10) — Foreign key → BOOK.ISBN — NOT NULL

KEYSWORD (Untitled6)

  • Keyword ID (Key) — int(10) — Primary key — NOT NULL
  • Keyword Name (Field) — char(20)
  • KDCNumber (Field2) — int(10)

PRINTING HOUSES (Untitled4)

  • Printing House ID (Key) — int(10) — Primary key — NOT NULL
  • name (Field2) — char(10)
  • address (Field3) — char(20)

PUBISHERS (Untitled2)

  • Publisher ID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(20)

Related Entities (Untitled7)

  • Entity ID (Key) — int(10) — Primary key — NOT NULL
  • type (Field) — char(10)
  • description (Field2) — int(10)