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