cloudpayment

Tables (13)

OrderItem (주문 상품)

  • Id (주문 상품 Id) — BIGINT PK — Primary key — NOT NULL
  • productName (상품명) — VARCHAR(32) — NOT NULL
  • unitPrice (상품가격) — BIGINT — NOT NULL
  • quantity (수량) — BIGINT — NOT NULL
  • orderId (주문Id) — BIGINT FK — Foreign key → order.Id — NOT NULL
  • productId (상품 Id) — BIGINT FK — Foreign key → product.Id — NOT NULL

PaymentMethod (결제 수단)

  • Id (결제수단 Id) — Primary key — NOT NULL
  • billingKey (Field)
  • customerUid (Field2)
  • pgProvider (enum)
  • isDefault (bolean)
  • PaymentMethodStatus (Field3)
  • paymentMethodUuid (Field4)

PointTransaction (포인트)

  • Id (포인트 PK) — Primary key — NOT NULL
  • userId (Field)
  • orderId (Field2)
  • points (Field3)
  • pointBalance (Field4)
  • PointTransactionType (Field5)
  • remainingPoints (Field6)
  • expiredAt (Field7) — LocalDateTime
  • Id (주문Id) — BIGINT PK — Foreign key → order.Id — NOT NULL
  • Id (사용자Id) — VARCHAR(255) — Foreign key → user.Id — NOT NULL

Subscription (구독)

  • Id (구독 Id) — Primary key — NOT NULL
  • subscriptionUuid (Field)
  • Id (사용자Id) — VARCHAR(255) — Foreign key → user.Id — NOT NULL
  • Id (플랜Id) — Foreign key → plan.Id — NOT NULL
  • SubscriptionStatus (Field2) — enum
  • Id (결제수단 Id) — Foreign key → PaymentMethod.Id — NOT NULL
  • currentPeriodEnd (Field3) — OffsetDateTime
  • canceledAt (Field4) — OffsetDateTime
  • amount (Field5)

SubscriptionBilling (구독 청구)

  • Id (청구 내역Id) — Primary key — NOT NULL
  • Id (구독 Id) — Foreign key → Subscription.Id — NOT NULL
  • amount (Field)
  • SubscriptionBillingStatus (Field2) — enum
  • paymentId (Field3)
  • attemptDate (Field4)
  • periodStart (Field5) — OffsetDateTime
  • periodEnd (Field6) — OffsetDateTime
  • failureMessage (Field7)
  • billingUuid (Field8)

membership (멤버십)

  • Id (멤버십Id) — VARCHAR(255) — Primary key — NOT NULL
  • Id (사용자Id) — VARCHAR(255) — Foreign key → user.Id — NOT NULL
  • grade (멤버십 등급) — enum — NOT NULL

order (주문)

  • Id (주문Id) — BIGINT PK — Primary key — NOT NULL
  • orderNumber (주문번호) — VARCHAR(50) — NOT NULL
  • totalAmount (주문 총액) — BIGINT — NOT NULL
  • orderStatus (상태) — ENUM — NOT NULL
  • createdAt (주문일) — DATETIME — NOT NULL
  • userId (사용자Id) — BIGINT FK — Foreign key → user.Id — NOT NULL
  • usedPointAmount (사용 포인트)
  • finalAmount (최종 결제 금액)

payment (결제)

  • Id (결제Id) — Primary key — NOT NULL
  • Id (주문Id) — VARCHAR(255) — Foreign key → order.Id — NOT NULL
  • portOneId (포트원 결제 Id)
  • paidAmount (결제 금액) — NOT NULL
  • paidStatus (결제 상태) — ENUM — NOT NULL
  • createdAt (결제 시작 시작) — NOT NULL
  • paitAt (결제 완료 시각) — OffsetDateTime
  • refundedAt (환불/취소일)
  • pointsToUse (Field)

plan (플랜)

  • Id (플랜Id) — Primary key — NOT NULL
  • name (Field)
  • amount (Field2)
  • billingCycle (Field3)
  • active (Field4) — boolean
  • planUuid (Field5)

product (상품)

  • Id (상품 Id) — BIGINT PK — Primary key — NOT NULL
  • name (상품명) — VARCHAR(32) — NOT NULL
  • price (판매가) — BIGINT — NOT NULL
  • stock (재고) — BIGINT — NOT NULL
  • description (설명) — TEXT — NOT NULL
  • productStatus (상품 상태) — BIGINT FK — NOT NULL
  • productCategory (카테고리) — ENUM — NOT NULL

refund (환불)

  • Id (환불Id) — BIGINT PK — Primary key — NOT NULL
  • refundAmount (환불 금액) — BIGINT — NOT NULL
  • refundReason (환불 사유) — TEXT — NOT NULL
  • refundStatus (환불 상태) — ENUM — NOT NULL
  • refundedAt (환불 처리 시각) — OffsetDateTime — NOT NULL
  • Id (결제Id) — Foreign key → payment.Id — NOT NULL

user (사용자)

  • Id (사용자Id) — VARCHAR(255) — Primary key — NOT NULL
  • name (사용자 이름) — VARCHAR(32) — NOT NULL
  • email (사용자 이메일) — VARCHAR(320) — NOT NULL
  • phoneNumber (사용자 전화번호) — NOT NULL
  • password (사용자 비밀번호) — VARCHAR(32) — NOT NULL
  • pointBalance (Field)
  • totalPaymentAmount (Field2)
  • membershipGrade (Field3) — enum — NOT NULL
  • customerUid (Field4)

webhock (웹훅)

  • Key — Primary key — NOT NULL
  • webhookUuid (Field)
  • portOneId (Field2)
  • eventStatus (Field3)
  • WebhookStatus (Field4) — enum