6

Tables (5)

Untitled (Book)

  • Key (ISBN) — char(30) — Primary key — NOT NULL
  • Field (Signature) — char(30)
  • Field (Publication date) — int(20)
  • Key (PublisherID) — int(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (Publisher Infor)

  • Key (PublisherID) — int(15) — Primary key — NOT NULL
  • Field (Name) — char(30)
  • Field (adress) — char(50)

Untitled (Writer)

  • Key (IDcard No.) — char(30) — Primary key — NOT NULL
  • Key (ISBN) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (Name) — char(30)
  • Field (adress) — char(50)
  • Field

Untitled (Printers)

  • Key (PrintersID) — INT(30) — Primary key — NOT NULL
  • Field (Name) — char(50)
  • Field (Adress) — char(50)
  • Key (ISBN) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Contract Information)

  • Key (PrintersID) — INT(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (No. of printed books) — int(30)
  • Field2 (printing deadline) — char(30)