metaBookstores
Tables (6)
book (책)
- book_no (책번호) — Primary key — NOT NULL
- title (책이름)
- author (저자)
- image (책이미지)
- pub (출판사)
- pub_date (출판날짜)
- description (책설명)
- price (가격)
- cate_no (카테고리 번호) — Foreign key → category.cate_no — NOT NULL
cart (장바구니)
- cart_no (장바구니 번호) — Primary key — NOT NULL
- user_no (회원번호) — Foreign key → member.user_no — NOT NULL
- book_no (책번호) — Foreign key → book.book_no — NOT NULL
- cart_book_qt (책수량)
- cart_total_price (총가격)
category (카테고리)
- cate_no (카테고리 번호) — Primary key — NOT NULL
- cate_name (카테고리 이름)
inventory (재고)
- stock_no (재고식별자) — Primary key — NOT NULL
- stock (재고)
- book_no (책번호) — Foreign key → book.book_no — NOT NULL
- sold_cnt (판매수량)
member (회원)
- user_no (회원번호) — Primary key — NOT NULL
- password (비밀번호)
- id (아이디)
- name (이름)
- address (주소)
- phone (핸드폰번호)
- email (이메일)
- status (상태)
- reg_date (가입일)
order (주문)
- order_no (주문식별자) — Primary key — NOT NULL
- user_no (회원번호) — Foreign key → member.user_no — NOT NULL
- book_no (책번호) — Foreign key → book.book_no — NOT NULL
- order_id (주문번호)
- order_qt (주문수량)
- order_total_price (총가격)
- receiver_addr (수령자주소)
- receiver_phone (수령자핸드폰번호)
- order_date (주문날짜)
- order_status (주문상태)