book

테이블 (9)

구매 (purchase)

  • (purch_id) — int
  • Field2 (mem_id) — int
  • Field (purch_price) — int
  • Field (book_id) — int
  • Field (purch_count) — int

구매 내역 (purchase_history)

  • (purch_history_id) — int
  • Field (purch_date) — date
  • Field (purch_method) — varchar2(150)

대여 (rental)

  • (rent_id) — int
  • (rent_date) — date
  • (rent_due_date) — date
  • (book_id) — int
  • (mem_id) — int
  • Field (book_status) — varchar2(100)

대여 기록 (rental_history)

  • Field (rent_history_id) — int
  • Field (rent_id) — int
  • Field (rent_date) — date
  • Field (rent_due_date)

반납 (return)

  • Field (return_id) — int
  • Field (mem_id) — int
  • Field (book_id) — int
  • Field (rental_id) — int
  • Field (return_date) — date
  • Field (rent_periiod) — date

예약 (reservation)

  • Field (reserv_id) — int
  • Field2 (mem_id) — int
  • Field (book_id) — int
  • Field (reserv_date) — date
  • Field (reserv_status) — varchar2(200)

장바구니 (cart)

  • (card_id) — int
  • (cart_count) — int
  • (mem_id) — int
  • (book_id) — int

책 목록 (book)

  • Field (book_id) — int
  • Field (book_title) — varchar2(300)
  • Field (book_wirter) — varchar2(100)
  • Field (book_publisher) — varchar2(100)
  • Field (book_img) — varchar2(300)
  • Field (book_price) — float — NOT NULL
  • Field (book_release_date) — date — NOT NULL
  • Field (book_category) — varchar2(100) — NOT NULL

회원 (member)

  • Field (mem_id) — int
  • Field2 (mem_name) — varchar2(100)
  • Field (mem_email) — varchar2(200)
  • Field (mem_password) — varchar2(200)
  • Field (mem_address) — varchar2(300)
  • Field (mem_postcode) — int
  • Field (mem_detail_address) — varchar2(200)
  • Field (mem_role) — varchar2(200)