Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
||||||
| providerCode | "employer_purchases"."enum_PaymentProviders_providerCode" | 2147483647 | null |
|
|
||||||
| providerName | varchar | 32 | null |
|
|
||||||
| countryCode | varchar | 8 | null |
|
|
||||||
| envType | "employer_purchases"."enum_PaymentProviders_envType" | 2147483647 | null |
|
|
||||||
| merchantId | varchar | 64 | √ | null |
|
|
|||||
| apiKey | varchar | 512 | null |
|
|
||||||
| signPublicKey | text | 2147483647 | √ | null |
|
|
|||||
| certificate | text | 2147483647 | √ | null |
|
|
|||||
| signatureAlgo | varchar | 32 | √ | null |
|
|
|||||
| baseUrl | varchar | 255 | null |
|
|
||||||
| paymentApiDetails | jsonb | 2147483647 | null |
|
|
||||||
| timeoutInMs | int4 | 10 | √ | 30000 |
|
|
|||||
| currency | varchar | 8 | null |
|
|
||||||
| paymentMethods | jsonb | 2147483647 | √ | null |
|
|
|||||
| webhookToken | varchar | 255 | √ | null |
|
|
|||||
| webhookSigningSecret | varchar | 255 | √ | null |
|
|
|||||
| status | "employer_purchases"."enum_PaymentProviders_status" | 2147483647 | null |
|
|
||||||
| processingConfig | jsonb | 2147483647 | √ | null |
|
|
|||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
||||||
| paymentSource | "employer_purchases"."enum_PaymentProviders_paymentSource" | 2147483647 | null |
|
|
||||||
| renewalMode | "employer_purchases"."enum_PaymentProviders_renewalMode" | 2147483647 | null |
|
|
AUTO: The provider natively manages subscription renewals, processing them automatically without requiring our system to initiate each cycle. TRIGGER: The provider does not support automatic subscription management, or its integration model requires our system to explicitly initiate each renewal cycle. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PaymentProviders_pkey | Primary key | Asc | id |
| PaymentProviders_countryCode_idx | Performance | Asc | countryCode |
| PaymentProviders_envType_idx | Performance | Asc | envType |
| PaymentProviders_paymentSource_idx | Performance | Asc | paymentSource |
| PaymentProviders_providerCode_countryCode_envType_paymentSource | Must be unique | Asc/Asc/Asc/Asc | providerCode + countryCode + envType + paymentSource |
| PaymentProviders_providerCode_idx | Performance | Asc | providerCode |
| PaymentProviders_renewalMode_idx | Performance | Asc | renewalMode |
| PaymentProviders_status_idx | Performance | Asc | status |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| PaymentProviders_webhookToken_webhookSigningSecret_check | ((("webhookToken" IS NOT NULL) OR ("webhookSigningSecret" IS NOT NULL))) |
Relationships
Close relationships within degrees of separation
