| id |
uuid |
|
false |
|
|
Unique identifier of the payment.(DC2Type:uuid) |
| status |
varchar(255) |
|
false |
|
|
Current status of the payment (PENDING, SUCCEEDED, FAILED, EXPIRED). |
| total_amount |
bigint |
|
false |
|
|
|
| total_currency |
character(3) |
|
false |
|
|
(DC2Type:currency) |
| stripe_client_secret |
varchar(255) |
NULL::character varying |
true |
|
|
Stripe client secret for payment intent initialization. |
| is_paid |
boolean |
false |
false |
|
|
Whether the payment has been successfully completed. |
| paid_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
The date and time when the payment was successfully completed.(DC2Type:datetimetz_immutable) |
| voucher_id |
uuid |
|
true |
|
public.voucher |
Optional voucher applied to reduce the payment amount.(DC2Type:uuid) |
| stripe_payment_intent_id |
varchar(255) |
NULL::character varying |
true |
|
|
Unique Stripe payment intent identifier. |
| payment_source |
varchar(255) |
NULL::character varying |
true |
|
|
Payment source: ONLINE (Stripe) or POS (point of sale). |
| expired_at |
timestamp(0) with time zone |
NULL::timestamp with time zone |
true |
|
|
The date and time when the payment expired without completion.(DC2Type:datetimetz_immutable) |
| voucher_redemption_id |
uuid |
|
true |
|
public.voucher_redemption |
Voucher redemption record if a voucher was used.(DC2Type:uuid) |
| cart_id |
uuid |
|
false |
|
public.cart |
Cart associated with this payment.(DC2Type:uuid) |
