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