Fivetran documentation

Search the docs

/

Prive

Explore the interactive ERD

Table & Field Reference

one_time_add_on

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PKFK
`variant_id`	Unknown	FK
`quantity`	Unknown

subscription_gift

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	PKFK
`created_at`	Unknown
`email`	Unknown
`gift_to`	Unknown
`is_opened`	Unknown
`is_prepaid`	Unknown
`message`	Unknown
`number_of_deliveries`	Unknown
`updated_at`	Unknown

subscription_recipient

Column	Type	Keys
`id`	Unknown	PKFK
`subscription_id`	Unknown	PKFK

subscription_custom_attribute

Column	Type	Keys
`key`	Unknown	PK
`subscription_id`	Unknown	PKFK
`value`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`subscriber_id`	Unknown	FK
`billing_address_1`	Unknown
`billing_address_2`	Unknown
`billing_cadence_count`	Unknown
`billing_cadence_unit`	Unknown
`billing_city`	Unknown
`billing_country`	Unknown
`billing_first_name`	Unknown
`billing_last_name`	Unknown
`billing_province`	Unknown
`billing_zip`	Unknown
`cancel_date`	Unknown
`cancel_reason`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`delivery_address_1`	Unknown
`delivery_address_2`	Unknown
`delivery_cadence_count`	Unknown
`delivery_cadence_unit`	Unknown
`delivery_city`	Unknown
`delivery_company`	Unknown
`delivery_country`	Unknown
`delivery_first_name`	Unknown
`delivery_last_name`	Unknown
`delivery_phone`	Unknown
`delivery_price`	Unknown
`delivery_province`	Unknown
`delivery_shipping_option`	Unknown
`delivery_zip`	Unknown
`external_id`	Unknown
`friendly_id`	Unknown
`is_prepaid`	Unknown
`next_billing_date`	Unknown
`next_delivery_date`	Unknown
`payment_method_brand`	Unknown
`payment_method_email`	Unknown
`payment_method_expiry_month`	Unknown
`payment_method_expiry_year`	Unknown
`payment_method_external_id`	Unknown
`payment_method_last_4_digit`	Unknown
`payment_method_name`	Unknown
`payment_method_type`	Unknown
`purchase_date`	Unknown
`status`	Unknown
`updated_at`	Unknown

billing_attempt

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`subscription_id`	Unknown	FK
`created_at`	Unknown
`error_code`	Unknown
`error_msg`	Unknown
`external_id`	Unknown
`updated_at`	Unknown

subscription_discount_code

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	FK
`code`	Unknown
`created_at`	Unknown
`discount_code_external_id`	Unknown
`updated_at`	Unknown

subscription_line

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	FK
`subscription_offer_option_id`	Unknown	FK
`variant_id`	Unknown	FK
`created_at`	Unknown
`current_price`	Unknown
`custom_attribute`	Unknown
`external_id`	Unknown
`quantity`	Unknown
`selling_plan_id`	Unknown
`updated_at`	Unknown

base_order_line_item

Column	Type	Keys
`id`	Unknown	PK
`base_order_id`	Unknown	FK
`variant_id`	Unknown	FK
`created_at`	Unknown
`current_price`	Unknown
`is_add_on_one_time`	Unknown
`quantity`	Unknown
`updated_at`	Unknown

entry_point_visibility

Column	Type	Keys
`index`	Unknown	PK
`swap_and_add_on_option_id`	Unknown	PKFK
`entry_point_visibility`	Unknown

variant_entry_point_visibility

Column	Type	Keys
`variant_external_id`	Unknown	PK
`swap_and_add_on_option_id`	Unknown	PKFK
`entry_point_visibility`	Json

swap_and_add_on_option

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`subscription_offer_id`	Unknown	FK
`created_at`	Unknown
`one_time_add_on_discount`	Unknown
`one_time_add_on_discount_modifier_type`	Unknown
`updated_at`	Unknown

product_variant

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`current_price`	Unknown
`external_id`	Unknown
`sku`	Unknown
`variant_title`	Unknown

product_subscription_offer

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`external_id`	Unknown
`name`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Unknown

product_subscription_offer_option

Column	Type	Keys
`id`	Unknown	PK
`product_subscription_offer_id`	Unknown	PKFK
`archived`	Unknown
`billing_cadence_count`	Unknown
`billing_cadence_unit`	Unknown
`created_at`	Unknown
`delivery_cadence_count`	Unknown
`delivery_cadence_unit`	Unknown
`discount`	Unknown
`discount_modifier`	Unknown
`external_id`	Unknown
`name`	Unknown
`type`	Unknown
`updated_at`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`subscription_offer_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`external_id`	Unknown
`image_url`	Unknown
`product_title`	Unknown
`updated_at`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`base_order_id`	Unknown	FK
`subscriber_id`	Unknown	FK
`charged_amount`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`delivery_amount`	Unknown
`external_id`	Unknown
`is_skipped`	Unknown
`purchase_date`	Unknown
`scheduled_date`	Unknown
`status`	Unknown
`subscription_charged_amount`	Unknown
`tax`	Unknown
`type`	Unknown
`updated_at`	Unknown

order_line_item

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`subscription_id`	Unknown	FK
`variant_id`	Unknown	FK
`created_at`	Unknown
`discount_allocation_total_amount`	Unknown
`external_id`	Unknown
`price_total`	Unknown
`price_total_discounted`	Unknown
`price_total_tax_with_discounts`	Unknown
`product_title`	Unknown
`quantity`	Unknown
`updated_at`	Unknown

base_order

Column	Type	Keys
`id`	Unknown	PK
`subscription_contract_id`	Unknown	FK
`created_at`	Unknown
`currency_code`	Unknown
`is_skipped`	Unknown
`scheduled_date`	Unknown
`sequence_number`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Unknown

subscriber

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`email`	Unknown
`external_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`phone`	Unknown
`phone_country_code`	Unknown
`updated_at`	Unknown

subscription_activity

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`event_timestamp`	Unknown
`type`	Unknown
`updated_at`	Unknown
`users`	Unknown