e-commerce

Tables (11)

Customers (소비자)

  • customer_id (일련번호) — Primary key
  • Field (아이디)
  • Field2 (상호명)
  • Field3 (매장휴대폰1)
  • Field4 (매장휴대폰2)
  • Field5 (매장주소)

Products (상품)

  • product_id (상품일련번호) — Primary key
  • category_id (카테고리일련번호) — Foreign key → category.category_id
  • product_name (상품명)
  • product_detail (상품정보)
  • product_price (상품가격)
  • product_sale (상품할인율)
  • product_option (상품옵션)
  • product_stock (상품재고)
  • product_img_download_score (상품이미지다운로드수)
  • product_heart_score (상품찜수)

category (카테고리)

  • category_id (카테고리일련번호) — Primary key
  • category_main (대분류)
  • category_center (중분류)
  • category_sub (소분류)
  • category_product (카테고리에 담긴 상품수)

customers_heart (소비자 찜)

  • customers_id (Field)
  • Field2
  • Field3

order_methods (주문방법)

  • all_pickup (사입_합포)
  • trust_delivery (위탁배송)

product_detail (상품정보)

  • product_id (상품일련번호) — Foreign key → Products.product_id
  • category_id (카테고리일련번호) — Foreign key → Products.category_id
  • main_img (대표이미지)
  • detail_img (상세이미지)
  • heart_score (찜갯수)
  • img_download_score (이미지다운로드갯수)

product_img_license (상품이미지이용권)

  • product_id (상품일련번호)
  • img_cart (이미지담기)
  • img_download_score (이미지다운로드수)
  • img_heart (이미지찜)

product_name (상품명)

  • product_id (상품일련번호) — Foreign key → Products.product_id
  • category_id (카테고리일련번호) — Foreign key → Products.category_id
  • nt_name (뉴톡 상품명)
  • wh_name (도매 상품명)
  • re_name (소매 상품명)

product_option (상품 옵션)

  • product_id (상품일련번호) — Foreign key → Products.product_id
  • category_id (카테고리일련번호) — Foreign key → Products.category_id
  • product_color (상품컬러)
  • product_size (상품사이즈)

trust (위탁자)

  • trust_id (일련번호) — Primary key
  • customer_id (일련번호2) — Foreign key → Customers.customer_id
  • tust_name (위탁자명)
  • trust_address (위탁주소)
  • trust_phone (위탁자 휴대폰번호)

users (Untitled)