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 (위탁자 휴대폰번호)