DATABASE

Tables (5)

Untitled (BOOK)

  • Key (ISBN) — char(13) — Primary key — NOT NULL
  • Key (workID) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — char(50)
  • Field (pubYear) — char(4)
  • Field (type) — char(12)

Untitled (WORK)

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

Untitled (WORK_AUTHOR)

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

Untitled (AUTHOR)

  • Key (authorID) — int(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (majerWork) — text

Untitled2 (AWARDS)

  • Key (awardID) — int(10) — Primary key — NOT NULL
  • Key (workID) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — char(50)
  • Field (awardYear) — char(4)
  • Field (descript) — text