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)