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)