# Paddle schema ERD

Table and field reference for the Fivetran Paddle connector.

## Table & Field Reference

### price_unit_price_override

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| price_id | Unknown | PK, FK |
| amount | Unknown |  |
| country_code | Unknown |  |
| currency_code | Unknown |  |

### price

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| billing_cycle_frequency | Unknown |  |
| billing_cycle_interval | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| import_meta_external_id | Unknown |  |
| import_meta_imported_from | Unknown |  |
| name | Unknown |  |
| quantity_maximum | Unknown |  |
| quantity_minimum | Unknown |  |
| status | Unknown |  |
| tax_mode | Unknown |  |
| trial_period_frequency | Unknown |  |
| trial_period_interval | Unknown |  |
| type | Unknown |  |
| unit_price_amount | Unknown |  |
| unit_price_currency_code | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### customer_business_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_business_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |

### customer_business

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| company_number | Unknown |  |
| created_at | Unknown |  |
| import_meta_external_id | Unknown |  |
| import_meta_imported_from | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| tax_identifier | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### subscription_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| price_id | Unknown | FK |
| product_id | Unknown | FK |
| created_at | Unknown |  |
| next_billed_at | Unknown |  |
| previously_billed_at | Unknown |  |
| quantity | Unknown |  |
| recurring | Unknown |  |
| status | Unknown |  |
| trial_date_ends_at | Unknown |  |
| trial_date_starts_at | Unknown |  |
| updated_at | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_id | Unknown | FK |
| business_id | Unknown | FK |
| customer_id | Unknown | FK |
| billing_cycle_frequency | Unknown |  |
| billing_cycle_interval | Unknown |  |
| billing_details_additional_information | Unknown |  |
| billing_details_enable_checkout | Unknown |  |
| billing_details_purchase_order_number | Unknown |  |
| canceled_at | Unknown |  |
| collection_mode | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| current_billing_period_ends_at | Unknown |  |
| current_billing_period_starts_at | Unknown |  |
| discount_ends_at | Unknown |  |
| discount_id | Unknown |  |
| discount_starts_at | Unknown |  |
| first_billed_at | Unknown |  |
| import_meta_external_id | Unknown |  |
| import_meta_imported_from | Unknown |  |
| management_url_cancel | Unknown |  |
| management_url_update_payment_method | Unknown |  |
| next_billed_at | Unknown |  |
| paused_at | Unknown |  |
| payment_term_frequency | Unknown |  |
| payment_term_interval | Unknown |  |
| scheduled_change_action | Unknown |  |
| scheduled_change_effective_at | Unknown |  |
| scheduled_change_resume_at | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### adjustment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adjustment_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| amount | Unknown |  |
| type | Unknown |  |

### adjustment_tax_rates_used

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| adjustment_id | Unknown | PK, FK |
| tax_rate | Unknown |  |

### adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| subscription_id | Unknown | FK |
| transaction_id | Unknown | FK |
| action | Unknown |  |
| created_at | Unknown |  |
| credit_applied_to_balance | Unknown |  |
| currency_code | Unknown |  |
| payout_total_chargeback_fee_amount | Unknown |  |
| payout_total_currency_code | Unknown |  |
| payout_total_earning | Unknown |  |
| payout_total_fee | Unknown |  |
| reason | Unknown |  |
| status | Unknown |  |
| total_currency_code | Unknown |  |
| total_earning | Unknown |  |
| total_fee | Unknown |  |
| updated_at | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| price_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| image_url | Unknown |  |
| import_meta_external_id | Unknown |  |
| import_meta_imported_from | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| tax_category | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| import_meta_external_id | Unknown |  |
| import_meta_imported_from | Unknown |  |
| locale | Unknown |  |
| marketing_consent | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### transaction_payment

| Column | Type | Keys |
| --- | --- | --- |
| payment_attempt_id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| amount | Unknown |  |
| captured_at | Unknown |  |
| created_at | Unknown |  |
| error_code | Unknown |  |
| method_card_cardholder_name | Unknown |  |
| method_card_expiry_month | Unknown |  |
| method_card_expiry_year | Unknown |  |
| method_card_last_4 | Unknown |  |
| method_card_type | Unknown |  |
| method_detail_type | Unknown |  |
| payment_method_id | Unknown |  |
| status | Unknown |  |

### transaction_detail_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| price_id | Unknown | FK |
| product_id | Unknown | FK |
| proration_billing_period_ends_at | Unknown |  |
| proration_billing_period_starts_at | Unknown |  |
| proration_rate | Unknown |  |
| quantity | Unknown |  |
| tax_rate | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adjustment_id | Unknown | FK |
| business_id | Unknown | FK |
| customer_id | Unknown | FK |
| subscription_id | Unknown | FK |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_created_at | Unknown |  |
| address_customer_id | Unknown |  |
| address_description | Unknown |  |
| address_first_line | Unknown |  |
| address_id | Unknown |  |
| address_import_meta_external_id | Unknown |  |
| address_import_meta_imported_from | Unknown |  |
| address_postal_code | Unknown |  |
| address_region | Unknown |  |
| address_second_line | Unknown |  |
| address_status | Unknown |  |
| address_updated_at | Unknown |  |
| adjusted_payout_total_chargeback_fee_amount | Unknown |  |
| adjusted_payout_total_earning | Unknown |  |
| adjusted_payout_total_fee | Unknown |  |
| adjusted_payout_total_original_amount | Unknown |  |
| adjusted_payout_total_original_currency_code | Unknown |  |
| adjusted_total_currency_code | Unknown |  |
| adjusted_total_earning | Unknown |  |
| adjusted_total_fee | Unknown |  |
| available_payment_methods | Json |  |
| billed_at | Unknown |  |
| billing_details_additional_information | Unknown |  |
| billing_details_enable_checkout | Unknown |  |
| billing_details_payment_frequency | Unknown |  |
| billing_details_payment_interval | Unknown |  |
| billing_details_purchase_order_number | Unknown |  |
| billing_period_ends_at | Unknown |  |
| billing_period_starts_at | Unknown |  |
| checkout_url | Unknown |  |
| collection_mode | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| discount_id | Unknown |  |
| invoice_id | Unknown |  |
| invoice_number | Unknown |  |
| origin | Unknown |  |
| payout_total_balance | Unknown |  |
| payout_total_credit | Unknown |  |
| payout_total_credit_to_balance | Unknown |  |
| payout_total_discount | Unknown |  |
| payout_total_earnings | Unknown |  |
| payout_total_fee | Unknown |  |
| receipt_data | Unknown |  |
| revised_at | Unknown |  |
| status | Unknown |  |
| total_balance | Unknown |  |
| total_credit | Unknown |  |
| total_discount | Unknown |  |
| total_earnings | Unknown |  |
| total_fee | Unknown |  |
| updated_at | Unknown |  |
| address_custom_** |  |  |
| custom_** |  |  |

## Relationships

- price_unit_price_override(price_id) → price(id)
- price(product_id) → product(id)
- customer_business_contact(customer_business_id) → customer_business(id)
- customer_business(customer_id) → customer(id)
- subscription_item(product_id) → product(id)
- subscription_item(price_id) → price(id)
- subscription_item(subscription_id) → subscription(id)
- subscription(address_id) → transaction(id)
- subscription(customer_id) → customer(id)
- subscription(business_id) → customer_business(id)
- adjustment_item(item_id) → transaction_detail_line_item(id)
- adjustment_item(adjustment_id) → adjustment(id)
- adjustment_tax_rates_used(adjustment_id) → adjustment(id)
- adjustment(subscription_id) → subscription(id)
- adjustment(customer_id) → customer(id)
- adjustment(transaction_id) → transaction(id)
- product(price_id) → price(id)
- transaction_payment(transaction_id) → transaction(id)
- transaction_detail_line_item(price_id) → price(id)
- transaction_detail_line_item(product_id) → product(id)
- transaction_detail_line_item(transaction_id) → transaction(id)
- transaction(adjustment_id) → adjustment(id)
- transaction(subscription_id) → subscription(id)
- transaction(customer_id) → customer(id)
- transaction(business_id) → customer_business(id)