Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| creditPurchaseOrderId | uuid | 2147483647 | null |
|
|
||||||
| paymentToken | text | 2147483647 | null |
|
|
paymentToken field in 2C2P response |
|||||
| webPaymentUrl | text | 2147483647 | √ | null |
|
|
webPaymentUrl field in 2C2P response (optional, empty for QR payments) |
||||
| requestedAt | timestamptz | 35,6 | null |
|
|
Timestamp of API call to 2C2P |
|||||
| expiryAt | timestamptz | 35,6 | null |
|
|
Computed during request based on paymentExpiry passed in payload |
|||||
| paidAt | timestamptz | 35,6 | √ | null |
|
|
transactionDateTime in 2C2P webhook payload |
||||
| metadata | jsonb | 2147483647 | null |
|
|
Complete 2C2P Payment Token Response object |
|||||
| createdAt | timestamptz | 35,6 | now() |
|
|
||||||
| updatedAt | timestamptz | 35,6 | now() |
|
|
||||||
| paymentResponseMetadata | jsonb | 2147483647 | √ | null |
|
|
Complete 2C2P Payment Response object from webhook or enquiry |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CreditPurchaseOrder2C2PPaymentRequests_pkey | Primary key | Asc | creditPurchaseOrderId |
| CreditPurchaseOrder2C2PPaymentRequests_paymentToken_key | Must be unique | Asc | paymentToken |
Relationships
Close relationships within degrees of separation
