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