Library

Tables (5)

book (책)

  • 책 식별키 (book_id) — varchar(10000) — Primary key — NOT NULL — book_pk
  • 제목 (book_title) — varchar(50) — NOT NULL
  • 저자 (book_author) — varchar(30) — NOT NULL
  • 출판사 (book_publisher) — varchar(20) — NOT NULL
  • 분야 (book_genre) — varchar(20) — NOT NULL

borrow (대출)

  • 대출 식별키 (borrow_id) — int — Primary key — NOT NULL — borrow_pk
  • 고객 식별키 (customer_id) — int — Foreign key → customer.고객 식별키 — NOT NULL — customer_pk
  • 책 식별키 (book_id) — varchar(10000) — Foreign key → book.책 식별키 — NOT NULL — book_pk
  • 대출 날짜 (reservation_date) — int — NOT NULL
  • 반납 날짜 (return_date) — int — NOT NULL

customer (고객)

  • 고객 식별키 (customer_id) — int — Primary key — NOT NULL — customer_pk
  • 고객 이름 (customer_name) — varchar(30) — NOT NULL
  • 고객 성별 (customer_sex) — varchar(10) — NOT NULL
  • 고객 나이 (customer_age) — int — NOT NULL
  • 고객 주소 (customer_address) — varchar(200) — NOT NULL
  • 고객 전화번호 (customer_pNum) — int — NOT NULL

library (서고)

  • 서고 식별키 (library_id) — int — Primary key — NOT NULL — library_pk
  • Field

reservation (예약)

  • 예약 식별키 (reservation_id) — int — Primary key — NOT NULL — reservation_pk
  • 고객 식별키 (customer_id) — int — Foreign key → customer.고객 식별키 — NOT NULL — customer_pk
  • 책 식별키 (book_id) — varchar(10000) — Foreign key → book.책 식별키 — NOT NULL — book_pk