commerce_payment_system

Tables (13)

cart

  • id — BIGINT — 장바구니 ID
  • member_id — BIGINT — NOT NULL — 회원 FK
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

cart_item

  • id — BIGINT — 장바구니상품 ID
  • cart_id — BIGINT — NOT NULL — 장바구니 FK
  • product_id — BIGINT — NOT NULL — 상품 FK
  • quantity — INT — NOT NULL — 수량
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

category

  • id — BIGINT — 카테고리 ID
  • name — VARCHAR(100) — NOT NULL — 카테고리명
  • created_at — TIMESTAMP — NOT NULL — 생성일시

member

  • id — BIGINT — 회원 ID
  • email — VARCHAR(255) — NOT NULL — 이메일
  • password — VARCHAR(255) — NOT NULL — 암호화된 비밀번호
  • name — VARCHAR(100) — NOT NULL — 회원명
  • phone — VARCHAR(20) — NOT NULL — 전화번호
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

order_item

  • id — BIGINT — 주문상품 ID
  • order_id — BIGINT — NOT NULL — 주문 FK
  • product_id — BIGINT — NOT NULL — 상품 FK
  • product_name_snapshot — VARCHAR(255) — NOT NULL — 주문시점 상품명
  • product_price_snapshot — INT — NOT NULL — 주문시점 가격
  • quantity — INT — NOT NULL — 주문 수량
  • refunded_quantity — INT — NOT NULL — 환불된 수량
  • created_at — TIMESTAMP — NOT NULL — 생성일시

orders

  • id — BIGINT — 주문 ID
  • member_id — BIGINT — NOT NULL — 회원 FK
  • order_number — VARCHAR(50) — NOT NULL — 주문번호
  • status — VARCHAR(20) — NOT NULL — 주문상태(PENDING_PAYMENT/COMPLETED/CANCELLED)
  • total_amount — INT — NOT NULL — 주문 총액
  • created_at — TIMESTAMP — NOT NULL — 주문일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

payment

  • id — BIGINT — 결제 ID
  • order_id — BIGINT — NOT NULL — 주문 FK
  • portone_payment_id — VARCHAR(100) — NOT NULL — PortOne 결제식별자
  • status — VARCHAR(30) — NOT NULL — 결제상태(PENDING/COMPLETED/FAILED/PARTIALLY_REFUNDED/FULLY_REFUNDED)
  • total_amount — INT — NOT NULL — 총 결제금액
  • pg_amount — INT — NOT NULL — PG 실결제금액
  • point_amount — INT — NOT NULL — 포인트 사용금액
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

point_balance

  • id — BIGINT — 포인트잔액 ID
  • member_id — BIGINT — NOT NULL — 회원 FK
  • balance — INT — NOT NULL — 현재 잔액(음수허용)
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

point_transaction

  • id — BIGINT — 거래 ID
  • member_id — BIGINT — NOT NULL — 회원 FK
  • payment_id — BIGINT — 결제 FK
  • type — VARCHAR(20) — NOT NULL — 거래유형(EARN/USE/EARN_CANCEL/USE_CANCEL)
  • amount — INT — NOT NULL — 거래금액
  • balance_after — INT — NOT NULL — 거래후 잔액
  • created_at — TIMESTAMP — NOT NULL — 거래일시

product

  • id — BIGINT — 상품 ID
  • category_id — BIGINT — NOT NULL — 카테고리 FK
  • name — VARCHAR(255) — NOT NULL — 상품명
  • description — TEXT — 상품 설명
  • price — INT — NOT NULL — 판매가
  • stock_quantity — INT — NOT NULL — 재고 수량
  • status — VARCHAR(20) — NOT NULL — 판매상태(ON_SALE/SOLD_OUT)
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • updated_at — TIMESTAMP — NOT NULL — 수정일시

refund

  • id — BIGINT — 환불 ID
  • payment_id — BIGINT — NOT NULL — 결제 FK
  • reason — VARCHAR(500) — NOT NULL — 환불 사유
  • total_refund_amount — INT — NOT NULL — 총 환불금액
  • pg_refund_amount — INT — NOT NULL — PG 환불금액
  • point_refund_amount — INT — NOT NULL — 포인트 환불금액
  • created_at — TIMESTAMP — NOT NULL — 환불일시

refund_item

  • id — BIGINT — 환불상품 ID
  • refund_id — BIGINT — NOT NULL — 환불 FK
  • order_item_id — BIGINT — NOT NULL — 주문상품 FK
  • quantity — INT — NOT NULL — 환불 수량
  • refund_amount — INT — NOT NULL — 환불 금액
  • created_at — TIMESTAMP — NOT NULL — 생성일시

webhook_event

  • id — BIGINT — 웹훅 ID
  • portone_payment_id — VARCHAR(100) — NOT NULL — PortOne 결제식별자
  • event_type — VARCHAR(50) — NOT NULL — 이벤트 유형
  • idempotency_key — VARCHAR(255) — NOT NULL — 멱등성 키
  • status — VARCHAR(20) — NOT NULL — 처리상태(RECEIVED/PROCESSING/SUCCESS/FAILED/SKIPPED)
  • raw_payload — TEXT — 원본 페이로드
  • error_message — VARCHAR(500) — 에러 메시지
  • received_at — TIMESTAMP — NOT NULL — 수신일시
  • processed_at — TIMESTAMP — 처리완료일시