Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
|||
| invoiceNo | text | 2147483647 | null |
|
|
invoiceNo in 2C2P response - maps to creditPurchaseOrderId in our database |
||
| transactionDateTime | text | 2147483647 | null |
|
|
transactionDateTime in 2C2P response |
||
| transactionStatusCode | text | 2147483647 | null |
|
|
respCode in 2C2P response - Transaction status code |
||
| transactionStatusDescription | text | 2147483647 | null |
|
|
respDesc in 2C2P response - Transaction status description |
||
| paymentId | text | 2147483647 | null |
|
|
paymentID in 2C2P response - Unique payment identifier |
||
| status | enum_PaymentToken2C2PWebhookLogs_type | 2147483647 | null |
|
|
|||
| metadata | jsonb | 2147483647 | null |
|
|
Complete 2C2P PaymentResponse object |
||
| createdAt | timestamptz | 35,6 | now() |
|
|
|||
| updatedAt | timestamptz | 35,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PaymentToken2C2PWebhookLogs_pkey | Primary key | Asc | id |
| PaymentToken2C2PWebhookLogs_invoiceNo_idx | Must be unique | Asc | invoiceNo |
| PaymentToken2C2PWebhookLogs_invoiceNo_search_idx | Performance | Asc | invoiceNo |
Relationships
Close relationships within degrees of separation
