sapar
Tables (16)
cart (장바구니)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → customer.customer_id — NOT NULL
cart_product (장바구니 상품)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → cart.Key — NOT NULL
category (카테고리)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → product.Key — NOT NULL
coupons (쿠폰)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → customer.customer_id — NOT NULL
- Key (Key3) — Foreign key → order_payment.Key — NOT NULL
customer (고객)
- customer_id (고객 고유 ID) — BIGINT — Primary key — NOT NULL
customer_address (고객 주소)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → customer.customer_id — NOT NULL
delivery (배송)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → order.Key — NOT NULL
discount (할인)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → product.Key — NOT NULL
order (주문)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → customer.customer_id — NOT NULL
order_payment (주문 결제)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → order.Key — NOT NULL
order_product (주문 상품)
- Key2 — Primary key — NOT NULL
- Key — Foreign key → order.Key — NOT NULL
product (상품)
- Key — Primary key — NOT NULL
- Key (Key4) — Foreign key → seller.Key — NOT NULL
- Key2 — Foreign key → wishlist.Key2 — NOT NULL
- Key (Key3) — Foreign key → cart_product.Key — NOT NULL
- Key2 (Key22) — Foreign key → order_product.Key2 — NOT NULL
product_image (상품 사진)
- Key2 — Primary key — NOT NULL
- Key — Foreign key → product.Key — NOT NULL
review (리뷰)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → product.Key — NOT NULL
- Key (Key3) — Foreign key → customer.customer_id — NOT NULL
seller (판매자)
- Key — Primary key — NOT NULL
wishlist (위시리스트)
- Key2 — Primary key — NOT NULL
- Key — Foreign key → customer.customer_id — NOT NULL