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