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 (주문상태)