Fivetran documentation

Search the docs

/

Ordergroove

Explore the interactive ERD

Table & Field Reference

payment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`billing_address`	Unknown
`cc_exp_date`	Unknown
`cc_holder`	Unknown
`cc_number_ending`	Unknown
`cc_type`	Unknown
`created`	Unknown
`label`	Unknown
`last_updated`	Unknown
`live`	Unknown
`payment_method`	Unknown
`token_id`	Unknown

offer_profile_offer_id

Column	Type	Keys
`offer_id`	Unknown	PK
`offer_profile_id`	Unknown	PKFK

offer_profile_initial_coupon_discount

Column	Type	Keys
`id`	Unknown	PK
`offer_profile_id`	Unknown	PKFK
`coupon`	Unknown
`field`	Unknown
`has_condition`	Unknown
`name`	Unknown
`object`	Unknown
`threshold_field`	Unknown
`threshold_value`	Unknown
`type`	Unknown
`value`	Unknown

offer_profile_recurring_coupon_discount

Column	Type	Keys
`id`	Unknown	PK
`offer_profile_id`	Unknown	PKFK
`coupon`	Unknown
`field`	Unknown
`has_condition`	Unknown
`name`	Unknown
`object`	Unknown
`threshold_field`	Unknown
`threshold_value`	Unknown
`type`	Unknown
`value`	Unknown

offer_profile

Column	Type	Keys
`id`	Unknown	PK
`initial_coupon_code`	Unknown
`initial_coupon_has_condition`	Unknown
`initial_coupon_name`	Unknown
`initial_coupon_public_id`	Unknown
`live`	Unknown
`merchant`	Unknown
`name`	Unknown
`recurring_coupon_code`	Unknown
`recurring_coupon_has_condition`	Unknown
`recurring_coupon_name`	Unknown
`recurring_coupon_public_id`	Unknown
`weight`	Unknown

item

Column	Type	Keys
`id`	Unknown	PK
`offer_id`	Unknown	FK
`order_id`	Unknown	FK
`product_id`	Unknown	FK
`subscription_id`	Unknown	FK
`component`	Json
`extra_cost`	Unknown
`first_placed`	Unknown
`frozen`	Unknown
`one_time`	Unknown
`order_placed_end_date`	Unknown
`order_placed_start_date`	Unknown
`price`	Unknown
`product_attribute`	Unknown
`quantity`	Unknown
`subscription_component`	Unknown
`total_price`	Unknown

product_group

Column	Type	Keys
`_fivetran_id`	String	PK
`product_id`	Unknown	PKFK
`group_type`	Unknown
`name`	Unknown

product_selection_rule_element

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`product_selection_rule_id`	Unknown	PKFK
`starting_date`	Unknown

product_selection_rule

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`selection_rule_type`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`autoship_by_default`	Unknown
`autoship_enabled`	Unknown
`created`	Unknown
`detail_url`	Unknown
`discontinued`	Unknown
`every`	Unknown
`every_period`	Unknown
`extra_data`	Json
`image_url`	Unknown
`incentive_group`	Unknown
`last_update`	Unknown
`live`	Unknown
`merchant`	Unknown
`name`	Unknown
`offer_profile`	Unknown
`premier_enabled`	Unknown
`prepaid_eligible`	Unknown
`price`	Unknown
`product_type`	Unknown
`sku`	Unknown

address

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`address`	Unknown
`address_2`	Unknown
`city`	Unknown
`company_name`	Unknown
`country_code`	Unknown
`created`	Unknown
`fax`	Unknown
`first_name`	Unknown
`label`	Unknown
`last_name`	Unknown
`live`	Unknown
`phone`	Unknown
`state_province_code`	Unknown
`store_public_id`	Unknown
`token_id`	Unknown
`zip_postal_code`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`created`	Unknown
`email`	Unknown
`extra_data`	Unknown
`first_name`	Unknown
`last_login`	Unknown
`last_name`	Unknown
`last_updated`	Unknown
`live`	Unknown
`locale`	Unknown
`merchant`	Unknown
`phone_number`	Unknown
`phone_type`	Unknown
`price_code`	Unknown
`session_id`	Unknown
`user_token_id`	Unknown

incentive

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`order_id`	Unknown	FK
`created`	Unknown
`description`	Unknown
`discount_type`	Unknown
`expires`	Unknown
`external_code`	Unknown
`field`	Unknown
`item`	Unknown
`last_updated`	Unknown
`merchant`	Unknown
`name`	Unknown
`public_id`	Unknown
`stacking_type`	Unknown
`target`	Unknown
`threshold_field`	Unknown
`threshold_value`	Unknown
`type`	Unknown
`value`	Unknown

merchant_cancel_reason

Column	Type	Keys
`_fivetran_id`	String	PK
`application`	Unknown
`cancel_reason`	Unknown

subscription_component

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

subscription

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`payment_id`	Unknown	FK
`product_id`	Unknown	FK
`shipping_address`	Unknown	FK
`cancel_reason`	Unknown
`cancel_reason_code`	Unknown
`cancelled`	Unknown
`club`	Unknown
`created`	Unknown
`currency_code`	Unknown
`customer_rep`	Unknown
`every`	Unknown
`every_period`	Unknown
`external_id`	Unknown
`extra_data_commitment_committed`	Unknown
`extra_data_commitment_version`	Unknown
`extra_data_migration_sub_id`	Unknown
`extra_data_shopify_contract_id`	Unknown
`frequency_days`	Unknown
`iteration`	Unknown
`live`	Unknown
`merchant`	Unknown
`merchant_order_id`	Unknown
`offer`	Unknown
`prepaid_subscription_context`	Unknown
`price`	Unknown
`product_attribute`	Unknown
`quantity`	Unknown
`raw_subscription_type`	Unknown
`reminder_days`	Unknown
`sequence`	Unknown
`session_id`	Unknown
`start_date`	Unknown
`subscription_type`	Unknown
`updated`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`payment_id`	Unknown	FK
`shipping_address`	Unknown	FK
`cancelled`	Unknown
`created`	Unknown
`currency_code`	Unknown
`discount_total`	Unknown
`extra_data`	Unknown
`generic_error_count`	Unknown
`locked`	Unknown
`merchant`	Unknown
`oos_free_shipping`	Unknown
`order_merchant_id`	Unknown
`place`	Unknown
`rejected_message`	Unknown
`shipping_total`	Unknown
`status`	Unknown
`sub_total`	Unknown
`tax_total`	Unknown
`total`	Unknown
`tries`	Unknown
`type`	Unknown
`updated`	Unknown

subscription_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`subscription_id`	Unknown	PKFK
`title`	Unknown