book

Tables (6)

Untitled (BOOK)

  • ISBN — char(10) — Primary key — NOT NULL
  • signature — char(40)
  • date of publication — date
  • publication ID — char(10) — Foreign key → Untitled.publication ID — NOT NULL

Untitled (PUBLISHER)

  • publication ID — char(10) — Primary key — NOT NULL
  • name — char(30)
  • address — char(60)

Untitled (AUTHOR)

  • authorID — char(10) — Primary key — NOT NULL
  • name — char(30)
  • address — char(60)
  • representative — char(100)

Untitled (BOOKAUTHOR)

  • ISBN — char(10) — Foreign key → Untitled.ISBN — NOT NULL
  • authorID — char(10) — Foreign key → Untitled.authorID — NOT NULL

Untitled (CONTRACT)

  • ISBN — char(10) — Foreign key → Untitled.ISBN — NOT NULL
  • printingID — char(10) — Foreign key → Untitled2.printingID — NOT NULL
  • number — INT
  • deadline — date

Untitled2 (PRINTINGHOUSE)

  • printingID — char(10) — Primary key — NOT NULL
  • name — char(10)
  • address — char(100)