# Recharge schema ERD

Table and field reference for the Fivetran Recharge connector.

## Table & Field Reference

### event_updated_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| attribute | Unknown |  |
| previous_value | Unknown |  |
| value | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| object_id | Unknown |  |
| object_type | Unknown |  |
| source_account_email | Unknown |  |
| source_account_id | Unknown |  |
| source_api_token_id | Unknown |  |
| source_api_token_name | Unknown |  |
| source_origin | Unknown |  |
| source_user_type | Unknown |  |
| verb | Unknown |  |
| custom_** |  |  |

### payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | FK |
| billing_address_address_1 | String |  |
| billing_address_address_2 | String |  |
| billing_address_city | String |  |
| billing_address_company | String |  |
| billing_address_country_code | String |  |
| billing_address_first_name | String |  |
| billing_address_last_name | String |  |
| billing_address_phone | String |  |
| billing_address_province | String |  |
| billing_address_zip | String |  |
| created_at | Instant |  |
| default_payment_method | Boolean |  |
| payment_details_brand | String |  |
| payment_details_exp_month | String |  |
| payment_details_exp_year | String |  |
| payment_details_last_4 | String |  |
| payment_type | String |  |
| processor_customer_token | String |  |
| processor_name | String |  |
| processor_payment_method_token | String |  |
| status | String |  |
| status_reason | String |  |
| updated_at | Instant |  |

### credit_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| available_balance | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| expires_at | Unknown |  |
| initial_value | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### bundle_selection_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bundle_selection_id | Unknown | PK, FK |
| collection_id | Unknown |  |
| collection_source | Unknown |  |
| created_at | Unknown |  |
| external_product_id | Unknown |  |
| external_variant_id | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| updated_at | Unknown |  |

### bundle_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| charge_id | Unknown | FK |
| order_id | Unknown | FK |
| bundle_variant_id | Unknown |  |
| created_at | Unknown |  |
| external_product_id | Unknown |  |
| external_variant_id | Unknown |  |
| is_fallback | Unknown |  |
| purchase_item_id | Unknown |  |
| updated_at | Instant |  |

### credit_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_account_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| ending_balance | Unknown |  |
| note | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### metafield

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| description | String |  |
| key | String |  |
| namespace | String |  |
| owner_id | String |  |
| owner_resource | String |  |
| updated_at | Instant |  |
| value | Json |  |
| value_type | String |  |

### discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| applies_once | Boolean |  |
| applies_to_id | Json |  |
| applies_to_product_type | String |  |
| applies_to_resource | String |  |
| automatic_redemptions_per_customer | Long |  |
| code | String |  |
| created_at | Instant |  |
| ends_at | Instant |  |
| minimum_order_amount | Long |  |
| starts_at | Instant |  |
| status | String |  |
| updated_at | Instant |  |
| usage_limit | Long |  |
| usage_limits_first_time_customer_restriction | Boolean |  |
| usage_limits_max_subsequent_redemptions | Long |  |
| usage_limits_one_application_per_customer | Boolean |  |
| usage_limits_redemptions | Long |  |
| value | Double |  |
| value_type | String |  |

### subscription_utm_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| subscription_id | Long | FK |
| campaign | String |  |
| content | String |  |
| data_source | String |  |
| medium | String |  |
| source | String |  |
| term | String |  |
| time_stamp | Instant |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| address_id | Long | FK |
| customer_id | Long | FK |
| cancellation_reason | String |  |
| cancellation_reason_comments | String |  |
| cancelled_at | Instant |  |
| charge_interval_frequency | Long |  |
| created_at | Instant |  |
| expire_after_specific_number_of_charges | Int |  |
| external_product_id_ecommerce | String |  |
| external_variant_id_ecommerce | String |  |
| next_charge_scheduled_at | LocalDate |  |
| number_charges_until_expiration | Int |  |
| order_day_of_month | Int |  |
| order_day_of_week | Int |  |
| order_interval_frequency | Long |  |
| order_interval_unit | String |  |
| price | String |  |
| product_title | String |  |
| quantity | Int |  |
| shopify_product_id | Long |  |
| shopify_variant_id | Long |  |
| sku | String |  |
| status | String |  |
| updated_at | Instant |  |
| variant_title | String |  |
| property_** |  |  |

### subscription_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| address_id | Unknown | FK |
| customer_id | Unknown | FK |
| cancellation_reason | String |  |
| cancellation_reason_comments | String |  |
| cancelled_at | Instant |  |
| charge_interval_frequency | Long |  |
| created_at | Instant |  |
| expire_after_specific_number_of_charges | Int |  |
| external_product_id_ecommerce | String |  |
| external_variant_id_ecommerce | String |  |
| next_charge_scheduled_at | LocalDate |  |
| number_charges_until_expiration | Int |  |
| order_day_of_month | Int |  |
| order_day_of_week | Int |  |
| order_interval_frequency | Long |  |
| order_interval_unit | String |  |
| price | String |  |
| product_title | String |  |
| quantity | Int |  |
| shopify_product_id | Long |  |
| shopify_variant_id | Long |  |
| sku | String |  |
| status | String |  |
| variant_title | String |  |
| property_** |  |  |

### plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| channel_settings_api_display | Boolean |  |
| channel_settings_checkout_page_display | Boolean |  |
| channel_settings_customer_portal_display | Boolean |  |
| channel_settings_merchant_portal_display | Boolean |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| discount_amount | String |  |
| discount_type | String |  |
| product_id_ecommerce | String |  |
| sort_order | Long |  |
| subscription_preference_charge_interval_frequency | Long |  |
| subscription_preference_cutoff_day_of_month | Long |  |
| subscription_preference_cutoff_day_of_week | Long |  |
| subscription_preference_expire_after_specific_number_of_charges | Long |  |
| subscription_preference_interval_unit | String |  |
| subscription_preference_order_day_of_month | Long |  |
| subscription_preference_order_day_of_week | Long |  |
| subscription_preference_order_interval_frequency | Long |  |
| title | String |  |
| type | String |  |
| updated_at | Instant |  |

### one_time_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| address_id | Long | FK |
| customer_id | Long | FK |
| created_at | Instant |  |
| external_product_id_ecommerce | String |  |
| external_variant_id_ecommerce | String |  |
| next_charge_scheduled_at | String |  |
| price | String |  |
| product_title | String |  |
| quantity | Long |  |
| sku | String |  |
| updated_at | Instant |  |
| variant_title | String |  |
| property_** |  |  |

### charge_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| charge_id | Long | PK, FK |
| price | String |  |
| rate | String |  |
| title | String |  |

### charge_activity_payment_method_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| charge_activity_index | Int | PK, FK |
| charge_id | Long | PK, FK |
| payment_method_id | Long | FK |
| brand | String |  |
| exp_month | Long |  |
| exp_year | Long |  |
| last_4 | String |  |
| payment_type | String |  |

### charge_activity

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| charge_id | Long | PK, FK |
| address_id | Long | FK |
| customer_id | Long | FK |
| payment_method_id | Long | FK |
| activity_sub_type | String |  |
| activity_type | String |  |
| charge_amount | Double |  |
| charge_attempts | Double |  |
| created_at | Instant |  |
| description | String |  |
| external_payment_method_id | String |  |
| id | Long |  |
| links | Json |  |
| order_id | Long |  |
| presentment_currency | String |  |
| store_id | Long |  |
| suggested_solution | String |  |
| updated_at | Instant |  |

### charge_shipping_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| charge_id | Long | PK, FK |
| code | String |  |
| price | Double |  |
| title | String |  |

### charge_order_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| charge_id | Long | PK, FK |
| order_attribute | Json |  |

### charge_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| charge_id | Long | PK, FK |
| external_product_id_ecommerce | String |  |
| external_variant_id_ecommerce | String |  |
| grams | Double |  |
| purchase_item_id | Long |  |
| purchase_item_type | String |  |
| quantity | Long |  |
| sku | String |  |
| tax_due | String |  |
| taxable | Boolean |  |
| taxable_amount | String |  |
| title | String |  |
| total_price | String |  |
| unit_price | String |  |
| unit_price_includes_tax | Boolean |  |
| variant_title | String |  |
| vendor | String |  |
| property_** |  |  |

### charge_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| charge_id | Long | PK, FK |
| id | Unknown | FK |
| code | String |  |
| value | Double |  |
| value_type | String |  |

### charge_utm_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| charge_id | Long | FK |
| campaign | String |  |
| content | String |  |
| data_source | String |  |
| medium | String |  |
| source | String |  |
| term | String |  |
| time_stamp | Instant |  |

### charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| address_id | Long | FK |
| customer_id | Long | FK |
| billing_address_address_1 | String |  |
| billing_address_address_2 | String |  |
| billing_address_city | String |  |
| billing_address_company | String |  |
| billing_address_country_code | String |  |
| billing_address_first_name | String |  |
| billing_address_last_name | String |  |
| billing_address_phone | String |  |
| billing_address_province | String |  |
| billing_address_zip | String |  |
| charge_attempts | Double |  |
| client_details_browser_ip | String |  |
| client_details_user_agent | String |  |
| created_at | Instant |  |
| currency | String |  |
| customer_hash | String |  |
| email | String |  |
| error | String |  |
| error_type | String |  |
| external_order_id_ecommerce | String |  |
| external_transaction_id_payment_processor | String |  |
| external_variant_id_not_found | Boolean |  |
| has_uncommited_changes | Boolean |  |
| note | String |  |
| orders_count | Long |  |
| payment_processor | String |  |
| processed_at | Instant |  |
| retry_date | Instant |  |
| scheduled_at | LocalDate |  |
| shipping_address_address_1 | String |  |
| shipping_address_address_2 | String |  |
| shipping_address_city | String |  |
| shipping_address_company | String |  |
| shipping_address_country_code | String |  |
| shipping_address_first_name | String |  |
| shipping_address_last_name | String |  |
| shipping_address_phone | String |  |
| shipping_address_province | String |  |
| shipping_address_zip | String |  |
| status | String |  |
| subtotal_price | Double |  |
| tags | String |  |
| tax_lines | Double |  |
| total_discounts | Double |  |
| total_line_items_price | Double |  |
| total_price | Double |  |
| total_refunds | Double |  |
| total_tax | Double |  |
| total_weight_grams | Double |  |
| type | String |  |
| updated_at | Instant |  |

### address_discounts

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| address_id | Long | PK, FK |
| id | Long |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | FK |
| payment_method_id | Long | FK |
| address_1 | String |  |
| address_2 | String |  |
| city | String |  |
| company | String |  |
| country_code | String |  |
| created_at | Instant |  |
| first_name | String |  |
| last_name | String |  |
| order_note | String |  |
| phone | String |  |
| province | String |  |
| updated_at | Instant |  |
| zip | String |  |
| cart_attribute_** |  |  |

### address_shipping_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| address_id | Long | PK, FK |
| code | String |  |
| price | String |  |
| title | String |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| order_id | Long | PK, FK |
| external_product_id_ecommerce | String |  |
| external_variant_id_ecommerce | String |  |
| grams | Double |  |
| product_title | String |  |
| purchase_item_id | Long |  |
| purchase_item_type | String |  |
| quantity | Long |  |
| sku | String |  |
| tax_due | String |  |
| taxable | Boolean |  |
| taxable_amount | String |  |
| title | String |  |
| total_price | String |  |
| unit_price | String |  |
| unit_price_includes_tax | Boolean |  |
| variant_title | String |  |
| property_** |  |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| address_id | Long | FK |
| charge_id | Long | FK |
| customer_id | Long | FK |
| billing_address_address_1 | String |  |
| billing_address_address_2 | String |  |
| billing_address_city | String |  |
| billing_address_company | String |  |
| billing_address_country_code | String |  |
| billing_address_first_name | String |  |
| billing_address_last_name | String |  |
| billing_address_phone | String |  |
| billing_address_province | String |  |
| billing_address_zip | String |  |
| charge_status | String |  |
| created_at | Instant |  |
| email | String |  |
| external_cart_token | String |  |
| external_order_id_ecommerce | String |  |
| external_order_number_ecommerce | String |  |
| is_prepaid | Boolean |  |
| processed_at | Instant |  |
| scheduled_at | Instant |  |
| shipped_date | Instant |  |
| shipping_address_address_1 | String |  |
| shipping_address_address_2 | String |  |
| shipping_address_city | String |  |
| shipping_address_company | String |  |
| shipping_address_country_code | String |  |
| shipping_address_first_name | String |  |
| shipping_address_last_name | String |  |
| shipping_address_phone | String |  |
| shipping_address_province | String |  |
| shipping_address_zip | String |  |
| status | String |  |
| total_price | String |  |
| transaction_id | String |  |
| type | String |  |
| updated_at | Instant |  |

### customer_utm_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| customer_id | Long | PK, FK |
| campaign | String |  |
| content | String |  |
| data_source | String |  |
| medium | String |  |
| source | String |  |
| term | String |  |
| time_stamp | Instant |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| email | String |  |
| external_customer_id_ecommerce | String |  |
| first_charge_processed_at | Instant |  |
| first_name | String |  |
| has_payment_method_in_dunning | Boolean |  |
| has_valid_payment_method | Boolean |  |
| hash | String |  |
| last_name | String |  |
| subscriptions_active_count | Int |  |
| subscriptions_total_count | Int |  |
| tax_exempt | Boolean |  |
| updated_at | Instant |  |

### customer_delivery_schedule_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_fivetran_id | Unknown | PK, FK |
| customer_id | Unknown | FK |
| external_product_id_ecommerce | Unknown |  |
| external_variant_id_ecommerce | Unknown |  |
| images | Json |  |
| is_prepaid | Unknown |  |
| is_skippable | Unknown |  |
| is_skipped | Unknown |  |
| offer_attributes | Unknown |  |
| original_price | Unknown |  |
| plan_type | Unknown |  |
| product_title | Unknown |  |
| quantity | Unknown |  |
| subscription_id | Unknown |  |
| subtotal_price | Unknown |  |
| unit_price | Unknown |  |
| variant_title | Unknown |  |
| custom_** |  |  |

### customer_delivery_schedule_order

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| address_id | Unknown | FK |
| charge_id | Unknown | FK |
| customer_id | Unknown | FK |
| id | Unknown | FK |
| payment_method_id | Unknown | FK |
| currency | Unknown |  |
| scheduled_deliveries_date | Unknown |  |
| shipping_address_address_1 | Unknown |  |
| shipping_address_address_2 | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country_code | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_province | Unknown |  |
| shipping_address_zip | Unknown |  |

### checkout_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| checkout_token | String | PK, FK |
| charge_interval_frequency | Long |  |
| cutoff_day_of_month | String |  |
| cutoff_day_of_week | String |  |
| expire_after_specific_number_of_charges | String |  |
| first_recurring_charge_delay | String |  |
| fulfillment_service | String |  |
| grams | Int |  |
| image | String |  |
| line_price | String |  |
| order_day_of_month | String |  |
| order_day_of_week | String |  |
| order_interval_frequency | Long |  |
| order_interval_unit | String |  |
| order_interval_unit_type | String |  |
| original_price | String |  |
| price | String |  |
| product_id | Long |  |
| product_type | String |  |
| properties | Json |  |
| quantity | Int |  |
| recurring_price | String |  |
| requires_shipping | Boolean |  |
| sku | String |  |
| tax_code | String |  |
| taxable | Boolean |  |
| title | String |  |
| type | String |  |
| variant_id | Long |  |
| variant_title | String |  |
| vendor | String |  |

### checkout_utm_tag

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| checkout_token | String | FK |
| campaign | String |  |
| content | String |  |
| data_source | String |  |
| medium | String |  |
| source | String |  |
| term | String |  |
| time_stamp | Instant |  |

### checkout

| Column | Type | Keys |
| --- | --- | --- |
| token | String | PK |
| charge_id | Long | FK |
| applied_discounts | Json |  |
| billing_address_address_1 | String |  |
| billing_address_address_2 | String |  |
| billing_address_city | String |  |
| billing_address_company | String |  |
| billing_address_country_code | String |  |
| billing_address_first_name | String |  |
| billing_address_last_name | String |  |
| billing_address_phone | String |  |
| billing_address_province | String |  |
| billing_address_zip | String |  |
| buyer_accepts_marketing | Boolean |  |
| completed_at | Instant |  |
| created_at | Instant |  |
| currency | String |  |
| discount_code | String |  |
| email | String |  |
| external_checkout_id | String |  |
| external_checkout_source | String |  |
| external_transaction_id_payment_processor | String |  |
| order_attributes | Json |  |
| phone | String |  |
| requires_shipping | Boolean |  |
| shipping_address_address_1 | String |  |
| shipping_address_address_2 | String |  |
| shipping_address_city | String |  |
| shipping_address_company | String |  |
| shipping_address_country_code | String |  |
| shipping_address_first_name | String |  |
| shipping_address_last_name | String |  |
| shipping_address_phone | String |  |
| shipping_address_province | String |  |
| shipping_address_validations_country_is_supported | Boolean |  |
| shipping_address_validations_ups | Boolean |  |
| shipping_address_zip | String |  |
| subtotal_price | String |  |
| taxes_included | Boolean |  |
| total_price | String |  |
| total_tax | String |  |
| updated_at | Instant |  |

## Relationships

- event_updated_attribute(event_id) → event(id)
- event(customer_id) → customer(id)
- payment_method(customer_id) → customer(id)
- credit_account(customer_id) → customer(id)
- bundle_selection_item(bundle_selection_id) → bundle_selection(id)
- bundle_selection(order_id) → orders(id)
- bundle_selection(charge_id) → charge(id)
- credit_adjustment(credit_account_id) → credit_account(id)
- subscription_utm_tag(subscription_id) → subscription(id)
- subscription(address_id) → address(id)
- subscription(customer_id) → customer(id)
- subscription_history(address_id) → address(id)
- subscription_history(customer_id) → customer(id)
- one_time_product(address_id) → address(id)
- one_time_product(customer_id) → customer(id)
- charge_tax_line(charge_id) → charge(id)
- charge_activity_payment_method_info(payment_method_id) → payment_method(id)
- charge_activity_payment_method_info(charge_id) → charge_activity(charge_id)
- charge_activity_payment_method_info(charge_activity_index) → charge_activity(index)
- charge_activity(payment_method_id) → payment_method(id)
- charge_activity(address_id) → address(id)
- charge_activity(customer_id) → customer(id)
- charge_activity(charge_id) → charge(id)
- charge_shipping_line(charge_id) → charge(id)
- charge_order_attribute(charge_id) → charge(id)
- charge_line_item(charge_id) → charge(id)
- charge_discount(charge_id) → charge(id)
- charge_discount(id) → discount(id)
- charge_utm_tag(charge_id) → charge(id)
- charge(address_id) → address(id)
- charge(customer_id) → customer(id)
- address_discounts(address_id) → address(id)
- address(payment_method_id) → payment_method(id)
- address(customer_id) → customer(id)
- address_shipping_line(address_id) → address(id)
- order_line_item(order_id) → orders(id)
- orders(address_id) → address(id)
- orders(customer_id) → customer(id)
- orders(charge_id) → charge(id)
- customer_utm_tag(customer_id) → customer(id)
- customer_delivery_schedule_order_line_item(order_fivetran_id) → customer_delivery_schedule_order(_fivetran_id)
- customer_delivery_schedule_order_line_item(customer_id) → customer(id)
- customer_delivery_schedule_order(id) → orders(id)
- customer_delivery_schedule_order(address_id) → address(id)
- customer_delivery_schedule_order(charge_id) → charge(id)
- customer_delivery_schedule_order(payment_method_id) → payment_method(id)
- customer_delivery_schedule_order(customer_id) → customer(id)
- checkout_line_item(checkout_token) → checkout(token)
- checkout_utm_tag(checkout_token) → checkout(token)
- checkout(charge_id) → charge(id)