db
Tables (6)
AUTHOR
- authorNo — int(4) — Primary key — NOT NULL
- name — char(20)
- nationality — char(10)
- gender — char(1)
BOOK
- ISBN — int(13) — Primary key — NOT NULL
- title — char(50)
- pubYear — int(4)
- Field (genre) — char(15)
EMPLOYEE (RECOMMENDER)
- Key (empNo) — int(3) — Primary key — NOT NULL
- Field (name) — char(5)
- Field (position) — char(5)
PUBLISHER
- pubNo — int(3) — Primary key — NOT NULL
- name — char(15)
SUBJECT
- subNo — int(4) — Primary key — NOT NULL
- name — char(30)
- Field (year) — int(4)
- Field (month) — char(3)
Untitled (BOOKPICK)
- Key (bpNo) — int(4) — Primary key — NOT NULL
- ISBN — int(13) — Foreign key → BOOK.ISBN — NOT NULL
- authorNo — int(3) — Foreign key → AUTHOR.authorNo — NOT NULL
- pubNo — int(3) — Foreign key → PUBLISHER.pubNo — NOT NULL
- Field (sentence) — text
- Field (callNo) — char(30)
- Key (subNo) — int(4) — Foreign key → SUBJECT.subNo — NOT NULL
- Key (empNo) — int(3) — Foreign key → EMPLOYEE.Key — NOT NULL