book

Tables (10)

Author (Untitled3)

  • AuthorID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Address (Field2)
  • RepresentativeWork (Field3)

Book_Author (Untitled4)

  • ISBN (Key) — Foreign key → book.ISBN — NOT NULL
  • PublisherID (Key2) — Foreign key → book.PublisherID — NOT NULL
  • AuthorID (Key3) — Foreign key → Author.AuthorID — NOT NULL

Book_Keyword (Untitled8)

  • ISBN (Key) — Foreign key → book.ISBN — NOT NULL
  • PublisherID (Key2) — Foreign key → book.PublisherID — NOT NULL
  • KDCCode (Key3) — Foreign key → KDC.KDCCode — NOT NULL

Book_Related (Untitled10)

  • ISBN (Key) — Foreign key → book.ISBN — NOT NULL
  • PublisherID (Key2) — Foreign key → book.PublisherID — NOT NULL
  • RelatedID (Key3) — Foreign key → RelatedPersonOrEvent.RelatedID — NOT NULL

Contract (Untitled6)

  • ContractID (Key) — Primary key — NOT NULL
  • ISBN (Key2) — Foreign key → book.ISBN — NOT NULL
  • PublisherID (Key22) — Foreign key → book.PublisherID — NOT NULL
  • PrintingHouseID (Key3) — Foreign key → PrintingHouse.PrintingHouseID — NOT NULL
  • NumberOfCopies (Field)
  • Deadline (Field2)

KDC (Untitled7)

  • KDCCode (Key) — Primary key — NOT NULL
  • Keyword (Field)

PrintingHouse (Untitled5)

  • PrintingHouseID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Address (Field2)

Publisher (Untitled2)

  • PublisherID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Address (Field2)

RelatedPersonOrEvent (Untitled9)

  • RelatedID (Key) — Primary key — NOT NULL
  • Description (Field)

book (Untitled)

  • ISBN (Key) — Primary key — NOT NULL
  • PublisherID (Key2) — Foreign key → Publisher.PublisherID — NOT NULL
  • Title (Field)
  • PublicationDate (Field2)