Recurly

Explore the interactive ERD

Table & Field Reference

external_account_history

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`account_updated_at`	Instant	PKFK
`created_at`	Unknown
`external_account_code`	Unknown
`external_connection_type`	Unknown
`id`	Unknown
`updated_at`	Unknown

billing_info_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`account_id`	Unknown	FK
`backup_payment_method`	Unknown
`billing_city`	Unknown
`billing_country`	Unknown
`billing_first_name`	Unknown
`billing_geo_code`	Unknown
`billing_last_name`	Unknown
`billing_phone`	Unknown
`billing_postal_code`	Unknown
`billing_region`	Unknown
`billing_street_1`	Unknown
`billing_street_2`	Unknown
`company`	Unknown
`created_at`	Unknown
`first_name`	Unknown
`fraud_decision`	Unknown
`fraud_risk_rules_triggered`	Json
`fraud_score`	Unknown
`last_name`	Unknown
`payment_gateway_references`	Json
`payment_method_account_type`	Unknown
`payment_method_billing_agreement_id`	Unknown
`payment_method_card_network_preference`	Unknown
`payment_method_card_type`	Unknown
`payment_method_cc_bin_country`	Unknown
`payment_method_exp_month`	Unknown
`payment_method_exp_year`	Unknown
`payment_method_first_six`	Unknown
`payment_method_funding_source`	Unknown
`payment_method_gateway_attributes_account_reference`	Unknown
`payment_method_gateway_code`	Unknown
`payment_method_gateway_token`	Unknown
`payment_method_last_four`	Unknown
`payment_method_last_two`	Unknown
`payment_method_name_on_account`	Unknown
`payment_method_object`	Unknown
`payment_method_routing_number`	Unknown
`payment_method_routing_number_bank`	Unknown
`payment_method_username`	Unknown
`primary_payment_method`	Unknown
`updated_by_country`	Unknown
`updated_by_ip`	Unknown
`valid`	Unknown
`vat_number`	Unknown

shipping_address_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`account_id`	Unknown	PKFK
`city`	Unknown
`company`	Unknown
`country`	Unknown
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`geo_code`	Unknown
`last_name`	Unknown
`nickname`	Unknown
`phone`	Unknown
`postal_code`	Unknown
`region`	Unknown
`street_1`	Unknown
`street_2`	Unknown
`vat_number`	Unknown

account_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`parent_account_id`	Unknown	FK
`account_city`	Unknown
`account_country`	Unknown
`account_geo_code`	Unknown
`account_phone`	Unknown
`account_postal_code`	Unknown
`account_region`	Unknown
`account_street_1`	Unknown
`account_street_2`	Unknown
`bill_date`	Unknown
`bill_to`	Unknown
`cc_emails`	Unknown
`code`	Unknown
`company`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`dunning_campaign_id`	Unknown
`email`	Unknown
`entity_use_code`	Unknown
`exemption_certificate`	Unknown
`first_name`	Unknown
`has_active_subscription`	Unknown
`has_canceled_subscription`	Unknown
`has_future_subscription`	Unknown
`has_live_subscription`	Unknown
`has_past_due_invoice`	Unknown
`has_paused_subscription`	Unknown
`hosted_login_token`	Unknown
`invoice_template_id`	Unknown
`last_name`	Unknown
`override_business_entity_id`	Unknown
`preferred_locale`	Unknown
`preferred_time_zone`	Unknown
`state`	Unknown
`tax_exempt`	Unknown
`username`	Unknown
`vat_number`	Unknown
`custom_`

bulk_unique_code

Column	Type	Keys
`id`	Unknown	PK
`bulk_code`	Unknown	PKFK
`bulk_coupon_id`	Unknown
`code`	Unknown
`created_at`	Unknown
`expired_at`	Unknown
`object`	Unknown
`redeemed_at`	Unknown
`state`	Unknown
`updated_at`	Instant

subscription_add_on_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`plan_add_on_id`	Unknown	FK
`subscription_id`	Unknown	FK
`add_on_source`	Unknown
`created_at`	Unknown
`expired_at`	Unknown
`object`	Unknown
`quantity`	Unknown
`unit_amount`	Unknown
`unit_amount_decimal`	Unknown

subscription_change_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`plan_id`	Unknown	FK
`subscription_id`	Unknown	FK
`activate_at`	Unknown
`activated`	Unknown
`billing_info_three_d_secure_action_result_token_id`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`object`	Unknown
`quantity`	Unknown
`tax_inclusive`	Unknown
`unit_amount`	Unknown

subscription_ramp_interval

Column	Type	Keys
`index`	Unknown	PK
`subscription_id`	Unknown	PKFK
`subscription_updated_at`	Unknown	PKFK
`ending_on`	Unknown
`remaining_billing_cycles`	Unknown
`starting_billing_cycle`	Unknown
`starting_on`	Unknown
`unit_amount`	Unknown

subscription_credit_invoice

Column	Type	Keys
`index`	Unknown	PK
`subscription_id`	Unknown	PKFK
`subscription_updated_at`	Unknown	PKFK
`credit_invoice_id`	Unknown	FK

subscription_coupon_redemption_history

Column	Type	Keys
`coupon_redemption_id`	Unknown	PKFK
`subscription_history_id`	Unknown	PKFK
`subscription_updated_at`	Unknown	PKFK

subscription_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`account_id`	Unknown	FK
`active_invoice_id`	Unknown	FK
`invoice_collection_charge_invoice_id`	Unknown	FK
`plan_id`	Unknown	FK
`shipping_address_id`	Unknown	FK
`action_result`	Json
`activated_at`	Unknown
`add_ons_total`	Unknown
`auto_renew`	Unknown
`bank_account_authorized_at`	Unknown
`billing_info_id`	Unknown
`business_entity_id`	Unknown
`canceled_at`	Unknown
`collection_method`	Unknown
`converted_at`	Unknown
`created_at`	Unknown
`credit_application_policy_mode`	Unknown
`currency`	Unknown
`current_period_ends_at`	Unknown
`current_period_started_at`	Unknown
`current_term_ends_at`	Unknown
`current_term_started_at`	Unknown
`customer_notes`	Unknown
`deleted_at`	Unknown
`expiration_reason`	Unknown
`expires_at`	Unknown
`gateway_code`	Unknown
`net_terms`	Unknown
`net_terms_type`	Unknown
`next_action`	Unknown
`object`	Unknown
`paused_at`	Unknown
`po_number`	Unknown
`price_segment_id`	Unknown
`quantity`	Unknown
`remaining_billing_cycles`	Unknown
`remaining_pause_cycles`	Unknown
`renewal_billing_cycles`	Unknown
`shipping_address_object`	Unknown
`shipping_amount`	Unknown
`shipping_method_code`	Unknown
`shipping_method_id`	Unknown
`shipping_method_name`	Unknown
`shipping_method_object`	Unknown
`started_with_gift`	Unknown
`state`	Unknown
`subtotal`	Unknown
`tax`	Unknown
`tax_inclusive`	Unknown
`terms_and_conditions`	Unknown
`total`	Unknown
`total_billing_cycles`	Unknown
`trial_ends_at`	Unknown
`trial_started_at`	Unknown
`unit_amount`	Unknown
`uuid`	Unknown
`custom_`

subscription_gift_card_mapping

Column	Type	Keys
`updated_at`	Unknown	PKFK
`uuid`	Unknown	PKFK
`converted_at`	Unknown
`started_with_gift`	Unknown

coupon_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`coupon_id`	Unknown	PK
`amount`	Unknown
`currency`	Unknown
`percentage`	Unknown
`trial_length`	Unknown
`trial_unit`	Unknown
`type`	Unknown

coupon_plan_history

Column	Type	Keys
`coupon_id`	Unknown	PKFK
`coupon_updated_at`	Instant	PKFK
`plan_id`	Unknown	PKFK

coupon_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`applies_to_all_plans`	Unknown
`applies_to_non_plan_charges`	Unknown
`code`	Unknown
`coupon_type`	Unknown
`created_at`	Unknown
`duration`	Unknown
`expired_at`	Unknown
`free_trial_amount`	Unknown
`free_trial_unit`	Unknown
`hosted_page_description`	Unknown
`invoice_description`	Unknown
`max_redemptions`	Unknown
`max_redemptions_per_account`	Unknown
`name`	Unknown
`redeem_by`	Unknown
`redemption_resource`	Unknown
`state`	Unknown
`temporal_amount`	Unknown
`temporal_unit`	Unknown
`unique_code_template`	Unknown
`unique_coupon_codes_count`	Unknown

line_item_tax_detail

Column	Type	Keys
`index`	Unknown	PK
`line_item_id`	Unknown	PKFK
`line_item_updated_at`	Instant	PKFK
`billable`	Unknown
`level`	Unknown
`name`	Unknown
`rate`	Unknown
`region`	Unknown
`tax`	Unknown
`type`	Unknown

line_item_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`account_id`	Unknown	FK
`add_on_id`	Unknown	FK
`bill_for_account_id`	Unknown	FK
`invoice_id`	Unknown	FK
`original_line_item_invoice_id`	Unknown	FK
`plan_id`	Unknown	FK
`previous_line_item_id`	Unknown	FK
`shipping_address_id`	Unknown	FK
`subscription_id`	Unknown	FK
`accounting_code`	Unknown
`add_on_code`	Unknown
`amount`	Unknown
`avalara_service_type`	Unknown
`avalara_transaction_type`	Unknown
`created_at`	Unknown
`credit_applied`	Unknown
`credit_reason_code`	Unknown
`currency`	Unknown
`description`	Unknown
`destination_tax_address_source`	Unknown
`discount`	Unknown
`end_date`	Unknown
`external_sku`	Unknown
`harmonized_system_code`	Unknown
`invoice_number`	Unknown
`item_code`	Unknown
`item_id`	Unknown
`legacy_category`	Unknown
`liability_gl_account_code`	Unknown
`origin`	Unknown
`origin_tax_address_source`	Unknown
`performance_obligation_id`	Unknown
`plan_code`	Unknown
`product_code`	Unknown
`proration_rate`	Unknown
`quantity`	Unknown
`quantity_decimal`	Unknown
`refund`	Unknown
`refunded_quantity`	Unknown
`refunded_quantity_decimal`	Unknown
`revenue_gl_account_code`	Unknown
`start_date`	Unknown
`state`	Unknown
`subtotal`	Unknown
`tax`	Unknown
`tax_code`	Unknown
`tax_exempt`	Unknown
`tax_inclusive`	Unknown
`tax_rate`	Unknown
`tax_region`	Unknown
`tax_type`	Unknown
`taxable`	Unknown
`type`	Unknown
`unit_amount`	Unknown
`unit_amount_decimal`	Unknown
`uuid`	Unknown
`custom_`

account_acquisition_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`account_id`	Unknown	FK
`acquired_at`	Unknown
`campaign`	Unknown
`channel`	Unknown
`cost_account`	Unknown
`cost_currency`	Unknown
`created_at`	Unknown
`subchannel`	Unknown

dummy_temp_us

Column	Type	Keys
`account_history_temp_cred_migration_us_dummy_id`	Unknown	PK
`id`	Unknown	PK
`updated_at`	Unknown	PK

account_balance_history

Column	Type	Keys
`account_id`	Unknown	PK
`account_updated_at`	Instant	PK
`currency`	Unknown	PK
`amount`	Unknown
`available_credit_amount`	Unknown
`past_due`	Unknown
`processing_prepayment_amount`	Unknown

invoice_transaction_history

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`invoice_updated_at`	Instant	PKFK
`transaction_id`	Unknown	PKFK

invoice_tax_detail

Column	Type	Keys
`index`	Unknown	PK
`invoice_id`	Unknown	PKFK
`invoice_updated_at`	Instant	PKFK
`transaction_id`	Unknown	FK
`billable`	Unknown
`level`	Unknown
`name`	Unknown

invoice_line_item

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`invoice_updated_at`	Instant	PKFK
`line_item_id`	Unknown	PKFK

invoice_subscription_history

Column	Type	Keys
`invoice_id`	Unknown	PKFK
`invoice_updated_at`	Instant	PKFK
`subscription_id`	Unknown	PKFK

invoice_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`account_id`	Unknown	FK
`previous_invoice_id`	Unknown	FK
`address_city`	Unknown
`address_company`	Unknown
`address_country`	Unknown
`address_first_name`	Unknown
`address_geo_code`	Unknown
`address_last_name`	Unknown
`address_name_on_account`	Unknown
`address_phone`	Unknown
`address_postal_code`	Unknown
`address_region`	Unknown
`address_street_1`	Unknown
`address_street_2`	Unknown
`balance`	Unknown
`billing_info_id`	Unknown
`business_entity_id`	Unknown
`closed_at`	Unknown
`collection_method`	Unknown
`created_at`	Unknown
`credit_payments`	Json
`currency`	Unknown
`customer_notes`	Unknown
`discount`	Unknown
`due_at`	Unknown
`dunning_campaign_id`	Unknown
`dunning_events_sent`	Unknown
`final_dunning_event`	Unknown
`gateway_code`	Unknown
`has_more_line_items`	Unknown
`net_terms`	Unknown
`net_terms_type`	Unknown
`number`	Unknown
`object`	Unknown
`origin`	Unknown
`paid`	Unknown
`po_number`	Unknown
`reference_only_currency_conversion_currency`	Unknown
`reference_only_currency_conversion_date`	Unknown
`reference_only_currency_conversion_rate`	Unknown
`reference_only_currency_conversion_source`	Unknown
`reference_only_currency_conversion_subtotal_in_cents`	Unknown
`reference_only_currency_conversion_tax_in_cents`	Unknown
`refundable_amount`	Unknown
`shipping_address_account_id`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company`	Unknown
`shipping_address_country`	Unknown
`shipping_address_created_at`	Unknown
`shipping_address_email`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_geo_code`	Unknown
`shipping_address_id`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_nickname`	Unknown
`shipping_address_object`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_postal_code`	Unknown
`shipping_address_region`	Unknown
`shipping_address_street_1`	Unknown
`shipping_address_street_2`	Unknown
`shipping_address_updated_at`	Unknown
`shipping_address_vat_number`	Unknown
`state`	Unknown
`subtotal`	Unknown
`subtotal_after_discount`	Unknown
`tax`	Unknown
`tax_rate`	Unknown
`tax_region`	Unknown
`tax_type`	Unknown
`terms_and_conditions`	Unknown
`total`	Unknown
`type`	Unknown
`used_tax_service`	Unknown
`uuid`	Unknown
`vat_number`	Unknown
`vat_reverse_charge_notes`	Unknown

plan_setup_fees

Column	Type	Keys
`index`	Unknown	PK
`plan_id`	Unknown	PKFK
`plan_updated_at`	Instant	PKFK
`currency`	Unknown
`unit_amount`	Unknown

plan_currency_history

Column	Type	Keys
`currency`	Unknown	PK
`plan_id`	Unknown	PKFK
`plan_updated_at`	Instant	PKFK
`price_segment_id`	Unknown
`setup_fees`	Unknown
`tax_inclusive`	Unknown
`unit_amount`	Unknown

plan_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`accounting_code`	Unknown
`allow_any_item_on_subscriptions`	Unknown
`auto_renew`	Unknown
`avalara_service_type`	Unknown
`avalara_transaction_type`	Unknown
`code`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`dunning_campaign_id`	Unknown
`harmonized_system_code`	Unknown
`hosted_page_bypass_confirmation`	Unknown
`hosted_page_cancel_url`	Unknown
`hosted_page_display_quantity`	Unknown
`hosted_page_success_url`	Unknown
`interval_length`	Unknown
`interval_unit`	Unknown
`liability_gl_account_id`	Unknown
`name`	Unknown
`performance_obligation_id`	Unknown
`pricing_model`	Unknown
`revenue_gl_account_id`	Unknown
`revenue_schedule_type`	Unknown
`setup_fee_accounting_code`	Unknown
`setup_fee_liability_gl_account_id`	Unknown
`setup_fee_performance_obligation_id`	Unknown
`setup_fee_revenue_gl_account_id`	Unknown
`setup_fee_revenue_schedule_type`	Unknown
`state`	Unknown
`tax_code`	Unknown
`tax_exempt`	Unknown
`total_billing_cycles`	Unknown
`trial_length`	Unknown
`trial_requires_billing_info`	Unknown
`trial_unit`	Unknown
`vertex_transaction_type`	Unknown
`custom_`

gift_card

Column	Type	Keys
`id`	Unknown	PK
`gifter_account_id`	Unknown	FK
`liability_gl_account_id`	Unknown	FK
`purchase_invoice_id`	Unknown	FK
`recipient_account_id`	Unknown	FK
`redemption_invoice_id`	Unknown	FK
`revenue_gl_account_id`	Unknown	FK
`balance`	Unknown
`canceled_at`	Unknown
`created_at`	Unknown
`currency`	Unknown
`delivered_at`	Unknown
`delivery_address_city`	Unknown
`delivery_address_country`	Unknown
`delivery_address_geo_code`	Unknown
`delivery_address_phone`	Unknown
`delivery_address_postal_code`	Unknown
`delivery_address_region`	Unknown
`delivery_address_street_1`	Unknown
`delivery_address_street_2`	Unknown
`delivery_deliver_at`	Unknown
`delivery_email_address`	Unknown
`delivery_first_name`	Unknown
`delivery_gifter_name`	Unknown
`delivery_last_name`	Unknown
`delivery_method`	Unknown
`delivery_personal_message`	Unknown
`performance_obligation_id`	Unknown
`product_code`	Unknown
`redeemed_at`	Unknown
`redemption_code`	Unknown
`unit_amount`	Unknown
`updated_at`	Unknown

invoice_coupon_redemption_history

Column	Type	Keys
`coupon_redemption_id`	Unknown	PKFK
`invoice_id`	Unknown	PKFK
`invoice_updated_at`	Instant	PKFK

external_subscription_payment_phase

Column	Type	Keys
`id`	Unknown	PK
`external_subscription_id`	Unknown	PKFK
`amount`	Unknown
`created_at`	Unknown
`currency`	Unknown
`ending_billing_period_index`	Unknown
`ends_at`	Unknown
`object`	Unknown
`offer_name`	Unknown
`offer_type`	Unknown
`period_count`	Unknown
`period_length`	Unknown
`started_at`	Unknown
`starting_billing_period_index`	Unknown
`updated_at`	Unknown

external_subscription

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`activated_at`	Unknown
`app_identifier`	Unknown
`auto_renew`	Unknown
`canceled_at`	Unknown
`created_at`	Unknown
`expires_at`	Unknown
`external_id`	Unknown
`external_product_reference_code`	Unknown
`external_product_reference_created_at`	Unknown
`external_product_reference_external_connection_type`	Unknown
`external_product_reference_id`	Unknown
`external_product_reference_object`	Unknown
`external_product_reference_updated_at`	Unknown
`imported`	Unknown
`in_grace_period`	Unknown
`last_purchased`	Unknown
`object`	Unknown
`quantity`	Unknown
`state`	Unknown
`test`	Unknown
`trial_ends_at`	Unknown
`trial_started_at`	Unknown
`updated_at`	Instant
`uuid`	Unknown

account_note_history

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`account_updated_at`	Instant	PKFK
`created_at`	Unknown
`message`	Unknown
`object`	Unknown
`user_created_at`	Unknown
`user_deleted_at`	Unknown
`user_email`	Unknown
`user_first_name`	Unknown
`user_id`	Unknown
`user_last_name`	Unknown
`user_object`	Unknown
`user_time_zone`	Unknown

credit_payment_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`account_id`	Unknown	PKFK
`applied_to_invoice_id`	Unknown	FK
`original_credit_payment_id`	Unknown	FK
`original_invoice_id`	Unknown	FK
`refund_transaction_id`	Unknown	FK
`action`	Unknown
`amount`	Unknown
`created_at`	Unknown
`currency`	Unknown
`uuid`	Unknown
`voided_at`	Unknown

usage_record_tiers

Column	Type	Keys
`index`	Unknown	PK
`usage_record_id`	Unknown	PKFK
`ending_quantity`	Unknown
`unit_amount`	Unknown
`unit_amount_decimal`	Unknown
`usage_percentage`	Unknown

usage_record_percentage_tiers

Column	Type	Keys
`index`	Unknown	PK
`usage_record_id`	Unknown	PKFK
`ending_amount`	Unknown
`usage_percentage`	Unknown

usage_record

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PK
`subscription_plan_add_on_id`	Unknown	PK
`amount`	Unknown
`billed_at`	Instant
`created_at`	Instant
`measured_unit_id`	Unknown
`merchant_tag`	Unknown
`object`	Unknown
`recording_timestamp`	Instant
`tier_type`	Unknown
`unit_amount`	Unknown
`unit_amount_decimal`	Unknown
`updated_at`	Instant
`usage_percentage`	Unknown
`usage_timestamp`	Instant
`usage_type`	Unknown

coupon_redemption_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`account_id`	Unknown	FK
`coupon_id`	Unknown	FK
`subscription_id`	Unknown	FK
`created_at`	Unknown
`currency`	Unknown
`discounted`	Unknown
`removed_at`	Unknown
`state`	Unknown

transaction_fraud_info_risk_rules_triggered

Column	Type	Keys
`index`	Unknown	PK
`transaction_id`	Unknown	PKFK
`code`	Unknown
`message`	Unknown

transaction_subscription

Column	Type	Keys
`subscription_id`	Unknown	PK
`transaction_id`	Unknown	PKFK

transaction

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`invoice_id`	Unknown	FK
`original_transaction_id`	Unknown	FK
`voided_by_invoice_id`	Unknown	FK
`action_result`	Json
`amount`	Unknown
`avs_check`	Unknown
`backup_payment_method_used`	Unknown
`billing_city`	Unknown
`billing_country`	Unknown
`billing_first_name`	Unknown
`billing_geo_code`	Unknown
`billing_last_name`	Unknown
`billing_phone`	Unknown
`billing_postal_code`	Unknown
`billing_region`	Unknown
`billing_street_1`	Unknown
`billing_street_2`	Unknown
`collected_at`	Unknown
`collection_method`	Unknown
`created_at`	Unknown
`currency`	Unknown
`customer_message`	Unknown
`customer_message_locale`	Unknown
`cvv_check`	Unknown
`fraud_info_decision`	Unknown
`fraud_info_object`	Unknown
`fraud_info_reference`	Unknown
`fraud_info_score`	Unknown
`gateway_approval_code`	Unknown
`gateway_message`	Unknown
`gateway_reference`	Unknown
`gateway_response_code`	Unknown
`gateway_response_time`	Unknown
`gateway_response_values`	Json
`initiator`	Unknown
`ip_address_country`	Unknown
`ip_address_v_4`	Unknown
`next_action_type`	Unknown
`next_action_value`	Unknown
`origin`	Unknown
`payment_gateway_id`	Unknown
`payment_gateway_name`	Unknown
`payment_gateway_type`	Unknown
`payment_method_account_type`	Unknown
`payment_method_billing_agreement_id`	Unknown
`payment_method_card_network_preference`	Unknown
`payment_method_card_type`	Unknown
`payment_method_cc_bin_country`	Unknown
`payment_method_exp_month`	Unknown
`payment_method_exp_year`	Unknown
`payment_method_first_six`	Unknown
`payment_method_funding_source`	Unknown
`payment_method_gateway_attribute_account_reference`	Unknown
`payment_method_gateway_code`	Unknown
`payment_method_gateway_token`	Unknown
`payment_method_last_four`	Unknown
`payment_method_last_two`	Unknown
`payment_method_name_on_account`	Unknown
`payment_method_object`	Unknown
`payment_method_routing_number`	Unknown
`payment_method_routing_number_bank`	Unknown
`payment_method_username`	Unknown
`refunded`	Unknown
`status`	Unknown
`status_code`	Unknown
`status_message`	Unknown
`success`	Unknown
`type`	Unknown
`updated_at`	Instant
`uuid`	Unknown
`voided_at`	Unknown

dummy_temp

Column	Type	Keys
`account_history_temp_cred_migration_dummy`	Unknown	PK
`id`	Unknown	PK
`updated_at`	Unknown	PK

plan_add_on_currency_history

Column	Type	Keys
`currency`	Unknown	PK
`plan_add_on_id`	Unknown	PKFK
`plan_add_on_updated_at`	Instant	PKFK
`tax_inclusive`	Unknown
`unit_amount`	Unknown
`unit_amount_decimal`	Unknown

plan_add_on_tier_history

Column	Type	Keys
`index`	Unknown	PK
`plan_add_on_id`	Unknown	PK
`plan_add_on_tier_index`	Unknown	PK
`plan_add_on_updated_at`	Instant	PK
`currency`	Unknown
`ending_quantity`	Unknown
`unit_amount`	Unknown
`unit_amount_decimal`	Unknown
`usage_percentage`	Unknown

plan_add_on_currency_percentage_tier

Column	Type	Keys
`index`	Unknown	PK
`plan_add_on_id`	Unknown	PK
`plan_add_on_percentage_tier_index`	Unknown	PK
`plan_add_on_updated_at`	Instant	PK
`currency`	Unknown
`ending_amount`	Unknown
`usage_percentage`	Unknown

plan_add_on_history

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Instant	PK
`plan_id`	Unknown	FK
`accounting_code`	Unknown
`add_on_type`	Unknown
`avalara_service_type`	Unknown
`avalara_transaction_type`	Unknown
`code`	Unknown
`created_at`	Unknown
`default_quantity`	Unknown
`deleted_at`	Unknown
`display_quantity`	Unknown
`external_sku`	Unknown
`harmonized_system_code`	Unknown
`item_code`	Unknown
`item_description`	Unknown
`item_id`	Unknown
`item_name`	Unknown
`item_object`	Unknown
`item_state`	Unknown
`liability_gl_account_id`	Unknown
`measured_unit_id`	Unknown
`name`	Unknown
`object`	Unknown
`optional`	Unknown
`performance_obligation_id`	Unknown
`revenue_gl_account_id`	Unknown
`state`	Unknown
`tax_code`	Unknown
`tier_type`	Unknown
`usage_calculation_type`	Unknown
`usage_percentage`	Unknown
`usage_timeframe`	Unknown
`usage_type`	Unknown