kakaoShopping

Tables (9)

cart (장바구니)

  • cart_id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → user.user_id — NOT NULL

cart_item (장바구니 상품)

  • cart_item_id (PK) — Primary key — NOT NULL
  • cart_id (FK) — Foreign key → cart.cart_id — NOT NULL
  • product_id (FK2) — Foreign key → product.product_id — NOT NULL
  • cart_item_quantity (개수)

image (이미지)

  • img_id (PK) — Primary key — NOT NULL
  • product_id (FK) — Foreign key → product.product_id — NOT NULL
  • img_name (이미지 파일명)
  • ori_img_name (원본 이미지 파일명)
  • img_url (이미지 조회 경로)
  • rep_img_yn (대표 이미지 여부)

option (옵션)

  • option_id (PK) — Primary key — NOT NULL
  • product_id (FK) — Foreign key → product.product_id — NOT NULL
  • option_name (옵션 이름)
  • option_price (옵션 가격)
  • stock_number (재고 개수)

order (주문)

  • order_id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → user.user_id — NOT NULL
  • order_date (주문 날짜)
  • order_status (주문 상태)

order_item (주문 상품)

  • order_item_id (PK) — Primary key — NOT NULL
  • order_id (FK) — Foreign key → order.order_id — NOT NULL
  • product_id (FK2) — Foreign key → product.product_id — NOT NULL
  • order_item_quantity (옵션 주문 개수)
  • order_tiem_price (옵션 주문 금액)

product (상품)

  • product_id (PK) — Primary key — NOT NULL
  • product_category_id (FK) — Foreign key → product_category.product_category_id — NOT NULL
  • product_name (이름)
  • description (상품 설명)

product_category (상품 카테고리)

  • product_category_id (PK) — Primary key — NOT NULL
  • product_category_name (카테고리 이름)

user (회원)

  • user_id (PK) — Primary key — NOT NULL
  • name (이름)
  • email (이메일)
  • password (비밀번호)
  • address (주소)
  • role (권한)
  • status (상태)