1019

Tables (7)

Untitled (BOOK)

  • Key (isbn) — char18 — Primary key — NOT NULL
  • Field (date) — char8
  • Field (publisher) — char30
  • Field (author) — char20
  • Field (print) — char20
  • Field (kdc) — char6
  • Field (keyword) — char20
  • Key (publisherId) — char10 — Foreign key → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (publisherId) — char10 — Primary key — NOT NULL
  • Field (name) — char30
  • Field (address) — char50

Untitled (AUTHORIMPORMATION)

  • Key (authorId) — char10 — Primary key — NOT NULL
  • Field (name) — char30
  • Field (address) — char50
  • Field (majorWork) — char50

Untitled (PRINTHOUSE)

  • Key (printhouseId) — char10 — Primary key — NOT NULL
  • Field (name) — char30
  • Field (address) — char50

Untitled (CONTRACT)

  • Key (contractNo) — char10 — Primary key — NOT NULL
  • Field (number) — char10
  • Field (date) — char8
  • Key (isbn) — char18 — Foreign key → Untitled.Key — NOT NULL
  • Key (printhouseId) — char10 — Foreign key → Untitled.Key — NOT NULL

Untitled (AUTHOR)

  • Key (isbn) — char18 — Foreign key → Untitled.Key — NOT NULL
  • Key (authorId) — char10 — Foreign key → Untitled.Key — NOT NULL

Untitled (KEYWORD)

  • Key (isbn) — char18 — Foreign key → Untitled.Key — NOT NULL
  • Field (people) — char20
  • Field (event) — char30
  • Field (date) — char8
  • Field (theme) — char20
  • Field (genre) — char20
  • Field (etc) — char40