coupang

테이블 (8)

Category_Product

  • category_id — INT — 기본 키 — NOT NULL
  • product_id — INT — 기본 키 — NOT NULL
  • orderItem_id — BIGINT — 외래 키 → 주문상품.orderItem_id — NOT NULL
  • product_vendor_id (product_vendor_id2) — INT — 외래 키 → 주문상품.product_vendor_id — NOT NULL

결제 (Payment)

  • payment_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • canceled_at — TIMESTAMP
  • cart_id — INT — 외래 키 → 장바구니.cart_id — NOT NULL
  • product_vendor_id (product_vendor_id2) — INT — 외래 키 → 장바구니.product_vendor_id — NOT NULL

상품 (VendorProduct)

  • product_vendor_id — INT — 기본 키 — NOT NULL
  • product_id — INT — NOT NULL
  • member_id — INT — NOT NULL
  • stock — INT — NOT NULL
  • price — INT — NOT NULL
  • option_group_id — INT — 외래 키 — NOT NULL

상품내역 (ProductOption)

  • product_id — INT — 기본 키 — NOT NULL
  • option_id — INT — 기본 키 — NOT NULL
  • orderItem_id — BIGINT — 외래 키 → 주문상품.orderItem_id — NOT NULL
  • product_vendor_id (product_vendor_id2) — INT — 외래 키 → 주문상품.product_vendor_id — NOT NULL

옵션 (Option)

  • option_id — INT — 기본 키 — NOT NULL
  • option_group_id — INT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • extra_price — INT — NOT NULL
  • option_group_id (option_group_id2) — INT — 외래 키 — NOT NULL

장바구니 (Cart)

  • cart_id — INT — 기본 키 — NOT NULL
  • product_vendor_id (product_vendor_id2) — INT — 외래 키 → 상품.product_vendor_id — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • product_vendor_id — INT — NOT NULL
  • member_id — INT — NOT NULL

주문상품 (OrderItem)

  • orderItem_id — BIGINT — 기본 키 — NOT NULL
  • product_vendor_id (product_vendor_id2) — INT — 외래 키 → 상품.product_vendor_id — NOT NULL
  • order_id — BIGINT — NOT NULL
  • product_vendor_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • total_price — INT — NOT NULL
  • order_id (order_id2) — BIGINT — 외래 키 — NOT NULL

주소 (Address)

  • address_id — INT — 기본 키 — NOT NULL
  • member_id — INT — NOT NULL
  • receiver_name — VARCHAR(255) — NOT NULL
  • address1 — VARCHAR(255) — NOT NULL
  • address2 — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(30) — NOT NULL
  • order_id — BIGINT — 외래 키 — NOT NULL