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