BOOK

Tables (5)

Appendix (appendix)

  • 도서번호 (book_number) — INT — Primary key — NOT NULL
  • 부록명 (appendix_name) — VARCHAR(55)
  • 도서번호 (book_number2) — INT — Foreign key → Book Number.도서번호 — NOT NULL

Book Number (book number)

  • 도서번호 (book_number) — INT — Primary key — NOT NULL
  • 저자 (author) — VARCHAR(100)
  • 도서명 (book_name) — VARCHAR(100)
  • 출판사 (publisher) — VARCHAR(100)
  • 발행일 (published_date) — DATE
  • 부록여부 (addendum) — VARCHAR(100)
  • 분류기호 (classification_code) — VARCHAR(150)
  • 예약여부 (reservation) — VARCHAR(50)

Member (member)

  • 회원번호 (member_number) — INT — Primary key — NOT NULL
  • 회원명 (member_name) — VARCHAR(50)
  • 주민번호 (jumin_number) — VARCHAR(50)
  • 회원등급 (member_ranking) — VARCHAR(50)
  • 주소 (address) — VARCHAR(100)
  • 전화번호 (phone_number) — INT — NOT NULL
  • 이메일 (email) — VARCHAR(100)
  • 연체료 (arrears) — VARCHAR(100)

Rental (rental)

  • 대여번호 (rental_number) — INT — Primary key — NOT NULL
  • 도서번호 (book_number) — INT — Primary key — NOT NULL
  • 회원번호 (member_number) — INT
  • 대출일자 (loan_date) — DATE
  • 반납일자 (return_date) — DATE
  • 부록대출여부 (loan_availability) — VARCHAR(100)
  • 연장 (extension) — VARCHAR(100)
  • 회원번호 (member_number2) — INT — Foreign key → Member.회원번호 — NOT NULL
  • 회원번호 (member_number3) — INT — Foreign key → Member.회원번호 — NOT NULL
  • 도서번호 (book_number2) — INT — Foreign key → Book Number.도서번호 — NOT NULL

Reservation (reservation)

  • Key — Primary key — NOT NULL
  • 대여번호 (rental_number) — INT
  • 회원번호 (member_number) — INT
  • 예약순번 (reservation order) — VARCHAR(100)
  • 회원번호 (member_number2) — INT — Foreign key → Member.회원번호 — NOT NULL
  • 대여번호 (rental_number2) — INT — Foreign key → Rental.대여번호 — NOT NULL
  • Key (Key2) — Foreign key → Rental.도서번호 — NOT NULL