TossPayments Reccuring Billing

Tables (8)

DiscountCoupon (할인 쿠폰)

  • Key (Id) — Guid — Primary key — NOT NULL

FreeTrialCoupon (무료 기간 쿠폰)

  • Key (Id) — Guid — Primary key — NOT NULL

Patient (회원)

  • Key (PatientId) — string — Primary key — NOT NULL

PeriodicPaymentInfo (기간별 결제 정보)

  • Key (Id) — Guid — Primary key — NOT NULL
  • Field (Title) — string — NOT NULL
  • Field (MonthlyAmount) — int — NOT NULL
  • Field (TotalAmount) — int — NOT NULL
  • Field (Days) — int — NOT NULL
  • Field (OrderName) — string — NOT NULL

ReccuringBillingSubscribers (자동결제 구독자)

  • Key (Id) — Guid — Primary key — NOT NULL
  • Key (PatientId) — string — Foreign key → Patient.Key — NOT NULL
  • Key (RecentTossPaymentHistory) — Guid — Foreign key → TossPaymentHistory.Key — NOT NULL
  • Field (SubscriptionStartDateTime) — DateTime — NOT NULL
  • Field (SubscriptionExpirationDateTime) — DateTime — NOT NULL
  • Field (IsRecurringBillingEnabled) — Boolean — NOT NULL

TossBillingKeyAndCard (토스 빌링키와 카드)

  • Key (Id) — Guid — Primary key — NOT NULL
  • Key (PatientId) — string — Foreign key → Patient.Key — NOT NULL
  • Unique (CustomerKey) — Guid — NOT NULL
  • Field (AuthenticatedAt) — DateTime — NOT NULL
  • Field (BillingKey) — string — NOT NULL
  • Field (CardCompany) — string — NOT NULL
  • Field (CardNumber) — string — NOT NULL

TossPayment (토스 결제)

  • Key (Id) — Guid — Primary key — NOT NULL
  • Key (PatientId) — string — Foreign key → Patient.Key — NOT NULL

TossPaymentHistory (토스 결제 기록)

  • Key (Id) — Guid — Primary key — NOT NULL
  • Key (PatientId) — string — Foreign key → Patient.Key — NOT NULL
  • Key (TossBillingKeyAndCardId) — Guid — Foreign key → TossBillingKeyAndCard.Key — NOT NULL
  • Key (PeriodicPaymentInfoId) — Guid — Foreign key → PeriodicPaymentInfo.Key — NOT NULL
  • Key (TossPaymentId) — Guid — Foreign key → TossPayment.Key
  • Key (DiscountCouponId) — Guid — Foreign key → DiscountCoupon.Key
  • Key (FreeTrialCoupon) — Guid — Foreign key → FreeTrialCoupon.Key
  • Field (PaymentDateTime) — DateTime — NOT NULL
  • Field (SubscriptionExpirationDateTime) — DateTime — NOT NULL