leport3

Tables (3)

Untitled (WORK)

  • Key (workID) — int(30) — Primary key — NOT NULL
  • Field (workTitle) — char(50)

Untitled (CHILDREN'S BOOK)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (originalTitle) — char(50)
  • Field (kdc_6th) — char(20)
  • Field (pubyear) — int(4)
  • Field (type) — char(10)
  • Field (expression) — char(3)
  • Field (author) — char(50)
  • Field (illustrator) — char(50)
  • Field (publisher) — char(50)
  • Field (price) — int(10)
  • Key (workID) — int(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (NOVEL BOOK)

  • Key (novISBN) — char(13) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (originalTitle) — char(50)
  • Field (kdc_6th) — char(20)
  • Field (pubYear) — int(4)
  • Field (type) — char(10)
  • Field (expression) — char(3)
  • Field (auther) — char(30)
  • Field (publisher) — char(50)
  • Field (price) — int(10)
  • Key (workID) — int(30) — Foreign key → Untitled.Key — NOT NULL