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)