DATABASE

Tables (5)

AUTHOR

  • aID — char(10) — Primary key — NOT NULL
  • name — char(20)
  • majorWork — text

AWARDS

  • aID — char(10) — Primary key — NOT NULL
  • name — char(20)

BOOK

  • ISBN — char(13) — Primary key — NOT NULL
  • title — char(50)
  • pubYear — char(4)
  • type (kdc_6th) — char(12)

WORK

  • ID — int(11) — Primary key — NOT NULL
  • ISBN — char(13) — Foreign key → BOOK.ISBN — NOT NULL
  • aID — char(10) — Foreign key → AWARDS.aID — NOT NULL
  • year — char(10)
  • description — text

WORK_AUTHOR

  • waID — int(11) — Primary key — NOT NULL
  • ISBN — char(13) — Foreign key → BOOK.ISBN — NOT NULL
  • aID — char(10) — Foreign key → AUTHOR.aID — NOT NULL
  • role — char(20)