Maxio Chargify

Explore the interactive ERD

Table & Field Reference

offer_signup_pages

Column	Type	Keys
`id`	Unknown	PK
`offer_id`	Unknown	PKFK
`enabled`	Unknown
`nickname`	Unknown
`return_params`	Unknown
`return_url`	Unknown

offer_discounts

Column	Type	Keys
`index`	Unknown	PK
`offer_id`	Unknown	PKFK
`coupon_code`	Unknown
`coupon_id`	Unknown
`coupon_name`	Unknown

offer_items

Column	Type	Keys
`component_id`	Unknown	PKFK
`offer_id`	Unknown	PKFK
`price_point_id`	Unknown	FK
`component_name`	Unknown
`component_unit_price`	Unknown
`currency_prices`	Unknown
`editable`	Unknown
`price_point_name`	Unknown
`starting_quantity`	Unknown

offer

Column	Type	Keys
`id`	Unknown	PK
`product_family_id`	Unknown	FK
`product_id`	Unknown	FK
`product_price_point_id`	Unknown	FK
`site_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`description`	Unknown
`handle`	Unknown
`name`	Unknown
`product_family_name`	Unknown
`product_name`	Unknown
`product_price_in_cents`	Unknown
`product_price_point_name`	Unknown
`product_revisable_number`	Unknown
`updated_at`	Unknown

customer_metadata

Column	Type	Keys
`id`	Unknown	PK
`metafield_id`	Unknown	FK
`resource_id`	Unknown	FK
`deleted_at`	Unknown
`name`	Unknown
`value`	Unknown

credit_note_refund

Column	Type	Keys
`uid`	Unknown	PK
`credit_note_uid`	Unknown	PKFK
`applied_amount`	Unknown
`gateway_handle`	Unknown
`gateway_transaction_id`	Unknown
`gateway_used`	Unknown
`memo`	Unknown
`original_amount`	Unknown
`payment_id`	Unknown
`transaction_id`	Unknown
`transaction_time`	Unknown

credit_note_application

Column	Type	Keys
`uid`	Unknown	PK
`credit_note_uid`	Unknown	PKFK
`invoice_uid`	Unknown	FK
`applied_amount`	Unknown
`memo`	Unknown
`transaction_time`	Unknown

credit_note_taxes_line_item

Column	Type	Keys
`uid`	Unknown	PK
`credit_note_taxes_uid`	Unknown	PKFK
`tax_amount`	Unknown
`taxable_amount`	Unknown

credit_note_taxes

Column	Type	Keys
`uid`	Unknown	PK
`credit_note_uid`	Unknown	PKFK
`percentage`	Unknown
`source_id`	Unknown
`source_type`	Unknown
`tax_amount`	Unknown
`taxable_amount`	Unknown
`title`	Unknown

credit_note_discount_line_item

Column	Type	Keys
`uid`	Unknown	PK
`credit_note_discount_uid`	Unknown	PKFK
`discount_amount`	Unknown
`eligible_amount`	Unknown

credit_note_discount

Column	Type	Keys
`uid`	Unknown	PK
`credit_note_uid`	Unknown	PKFK
`code`	Unknown
`discount_amount`	Unknown
`discount_type`	Unknown
`eligible_amount`	Unknown
`percentage`	Unknown
`source_id`	Unknown
`source_type`	Unknown
`title`	Unknown

credit_note_line_item

Column	Type	Keys
`uid`	Unknown	PK
`credit_note_uid`	Unknown	PKFK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`product_id`	Unknown	FK
`description`	Unknown
`discount_amount`	Unknown
`period_range_end`	Unknown
`period_range_start`	Unknown
`product_version`	Unknown
`quantity`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`tiered_unit_price`	Unknown
`title`	Unknown
`total_amount`	Unknown
`unit_price`	Unknown

credit_note

Column	Type	Keys
`uid`	Unknown	PK
`customer_id`	Unknown	FK
`site_id`	Unknown	FK
`subscription_id`	Unknown	FK
`applied_amount`	Unknown
`applied_date`	Unknown
`billing_address_city`	Unknown
`billing_address_country`	Unknown
`billing_address_line_2`	Unknown
`billing_address_state`	Unknown
`billing_address_street`	Unknown
`billing_address_zip`	Unknown
`currency`	Unknown
`customer_chargify_id`	Unknown
`customer_email`	Unknown
`customer_first_name`	Unknown
`customer_last_name`	Unknown
`customer_organization`	Unknown
`customer_reference`	Unknown
`discount_amount`	Unknown
`issue_date`	Unknown
`memo`	Unknown
`number`	Unknown
`remaining_amount`	Unknown
`seller_address_city`	Unknown
`seller_address_country`	Unknown
`seller_address_line_2`	Unknown
`seller_address_state`	Unknown
`seller_address_street`	Unknown
`seller_address_zip`	Unknown
`seller_name`	Unknown
`seller_phone`	Unknown
`sequence_number`	Unknown
`shipping_address_city`	Unknown
`shipping_address_country`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_state`	Unknown
`shipping_address_street`	Unknown
`shipping_address_zip`	Unknown
`status`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`total_amount`	Unknown

subscription_proforma_invoice_line_item

Column	Type	Keys
`uid`	Unknown	PK
`subscription_proforma_invoice_uid`	Unknown	PKFK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`product_id`	Unknown	FK
`product_price_point_id`	Unknown	FK
`description`	Unknown
`discount_amount`	Unknown
`period_range_end`	Unknown
`period_range_start`	Unknown
`product_version`	Unknown
`quantity`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`tiered_unit_price`	Unknown
`title`	Unknown
`total_amount`	Unknown
`unit_price`	Unknown

subscription_proforma_invoice

Column	Type	Keys
`uid`	Unknown	PK
`customer_id`	Unknown	FK
`site_id`	Unknown	FK
`subscription_id`	Unknown	FK
`billing_address_city`	Unknown
`billing_address_country`	Unknown
`billing_address_line_2`	Unknown
`billing_address_state`	Unknown
`billing_address_street`	Unknown
`billing_address_zip`	Unknown
`collection_method`	Unknown
`consolidation_level`	Unknown
`created_at`	Unknown
`credit_amount`	Unknown
`credits`	Json
`currency`	Unknown
`custom_fields`	Json
`delivery_date`	Unknown
`discount_amount`	Unknown
`discounts`	Unknown
`due_amount`	Unknown
`number`	Unknown
`paid_amount`	Unknown
`payment_instructions`	Unknown
`payments`	Json
`product_family_name`	Unknown
`product_name`	Unknown
`refund_amount`	Unknown
`role`	Unknown
`seller_address_city`	Unknown
`seller_address_country`	Unknown
`seller_address_line_2`	Unknown
`seller_address_state`	Unknown
`seller_address_street`	Unknown
`seller_address_zip`	Unknown
`seller_name`	Unknown
`seller_phone`	Unknown
`sequence_number`	Unknown
`shipping_address_city`	Unknown
`shipping_address_country`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_state`	Unknown
`shipping_address_street`	Unknown
`shipping_address_zip`	Unknown
`status`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`taxes`	Json
`total_amount`	Unknown

customer_metafield

Column	Type	Keys
`id`	Unknown	PK
`enum`	Json
`input_type`	Unknown
`name`	Unknown

subscription_metadata

Column	Type	Keys
`id`	Unknown	PK
`metafield_id`	Unknown	FK
`resource_id`	Unknown	FK
`deleted_at`	Unknown
`name`	Unknown
`value`	Unknown

subscription_metafield

Column	Type	Keys
`id`	Unknown	PK
`enum`	Json
`input_type`	Unknown
`name`	Unknown

insight_site_stat

Column	Type	Keys
`site_id`	Unknown	PKFK
`seller_name`	Unknown
`site_currency`	Unknown
`site_name`	Unknown
`stats_revenue_this_month`	Unknown
`stats_revenue_this_year`	Unknown
`stats_revenue_today`	Unknown
`stats_subscriptions_today`	Unknown
`stats_total_revenue`	Unknown
`stats_total_subscriptions`	Unknown

invoice_event_data_payment

Column	Type	Keys
`transaction_id`	Unknown	PK
`invoice_event_id`	Unknown	PKFK
`applied_amount`	Unknown
`memo`	Unknown
`original_amount`	Unknown
`payment_method_card_brand`	Unknown
`payment_method_card_expiration`	Unknown
`payment_method_last_four`	Unknown
`payment_method_masked_card_number`	Unknown
`payment_method_type`	Unknown
`prepayment`	Unknown
`transaction_time`	Unknown

invoice_event_data_taxes_line_item

Column	Type	Keys
`uid`	Unknown	PK
`invoice_event_data_taxes_uid`	Unknown	PKFK
`tax_amount`	Unknown
`tax_exempt_amount`	Unknown
`taxable_amount`	Unknown

invoice_event_data_taxes

Column	Type	Keys
`uid`	Unknown	PK
`invoice_event_id`	Unknown	PKFK
`description`	Unknown
`eu_vat`	Unknown
`percentage`	Unknown
`source_id`	Unknown
`source_type`	Unknown
`tax_amount`	Unknown
`tax_component_breakouts`	Unknown
`tax_exempt_amount`	Unknown
`taxable_amount`	Unknown
`title`	Unknown
`transaction_id`	Unknown

invoice_event_data_line_item

Column	Type	Keys
`uid`	Unknown	PK
`invoice_event_id`	Unknown	PKFK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`product_id`	Unknown	FK
`product_price_point_id`	Unknown	FK
`component_cost_data`	Unknown
`description`	Unknown
`discount_amount`	Unknown
`hide`	Unknown
`period_range_end`	Unknown
`period_range_start`	Unknown
`product_version`	Unknown
`quantity`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`tax_code`	Unknown
`tax_exempt_amount`	Unknown
`tax_included`	Unknown
`tiered_unit_price`	Unknown
`title`	Unknown
`total_amount`	Unknown
`transaction_id`	Unknown
`unit_price`	Unknown

invoice_event

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`invoice_uid`	Unknown	FK
`parent_invoice_id`	Unknown	FK
`payer_chargify_id`	Unknown	FK
`site_id`	Unknown	FK
`event_data_backported_at`	Unknown
`event_data_billing_address_city`	Unknown
`event_data_billing_address_country`	Unknown
`event_data_billing_address_line_2`	Unknown
`event_data_billing_address_state`	Unknown
`event_data_billing_address_street`	Unknown
`event_data_billing_address_zip`	Unknown
`event_data_collection_method`	Unknown
`event_data_consolidation_level`	Unknown
`event_data_created_at`	Unknown
`event_data_credit_amount`	Unknown
`event_data_credits`	Unknown
`event_data_currency`	Unknown
`event_data_custom_fields`	Unknown
`event_data_customer_id`	Unknown
`event_data_discount_amount`	Unknown
`event_data_discounts`	Unknown
`event_data_display_settings_display_eu_vat_breakdown`	Unknown
`event_data_display_settings_display_introductory_offer`	Unknown
`event_data_display_settings_eu_vat_breakdown_exchange_rate`	Unknown
`event_data_display_settings_eu_vat_breakdown_exchange_rate_cached_at`	Unknown
`event_data_display_settings_eu_vat_breakdown_message_template`	Unknown
`event_data_display_settings_eu_vat_breakdown_total_in_eur`	Unknown
`event_data_display_settings_eu_vat_breakdown_vat_in_eur`	Unknown
`event_data_display_settings_hide_zero_subtotal_lines`	Unknown
`event_data_display_settings_include_discounts_on_lines`	Unknown
`event_data_display_settings_introductory_offer`	Unknown
`event_data_due_amount`	Unknown
`event_data_due_date`	Unknown
`event_data_id`	Unknown
`event_data_issue_date`	Unknown
`event_data_legacy_invoice_number`	Unknown
`event_data_memo`	Unknown
`event_data_net_terms`	Unknown
`event_data_number`	Unknown
`event_data_paid_amount`	Unknown
`event_data_paid_date`	Unknown
`event_data_parent_invoice_id`	Unknown
`event_data_parent_invoice_number`	Unknown
`event_data_payment_instructions`	Unknown
`event_data_prepaid_usage_details`	Unknown
`event_data_product_family_name`	Unknown
`event_data_product_name`	Unknown
`event_data_recipient_emails`	Unknown
`event_data_refund_amount`	Unknown
`event_data_refunds`	Unknown
`event_data_role`	Unknown
`event_data_seller_address_city`	Unknown
`event_data_seller_address_country`	Unknown
`event_data_seller_address_line_2`	Unknown
`event_data_seller_address_state`	Unknown
`event_data_seller_address_street`	Unknown
`event_data_seller_address_zip`	Unknown
`event_data_seller_logo_url`	Unknown
`event_data_seller_name`	Unknown
`event_data_seller_phone`	Unknown
`event_data_sequence_number`	Unknown
`event_data_shipping_address_city`	Unknown
`event_data_shipping_address_country`	Unknown
`event_data_shipping_address_line_2`	Unknown
`event_data_shipping_address_state`	Unknown
`event_data_shipping_address_street`	Unknown
`event_data_shipping_address_zip`	Unknown
`event_data_site_id`	Unknown
`event_data_statement_id`	Unknown
`event_data_status`	Unknown
`event_data_status_changed_at`	Unknown
`event_data_subscription_group_id`	Unknown
`event_data_subscription_id`	Unknown
`event_data_subtotal_amount`	Unknown
`event_data_tax_amount`	Unknown
`event_data_tax_exempt_amount`	Unknown
`event_data_total_amount`	Unknown
`event_data_transaction_time`	Unknown
`event_data_uid`	Unknown
`event_data_updated_at`	Unknown
`event_type`	Unknown
`invoice_id`	Unknown
`timestamps`	Instant

component_price_point_price

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`ending_quantity`	Unknown
`formatted_unit_price`	Unknown
`segment_id`	Unknown
`starting_quantity`	Unknown
`unit_price`	Unknown

component_price_point

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`defaults`	Unknown
`handle`	Unknown
`name`	Unknown
`pricing_scheme`	Unknown
`tax_included`	Unknown
`type`	Unknown
`updated_at`	Instant

reason_code

Column	Type	Keys
`id`	Unknown	PK
`site_id`	Unknown	FK
`code`	Unknown
`created_at`	Unknown
`description`	Unknown
`position`	Unknown
`updated_at`	Unknown

group_subscription_id

Column	Type	Keys
`group_subscription_id`	Unknown	PKFK
`subscription_group_id`	Unknown	PKFK

subscription_group

Column	Type	Keys
`uid`	Unknown	PK
`customer_id`	Unknown	FK
`primary_subscription_id`	Unknown	FK
`cancel_at_end_of_period`	Unknown
`next_assessment_at`	Unknown
`payment_profile_id`	Unknown
`pending_discounts_balance_in_cents`	Unknown
`prepayments_balance_in_cents`	Unknown
`scheme`	Unknown
`service_credits_balance_in_cents`	Unknown
`state`	Unknown

product_family

Column	Type	Keys
`id`	Unknown	PK
`accounting_code`	Unknown
`created_at`	Unknown
`description`	Unknown
`handle`	Unknown
`name`	Unknown
`updated_at`	Instant

coupon_restrictions

Column	Type	Keys
`id`	Unknown	PK
`coupon_id`	Unknown	PKFK
`handle`	Unknown
`item_id`	Unknown
`item_type`	Unknown
`name`	Unknown

coupon

Column	Type	Keys
`id`	Unknown	PK
`product_family_id`	Unknown	FK
`allow_negative_balance`	Unknown
`amount`	Unknown
`amount_in_cents`	Unknown
`apply_on_cancel_at_end_of_period`	Unknown
`archived_at`	Unknown
`code`	Unknown
`compounding_strategy`	Unknown
`conversion_limit`	Unknown
`created_at`	Unknown
`description`	Unknown
`discount_type`	Unknown
`duration_interval`	Unknown
`duration_interval_span`	Unknown
`duration_interval_unit`	Unknown
`duration_period_count`	Unknown
`end_date`	Unknown
`exclude_mid_period_allocations`	Unknown
`name`	Unknown
`percentage`	Unknown
`product_family_name`	Unknown
`recurring`	Unknown
`recurring_scheme`	Unknown
`stackable`	Unknown
`start_date`	Unknown
`updated_at`	Instant
`use_site_exchange_rate`	Unknown

payment_profile

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`bank_account_holder_type`	Unknown
`bank_account_type`	Unknown
`bank_name`	Unknown
`billing_address`	Unknown
`billing_address_2`	Unknown
`billing_city`	Unknown
`billing_country`	Unknown
`billing_state`	Unknown
`billing_zip`	Unknown
`current_vault`	Unknown
`customer_vault_token`	Unknown
`first_name`	Unknown
`gateway_handle`	Unknown
`last_name`	Unknown
`masked_bank_account_number`	Unknown
`masked_bank_routing_number`	Unknown
`payment_type`	Unknown
`site_gateway_setting_id`	Unknown
`vault_token`	Unknown
`verified`	Unknown

component_price

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	PKFK
`price_point_id`	Unknown	FK
`ending_quantity`	Unknown
`formatted_unit_price`	Unknown
`segment_id`	Unknown
`starting_quantity`	Unknown
`unit_price`	Unknown

component

Column	Type	Keys
`id`	Unknown	PK
`default_price_point_id`	Unknown	FK
`product_family_id`	Unknown	FK
`accounting_code`	Unknown
`allow_fractional_quantities`	Unknown
`archived`	Unknown
`archived_at`	Unknown
`created_at`	Unknown
`description`	Unknown
`downgrade_credit`	Unknown
`handle`	Unknown
`hide_date_range_on_invoice`	Unknown
`item_category`	Unknown
`kind`	Unknown
`name`	Unknown
`price_per_unit_in_cents`	Unknown
`price_points_url`	Unknown
`pricing_scheme`	Unknown
`recurring`	Unknown
`tax_code`	Unknown
`taxable`	Unknown
`unit_name`	Unknown
`unit_price`	Unknown
`updated_at`	Instant
`upgrade_charge`	Unknown
`use_site_exchange_rate`	Unknown

site

Column	Type	Keys
`id`	Unknown	PK
`currency`	Unknown
`customer_hierarchy_enabled`	Unknown
`default_payment_collection_method`	Unknown
`name`	Unknown
`net_terms_automatic_net_terms`	Unknown
`net_terms_custom_net_terms_enabled`	Unknown
`net_terms_default_net_terms`	Unknown
`net_terms_net_terms_on_remittance_signups_enabled`	Unknown
`net_terms_remittance_net_terms`	Unknown
`non_primary_currencies`	Json
`organization_address_city`	Unknown
`organization_address_country`	Unknown
`organization_address_line_2`	Unknown
`organization_address_name`	Unknown
`organization_address_phone`	Unknown
`organization_address_state`	Unknown
`organization_address_street`	Unknown
`organization_address_zip`	Unknown
`relationship_invoicing_enabled`	Unknown
`seller_id`	Unknown
`subdomain`	Unknown
`tax_configuration_destination_address`	Unknown
`tax_configuration_fully_configured`	Unknown
`tax_configuration_kind`	Unknown
`test`	Unknown
`whopays_default_payer`	Unknown
`whopays_enabled`	Unknown

coupon_usage

Column	Type	Keys
`id`	Unknown	PK
`coupon_id`	Unknown	FK
`product_family_id`	Unknown	FK
`name`	Unknown
`revenue`	Unknown
`revenue_in_cents`	Unknown
`savings`	Unknown
`savings_in_cents`	Unknown
`signups`	Unknown

invoice_payment

Column	Type	Keys
`transaction_id`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`applied_amount`	Unknown
`gateway_transaction_id`	Unknown
`memo`	Unknown
`original_amount`	Unknown
`payment_method_card_brand`	Unknown
`payment_method_card_expiration`	Unknown
`payment_method_details`	Unknown
`payment_method_kind`	Unknown
`payment_method_last_four`	Unknown
`payment_method_masked_card_number`	Unknown
`payment_method_memo`	Unknown
`payment_method_type`	Unknown
`prepayment`	Unknown
`transaction_time`	Unknown

invoice_line_item

Column	Type	Keys
`uid`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`product_id`	Unknown	FK
`component_cost_data`	Json
`description`	Unknown
`discount_amount`	Unknown
`period_range_end`	Unknown
`period_range_start`	Unknown
`product_version`	Unknown
`quantity`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`tiered_unit_price`	Unknown
`title`	Unknown
`total_amount`	Unknown
`unit_price`	Unknown

invoice_discount_line_item

Column	Type	Keys
`uid`	Unknown	PK
`invoice_discount_uid`	Unknown	PKFK
`discount_amount`	Unknown
`eligible_amount`	Unknown

invoice_discount

Column	Type	Keys
`uid`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`code`	Unknown	FK
`discount_amount`	Unknown
`discount_type`	Unknown
`eligible_amount`	Unknown
`integer`	Unknown
`percentage`	Unknown
`source_id`	Unknown
`source_type`	Unknown
`title`	Unknown

invoice_taxes_line_item

Column	Type	Keys
`uid`	Unknown	PK
`invoice_taxes_uid`	Unknown	PKFK
`tax_amount`	Unknown
`taxable_amount`	Unknown

invoice_taxes

Column	Type	Keys
`uid`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`code`	Unknown
`percentage`	Unknown
`source_id`	Unknown
`source_type`	Unknown
`tax_amount`	Unknown
`taxable_amount`	Unknown
`title`	Unknown

invoice_credit

Column	Type	Keys
`uid`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`credit_note_uid`	Unknown	FK
`applied_amount`	Unknown
`credit_note_number`	Unknown
`memo`	Unknown
`original_amount`	Unknown
`transaction_time`	Unknown

invoice_refund

Column	Type	Keys
`transaction_id`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`applied_amount`	Unknown
`gateway_transaction_id`	Unknown
`memo`	Unknown
`original_amount`	Unknown
`payment_id`	Unknown

invoice_custom_field

Column	Type	Keys
`index`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`name`	Unknown
`owner_id`	Unknown
`owner_type`	Unknown
`value`	Unknown

previous_balance_data_invoice

Column	Type	Keys
`previous_balance_data_invoice_uid`	Unknown	PK
`invoice_uid`	Unknown	PKFK
`number`	Unknown
`outstanding_amount`	Unknown

invoice

Column	Type	Keys
`uid`	Unknown	PK
`customer_id`	Unknown	FK
`group_primary_subscription_id`	Unknown	FK
`parent_invoice_uid`	Unknown	FK
`site_id`	Unknown	FK
`subscription_id`	Unknown	FK
`billing_address_city`	Unknown
`billing_address_country`	Unknown
`billing_address_line_2`	Unknown
`billing_address_state`	Unknown
`billing_address_street`	Unknown
`billing_address_zip`	Unknown
`collection_method`	Unknown
`consolidation_level`	Unknown
`created_at`	Unknown
`credit_amount`	Unknown
`currency`	Unknown
`discount_amount`	Unknown
`due_amount`	Unknown
`due_date`	Unknown
`issue_date`	Unknown
`memo`	Unknown
`number`	Unknown
`paid_amount`	Unknown
`paid_date`	Unknown
`parent_invoice_number`	Unknown
`payment_instructions`	Unknown
`previous_balance_data_capture_date`	Unknown
`product_family_name`	Unknown
`product_name`	Unknown
`public_url`	Unknown
`refund_amount`	Unknown
`seller_address_city`	Unknown
`seller_address_country`	Unknown
`seller_address_line_2`	Unknown
`seller_address_state`	Unknown
`seller_address_street`	Unknown
`seller_address_zip`	Unknown
`seller_name`	Unknown
`seller_phone`	Unknown
`sequence_number`	Unknown
`shipping_address_city`	Unknown
`shipping_address_country`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_state`	Unknown
`shipping_address_street`	Unknown
`shipping_address_zip`	Unknown
`status`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`total_amount`	Unknown
`updated_at`	Instant

transaction_taxation_tax_rules

Column	Type	Keys
`index`	Unknown	PK
`transaction_id`	Unknown	PKFK
`transaction_taxation_index`	Unknown	PKFK
`country_code`	Unknown
`description`	Unknown
`subdivision_code`	Unknown
`tax_rule_id`	Unknown

transaction_taxation

Column	Type	Keys
`index`	Unknown	PK
`transaction_id`	Unknown	PKFK
`rate`	Unknown
`tax_amount_in_cents`	Unknown
`tax_charge_id`	Unknown
`tax_id`	Unknown
`tax_name`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	FK
`component_price_point_id`	Unknown	FK
`customer_id`	Unknown	FK
`product_id`	Unknown	FK
`subscription_id`	Unknown	FK
`amount_in_cents`	Unknown
`card_expiration`	Unknown
`card_number`	Unknown
`card_type`	Unknown
`component_handle`	Unknown
`component_price_point_handle`	Unknown
`created_at`	Instant
`currency`	Unknown
`discount_amount_in_cents`	Unknown
`ending_balance_in_cents`	Unknown
`exchange_rate`	Unknown
`gateway_handle`	Unknown
`gateway_order_id`	Unknown
`gateway_response_code`	Unknown
`gateway_transaction_id`	Unknown
`gateway_used`	Unknown
`item_name`	Unknown
`kind`	Unknown
`memo`	Unknown
`original_amount_in_cents`	Unknown
`parent_id`	Unknown
`payment_id`	Unknown
`period_range_end`	Unknown
`period_range_start`	Unknown
`price_point_handle`	Unknown
`price_point_id`	Unknown
`quantity`	Unknown
`refunded_amount_in_cents`	Unknown
`role`	Unknown
`site_gateway_setting_id`	Unknown
`starting_balance_in_cents`	Unknown
`statement_id`	Unknown
`success`	Unknown
`tax_id`	Unknown
`taxable_amount_in_cents`	Unknown
`type`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`default_subscription_group_uid`	Unknown	FK
`parent_id`	Unknown	FK
`address`	Unknown
`address_2`	Unknown
`cc_emails`	Unknown
`city`	Unknown
`country`	Unknown
`country_name`	Unknown
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`locale`	Unknown
`organization`	Unknown
`phone`	Unknown
`portal_customer_created_at`	Unknown
`portal_invite_last_accepted_at`	Unknown
`portal_invite_last_sent_at`	Unknown
`reference`	Unknown
`state`	Unknown
`state_name`	Unknown
`tax_exempt`	Unknown
`updated_at`	Instant
`vat_number`	Unknown
`verified`	Unknown
`zip`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`bank_account_customer_id`	Unknown	FK
`coupon_code`	Unknown	FK
`credit_card_customer_id`	Unknown	FK
`customer_id`	Unknown	FK
`next_product_id`	Unknown	FK
`next_product_price_point_id`	Unknown	FK
`offer_id`	Unknown	FK
`payer_id`	Unknown	FK
`product_id`	Unknown	FK
`product_price_point_id`	Unknown	FK
`reason_code`	Unknown	FK
`activated_at`	Unknown
`automatically_resume_at`	Unknown
`balance_in_cents`	Unknown
`bank_account_bank_name`	Unknown
`bank_account_billing_address`	Unknown
`bank_account_billing_address_2`	Unknown
`bank_account_billing_city`	Unknown
`bank_account_billing_country`	Unknown
`bank_account_billing_state`	Unknown
`bank_account_billing_zip`	Unknown
`bank_account_chargify_token`	Unknown
`bank_account_current_vault`	Unknown
`bank_account_customer_vault_token`	Unknown
`bank_account_first_name`	Unknown
`bank_account_gateway_handle`	Unknown
`bank_account_holder_type`	Unknown
`bank_account_id`	Unknown
`bank_account_last_name`	Unknown
`bank_account_masked_bank_account_number`	Unknown
`bank_account_masked_bank_routing_number`	Unknown
`bank_account_site_gateway_setting_id`	Unknown
`bank_account_type`	Unknown
`bank_account_vault_token`	Unknown
`cancel_at_end_of_period`	Unknown
`canceled_at`	Unknown
`cancellation_message`	Unknown
`cancellation_method`	Unknown
`coupon_use_count`	Unknown
`coupon_uses_allowed`	Unknown
`created_at`	Unknown
`credit_card_billing_address`	Unknown
`credit_card_billing_address_2`	Unknown
`credit_card_billing_city`	Unknown
`credit_card_billing_country`	Unknown
`credit_card_billing_state`	Unknown
`credit_card_billing_zip`	Unknown
`credit_card_card_type`	Unknown
`credit_card_current_vault`	Unknown
`credit_card_customer_vault_token`	Unknown
`credit_card_expiration_month`	Unknown
`credit_card_expiration_year`	Unknown
`credit_card_first_name`	Unknown
`credit_card_gateway_handle`	Unknown
`credit_card_id`	Unknown
`credit_card_last_name`	Unknown
`credit_card_masked_card_number`	Unknown
`credit_card_payment_type`	Unknown
`credit_card_site_gateway_setting_id`	Unknown
`credit_card_vault_token`	Unknown
`current_billing_amount_in_cents`	Unknown
`current_period_ends_at`	Unknown
`current_period_started_at`	Unknown
`delayed_cancel_at`	Unknown
`dunning_communication_delay_enabled`	Unknown
`dunning_communication_delay_time_zone`	Unknown
`expires_at`	Unknown
`group_primarys`	Unknown
`group_uid`	Unknown
`net_terms`	Unknown
`next_assessment_at`	Unknown
`on_hold_at`	Unknown
`payment_collection_method`	Unknown
`payment_type`	Unknown
`prepaid_dunning`	Unknown
`previous_state`	Unknown
`reference`	Unknown
`referral_code`	Unknown
`signup_payment_id`	Unknown
`signup_revenue`	Unknown
`snap_day`	Unknown
`state`	Unknown
`stored_credential_transaction_id`	Unknown
`total_revenue_in_cents`	Unknown
`trial_ended_at`	Unknown
`trial_started_at`	Unknown
`updated_at`	Instant

event

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`event_specific_data_component_id`	Unknown	FK
`subscription_id`	Unknown	FK
`created_at`	Instant
`event_specific_data_event_type`	Unknown
`event_specific_data_memo`	Unknown
`event_specific_data_metafield_id`	Unknown
`event_specific_data_metafield_name`	Unknown
`event_specific_data_new_subscription_state`	Unknown
`event_specific_data_new_unit_balance`	Unknown
`event_specific_data_new_value`	Unknown
`event_specific_data_old_value`	Unknown
`event_specific_data_previous_subscription_state`	Unknown
`event_specific_data_previous_unit_balance`	Unknown
`event_specific_data_resource_id`	Unknown
`event_specific_data_resource_type`	Unknown
`event_specific_data_usage_quantity`	Unknown
`key`	Unknown
`message`	Unknown

product_public_signup_page

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`currency`	Unknown
`enabled`	Unknown
`nickname`	Unknown
`return_params`	Unknown
`return_url`	Unknown
`url`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`default_product_price_point_id`	Unknown	FK
`product_family_id`	Unknown	FK
`product_price_point_id`	Unknown	FK
`accounting_code`	Unknown
`archived_at`	Unknown
`created_at`	Unknown
`description`	Unknown
`expiration_interval`	Unknown
`expiration_interval_unit`	Unknown
`handle`	Unknown
`initial_charge_after_trial`	Unknown
`initial_charge_in_cents`	Unknown
`interval`	Unknown
`interval_unit`	Unknown
`item_category`	Unknown
`name`	Unknown
`price_in_cents`	Unknown
`request_billing_address`	Unknown
`request_credit_card`	Unknown
`require_billing_address`	Unknown
`require_credit_card`	Unknown
`require_shipping_address`	Unknown
`return_params`	Unknown
`tax_code`	Unknown
`taxable`	Unknown
`trial_interval`	Unknown
`trial_interval_unit`	Unknown
`trial_price_in_cents`	Unknown
`update_return_params`	Unknown
`update_return_url`	Unknown
`updated_at`	Instant
`use_site_exchange_rate`	Unknown
`version_number`	Unknown

subscription_component

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`product_family_id`	Unknown	FK
`subscription_id`	Unknown	FK
`currency`	Unknown
`display_on_hosted_page`	Unknown
`unit_balance`	Unknown
`updated_at`	Instant

products_price_point

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`subscription_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`expiration_interval`	Unknown
`expiration_interval_unit`	Unknown
`handle`	Unknown
`initial_charge_after_trial`	Unknown
`initial_charge_in_cents`	Unknown
`interval`	Unknown
`interval_unit`	Unknown
`introductory_offer`	Unknown
`name`	Unknown
`price_in_cents`	Unknown
`tax_included`	Unknown
`trial_interval`	Unknown
`trial_interval_unit`	Unknown
`trial_price_in_cents`	Unknown
`trial_type`	Unknown
`type`	Unknown
`updated_at`	Instant

allocation

Column	Type	Keys
`_fivetran_id`	String	PK
`id`	Unknown	FK
`component_id`	Unknown
`memo`	Unknown
`previous_quantity`	Unknown
`proration_downgrade_scheme`	Unknown
`proration_upgrade_scheme`	Unknown
`quantity`	Unknown
`subscription_id`	Unknown
`timestamps`	Unknown

usage

Column	Type	Keys
`id`	Unknown	PK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`subscription_id`	Unknown	FK
`created_at`	Instant
`memo`	Unknown
`quantity`	Unknown

prepayment

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	FK
`amount_in_cents`	Unknown
`created_at`	Instant
`details`	Unknown
`external`	Unknown
`memo`	Unknown
`payment_type`	Unknown
`remaining_amount_in_cents`	Unknown

subscription_note

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	FK
`body`	Unknown
`created_at`	Unknown
`sticky`	Unknown
`updated_at`	Unknown

preview_custom_field

Column	Type	Keys
`index`	Unknown	PK
`preview_performa_invoice_subscription_id`	Unknown	PKFK
`metadatum_id`	Unknown
`name`	Unknown
`owner_id`	Unknown
`owner_type`	Unknown
`value`	Unknown

preview_payment

Column	Type	Keys
`_fivetran_id`	String	PK
`preview_performa_invoice_subscription_id`	Unknown	FK
`applied_amount`	Unknown
`memo`	Unknown
`original_amount`	Unknown
`prepayment`	Unknown

preview_credit

Column	Type	Keys
`uid`	Unknown	PK
`preview_performa_invoice_subscription_id`	Unknown	PKFK
`applied_amount`	Unknown
`memo`	Unknown
`original_amount`	Unknown

preview_taxes_line_item

Column	Type	Keys
`_fivetran_id`	String	PK
`preview_performa_invoice_subscription_id`	Unknown	FK
`preview_taxes_uid`	Unknown	FK
`tax_amount`	Unknown
`taxable_amount`	Unknown

preview_taxes

Column	Type	Keys
`uid`	Unknown	PK
`preview_performa_invoice_subscription_id`	Unknown	PKFK
`percentage`	Unknown
`source_type`	Unknown
`tax_amount`	Unknown
`taxable_amount`	Unknown
`title`	Unknown

preview_discount_line_item

Column	Type	Keys
`_fivetran_id`	String	PK
`preview_discount_index`	Unknown	FK
`preview_performa_invoice_subscription_id`	Unknown	FK
`discount_amount`	Unknown
`eligible_amount`	Unknown

preview_discount

Column	Type	Keys
`index`	Unknown	PK
`preview_performa_invoice_subscription_id`	Unknown	PKFK
`discount_amount`	Unknown
`discount_type`	Unknown
`eligible_amount`	Unknown
`source_type`	Unknown
`title`	Unknown

preview_line_item

Column	Type	Keys
`uid`	Unknown	PK
`preview_performa_invoice_subscription_id`	Unknown	PKFK
`component_id`	Unknown	FK
`price_point_id`	Unknown	FK
`product_id`	Unknown	FK
`product_price_point_id`	Unknown	FK
`description`	Unknown
`discount_amount`	Unknown
`period_range_end`	Unknown
`period_range_start`	Unknown
`quantity`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`tiered_unit_price`	Unknown
`title`	Unknown
`total_amount`	Unknown
`unit_price`	Unknown

preview_performa_invoice

Column	Type	Keys
`subscription_id`	Unknown	PKFK
`customer_chargify_id`	Unknown	FK
`customer_id`	Unknown	FK
`site_id`	Unknown	FK
`billing_address_city`	Unknown
`billing_address_country`	Unknown
`billing_address_line_2`	Unknown
`billing_address_state`	Unknown
`billing_address_street`	Unknown
`billing_address_zip`	Unknown
`collection_method`	Unknown
`consolidation_level`	Unknown
`created_at`	Unknown
`credit_amount`	Unknown
`currency`	Unknown
`delivery_date`	Unknown
`discount_amount`	Unknown
`due_amount`	Unknown
`memo`	Unknown
`number`	Unknown
`paid_amount`	Unknown
`payment_instructions`	Unknown
`product_family_name`	Unknown
`refund_amount`	Unknown
`role`	Unknown
`seller_address_city`	Unknown
`seller_address_country`	Unknown
`seller_address_line_2`	Unknown
`seller_address_state`	Unknown
`seller_address_street`	Unknown
`seller_address_zip`	Unknown
`seller_name`	Unknown
`seller_phone`	Unknown
`sequence_number`	Unknown
`shipping_address_city`	Unknown
`shipping_address_country`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_state`	Unknown
`shipping_address_street`	Unknown
`shipping_address_zip`	Unknown
`status`	Unknown
`subtotal_amount`	Unknown
`tax_amount`	Unknown
`total_amount`	Unknown
`uid`	Unknown