# Afterpay schema ERD

Table and field reference for the Fivetran Afterpay connector.

## Table & Field Reference

### payment_order_detail_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payment_id | Unknown | PK, FK |
| 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 | PK, FK |
| discount_amount | Unknown |  |
| discount_amount_currency | Unknown |  |
| display_name | Unknown |  |

### payment_refund

| Column | Type | Keys |
| --- | --- | --- |
| refund_id | Unknown | PK |
| payment_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- payment_order_detail_item(payment_id) → payment(id)
- payment_order_detail_discount(payment_id) → payment(id)
- payment_refund(payment_id) → payment(id)
- payment_event(payment_id) → payment(id)