book

Tables (3)

BOOK (도서정보)

  • bookNo (도서번호) — int(10) — Primary key — NOT NULL
  • name (도서명) — text
  • author (지은이) — char(100)
  • publisher (출판사) — text
  • pubYear (출판일) — char(8)

borrow (대출)

  • bookNo (도서번호) — int(10) — Foreign key → BOOK.bookNo — NOT NULL
  • userID (회원번호) — int(10) — Foreign key → user.userID — NOT NULL
  • borrowDate (대여일자) — char(8)

user (회원)

  • userID (회원번호) — int(10) — Primary key — NOT NULL
  • userName (회원명) — char(100)
  • joinDate (가입일) — char(8)