Afterpay
Explore the interactive ERD
Table & Field Reference
payment_order_detail_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
payment_id | Unknown | PKFK |
categories | Json | |
estimated_shipment_date | Unknown | |
image_url | Unknown | |
name | Unknown | |
page_url | Unknown | |
price | Unknown | |
price_currency | Unknown | |
quantity | Unknown | |
sku | Unknown |
payment_order_detail_discount
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
payment_id | Unknown | PKFK |
discount_amount | Unknown | |
discount_amount_currency | Unknown | |
display_name | Unknown |
payment_refund
| Column | Type | Keys |
|---|---|---|
refund_id | Unknown | PK |
payment_id | Unknown | PKFK |
refund_amount | Unknown | |
refund_amount_currency | Unknown | |
refund_merchant_reference | Unknown | |
refunded_at | Unknown | |
request_id | Unknown |
payment_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payment_id | Unknown | PKFK |
created | Unknown | |
event_amount | Unknown | |
event_amount_currency | Unknown | |
expires | Unknown | |
payment_event_merchant_reference | Unknown | |
type | Unknown |
payment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
billing_area_1 | Unknown | |
billing_area_2 | Unknown | |
billing_country_code | Unknown | |
billing_line_1 | Unknown | |
billing_line_2 | Unknown | |
billing_name | Unknown | |
billing_phone_number | Unknown | |
billing_postcode | Unknown | |
billing_region | Unknown | |
consumer_email | Unknown | |
consumer_given_name | Unknown | |
consumer_phone_number | Unknown | |
consumer_surname | Unknown | |
courier_name | Unknown | |
courier_priority | Unknown | |
courier_shipped_at | Unknown | |
courier_tracking | Unknown | |
created | Unknown | |
merchant_reference | Unknown | |
open_to_capture_amount | Unknown | |
open_to_capture_amount_currency | Unknown | |
original_amount | Unknown | |
original_amount_currency | Unknown | |
payment_state | Unknown | |
shipping_amount | Unknown | |
shipping_amount_currency | Unknown | |
shipping_area_1 | Unknown | |
shipping_area_2 | Unknown | |
shipping_country_code | Unknown | |
shipping_line_1 | Unknown | |
shipping_line_2 | Unknown | |
shipping_name | Unknown | |
shipping_phone_number | Unknown | |
shipping_postcode | Unknown | |
shipping_region | Unknown | |
status | Unknown | |
tax_amount | Unknown | |
tax_amount_currency | Unknown | |
token | Unknown |