# Chargebee Product Catalog 1.0 schema ERD

Table and field reference for the Fivetran Chargebee Product Catalog 1.0 connector.

## Table & Field Reference

### gift_timeline

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| gift_id | Unknown | PK, FK |
| occurred_at | Unknown |  |
| status | Unknown |  |

### gift

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| gift_receiver_customer_id | Unknown | FK |
| gift_receiver_subscription_id | Unknown | FK |
| gifter_customer_id | Unknown | FK |
| gifter_invoice_id | Unknown | FK |
| auto_claim | Unknown |  |
| claim_expiry_date | Unknown |  |
| gift_receiver_email | Unknown |  |
| gift_receiver_first_name | Unknown |  |
| gift_receiver_last_name | Unknown |  |
| gift_timelines | Unknown |  |
| gifter_object | Unknown |  |
| gifter_signature | Unknown |  |
| no_expiry | Unknown |  |
| object | Unknown |  |
| resource_version | Unknown |  |
| scheduled_at | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### credit_note_invoice_allocation

| Column | Type | Keys |
| --- | --- | --- |
| credit_note_id | Unknown | PK, FK |
| invoice_id | Unknown | PK, FK |
| allocated_amount | Unknown |  |
| allocated_at | Unknown |  |
| invoice_date | Unknown |  |
| invoice_status | Unknown |  |

### credit_note_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| customer_id | Unknown | FK |
| reference_line_item_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_decimal | Unknown |  |
| date_from | Unknown |  |
| date_to | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| entity_description | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| is_taxed | Unknown |  |
| item_level_discount_amount | Unknown |  |
| object | Unknown |  |
| pricing_model | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |
| tax_amount | Unknown |  |
| tax_exempt_reason | Unknown |  |
| tax_rate | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |

### credit_note_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| is_non_compliance_tax | Unknown |  |
| is_partial_tax_applied | Unknown |  |
| local_currency_code | Unknown |  |
| tax_amount | Unknown |  |
| tax_amount_in_local_currency | Unknown |  |
| tax_juris_code | Unknown |  |
| tax_juris_name | Unknown |  |
| tax_juris_type | Unknown |  |
| tax_name | Unknown |  |
| tax_rate | Unknown |  |
| taxable_amount | Unknown |  |

### credit_note_line_item_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| coupon_id | Unknown | FK |
| line_item_id | Unknown | FK |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |

### credit_note_line_item_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| quantity_used | Unknown |  |
| quantity_used_in_decimal | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |

### credit_note_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| amount | Unknown |  |
| coupon_set_code | Unknown |  |
| description | Unknown |  |
| discount_percentage | Unknown |  |
| discount_type | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |

### credit_note_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| amount | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### credit_note_linked_refund

| Column | Type | Keys |
| --- | --- | --- |
| txn_id | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |
| refund_reason_code | Unknown |  |
| txn_amount | Unknown |  |
| txn_date | Unknown |  |
| txn_status | Unknown |  |

### credit_note_linked_tax_withheld_refund

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | PK, FK |
| amount | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| reference_number | Unknown |  |

### credit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| reference_invoice_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount_allocated | Unknown |  |
| amount_available | Unknown |  |
| amount_refunded | Unknown |  |
| base_currency_code | Unknown |  |
| business_entity_id | Unknown |  |
| channel | Unknown |  |
| create_reason_code | Unknown |  |
| credit_note_billing_address_city | Unknown |  |
| credit_note_billing_address_company | Unknown |  |
| credit_note_billing_address_country | Unknown |  |
| credit_note_billing_address_email | Unknown |  |
| credit_note_billing_address_first_name | Unknown |  |
| credit_note_billing_address_last_name | Unknown |  |
| credit_note_billing_address_line_1 | Unknown |  |
| credit_note_billing_address_line_2 | Unknown |  |
| credit_note_billing_address_line_3 | Unknown |  |
| credit_note_billing_address_object | Unknown |  |
| credit_note_billing_address_phone | Unknown |  |
| credit_note_billing_address_state | Unknown |  |
| credit_note_billing_address_state_code | Unknown |  |
| credit_note_billing_address_validation_status | Unknown |  |
| credit_note_billing_address_zip | Unknown |  |
| credit_note_shipping_address_city | Unknown |  |
| credit_note_shipping_address_company | Unknown |  |
| credit_note_shipping_address_country | Unknown |  |
| credit_note_shipping_address_email | Unknown |  |
| credit_note_shipping_address_first_name | Unknown |  |
| credit_note_shipping_address_index | Unknown |  |
| credit_note_shipping_address_last_name | Unknown |  |
| credit_note_shipping_address_line_1 | Unknown |  |
| credit_note_shipping_address_line_2 | Unknown |  |
| credit_note_shipping_address_line_3 | Unknown |  |
| credit_note_shipping_address_object | Unknown |  |
| credit_note_shipping_address_phone | Unknown |  |
| credit_note_shipping_address_state | Unknown |  |
| credit_note_shipping_address_state_code | Unknown |  |
| credit_note_shipping_address_validation_status | Unknown |  |
| credit_note_shipping_address_zip | Unknown |  |
| currency_code | Unknown |  |
| date | Unknown |  |
| deleted | Unknown |  |
| discounts | Unknown |  |
| e_invoice_id | Unknown |  |
| e_invoice_message | Unknown |  |
| e_invoice_status | Unknown |  |
| exchange_rate | Unknown |  |
| fractional_correction | Unknown |  |
| generated_at | Unknown |  |
| local_currency_code | Unknown |  |
| object | Unknown |  |
| price_type | Unknown |  |
| reason_code | Unknown |  |
| refunded_at | Unknown |  |
| resource_version | Unknown |  |
| round_off_amount | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| sub_total_in_local_currency | Unknown |  |
| taxes | Unknown |  |
| total | Unknown |  |
| total_in_local_currency | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| vat_number | Unknown |  |
| vat_number_prefix | Unknown |  |
| voided_at | Unknown |  |

### coupon_set_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| coupon_set_id | Unknown | PK, FK |
| value | Unknown |  |

### coupon_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| coupon_id | Unknown | FK |
| archived_count | Unknown |  |
| name | Unknown |  |
| redeemed_count | Unknown |  |
| total_count | Unknown |  |

### quote_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| customer_id | Unknown | FK |
| reference_line_item_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_decimal | Unknown |  |
| date_from | Unknown |  |
| date_to | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| entity_description | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| is_taxed | Unknown |  |
| item_level_discount_amount | Unknown |  |
| object | Unknown |  |
| pricing_model | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |
| tax_amount | Unknown |  |
| tax_exempt_reason | Unknown |  |
| tax_rate | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |

### quote_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| amount | Unknown |  |
| coupon_set_code | Unknown |  |
| description | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |

### quote_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| is_non_compliance_tax | Unknown |  |
| is_partial_tax_applied | Unknown |  |
| local_currency_code | Unknown |  |
| tax_amount | Unknown |  |
| tax_amount_in_local_currency | Unknown |  |
| tax_juris_code | Unknown |  |
| tax_juris_name | Unknown |  |
| tax_juris_type | Unknown |  |
| tax_name | Unknown |  |
| tax_rate | Unknown |  |
| taxable_amount | Unknown |  |

### quote_line_item_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| coupon_id | Unknown | FK |
| line_item_id | Unknown | FK |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |

### quote_line_item_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| quantity_used | Unknown |  |
| quantity_used_in_decimal | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |

### quote_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| quote_id | Unknown | PK, FK |
| amount | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| invoice_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount_due | Unknown |  |
| amount_paid | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_company | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_email | Unknown |  |
| billing_address_first_name | Unknown |  |
| billing_address_last_name | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_line_3 | Unknown |  |
| billing_address_object | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_state_code | Unknown |  |
| billing_address_validation_status | Unknown |  |
| billing_address_zip | Unknown |  |
| charge_on_acceptance | Unknown |  |
| contract_term_end | Unknown |  |
| contract_term_start | Unknown |  |
| contract_term_termination_fee | Unknown |  |
| credits_applied | Unknown |  |
| currency_code | Unknown |  |
| date | Unknown |  |
| deleted | Unknown |  |
| discounts | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| object | Unknown |  |
| operation_type | Unknown |  |
| po_number | Unknown |  |
| price_type | Unknown |  |
| resource_version | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_email | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_index | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_line_1 | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_line_3 | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_state_code | Unknown |  |
| shipping_address_validation_status | Unknown |  |
| shipping_address_zip | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| taxes | Unknown |  |
| total | Unknown |  |
| total_payable | Unknown |  |
| updated_at | Unknown |  |
| valid_till | Unknown |  |
| vat_number | Unknown |  |
| vat_number_prefix | Unknown |  |
| version | Unknown |  |

### subscription_renewal_invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| subscription_estimate_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount | Unknown |  |
| date_from | Unknown |  |
| date_to | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| is_taxed | Unknown |  |
| item_level_discount_amount | Unknown |  |
| object | Unknown |  |
| pricing_model | Unknown |  |
| quantity | Unknown |  |
| tax_amount | Unknown |  |
| unit_amount | Unknown |  |

### subscription_estimate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| subscription_estimate_id | Unknown | PK, FK |

### subscription_renewal_invoice_estimate

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| subscription_estimate_id | Unknown | PK, FK |

### subscription_renewal_credit_note_estimate

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| subscription_estimate_id | Unknown | PK, FK |

### subscription_renewal_unbilled_charge_estimate

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| subscription_estimate_id | Unknown | PK, FK |

### subscription_renewal_estimate

| Column | Type | Keys |
| --- | --- | --- |
| subscription_estimate_id | Unknown | PK, FK |
| customer_id | Unknown | FK |
| created_at | Unknown |  |
| invoice_estimate_amount_due | Unknown |  |
| invoice_estimate_amount_paid | Unknown |  |
| invoice_estimate_credits_applied | Unknown |  |
| invoice_estimate_currency_code | Unknown |  |
| invoice_estimate_line_item_discounts | Json |  |
| invoice_estimate_line_item_taxes | Json |  |
| invoice_estimate_object | Unknown |  |
| invoice_estimate_price_type | Unknown |  |
| invoice_estimate_recurring | Unknown |  |
| invoice_estimate_round_off_amount | Unknown |  |
| invoice_estimate_sub_total | Unknown |  |
| invoice_estimate_taxes | Json |  |
| invoice_estimate_total | Unknown |  |
| object | Unknown |  |
| subscription_estimate_currency_code | Unknown |  |
| subscription_estimate_next_billing_at | Unknown |  |
| subscription_estimate_object | Unknown |  |
| subscription_estimate_pause_date | Unknown |  |
| subscription_estimate_resume_date | Unknown |  |
| subscription_estimate_status | Unknown |  |
| subscription_estimate_trial_end_action | Unknown |  |

### payment_source_mandate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_source_id | Unknown | PK, FK |
| subscription_id | Unknown | FK |
| created_at | Unknown |  |

### payment_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| amazon_payment_agreement_id | Unknown |  |
| amazon_payment_email | Unknown |  |
| bank_account_bank_name | Unknown |  |
| bank_account_direct_debit_scheme | Unknown |  |
| bank_account_echeck_type | Unknown |  |
| bank_account_email | Unknown |  |
| bank_account_first_name | Unknown |  |
| bank_account_holder_type | Unknown |  |
| bank_account_last_4 | Unknown |  |
| bank_account_last_name | Unknown |  |
| bank_account_mandate_id | Unknown |  |
| bank_account_name_on_account | Unknown |  |
| bank_account_type | Unknown |  |
| boleto_email | Unknown |  |
| boleto_first_name | Unknown |  |
| boleto_last_4 | Unknown |  |
| boleto_last_name | Unknown |  |
| business_entity_id | Unknown |  |
| card_billing_addr_1 | Unknown |  |
| card_billing_addr_2 | Unknown |  |
| card_billing_city | Unknown |  |
| card_billing_country | Unknown |  |
| card_billing_state | Unknown |  |
| card_billing_state_code | Unknown |  |
| card_billing_zip | Unknown |  |
| card_brand | Unknown |  |
| card_expiry_month | Unknown |  |
| card_expiry_year | Unknown |  |
| card_first_name | Unknown |  |
| card_funding_type | Unknown |  |
| card_iin | Unknown |  |
| card_last_4 | Unknown |  |
| card_last_name | Unknown |  |
| card_masked_number | Unknown |  |
| card_object | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| gateway | Unknown |  |
| gateway_account_id | Unknown |  |
| ip_address | Unknown |  |
| issuing_country | Unknown |  |
| klarna_pay_now_email | Unknown |  |
| object | Unknown |  |
| paypal_agreement_id | Unknown |  |
| paypal_email | Unknown |  |
| reference_id | Unknown |  |
| resource_version | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| upi_vpa | Unknown |  |
| venmo_user_name | Unknown |  |

### plan_applicable_addon

| Column | Type | Keys |
| --- | --- | --- |
| addon_id | Unknown | PK, FK |
| plan_id | Unknown | PK, FK |

### plan_event_based_addon

| Column | Type | Keys |
| --- | --- | --- |
| addon_id | Unknown | PK, FK |
| plan_id | Unknown | PK, FK |
| charge_once | Unknown |  |
| on_event | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |

### plan_attached_addon

| Column | Type | Keys |
| --- | --- | --- |
| addon_id | Unknown | PK, FK |
| plan_id | Unknown | PK, FK |
| billing_cycles | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |
| type | Unknown |  |

### plan_tax_provider_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| plan_id | Unknown | PK, FK |
| field_id | Unknown |  |
| field_value | Unknown |  |
| provider_name | Unknown |  |

### plan_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| plan_id | Unknown | PK, FK |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| price | Unknown |  |
| price_in_decimal | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |

### plan_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| plan_id | Unknown | PK, FK |
| value | Unknown |  |

### plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounting_category_1 | Unknown |  |
| accounting_category_2 | Unknown |  |
| accounting_category_3 | Unknown |  |
| accounting_category_4 | Unknown |  |
| accounting_code | Unknown |  |
| addon_applicability | Unknown |  |
| archived_at | Unknown |  |
| avalara_sale_type | Unknown |  |
| avalara_service_type | Unknown |  |
| avalara_transaction_type | Unknown |  |
| billing_cycles | Unknown |  |
| channel | Unknown |  |
| charge_model | Unknown |  |
| claim_url | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| enabled_in_hosted_pages | Unknown |  |
| enabled_in_portal | Unknown |  |
| ending_unit | Unknown |  |
| free_quantity | Unknown |  |
| free_quantity_in_decimal | Unknown |  |
| giftable | Unknown |  |
| hsn_code | Unknown |  |
| invoice_name | Unknown |  |
| invoice_notes | Unknown |  |
| is_shippable | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| period | Unknown |  |
| period_unit | Unknown |  |
| price | Unknown |  |
| price_in_decimal | Unknown |  |
| pricing_model | Unknown |  |
| quantity | Unknown |  |
| redirect_url | Unknown |  |
| resource_version | Unknown |  |
| setup_cost | Unknown |  |
| shipping_frequency_period | Unknown |  |
| shipping_frequency_period_unit | Unknown |  |
| show_description_in_invoices | Unknown |  |
| show_description_in_quotes | Unknown |  |
| sku | Unknown |  |
| starting_unit | Unknown |  |
| status | Unknown |  |
| tax_code | Unknown |  |
| tax_profile_id | Unknown |  |
| taxable | Unknown |  |
| taxjar_product_code | Unknown |  |
| trial_end_action | Unknown |  |
| trial_period | Unknown |  |
| trial_period_unit | Unknown |  |
| updated_at | Unknown |  |

### site_migration_detail

| Column | Type | Keys |
| --- | --- | --- |
| entity_id | Unknown | PK |
| entity_id_at_other_site | Unknown |  |
| entity_type | Unknown |  |
| migrated_at | Unknown |  |
| other_site_name | Unknown |  |
| status | Unknown |  |

### resent_order

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK, FK |
| resent_order_id | Unknown | PK, FK |
| amount | Unknown |  |
| reason | Unknown |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| invoice_line_item_id | Unknown | FK |
| amount | Unknown |  |
| amount_adjusted | Unknown |  |
| amount_paid | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| fulfillment_amount | Unknown |  |
| fulfillment_quantity | Unknown |  |
| is_shippable | Unknown |  |
| item_level_discount_amount | Unknown |  |
| refundable_credits | Unknown |  |
| refundable_credits_issued | Unknown |  |
| sku | Unknown |  |
| status | Unknown |  |
| tax_amount | Unknown |  |
| unit_price | Unknown |  |

### order_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| is_non_compliance_tax | Unknown |  |
| is_partial_tax_applied | Unknown |  |
| local_currency_code | Unknown |  |
| prorated_taxable_amount | Unknown |  |
| tax_amount | Unknown |  |
| tax_amount_in_local_currency | Unknown |  |
| tax_juris_code | Unknown |  |
| tax_juris_name | Unknown |  |
| tax_juris_type | Unknown |  |
| tax_name | Unknown |  |
| tax_rate | Unknown |  |
| taxable_amount | Unknown |  |

### order_line_item_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |

### order_linked_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |
| amount | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| gift_id | Unknown | FK |
| invoice_id | Unknown | FK |
| original_order_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount_adjusted | Unknown |  |
| amount_paid | Unknown |  |
| batch_id | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_company | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_email | Unknown |  |
| billing_address_first_name | Unknown |  |
| billing_address_last_name | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_line_3 | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_state_code | Unknown |  |
| billing_address_validation_status | Unknown |  |
| billing_address_zip | Unknown |  |
| cancellation_reason | Unknown |  |
| cancelled_at | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| currency_code | Unknown |  |
| deleted | Unknown |  |
| delivered_at | Unknown |  |
| discount | Unknown |  |
| document_number | Unknown |  |
| fulfillment_status | Unknown |  |
| gift_note | Unknown |  |
| invoice_round_off_amount | Unknown |  |
| is_gifted | Unknown |  |
| is_resent | Unknown |  |
| note | Unknown |  |
| order_date | Unknown |  |
| order_type | Unknown |  |
| paid_on | Unknown |  |
| payment_status | Unknown |  |
| price_type | Unknown |  |
| reference_id | Unknown |  |
| refundable_credits | Unknown |  |
| refundable_credits_issued | Unknown |  |
| resend_reason | Unknown |  |
| resent_status | Unknown |  |
| resource_version | Unknown |  |
| rounding_adjustement | Unknown |  |
| shipment_carrier | Unknown |  |
| shipped_at | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_email | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_index | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_line_1 | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_line_3 | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_state_code | Unknown |  |
| shipping_address_validation_status | Unknown |  |
| shipping_address_zip | Unknown |  |
| shipping_cut_off_date | Unknown |  |
| shipping_date | Unknown |  |
| status | Unknown |  |
| status_update_at | Unknown |  |
| sub_total | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| tracking_id | Unknown |  |
| tracking_url | Unknown |  |
| updated_at | Unknown |  |

### virtual_bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| account_number | Unknown |  |
| bank_name | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| email | Unknown |  |
| gateway | Unknown |  |
| gateway_account_id | Unknown |  |
| object | Unknown |  |
| reference_id | Unknown |  |
| resource_version | Unknown |  |
| routing_number | Unknown |  |
| scheme | Unknown |  |
| swift_code | Unknown |  |
| updated_at | Unknown |  |

### addon_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| addon_id | Unknown | PK, FK |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| price | Unknown |  |
| price_in_decimal | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |

### addon_tax_provider_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| addon_id | Unknown | PK, FK |
| field_id | Unknown |  |
| field_value | Unknown |  |
| provider_name | Unknown |  |

### addon_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| addon_id | Unknown | PK, FK |
| value | Unknown |  |

### addon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounting_category_1 | Unknown |  |
| accounting_category_2 | Unknown |  |
| accounting_category_3 | Unknown |  |
| accounting_category_4 | Unknown |  |
| accounting_code | Unknown |  |
| archived_at | Unknown |  |
| avalara_sale_type | Unknown |  |
| avalara_service_type | Unknown |  |
| avalara_transaction_type | Unknown |  |
| channel | Unknown |  |
| charge_type | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| enabled_in_portal | Unknown |  |
| ending_unit | Unknown |  |
| hsn_code | Unknown |  |
| included_in_mrr | Unknown |  |
| invoice_name | Unknown |  |
| invoice_notes | Unknown |  |
| is_shippable | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| period | Unknown |  |
| period_unit | Unknown |  |
| price | Unknown |  |
| price_in_decimal | Unknown |  |
| pricing_model | Unknown |  |
| proration_type | Unknown |  |
| resource_version | Unknown |  |
| shipping_frequency_period | Unknown |  |
| shipping_frequency_period_unit | Unknown |  |
| show_description_in_invoices | Unknown |  |
| show_description_in_quotes | Unknown |  |
| sku | Unknown |  |
| starting_unit | Unknown |  |
| status | Unknown |  |
| tax_code | Unknown |  |
| tax_profile_id | Unknown |  |
| taxable | Unknown |  |
| taxjar_product_code | Unknown |  |
| unit | Unknown |  |
| updated_at | Unknown |  |

### subscription_addon

| Column | Type | Keys |
| --- | --- | --- |
| addon_id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| subscription_updated_at | Unknown | FK |
| amount | Unknown |  |
| amount_in_decimal | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |
| remaining_billing_cycles | Unknown |  |
| trial_end | Unknown |  |
| unit_price | Unknown |  |
| unit_price_in_decimal | Unknown |  |

### subscription_event_based_addon

| Column | Type | Keys |
| --- | --- | --- |
| addon_id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| subscription_updated_at | Unknown | FK |
| charge_once | Unknown |  |
| on_event | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |
| unit_price | Unknown |  |
| unit_price_in_decimal | Unknown |  |

### subscription_charged_event_based_addon

| Column | Type | Keys |
| --- | --- | --- |
| addon_id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| subscription_updated_at | Unknown | FK |
| last_charged_at | Unknown |  |

### subscription_coupon

| Column | Type | Keys |
| --- | --- | --- |
| coupon_id | Unknown | PK, FK |
| subscription_id | Unknown | PK, FK |
| subscription_updated_at | Unknown | FK |
| applied_count | Unknown |  |
| apply_till | Unknown |  |
| coupon_code | Unknown |  |

### subscription_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| subscription_updated_at | Unknown | PK, FK |
| value | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| updated_at | Unknown | PK |
| customer_id | Unknown | FK |
| gift_id | Unknown | FK |
| payment_source_id | Unknown | FK |
| plan_id | Unknown | FK |
| activated_at | Unknown |  |
| affiliate_token | Unknown |  |
| auto_close_invoices | Unknown |  |
| auto_collection | Unknown |  |
| base_currency_code | Unknown |  |
| billing_period | Unknown |  |
| billing_period_unit | Unknown |  |
| business_entity_id | Unknown |  |
| cancel_reason | Unknown |  |
| cancel_reason_code | Unknown |  |
| cancel_schedule_created_at | Unknown |  |
| cancelled_at | Unknown |  |
| changes_scheduled_at | Unknown |  |
| channel | Unknown |  |
| contract_term_action_at_term_end | Unknown |  |
| contract_term_billing_cycle | Unknown |  |
| contract_term_billing_cycle_on_renewal | Unknown |  |
| contract_term_cancellation_cutoff_period | Unknown |  |
| contract_term_contract_end | Unknown |  |
| contract_term_contract_start | Unknown |  |
| contract_term_created_at | Unknown |  |
| contract_term_id | Unknown |  |
| contract_term_remaining_billing_cycles | Unknown |  |
| contract_term_status | Unknown |  |
| contract_term_total_contract_value | Unknown |  |
| contract_term_total_contract_value_before_tax | Unknown |  |
| create_pending_invoices | Unknown |  |
| created_at | Unknown |  |
| created_from_ip | Unknown |  |
| currency_code | Unknown |  |
| current_term_end | Unknown |  |
| current_term_start | Unknown |  |
| deleted | Unknown |  |
| due_invoices_count | Unknown |  |
| due_since | Unknown |  |
| exchange_rate | Unknown |  |
| free_period | Unknown |  |
| free_period_unit | Unknown |  |
| has_scheduled_advance_invoices | Unknown |  |
| has_scheduled_changes | Unknown |  |
| invoice_notes | Unknown |  |
| mrr | Unknown |  |
| next_billing_at | Unknown |  |
| offline_payment_method | Unknown |  |
| override_relationship | Unknown |  |
| pause_date | Unknown |  |
| plan_amount | Unknown |  |
| plan_amount_in_decimal | Unknown |  |
| plan_free_quantity | Unknown |  |
| plan_free_quantity_in_decimal | Unknown |  |
| plan_quantity | Unknown |  |
| plan_quantity_in_decimal | Unknown |  |
| plan_unit_price | Unknown |  |
| plan_unit_price_in_decimal | Unknown |  |
| po_number | Unknown |  |
| referral_info_account_id | Unknown |  |
| referral_info_campaign_id | Unknown |  |
| referral_info_coupon_code | Unknown |  |
| referral_info_destination_url | Unknown |  |
| referral_info_external_campaign_id | Unknown |  |
| referral_info_external_reference_id | Unknown |  |
| referral_info_friend_offer_type | Unknown |  |
| referral_info_notify_referral_system | Unknown |  |
| referral_info_post_purchase_widget_enabled | Unknown |  |
| referral_info_referral_code | Unknown |  |
| referral_info_referral_system | Unknown |  |
| referral_info_referrer_id | Unknown |  |
| referral_info_referrer_reward_type | Unknown |  |
| referral_info_reward_status | Unknown |  |
| remaining_billing_cycles | Unknown |  |
| resource_version | Unknown |  |
| resume_date | Unknown |  |
| setup_fee | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_email | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_line_1 | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_line_3 | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_state_code | Unknown |  |
| shipping_address_validation_status | Unknown |  |
| shipping_address_zip | Unknown |  |
| start_date | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| total_dues | Unknown |  |
| trial_end | Unknown |  |
| trial_end_action | Unknown |  |
| trial_start | Unknown |  |
| meta_data_** |  |  |

### promotional_credit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_decimal | Unknown |  |
| closing_balance | Unknown |  |
| created_at | Unknown |  |
| credit_type | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| done_by | Unknown |  |
| object | Unknown |  |
| reference | Unknown |  |
| type | Unknown |  |

### event_webhook

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| status | Unknown |  |

### event_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| event_id | Unknown | PK, FK |
| value | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| api_version | Unknown |  |
| event_type | Unknown |  |
| occurred_at | Unknown |  |
| origin_user | Unknown |  |
| source | Unknown |  |
| users | Unknown |  |
| webhook_status | Unknown |  |

### coupon_code

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| coupon_id | Unknown | FK |
| coupon_set_id | Unknown | FK |
| coupon_set_name | Unknown |  |
| status | Unknown |  |

### coupon_plan

| Column | Type | Keys |
| --- | --- | --- |
| coupon_id | Unknown | PK, FK |
| plan_id | Unknown | PK, FK |

### coupon_addon

| Column | Type | Keys |
| --- | --- | --- |
| addon_id | Unknown | PK, FK |
| coupon_id | Unknown | PK, FK |

### coupon_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| value | Unknown |  |

### coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| addon_constraint | Unknown |  |
| apply_on | Unknown |  |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| discount_amount | Unknown |  |
| discount_percentage | Unknown |  |
| discount_type | Unknown |  |
| duration_type | Unknown |  |
| included_in_mrr | Unknown |  |
| invoice_name | Unknown |  |
| invoice_notes | Unknown |  |
| max_redemptions | Unknown |  |
| name | Unknown |  |
| period | Unknown |  |
| period_unit | Unknown |  |
| plan_constraint | Unknown |  |
| redemptions | Unknown |  |
| resource_version | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| valid_till | Unknown |  |

### hosted_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_entity_id | Unknown |  |
| checkout_info | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| embed | Unknown |  |
| expires_at | Unknown |  |
| object | Unknown |  |
| pass_thru_content | Unknown |  |
| resource_version | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### unbilled_charge_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| unbilled_charge_id | Unknown | PK, FK |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| quantity_used | Unknown |  |
| quantity_used_in_decimal | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |

### unbilled_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_decimal | Unknown |  |
| currency_code | Unknown |  |
| date_from | Unknown |  |
| date_to | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| is_advance_charge | Unknown |  |
| is_voided | Unknown |  |
| object | Unknown |  |
| pricing_model | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |
| updated_at | Unknown |  |
| voided_at | Unknown |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| added_by | Unknown |  |
| created_at | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| notes | Unknown |  |
| type | Unknown |  |

### invoice_issued_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| cn_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| invoice_updated_at | Unknown | FK |

### invoice_adjustment_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| cn_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| invoice_updated_at | Unknown | FK |

### invoice_dunning_attempt

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_updated_at | Unknown | PK, FK |
| transaction_id | Unknown | FK |
| attempt | Unknown |  |
| created_at | Unknown |  |
| dunning_type | Unknown |  |
| txn_amount | Unknown |  |
| txn_status | Unknown |  |

### invoice_applied_credit

| Column | Type | Keys |
| --- | --- | --- |
| cn_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| invoice_updated_at | Unknown | FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |
| cn_create_reason_code | Unknown |  |
| cn_date | Unknown |  |
| cn_reason_code | Unknown |  |
| cn_status | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_updated_at | Unknown | PK, FK |
| customer_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount | Unknown |  |
| amount_in_decimal | Unknown |  |
| date_from | Unknown |  |
| date_to | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| entity_description | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| is_taxed | Unknown |  |
| item_level_discount_amount | Unknown |  |
| object | Unknown |  |
| pricing_model | Unknown |  |
| quantity | Unknown |  |
| quantity_in_decimal | Unknown |  |
| tax_amount | Unknown |  |
| tax_exempt_reason | Unknown |  |
| tax_rate | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |

### invoice_line_item_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_updated_at | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| is_non_compliance_tax | Unknown |  |
| is_partial_tax_applied | Unknown |  |
| local_currency_code | Unknown |  |
| prorated_taxable_amount | Unknown |  |
| tax_amount | Unknown |  |
| tax_amount_in_local_currency | Unknown |  |
| tax_juris_code | Unknown |  |
| tax_juris_name | Unknown |  |
| tax_juris_type | Unknown |  |
| tax_name | Unknown |  |
| tax_rate | Unknown |  |
| taxable_amount | Unknown |  |

### invoice_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_updated_at | Unknown | PK, FK |
| amount | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### invoice_line_item_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_updated_at | Unknown | PK, FK |
| coupon_id | Unknown | FK |
| line_item_id | Unknown | FK |
| discount_amount | Unknown |  |
| discount_type | Unknown |  |

### invoice_line_item_tier

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| invoice_updated_at | Unknown | FK |
| ending_unit | Unknown |  |
| ending_unit_in_decimal | Unknown |  |
| quantity_used | Unknown |  |
| quantity_used_in_decimal | Unknown |  |
| starting_unit | Unknown |  |
| starting_unit_in_decimal | Unknown |  |
| unit_amount | Unknown |  |
| unit_amount_in_decimal | Unknown |  |

### invoice_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_updated_at | Unknown | PK, FK |
| line_item_id | Unknown | FK |
| amount | Unknown |  |
| coupon_set_code | Unknown |  |
| description | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |

### invoice_linked_payment

| Column | Type | Keys |
| --- | --- | --- |
| txn_id | Unknown | PK |
| invoice_id | Unknown | FK |
| invoice_updated_at | Unknown | FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |
| txn_amount | Unknown |  |
| txn_date | Unknown |  |
| txn_status | Unknown |  |

### invoice_linked_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| invoice_updated_at | Unknown | FK |
| batch_id | Unknown |  |
| created_at | Unknown |  |
| document_number | Unknown |  |
| fulfillment_status | Unknown |  |
| order_type | Unknown |  |
| reference_id | Unknown |  |
| status | Unknown |  |

### invoice_note

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| invoice_updated_at | Unknown | PK, FK |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| note | Unknown |  |

### invoice_linked_taxes_withheld

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | FK |
| invoice_updated_at | Unknown | FK |
| amount | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| reference_number | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| updated_at | Unknown | PK |
| customer_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount_adjusted | Unknown |  |
| amount_due | Unknown |  |
| amount_paid | Unknown |  |
| amount_to_collect | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_company | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_email | Unknown |  |
| billing_address_first_name | Unknown |  |
| billing_address_last_name | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_line_3 | Unknown |  |
| billing_address_object | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_state_code | Unknown |  |
| billing_address_validation_status | Unknown |  |
| billing_address_zip | Unknown |  |
| channel | Unknown |  |
| credits_applied | Unknown |  |
| currency_code | Unknown |  |
| date | Unknown |  |
| deleted | Unknown |  |
| due_date | Unknown |  |
| dunning_status | Unknown |  |
| einvoice_id | Unknown |  |
| einvoice_message | Unknown |  |
| einvoice_reference_number | Unknown |  |
| einvoice_status | Unknown |  |
| exchange_rate | Unknown |  |
| expected_payment_date | Unknown |  |
| first_invoice | Unknown |  |
| generated_at | Unknown |  |
| has_advance_charges | Unknown |  |
| is_gifted | Unknown |  |
| is_written_off | Unknown |  |
| local_currency_code | Unknown |  |
| local_currency_exchange_rate | Unknown |  |
| net_term_days | Unknown |  |
| new_sales_amount | Unknown |  |
| next_retry_at | Unknown |  |
| notes | Unknown |  |
| paid_at | Unknown |  |
| payment_owner | Unknown |  |
| po_number | Unknown |  |
| price_type | Unknown |  |
| recurring | Unknown |  |
| resource_version | Unknown |  |
| round_off_amount | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_email | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_index | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_line_1 | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_line_3 | Unknown |  |
| shipping_address_object | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_state_code | Unknown |  |
| shipping_address_validation_status | Unknown |  |
| shipping_address_zip | Unknown |  |
| site_details_at_creation_organization_address_city | Unknown |  |
| site_details_at_creation_organization_address_country_code | Unknown |  |
| site_details_at_creation_organization_address_line_1 | Unknown |  |
| site_details_at_creation_organization_address_state | Unknown |  |
| site_details_at_creation_organization_address_zip | Unknown |  |
| site_details_at_creation_organization_email | Unknown |  |
| site_details_at_creation_organization_name | Unknown |  |
| site_details_at_creation_organization_phone | Unknown |  |
| site_details_at_creation_organization_website | Unknown |  |
| site_details_at_creation_timezone | Unknown |  |
| statement_descriptor | Unknown |  |
| statement_descriptor_id | Unknown |  |
| status | Unknown |  |
| sub_total | Unknown |  |
| sub_total_in_local_currency | Unknown |  |
| tax | Unknown |  |
| tax_category | Unknown |  |
| tax_origin_country | Unknown |  |
| tax_origin_registration_number | Unknown |  |
| tax_override_reason | Unknown |  |
| term_finalized | Unknown |  |
| total | Unknown |  |
| total_in_local_currency | Unknown |  |
| use_for_proration | Unknown |  |
| vat_number | Unknown |  |
| vat_number_prefix | Unknown |  |
| void_reason_code | Unknown |  |
| voided_at | Unknown |  |
| write_off_amount | Unknown |  |
| write_off_date | Unknown |  |

### transaction_refund

| Column | Type | Keys |
| --- | --- | --- |
| refund_transaction_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |

### transaction_linked_payment

| Column | Type | Keys |
| --- | --- | --- |
| linked_payments_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |

### transaction_invoice

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |

### transaction_linked_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| cn_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |
| applied_amount | Unknown |  |
| applied_at | Unknown |  |
| cn_reason_code | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| payment_source_id | Unknown | FK |
| reference_authorization_id | Unknown | FK |
| reference_transaction_id | Unknown | FK |
| refunded_txn_id | Unknown | FK |
| reversal_transaction_id | Unknown | FK |
| subscription_id | Unknown | FK |
| amount | Unknown |  |
| amount_capturable | Unknown |  |
| amount_unused | Unknown |  |
| authorization_reason | Unknown |  |
| currency_code | Unknown |  |
| custom_payment_method_id | Unknown |  |
| custom_payment_method_name | Unknown |  |
| date | Unknown |  |
| deleted | Unknown |  |
| error_cause_customer_message | Unknown |  |
| error_cause_id | Unknown |  |
| error_cause_merchant_message | Unknown |  |
| error_code | Unknown |  |
| error_detail_decline_code | Unknown |  |
| error_detail_decline_message | Unknown |  |
| error_detail_error_category | Unknown |  |
| error_detail_error_code | Unknown |  |
| error_detail_error_field | Unknown |  |
| error_detail_error_message | Unknown |  |
| error_detail_network_error_code | Unknown |  |
| error_detail_network_error_message | Unknown |  |
| error_detail_processor_error_code | Unknown |  |
| error_detail_processor_error_message | Unknown |  |
| error_detail_recommendation_code | Unknown |  |
| error_detail_recommendation_message | Unknown |  |
| error_detail_request_id | Unknown |  |
| error_text | Unknown |  |
| exchange_rate | Unknown |  |
| fraud_flag | Unknown |  |
| fraud_reason | Unknown |  |
| gateway | Unknown |  |
| gateway_account_id | Unknown |  |
| id_at_gateway | Unknown |  |
| iin | Unknown |  |
| initiator_type | Unknown |  |
| last_4 | Unknown |  |
| masked_card_number | Unknown |  |
| merchant_reference_id | Unknown |  |
| payment_method | Unknown |  |
| payment_method_details | Unknown |  |
| reference_number | Unknown |  |
| resource_version | Unknown |  |
| settled_at | Unknown |  |
| status | Unknown |  |
| three_d_secure | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| voided_at | Unknown |  |

### customer_referral_url

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| created_at | Unknown |  |
| referral_account_id | Unknown |  |
| referral_campaign_id | Unknown |  |
| referral_external_campaign_id | Unknown |  |
| referral_sharing_url | Unknown |  |
| referral_system | Unknown |  |
| updated_at | Unknown |  |

### customer_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| email | Unknown |  |
| enabled | Unknown |  |
| first_name | Unknown |  |
| label | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| send_account_email | Unknown |  |
| send_billing_email | Unknown |  |

### customer_balance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_id | Unknown | PK, FK |
| currency_code | Unknown |  |
| excess_payments | Unknown |  |
| promotional_credits | Unknown |  |
| refundable_credits | Unknown |  |
| unbilled_charges | Unknown |  |

### customer_tax_provider_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_id | Unknown | PK, FK |
| field_id | Unknown |  |
| field_value | Unknown |  |
| provider_name | Unknown |  |

### customer_entity_identifier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| scheme | Unknown |  |
| standard | Unknown |  |
| value | Unknown |  |

### customer_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| customer_id | Unknown | PK, FK |
| value | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| backup_payment_source_id | Unknown | FK |
| primary_payment_source_id | Unknown | FK |
| allow_direct_debit | Unknown |  |
| auto_close_invoices | Unknown |  |
| auto_collection | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_company | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_email | Unknown |  |
| billing_address_first_name | Unknown |  |
| billing_address_last_name | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_line_3 | Unknown |  |
| billing_address_object | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_state_code | Unknown |  |
| billing_address_validation_status | Unknown |  |
| billing_address_zip | Unknown |  |
| billing_date | Unknown |  |
| billing_date_mode | Unknown |  |
| billing_day_of_week | Unknown |  |
| billing_day_of_week_mode | Unknown |  |
| billing_month | Unknown |  |
| business_customer_without_vat_number | Unknown |  |
| business_entity_id | Unknown |  |
| channel | Unknown |  |
| child_account_access_portal_download_invoices | Unknown |  |
| child_account_access_portal_edit_subscriptions | Unknown |  |
| child_account_access_send_invoice_emails | Unknown |  |
| child_account_access_send_payment_emails | Unknown |  |
| child_account_access_send_subscription_emails | Unknown |  |
| client_profile_id | Unknown |  |
| company | Unknown |  |
| consolidated_invoicing | Unknown |  |
| created_at | Unknown |  |
| created_from_ip | Unknown |  |
| customer_type | Unknown |  |
| deleted | Unknown |  |
| einvoicing_method | Unknown |  |
| email | Unknown |  |
| entity_code | Unknown |  |
| entity_identifier_scheme | Unknown |  |
| entity_identifier_standard | Unknown |  |
| excess_payments | Unknown |  |
| exempt_number | Unknown |  |
| exemption_details | Unknown |  |
| first_name | Unknown |  |
| fraud_flag | Unknown |  |
| invoice_notes | Unknown |  |
| is_einvoice_enabled | Unknown |  |
| is_location_valid | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| net_term_days | Unknown |  |
| offline_payment_method | Unknown |  |
| parent_account_access_portal_download_child_invoices | Unknown |  |
| parent_account_access_portal_edit_child_subscriptions | Unknown |  |
| parent_account_access_send_invoice_emails | Unknown |  |
| parent_account_access_send_payment_emails | Unknown |  |
| parent_account_access_send_subscription_emails | Unknown |  |
| phone | Unknown |  |
| pii_cleared | Unknown |  |
| preferred_currency_code | Unknown |  |
| promotional_credits | Unknown |  |
| refundable_credits | Unknown |  |
| registered_for_gst | Unknown |  |
| relationship_invoice_owner_id | Unknown |  |
| relationship_parent_id | Unknown |  |
| relationship_payment_owner_id | Unknown |  |
| resource_version | Unknown |  |
| taxability | Unknown |  |
| unbilled_charges | Unknown |  |
| updated_at | Unknown |  |
| use_default_hierarchy_settings | Unknown |  |
| vat_number | Unknown |  |
| vat_number_prefix | Unknown |  |
| vat_number_status | Unknown |  |
| vat_number_validated_time | Unknown |  |
| meta_data_** |  |  |

## Relationships

- gift_timeline(gift_id) → gift(id)
- gift(gift_receiver_customer_id) → customer(id)
- gift(gift_receiver_subscription_id) → subscription(id)
- gift(gifter_customer_id) → customer(id)
- gift(gifter_invoice_id) → invoice(id)
- credit_note_invoice_allocation(invoice_id) → invoice(id)
- credit_note_invoice_allocation(credit_note_id) → credit_note(id)
- credit_note_line_item(subscription_id) → subscription(id)
- credit_note_line_item(customer_id) → customer(id)
- credit_note_line_item(reference_line_item_id) → credit_note_line_item(id)
- credit_note_line_item(credit_note_id) → credit_note(id)
- credit_note_line_item_tax(line_item_id) → credit_note_line_item(id)
- credit_note_line_item_tax(credit_note_id) → credit_note(id)
- credit_note_line_item_discount(line_item_id) → credit_note_line_item(id)
- credit_note_line_item_discount(coupon_id) → coupon(id)
- credit_note_line_item_discount(credit_note_id) → credit_note(id)
- credit_note_line_item_tier(line_item_id) → credit_note_line_item(id)
- credit_note_line_item_tier(credit_note_id) → credit_note(id)
- credit_note_discount(line_item_id) → credit_note_line_item(id)
- credit_note_discount(credit_note_id) → credit_note(id)
- credit_note_tax(credit_note_id) → credit_note(id)
- credit_note_linked_refund(credit_note_id) → credit_note(id)
- credit_note_linked_tax_withheld_refund(credit_note_id) → credit_note(id)
- credit_note(reference_invoice_id) → invoice(id)
- credit_note(subscription_id) → subscription(id)
- credit_note(customer_id) → customer(id)
- coupon_set_metadata(coupon_set_id) → coupon_set(id)
- coupon_set(coupon_id) → coupon(id)
- quote_line_item(subscription_id) → subscription(id)
- quote_line_item(customer_id) → customer(id)
- quote_line_item(reference_line_item_id) → quote_line_item(id)
- quote_line_item(quote_id) → quote(id)
- quote_discount(line_item_id) → quote_line_item(id)
- quote_discount(quote_id) → quote(id)
- quote_line_item_tax(line_item_id) → quote_line_item(id)
- quote_line_item_tax(quote_id) → quote(id)
- quote_line_item_discount(line_item_id) → quote_line_item(id)
- quote_line_item_discount(coupon_id) → coupon(id)
- quote_line_item_discount(quote_id) → quote(id)
- quote_line_item_tier(line_item_id) → quote_line_item(id)
- quote_line_item_tier(quote_id) → quote(id)
- quote_tax(quote_id) → quote(id)
- quote(subscription_id) → subscription(id)
- quote(invoice_id) → invoice(id)
- quote(customer_id) → customer(id)
- subscription_renewal_invoice_line_item(subscription_id) → subscription(id)
- subscription_renewal_invoice_line_item(customer_id) → customer(id)
- subscription_renewal_invoice_line_item(subscription_estimate_id) → subscription_renewal_estimate(subscription_estimate_id)
- subscription_estimate(id) → subscription(id)
- subscription_estimate(subscription_estimate_id) → subscription_renewal_estimate(subscription_estimate_id)
- subscription_renewal_invoice_estimate(customer_id) → customer(id)
- subscription_renewal_invoice_estimate(subscription_estimate_id) → subscription_renewal_estimate(subscription_estimate_id)
- subscription_renewal_credit_note_estimate(customer_id) → customer(id)
- subscription_renewal_credit_note_estimate(subscription_estimate_id) → subscription_renewal_estimate(subscription_estimate_id)
- subscription_renewal_unbilled_charge_estimate(customer_id) → customer(id)
- subscription_renewal_unbilled_charge_estimate(subscription_estimate_id) → subscription_renewal_estimate(subscription_estimate_id)
- subscription_renewal_estimate(subscription_estimate_id) → subscription(id)
- subscription_renewal_estimate(customer_id) → customer(id)
- payment_source_mandate(subscription_id) → subscription(id)
- payment_source_mandate(payment_source_id) → payment_source(id)
- payment_source(customer_id) → customer(id)
- plan_applicable_addon(addon_id) → addon(id)
- plan_applicable_addon(plan_id) → plan(id)
- plan_event_based_addon(addon_id) → addon(id)
- plan_event_based_addon(plan_id) → plan(id)
- plan_attached_addon(addon_id) → addon(id)
- plan_attached_addon(plan_id) → plan(id)
- plan_tax_provider_field(plan_id) → plan(id)
- plan_tier(plan_id) → plan(id)
- plan_metadata(plan_id) → plan(id)
- resent_order(resent_order_id) → orders(id)
- resent_order(order_id) → orders(id)
- order_line_item(invoice_line_item_id) → invoice_line_item(id)
- order_line_item(invoice_id) → invoice(id)
- order_line_item(order_id) → orders(id)
- order_line_item_tax(line_item_id) → order_line_item(id)
- order_line_item_tax(order_id) → orders(id)
- order_line_item_discount(line_item_id) → order_line_item(id)
- order_line_item_discount(order_id) → orders(id)
- order_linked_credit_note(id) → credit_note(id)
- order_linked_credit_note(order_id) → orders(id)
- orders(gift_id) → gift(id)
- orders(original_order_id) → orders(id)
- orders(subscription_id) → subscription(id)
- orders(invoice_id) → invoice(id)
- orders(customer_id) → customer(id)
- virtual_bank_account(customer_id) → customer(id)
- addon_tier(addon_id) → addon(id)
- addon_tax_provider_field(addon_id) → addon(id)
- addon_metadata(addon_id) → addon(id)
- subscription_addon(addon_id) → addon(id)
- subscription_addon(subscription_id) → subscription(id)
- subscription_addon(subscription_updated_at) → subscription(updated_at)
- subscription_event_based_addon(addon_id) → addon(id)
- subscription_event_based_addon(subscription_id) → subscription(id)
- subscription_event_based_addon(subscription_updated_at) → subscription(updated_at)
- subscription_charged_event_based_addon(addon_id) → addon(id)
- subscription_charged_event_based_addon(subscription_id) → subscription(id)
- subscription_charged_event_based_addon(subscription_updated_at) → subscription(updated_at)
- subscription_coupon(coupon_id) → coupon(id)
- subscription_coupon(subscription_id) → subscription(id)
- subscription_coupon(subscription_updated_at) → subscription(updated_at)
- subscription_metadata(subscription_id) → subscription(id)
- subscription_metadata(subscription_updated_at) → subscription(updated_at)
- subscription(gift_id) → gift(id)
- subscription(plan_id) → plan(id)
- subscription(customer_id) → customer(id)
- subscription(payment_source_id) → payment_source(id)
- promotional_credit(customer_id) → customer(id)
- event_webhook(event_id) → event(id)
- event_metadata(event_id) → event(id)
- coupon_code(coupon_id) → coupon(id)
- coupon_code(coupon_set_id) → coupon_set(id)
- coupon_plan(plan_id) → plan(id)
- coupon_plan(coupon_id) → coupon(id)
- coupon_addon(addon_id) → addon(id)
- coupon_addon(coupon_id) → coupon(id)
- coupon_metadata(coupon_id) → coupon(id)
- unbilled_charge_tier(unbilled_charge_id) → unbilled_charge(id)
- unbilled_charge(subscription_id) → subscription(id)
- unbilled_charge(customer_id) → customer(id)
- invoice_issued_credit_note(cn_id) → credit_note(id)
- invoice_issued_credit_note(invoice_id) → invoice(id)
- invoice_issued_credit_note(invoice_updated_at) → invoice(updated_at)
- invoice_adjustment_credit_note(cn_id) → credit_note(id)
- invoice_adjustment_credit_note(invoice_id) → invoice(id)
- invoice_adjustment_credit_note(invoice_updated_at) → invoice(updated_at)
- invoice_dunning_attempt(transaction_id) → transaction(id)
- invoice_dunning_attempt(invoice_id) → invoice(id)
- invoice_dunning_attempt(invoice_updated_at) → invoice(updated_at)
- invoice_applied_credit(cn_id) → credit_note(id)
- invoice_applied_credit(invoice_id) → invoice(id)
- invoice_applied_credit(invoice_updated_at) → invoice(updated_at)
- invoice_line_item(subscription_id) → subscription(id)
- invoice_line_item(customer_id) → customer(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice_line_item(invoice_updated_at) → invoice(updated_at)
- invoice_line_item_tax(line_item_id) → invoice_line_item(id)
- invoice_line_item_tax(invoice_id) → invoice(id)
- invoice_line_item_tax(invoice_updated_at) → invoice(updated_at)
- invoice_tax(invoice_updated_at) → invoice(updated_at)
- invoice_tax(invoice_id) → invoice(id)
- invoice_line_item_discount(line_item_id) → invoice_line_item(id)
- invoice_line_item_discount(coupon_id) → coupon(id)
- invoice_line_item_discount(invoice_id) → invoice(id)
- invoice_line_item_discount(invoice_updated_at) → invoice(updated_at)
- invoice_line_item_tier(line_item_id) → invoice_line_item(id)
- invoice_line_item_tier(invoice_id) → invoice(id)
- invoice_line_item_tier(invoice_updated_at) → invoice(updated_at)
- invoice_discount(line_item_id) → invoice_line_item(id)
- invoice_discount(invoice_id) → invoice(id)
- invoice_discount(invoice_updated_at) → invoice(updated_at)
- invoice_linked_payment(invoice_updated_at) → invoice(updated_at)
- invoice_linked_payment(invoice_id) → invoice(id)
- invoice_linked_order(id) → orders(id)
- invoice_linked_order(invoice_id) → invoice(id)
- invoice_linked_order(invoice_updated_at) → invoice(updated_at)
- invoice_note(invoice_updated_at) → invoice(updated_at)
- invoice_note(invoice_id) → invoice(id)
- invoice_linked_taxes_withheld(invoice_updated_at) → invoice(updated_at)
- invoice_linked_taxes_withheld(invoice_id) → invoice(id)
- invoice(subscription_id) → subscription(id)
- invoice(customer_id) → customer(id)
- transaction_refund(refund_transaction_id) → transaction(id)
- transaction_refund(transaction_id) → transaction(id)
- transaction_linked_payment(linked_payments_id) → transaction(id)
- transaction_linked_payment(transaction_id) → transaction(id)
- transaction_invoice(invoice_id) → invoice(id)
- transaction_invoice(transaction_id) → transaction(id)
- transaction_linked_credit_note(cn_id) → credit_note(id)
- transaction_linked_credit_note(transaction_id) → transaction(id)
- transaction(reference_transaction_id) → transaction(id)
- transaction(subscription_id) → subscription(id)
- transaction(reference_authorization_id) → transaction(id)
- transaction(refunded_txn_id) → transaction(id)
- transaction(reversal_transaction_id) → transaction(id)
- transaction(customer_id) → customer(id)
- transaction(payment_source_id) → payment_source(id)
- customer_referral_url(customer_id) → customer(id)
- customer_contact(customer_id) → customer(id)
- customer_balance(customer_id) → customer(id)
- customer_tax_provider_field(customer_id) → customer(id)
- customer_entity_identifier(customer_id) → customer(id)
- customer_metadata(customer_id) → customer(id)
- customer(backup_payment_source_id) → payment_source(id)
- customer(primary_payment_source_id) → payment_source(id)