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