point3

Tables (17)

buyer

  • id — BIGINT — Primary key — NOT NULL
  • kakao_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(50)
  • phone — VARCHAR(20)
  • payer_id — VARCHAR(64) — point3 결제자 식별값. 받은 문자열 그대로 저장
  • created_at — DATETIME(6) — NOT NULL

cart

  • id — BIGINT — Primary key — NOT NULL
  • buyer_id — BIGINT — Foreign key — NOT NULL
  • seller_id — BIGINT — Foreign key — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

cart_item

  • id — BIGINT — Primary key — NOT NULL
  • cart_id — BIGINT — Foreign key → cart.id — NOT NULL
  • sale_form_id — BIGINT — Foreign key — NOT NULL — 담을 때 cart.seller_id 와 일치하는지 검증
  • product_id — BIGINT — Foreign key — NOT NULL
  • option_id — BIGINT — Foreign key
  • qty — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

order_group

  • id — BIGINT — Primary key — NOT NULL
  • group_no — VARCHAR(32) — NOT NULL — 외부 노출용 주문번호
  • buyer_id — BIGINT — Foreign key — NOT NULL
  • seller_id — BIGINT — Foreign key — NOT NULL — 한 묶음은 한 셀러로 제한
  • first_amount — INT — NOT NULL — 1차금 = 하위 orders 상품가 합계
  • second_amount — INT — 배송비 등 2차금. 전 폼 입고 후 확정
  • status — VARCHAR(20) — NOT NULL — CREATED | PAY_PENDING | PAID | SECOND_PENDING' ' | SECOND_PAID | SHIPPED | CANCELED | EXPIRED | FAILED
  • canceled_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

order_item

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • option_id — BIGINT — Foreign key → product_option.id — 옵션 없는 상품이면 NULL
  • qty — INT — NOT NULL
  • unit_price — INT — NOT NULL — product.base_price 스냅샷
  • extra_price — INT — NOT NULL — option.extra_price 스냅샷
  • line_amount — INT — NOT NULL — (unit_price + extra_price) * qty
  • product_name — VARCHAR(200) — NOT NULL — 표시용 스냅샷
  • option_name — VARCHAR(100)

orders

  • id — BIGINT — Primary key — NOT NULL
  • order_no — VARCHAR(32) — NOT NULL — 외부 노출용 주문번호
  • buyer_id — BIGINT — Foreign key → buyer.id — NOT NULL
  • sale_form_id — BIGINT — Foreign key → sale_form.id — NOT NULL
  • total_qty — INT — NOT NULL
  • first_amount — INT — NOT NULL — 1차금 = 상품가 합계
  • second_amount — INT — 2차금. 입고 후 확정될 수 있음
  • status — VARCHAR(20) — NOT NULL — CREATED | PAY_PENDING | PAID | RECRUITING | CLOSED' ' | PRODUCING | ARRIVED | SECOND_PENDING | SECOND_PAID' ' | SHIPPED…
  • canceled_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

outbox

  • id — BIGINT — Primary key — NOT NULL
  • aggregate_type — VARCHAR(30) — NOT NULL — ORDER | SALE_FORM | PAYMENT
  • aggregate_id — BIGINT — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • payload — JSON — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING | SENT | DEAD
  • retry_count — INT — NOT NULL
  • last_error — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • sent_at — DATETIME(6)

payment

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • phase — VARCHAR(10) — NOT NULL — FIRST | SECOND
  • session_id — VARCHAR(128) — point3 sessionId
  • amount — INT — NOT NULL
  • supply_amount — INT
  • vat — INT
  • tax_free_amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — CREATED | CAPTURE_PENDING | CAPTURED | FAILED
  • fail_reason — VARCHAR(100)
  • refunded_amount — INT — NOT NULL
  • captured_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

payment_event

  • id — BIGINT — Primary key — NOT NULL
  • payment_id — BIGINT — Foreign key → payment.id — NOT NULL
  • from_status — VARCHAR(20)
  • to_status — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(200)
  • actor — VARCHAR(10) — NOT NULL — USER | BATCH | SELLER | SYSTEM
  • created_at — DATETIME(6) — NOT NULL

product

  • id — BIGINT — Primary key — NOT NULL
  • sale_form_id — BIGINT — Foreign key → sale_form.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • base_price — INT — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

product_option

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • extra_price — INT — NOT NULL
  • sort_order — INT — NOT NULL

refund

  • id — BIGINT — Primary key — NOT NULL
  • payment_id — BIGINT — Foreign key → payment.id — NOT NULL
  • point3_refund_id — VARCHAR(128)
  • idempotency_key — VARCHAR(300) — 중복 차단용. 재시도용 아님
  • amount — INT — NOT NULL
  • tax_free_amount — INT — NOT NULL
  • vat — INT — NOT NULL
  • reason — VARCHAR(200) — 최대 200자
  • requested_by — VARCHAR(10) — NOT NULL — BUYER | SELLER | SYSTEM
  • status — VARCHAR(20) — NOT NULL — PROCESSING | COMPLETED | FAILED
  • settled_manual — TINYINT(1) — NOT NULL — 정산 완료 후 셀러 직접 환불 접수건
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

sale_form

  • id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → seller.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • slug — VARCHAR(120) — NOT NULL — 판매 링크 경로
  • sale_type — VARCHAR(10) — NOT NULL — GROUP | SOLO
  • status — VARCHAR(20) — NOT NULL — DRAFT | SELLING | PAUSED | CLOSED | ENDED
  • stock_max — INT — NOT NULL
  • held — INT — NOT NULL
  • sold — INT — NOT NULL
  • target_qty — INT — 목표수량(최소). SOLO 는 NULL
  • opens_at — DATETIME(6)
  • closes_at — DATETIME(6)
  • extended_count — INT — NOT NULL
  • shortfall_policy — VARCHAR(10) — CANCEL | EXTEND | PROCEED
  • second_type — VARCHAR(20) — NOT NULL — SHIPPING_FEE | BALANCE | NONE
  • second_amount — INT — BALANCE 는 입고 후 확정되므로 NULL 허용
  • progress_public — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

sale_form_history

  • id — BIGINT — Primary key — NOT NULL
  • sale_form_id — BIGINT — Foreign key → sale_form.id — NOT NULL
  • field — VARCHAR(50) — NOT NULL
  • old_value — VARCHAR(500)
  • new_value — VARCHAR(500)
  • changed_by — BIGINT — seller.id
  • created_at — DATETIME(6) — NOT NULL

seller

  • id — BIGINT — Primary key — NOT NULL
  • kakao_id — VARCHAR(64) — NOT NULL
  • store_slug — VARCHAR(64) — NOT NULL — 판매공간 URL 식별자
  • review_status — VARCHAR(20) — NOT NULL — PENDING | APPROVED | REJECTED
  • business_no_enc — VARBINARY(255) — 사업자번호(암호화)
  • settlement_acct_enc — VARBINARY(255) — 정산계좌(암호화)
  • representative_name — VARCHAR(50)
  • phone — VARCHAR(20)
  • email — VARCHAR(120)
  • approved_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

shipping

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • recipient — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • zipcode — VARCHAR(10)
  • address — VARCHAR(255) — NOT NULL
  • address_detail — VARCHAR(255)
  • memo — VARCHAR(200)
  • carrier — VARCHAR(50)
  • tracking_no — VARCHAR(50)
  • shipped_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL

stock_hold

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • sale_form_id — BIGINT — Foreign key → sale_form.id — NOT NULL
  • qty — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — HELD | COMMITTED | RELEASED
  • expires_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL