CreditPurchaseOrderSubscriptionDetails


Columns

Column Type Size Nulls Auto Default Children Parents Comments
creditPurchaseOrderId uuid 2147483647 null
CreditPurchaseOrders.id CreditPurchaseOrderSubscriptionDetai_creditPurchaseOrderId_fkey C
creditProductPurchaseOrderId uuid 2147483647 null
CreditProductPurchaseOrders.id CreditPurchaseOrderSubscripti_creditProductPurchaseOrderId_fkey C
paymentFrequencyTimePeriod int4 10 null
paymentFrequencyTimePeriodUnit "employer_purchases"."enum_employer_purchases_timePeriodUnit" 2147483647 null
companyProductSubscriptionId uuid 2147483647 √ null
CompanyProductSubscriptions.id CreditPurchaseOrderSubscripti_companyProductSubscriptionId_fkey R
freeTrialOfferId uuid 2147483647 √ null
CompanyProductSubscriptionFreeTrialOffers.id CreditPurchaseOrderSubscriptionDetails_freeTrialOfferId_fkey R
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CreditPurchaseOrderSubscriptionDetails_pkey Primary key Asc creditPurchaseOrderId
CreditPurchaseOrderSubscriptionDetails_companyProductSubscripti Must be unique Asc companyProductSubscriptionId

Check Constraints

Constraint Name Constraint
CreditPurchaseOrderSubscriptio_paymentFrequencyTimePeriod_check (("paymentFrequencyTimePeriod" > 0))

Relationships

Close relationships within degrees of separation