Recharge

Explore the interactive ERD

Table & Field Reference

event_updated_attribute

Column	Type	Keys
`index`	Unknown	PK
`event_id`	Unknown	PKFK
`attribute`	Unknown
`previous_value`	Unknown
`value`	Unknown

event

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

payment_method

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

credit_account

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

bundle_selection_item

Column	Type	Keys
`id`	Unknown	PK
`bundle_selection_id`	Unknown	PKFK
`collection_id`	Unknown
`collection_source`	Unknown
`created_at`	Unknown
`external_product_id`	Unknown
`external_variant_id`	Unknown
`price`	Unknown
`quantity`	Unknown
`updated_at`	Unknown

bundle_selection

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

credit_adjustment

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

metafield

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

discount

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

subscription_utm_tag

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

subscription

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

subscription_history

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

plan

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

one_time_product

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

charge_tax_line

Column	Type	Keys
`index`	Int	PK
`charge_id`	Long	PKFK
`price`	String
`rate`	String
`title`	String

charge_activity_payment_method_info

Column	Type	Keys
`index`	Int	PK
`charge_activity_index`	Int	PKFK
`charge_id`	Long	PKFK
`payment_method_id`	Long	FK
`brand`	String
`exp_month`	Long
`exp_year`	Long
`last_4`	String
`payment_type`	String

charge_activity

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

charge_shipping_line

Column	Type	Keys
`index`	Int	PK
`charge_id`	Long	PKFK
`code`	String
`price`	Double
`title`	String

charge_order_attribute

Column	Type	Keys
`index`	Int	PK
`charge_id`	Long	PKFK
`order_attribute`	Json

charge_line_item

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

charge_discount

Column	Type	Keys
`index`	Int	PK
`charge_id`	Long	PKFK
`id`	Unknown	FK
`code`	String
`value`	Double
`value_type`	String

charge_utm_tag

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

charge

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

address_discounts

Column	Type	Keys
`index`	Int	PK
`address_id`	Long	PKFK
`id`	Long

address

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

address_shipping_line

Column	Type	Keys
`index`	Int	PK
`address_id`	Long	PKFK
`code`	String
`price`	String
`title`	String

order_line_item

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

orders

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

customer_utm_tag

Column	Type	Keys
`_fivetran_id`	String	PK
`customer_id`	Long	PKFK
`campaign`	String
`content`	String
`data_source`	String
`medium`	String
`source`	String
`term`	String
`time_stamp`	Instant

customer

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

customer_delivery_schedule_order_line_item

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

customer_delivery_schedule_order

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

checkout_line_item

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

checkout_utm_tag

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

checkout

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