# ChargeDesk schema ERD

Table and field reference for the Fivetran ChargeDesk connector.

## Table & Field Reference

### agent_activity_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action_params | Unknown |  |
| action_reason | Unknown |  |
| action_type | Unknown |  |
| company | Unknown |  |
| context | Unknown |  |
| description | Unknown |  |
| event | Unknown |  |
| ip | Unknown |  |
| object_type | Unknown |  |
| occurred | Instant |  |
| params | Unknown |  |
| source | Unknown |  |
| sub_description | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| amount_formatted | Unknown |  |
| amount_symbol | Unknown |  |
| billing_cycles_total | Unknown |  |
| chargeable | Unknown |  |
| charges | Unknown |  |
| company | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| first_seen | Instant |  |
| gateway_id | Unknown |  |
| has_agent_log | Unknown |  |
| interval | Unknown |  |
| interval_count | Unknown |  |
| logs | Json |  |
| name | Unknown |  |
| quantity | Unknown |  |
| readable_interval | Unknown |  |
| setup_amount | Unknown |  |
| status | Unknown |  |
| support_url | Unknown |  |
| taxable | Unknown |  |
| trial_period_days | Unknown |  |
| url | Unknown |  |

### subscrption_cancellation_log

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| action | Unknown |  |
| email | Unknown |  |
| ip | Unknown |  |
| method | Unknown |  |
| occurred | Instant |  |
| reason | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| subscription_id | Unknown | FK |
| amount | Unknown |  |
| amount_formatted | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| percents | Unknown |  |
| quantity | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| product_id | Unknown | FK |
| accurate_at | Instant |  |
| amount | Unknown |  |
| amount_formatted | Unknown |  |
| amount_symbol | Unknown |  |
| billing_cycles_current | Unknown |  |
| billing_cycles_total | Unknown |  |
| canceled_at | Instant |  |
| charges | Unknown |  |
| company | Unknown |  |
| currency | Unknown |  |
| current_period_end | Instant |  |
| current_period_start | Instant |  |
| ended_at | Instant |  |
| first_seen | Instant |  |
| gateway_id | Unknown |  |
| gateway_url | Unknown |  |
| has_items | Unknown |  |
| has_meta | Unknown |  |
| interval | Unknown |  |
| interval_count | Unknown |  |
| last_email | Instant |  |
| logs | Json |  |
| manage_url | Unknown |  |
| metadata | Json |  |
| methods_active | Json |  |
| methods_supported | Json |  |
| object | Unknown |  |
| product_desc | Unknown |  |
| quantity | Unknown |  |
| readable_interval | Unknown |  |
| setup_amount | Unknown |  |
| status | Unknown |  |
| status_text | Unknown |  |
| trial_end | Instant |  |
| trial_period_days | Unknown |  |
| trial_start | Instant |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accurate_at | Instant |  |
| billing_address | Unknown |  |
| card_on_file | Unknown |  |
| charges | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| customer_company | Unknown |  |
| delinquent | Unknown |  |
| description | Unknown |  |
| edited | Unknown |  |
| email | Unknown |  |
| email_domain | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| first_seen | Instant |  |
| gateway_id | Unknown |  |
| gateway_url | Unknown |  |
| has_items | Unknown |  |
| invoice_details | Unknown |  |
| items | Json |  |
| last_charge_id | Unknown |  |
| last_paid_charge | Unknown |  |
| logs | Json |  |
| manage_url | Unknown |  |
| metadata | Json |  |
| methods_active | Json |  |
| methods_supported | Json |  |
| name | Unknown |  |
| object | Unknown |  |
| phone | Unknown |  |
| readable_country | Unknown |  |
| send_email_to | Unknown |  |
| shipping_address | Unknown |  |
| tax_number | Unknown |  |
| tax_number_abr | Unknown |  |
| tickets | Unknown |  |
| unsubscribe_authorize | Unknown |  |
| unsubscribe_receipts | Unknown |  |
| unsubscribe_refunds | Unknown |  |
| unsubscribe_void | Unknown |  |
| username | Unknown |  |
| website | Unknown |  |

### charge_preview_tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| product_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_formatted | Unknown |  |
| rate | Unknown |  |
| type | Unknown |  |

### charge_preview

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| product_id | Unknown | PK, FK |
| subtotal_amount | Unknown |  |
| subtotal_amount_formatted | Unknown |  |
| total_amount | Unknown |  |
| total_amount_formatted | Unknown |  |

### charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| product_id | Unknown | FK |
| subscription_id | Unknown | FK |
| accurate_at | Instant |  |
| added_tax | Unknown |  |
| amount | Unknown |  |
| amount_formatted | Unknown |  |
| amount_refunded | Unknown |  |
| amount_refunded_formatted | Unknown |  |
| amount_symbol | Unknown |  |
| amount_with_commas | Unknown |  |
| audited_job | Unknown |  |
| company | Unknown |  |
| currency | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_email_domain | Unknown |  |
| customer_name | Unknown |  |
| customer_phone | Unknown |  |
| customer_username | Unknown |  |
| description | Unknown |  |
| email_last_sent | Instant |  |
| failure_reason | Unknown |  |
| gateway_id | Unknown |  |
| gateway_url | Unknown |  |
| invoice_company | Unknown |  |
| invoice_download_url | Unknown |  |
| invoice_url | Unknown |  |
| is_paid | Unknown |  |
| last_4_digits | Unknown |  |
| logs | Json |  |
| manage_url | Unknown |  |
| metadata | Json |  |
| methods_active | Json |  |
| methods_supported | Json |  |
| name_email | Unknown |  |
| name_send_email | Unknown |  |
| object | Unknown |  |
| occurred | Instant |  |
| occurred_formatted | Unknown |  |
| occurred_relative | Unknown |  |
| payment_method | Unknown |  |
| payment_method_bank | Unknown |  |
| payment_method_brand | Unknown |  |
| payment_method_describe | Unknown |  |
| product_desc | Unknown |  |
| refunded_at | Instant |  |
| refunded_at_formatted | Unknown |  |
| sent_authorize | Unknown |  |
| sent_dunning | Unknown |  |
| sent_invoice | Unknown |  |
| sent_invoice_reminder | Unknown |  |
| sent_receipt | Unknown |  |
| sent_refund_receipt | Unknown |  |
| sent_void | Unknown |  |
| statement_description | Unknown |  |
| status | Unknown |  |
| status_text | Unknown |  |
| support_email | Unknown |  |
| support_url | Unknown |  |
| transaction_id | Unknown |  |

## Relationships

- subscrption_cancellation_log(customer_id) → customer(id)
- subscrption_cancellation_log(subscription_id) → subscription(id)
- item(subscription_id) → subscription(id)
- subscription(product_id) → product(id)
- subscription(customer_id) → customer(id)
- charge_preview_tax_rate(product_id) → charge_preview(product_id)
- charge_preview(product_id) → product(id)
- charge(product_id) → product(id)
- charge(subscription_id) → subscription(id)
- charge(customer_id) → customer(id)