ex6

Tables (6)

PrintingWorker (Untitled5)

  • PrintID (Key) — char(40) — Primary key — NOT NULL
  • Name (Field) — char(30)
  • adress (Field2) — char(30)
  • Field3

Printingbook (Untitled6)

  • ISBN (Key) — char(50) — Foreign key → book.ISBN — NOT NULL
  • PrintID (Key2) — char(40) — Foreign key → PrintingWorker.PrintID — NOT NULL
  • deadline (Field) — date
  • count (Field2) — integer

Publiser (Untitled2)

  • publiserID (Key) — char(50) — Primary key — NOT NULL
  • Name (Field) — char(30
  • adress (Field2) — char(50)

author (Untitled3)

  • RegID (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(30)
  • adress (Field2) — char(40)

authorbook (Untitled4)

  • ISBN (Key) — char(50) — Foreign key → book.ISBN — NOT NULL
  • RegID (Key2) — char(13) — Foreign key → author.RegID — NOT NULL

book (Untitled)

  • ISBN (Key) — char(50) — Primary key — NOT NULL
  • sign (Field) — char(50)
  • Publicdate (Field2) — date
  • publiserID (Key2) — char(50) — Foreign key → Publiser.publiserID — NOT NULL