BOOK

Tables (8)

Untitled (WORK)

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

Untitled (BOOK)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Field (title) — char(50)
  • Field (pubDate) — date
  • Field (type) — char(10)
  • Field (kdc) — char(20)
  • Field (price) — int(10)
  • Key (pubID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (workID) — int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (PUBLISHER)

  • Key (pubID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (phone) — char(20)

Untitled (AUTHOR)

  • Key (authID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — text
  • Field (majorWorks) — text

Untitled (ITEM)

  • Key (itemEM) — char(30) — Primary key — NOT NULL
  • Field (callNum) — char(30)
  • Field (purchasedDate) — date
  • Field (price) — integer
  • Key (ISBN) — char(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (SUBJECT)

  • Key (subID) — int(20) — Primary key — NOT NULL
  • Field (subjectHeading) — char(30)
  • Field (description) — text

Untitled (WORK_SUBJECT)

  • Key (workID) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (subID) — int(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (WORK_AUTHOR)

  • Key (workID) — int(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (authID) — int(10) — Foreign key → Untitled.Key — NOT NULL