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 — 처리완료일시