# Shopify schema ERD

Table and field reference for the Fivetran Shopify connector.

## Table & Field Reference

### media_file_error

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| media_id | Long | PK, FK |
| code | String |  |
| details | String |  |
| message | String |  |

### price_rule_prereq_collection

| Column | Type | Keys |
| --- | --- | --- |
| collection_id | Long | PK, FK |
| price_rule_id | Long | PK, FK |

### company_location_tax_exemption

| Column | Type | Keys |
| --- | --- | --- |
| tax_exemption | String | PK |
| company_location_id | Long | PK, FK |

### draft_order_note_attribute

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| draft_order_id | Long | PK, FK |
| value | String |  |

### inventory_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| country_code_of_origin | String |  |
| created_at | Instant |  |
| duplicate_sku_count | Int |  |
| harmonized_system_code | String |  |
| inventory_history_url | String |  |
| legacy_resource_id | Long |  |
| measurement_id | Long |  |
| measurement_weight_unit | String |  |
| measurement_weight_value | Float |  |
| province_code_of_origin | String |  |
| requires_shipping | Boolean |  |
| sku | String |  |
| tracked | Boolean |  |
| tracked_editable_locked | Boolean |  |
| tracked_editable_reason | String |  |
| unit_cost_amount | Double |  |
| unit_cost_currency_code | String |  |
| updated_at | Instant |  |

### order_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| order_id | Long | PK, FK |
| value | String |  |

### fulfillment_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| fulfillment_order_id | Long | PK, FK |
| inventory_item_id | Long |  |
| remaining_quantity | Long |  |
| total_quantity | Long |  |

### catalog

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| status | String |  |
| title | String |  |
| price_list_** |  |  |

### abandoned_checkout

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | FK |
| location_id | Long | FK |
| user_id | Long | FK |
| abandoned_checkout_url | String |  |
| buyer_accepts_marketing | Boolean |  |
| cart_token | String |  |
| closed_at | Instant |  |
| completed_at | Instant |  |
| created_at | Instant |  |
| currency | String |  |
| customer_locale | String |  |
| device_id | Long |  |
| email | String |  |
| gateway | String |  |
| landing_site_base_url | String |  |
| name | String |  |
| note | String |  |
| note_attributes | Json |  |
| phone | String |  |
| presentment_currency | String |  |
| referring_site | String |  |
| shipping_line | String |  |
| shipping_rate_id | String |  |
| shipping_rate_price | Double |  |
| shipping_rate_title | String |  |
| source | String |  |
| source_identifier | String |  |
| source_name | String |  |
| source_url | String |  |
| subtotal_price | Double |  |
| taxes_included | Boolean |  |
| token | String |  |
| total_discounts | Double |  |
| total_duties | String |  |
| total_line_items_price | Double |  |
| total_price | Double |  |
| total_tax | Double |  |
| total_weight | Long |  |
| updated_at | Instant |  |
| applied_discount_** |  |  |
| billing_address_** |  |  |
| credit_card_** |  |  |
| shipping_address_** |  |  |

### product_viewed_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| product_variant_id | Long | FK |
| event_client_id | String |  |
| event_timestamp | Instant |  |

### price_rule_ent_product

| Column | Type | Keys |
| --- | --- | --- |
| price_rule_id | Long | PK, FK |
| product_id | Long | PK, FK |

### customer_tax_exemption

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| customer_id | Long | PK, FK |
| tax_exemption | String |  |

### discount_code_free_shipping

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| applies_on_one_time_purchase | Boolean |  |
| applies_on_subscription | Boolean |  |
| applies_once_per_customer | Boolean |  |
| async_usage_count | Int |  |
| codes_count | Int |  |
| codes_precision | String |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| customer_selection_all_customers | Boolean |  |
| destination_selection_all_countries | Boolean |  |
| destination_selection_include_rest_of_world | Boolean |  |
| discount_class | String |  |
| ends_at | Instant |  |
| has_timeline_comment | Boolean |  |
| maximum_shipping_price_amount | Double |  |
| maximum_shipping_price_currency_code | String |  |
| minimum_requirement_greater_than_or_equal_to_quantity | Int |  |
| minimum_requirement_gte_subtotal_amount | Double |  |
| minimum_requirement_gte_subtotal_currency_code | String |  |
| recurring_cycle_limit | Int |  |
| short_summary | String |  |
| starts_at | Instant |  |
| status | String |  |
| summary | String |  |
| title | String |  |
| total_sales_amount | Double |  |
| total_sales_currency_code | String |  |
| updated_at | Instant |  |
| usage_limit | Long |  |

### order_shipping_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| order_shipping_line_id | Long | PK, FK |
| price | Double |  |
| price_set | Json |  |
| rate | Double |  |
| title | String |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| address_1 | String |  |
| address_2 | String |  |
| city | String |  |
| country | String |  |
| country_code | String |  |
| country_name | String |  |
| created_at | Instant |  |
| legacy | Boolean |  |
| localized_country_name | String |  |
| localized_province_name | String |  |
| name | String |  |
| phone | String |  |
| province | String |  |
| province_code | String |  |
| updated_at | Instant |  |
| zip | String |  |

### product_removed_from_cart_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| merchandise_id | Unknown | FK |
| cost_amount | Double |  |
| cost_currency_code | String |  |
| event_client_id | String |  |
| event_timestamp | Instant |  |
| quantity | Int |  |

### discount_automatic_free_shipping

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| applies_on_one_time_purchase | Boolean |  |
| applies_on_subscription | Boolean |  |
| async_usage_count | Long |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| destination_selection_all_countries | Boolean |  |
| destination_selection_include_rest_of_world | Boolean |  |
| discount_class | String |  |
| ends_at | Instant |  |
| has_timeline_comment | Boolean |  |
| maximum_shipping_price_amount | Double |  |
| maximum_shipping_price_currency_code | String |  |
| minimum_requirement_greater_than_or_equal_to_quantity | Int |  |
| minimum_requirement_gte_subtotal_amount | Double |  |
| minimum_requirement_gte_subtotal_currency_code | String |  |
| recurring_cycle_limit | Long |  |
| short_summary | String |  |
| starts_at | Instant |  |
| status | String |  |
| summary | String |  |
| title | String |  |
| total_sales_amount | Double |  |
| total_sales_currency_code | String |  |
| updated_at | Instant |  |

### app

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| app_store_app_url | String |  |
| app_store_developer_url | String |  |
| description | String |  |
| developer_name | String |  |
| developer_type | String |  |
| embedded | Boolean |  |
| features | Json |  |
| handle | String |  |
| install_url | String |  |
| is_post_purchase_app_in_use | Boolean |  |
| previously_installed | Boolean |  |
| pricing_details | String |  |
| pricing_details_summary | String |  |
| privacy_policy_url | String |  |
| published | Boolean |  |
| shopify_developed | Boolean |  |
| title | String |  |
| uninstall_message | String |  |
| banner_** |  |  |
| icon_** |  |  |

### product_publication

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Long | PK, FK |
| publication_id | Long | PK, FK |

### customer_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| customer_id | Long | PK, FK |
| value | String |  |

### discount_customer_gets_collection

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_resource | String | PK |
| collection_id | Long | PK, FK |

### gift_card

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | FK |
| line_item_id | Long | FK |
| order_id | Long | FK |
| user_id | Long | FK |
| api_client_id | String |  |
| balance | Double |  |
| code | String |  |
| created_at | Instant |  |
| currency | String |  |
| disabled_at | String |  |
| expires_on | LocalDate |  |
| initial_value | String |  |
| last_characters | String |  |
| note | String |  |
| template_suffix | String |  |
| updated_at | Instant |  |

### bundle_component_variant

| Column | Type | Keys |
| --- | --- | --- |
| bundle_component_index | Long | PK, FK |
| component_variant_id | Long | PK, FK |
| product_id | Long | PK, FK |

### discount_code_app

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| app_discount_type_app_id | Long | FK |
| app_discount_type_app_bridge_create_path | String |  |
| app_discount_type_app_bridge_details_path | String |  |
| app_discount_type_app_key | String |  |
| app_discount_type_description | String |  |
| app_discount_type_discount_class | String |  |
| app_discount_type_function_id | String |  |
| app_discount_type_target_type | String |  |
| app_discount_type_title | String |  |
| applies_on_one_time_purchase | Boolean |  |
| applies_on_subscription | Boolean |  |
| applies_once_per_customer | Boolean |  |
| async_usage_count | Long |  |
| codes_count_count | Int |  |
| codes_count_precision | String |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| customer_selection_all_customers | Boolean |  |
| discount_class | String |  |
| discount_id | Long |  |
| ends_at | Instant |  |
| has_timeline_comment | Boolean |  |
| recurring_cycle_limit | Long |  |
| starts_at | Instant |  |
| status | String |  |
| title | String |  |
| total_sales_amount | Double |  |
| total_sales_currency_code | String |  |
| updated_at | Instant |  |
| usage_limit | Long |  |
| error_history_** |  |  |

### inventory_level

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| inventory_item_id | Long | PK, FK |
| location_id | Long | PK, FK |
| can_deactivate | Boolean |  |
| created_at | Instant |  |
| deactivation_alert | String |  |
| updated_at | Instant |  |

### company_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| company_id | Long | FK |
| created_at | Instant |  |
| currency | String |  |
| external_id | String |  |
| has_timeline_comment | Boolean |  |
| locale | String |  |
| name | String |  |
| note | String |  |
| phone | String |  |
| tax_settings_tax_exempt | Boolean |  |
| tax_settings_tax_registration_id | String |  |
| total_spent_amount | Double |  |
| total_spent_currency_code | String |  |
| updated_at | Instant |  |
| billing_address_** |  |  |
| buyer_exp_config_** |  |  |
| shipping_address_** |  |  |

### collection_product

| Column | Type | Keys |
| --- | --- | --- |
| collection_id | Long | PK, FK |
| product_id | Long | PK, FK |

### payout

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| amount | Double |  |
| currency | String |  |
| date | LocalDate |  |
| status | String |  |

### customer_visit

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | FK |
| landing_page | String |  |
| landing_page_html | String |  |
| occurred_at | Instant |  |
| referral_code | String |  |
| referral_info_html | String |  |
| referrer_url | String |  |
| source | String |  |
| source_description | String |  |
| source_type | String |  |
| type | String |  |
| utm_parameters_** |  |  |

### cart_line_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| event_id | String | PK, FK |
| merchandise_id | Unknown | FK |
| cost_amount | Double |  |
| cost_currency_code | String |  |
| quantity | Int |  |

### discount_customer_buys_product

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_resource | String | PK |
| product_id | Long | PK, FK |

### marketing_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| app_id | Long | FK |
| channel_handle | String |  |
| description | String |  |
| ended_at | Instant |  |
| manage_url | String |  |
| marketing_channel_type | String |  |
| preview_url | String |  |
| remote_id | String |  |
| scheduled_to_end_at | Instant |  |
| source_and_medium | String |  |
| started_at | Instant |  |
| type | String |  |
| utm_campaign | String |  |
| utm_medium | String |  |
| utm_source | String |  |

### return_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| return_id | Long | PK, FK |
| order_line_id | Long | FK |
| customer_note | String |  |
| quantity | Int |  |
| refundable_quantity | Int |  |
| refunded_quantity | Int |  |
| restocking_fee_amount_set_pres_amount | Double |  |
| restocking_fee_amount_set_pres_currency_code | String |  |
| restocking_fee_amount_set_shop_amount | Double |  |
| restocking_fee_amount_set_shop_currency_code | String |  |
| restocking_fee_id | Long |  |
| restocking_fee_percentage | Double |  |
| return_reason | String |  |
| return_reason_note | String |  |
| return_reason_definition_** |  |  |

### applied_gift_card

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| checkout_id | Long | FK |
| amount_used | Double |  |

### order_payment_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| draft_order_id | Long | FK |
| due | Boolean |  |
| due_in_days | Int |  |
| overdue | Boolean |  |
| payment_terms_name | String |  |
| payment_terms_type | String |  |
| translated_name | String |  |

### checkout_line_item_discount_allocation_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| checkout_line_item_id | String | PK, FK |
| event_id | String | PK, FK |
| amount | Double |  |
| currency_code | String |  |
| discount_application_** |  |  |

### price_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| allocation_limit | Long |  |
| allocation_method | String |  |
| created_at | Instant |  |
| customer_selection | String |  |
| ends_at | Instant |  |
| once_per_customer | Boolean |  |
| prerequisite_quantity_range | Double |  |
| prerequisite_shipping_price_range | Double |  |
| prerequisite_subtotal_range | Double |  |
| prerequisite_to_entitlement_purchase_prerequisite_amount | Double |  |
| quantity_ratio_entitled_quantity | Long |  |
| quantity_ratio_prerequisite_quantity | Long |  |
| starts_at | Instant |  |
| target_selection | String |  |
| target_type | String |  |
| title | String |  |
| updated_at | Instant |  |
| usage_limit | Long |  |
| value | Double |  |
| value_type | String |  |

### fulfillment_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| fulfillment_id | Long | FK |
| order_id | Long | FK |
| address_1 | String |  |
| city | String |  |
| country | String |  |
| created_at | Instant |  |
| estimated_delivery_at | Instant |  |
| happened_at | Instant |  |
| latitude | Float |  |
| longitude | Float |  |
| message | String |  |
| province | String |  |
| shop_id | Long |  |
| status | String |  |
| updated_at | Instant |  |
| zip | String |  |

### return_exchange_line_item_order_line

| Column | Type | Keys |
| --- | --- | --- |
| order_line_item_id | Long | PK, FK |
| return_exchange_line_item_id | Long | PK, FK |

### translatable_resource_translation

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| locale | String | PK |
| resource_type | String | PK |
| resource_id | Long | PK, FK |
| market_id | Long | FK |
| outdated | Boolean |  |
| updated_at | Instant |  |
| value | String |  |

### discount_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| price_rule_id | Long | FK |
| code | String |  |
| created_at | Instant |  |
| updated_at | Instant |  |
| usage_count | Double |  |

### order_url_tag

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| order_id | Long | PK, FK |
| value | String |  |

### video

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Long | PK, FK |
| duration | Int |  |
| file_name | String |  |
| original_source_** |  |  |

### abandoned_checkout_discount_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| checkout_id | Long | PK, FK |
| amount | Double |  |
| code | String |  |
| created_at | Instant |  |
| type | String |  |
| updated_at | Instant |  |

### order_payment_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_payment_term_id | Long | PK, FK |
| balance_due_amount | Double |  |
| balance_due_currency_code | String |  |
| completed_at | Instant |  |
| due | Boolean |  |
| due_at | Instant |  |
| issued_at | Instant |  |
| total_balance_amount | Double |  |
| total_balance_currency_code | String |  |

### checkout_delivery_option_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| event_id | String | PK, FK |
| cost_after_discounts_amount | Double |  |
| cost_after_discounts_currency_code | String |  |
| cost_amount | Double |  |
| cost_currency_code | String |  |
| description | String |  |
| handle | String |  |
| title | String |  |
| type | String |  |

### draft_order_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| draft_order_id | Long | PK, FK |
| value | String |  |

### sale_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| sale_id | Long | PK, FK |
| pres_amount | Double |  |
| pres_currency_code | String |  |
| shop_amount | Double |  |
| shop_currency_code | String |  |
| tax_line_** |  |  |

### dispute

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | FK |
| amount | Double |  |
| currency | String |  |
| evidence_due_by | Instant |  |
| evidence_sent_on | Instant |  |
| finalized_on | Instant |  |
| network_reason_code | String |  |
| reason | String |  |
| status | String |  |
| type | String |  |

### product_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_id | Long | FK |
| linked_metafield_key | String |  |
| linked_metafield_namespace | String |  |
| name | String |  |
| position | Long |  |
| values | Json |  |

### return_shipping_fee

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| return_id | Long | PK, FK |
| amount_set_presentment_money_amount | Double |  |
| amount_set_presentment_money_currency_code | String |  |
| amount_set_shop_money_amount | Double |  |
| amount_set_shop_money_currency_code | String |  |

### product_added_to_cart_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| merchandise_id | Unknown | FK |
| cost_amount | Double |  |
| cost_currency_code | String |  |
| event_client_id | String |  |
| event_timestamp | Instant |  |
| quantity | Int |  |

### return_exchange_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| return_id | Long | PK, FK |
| order_id | Long | FK |
| variant_id | Long | FK |
| processable_quantity | Int |  |
| processed_quantity | Int |  |
| quantity | Int |  |
| unprocessed_quantity | Int |  |

### discount_shareable_url

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_type | String | PK |
| index | Int | PK |
| target_type | String |  |
| title | String |  |
| url | String |  |
| target_item_image_** |  |  |

### fulfillment_order_fulfillment_hold

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| fulfillment_order_id | Long | PK, FK |
| reason | String |  |
| reason_notes | String |  |

### market_condition_company_location

| Column | Type | Keys |
| --- | --- | --- |
| company_location_id | Long | PK, FK |
| market_id | Long | PK, FK |

### discount_automatic_basic

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| async_usage_count | Long |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| discount_class | String |  |
| ends_at | Instant |  |
| minimum_requirement_greater_than_or_equal_to_quantity | Int |  |
| minimum_requirement_gte_subtotal_amount | Double |  |
| minimum_requirement_gte_subtotal_currency_code | String |  |
| recurring_cycle_limit | Long |  |
| short_summary | String |  |
| starts_at | Instant |  |
| status | String |  |
| summary | String |  |
| title | String |  |
| updated_at | Instant |  |
| customer_gets_** |  |  |

### price_list_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| price_list_id | Long | PK, FK |
| variant_id | Long | FK |
| compare_at_price_amount | Double |  |
| compare_at_price_currency_code | String |  |
| origin_type | String |  |
| price_amount | Double |  |
| price_currency_code | String |  |

### order_discount_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| order_id | Long | PK, FK |
| code | String | FK |
| amount | Double |  |
| type | String |  |

### model_3_d

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Long | PK, FK |
| bounding_box_size_x | Double |  |
| bounding_box_size_y | Double |  |
| bounding_box_size_z | Double |  |
| file_name | String |  |
| original_source_** |  |  |

### catalog_app

| Column | Type | Keys |
| --- | --- | --- |
| app_id | Long | PK, FK |
| catalog_id | Long | PK, FK |

### return

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| created_at | Instant |  |
| decline_note | String |  |
| decline_reason | String |  |
| name | String |  |
| return_shipping_fees | Json |  |
| status | String |  |
| total_quantity | Int |  |

### translatable_resource_translatable_content

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| resource_type | String | PK |
| resource_id | Long | PK, FK |
| digest | String |  |
| locale | String |  |
| type | String |  |
| value | String |  |

### price_rule_ent_country

| Column | Type | Keys |
| --- | --- | --- |
| country_id | Long | PK |
| price_rule_id | Long | PK, FK |

### order_note_attribute

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| order_id | Long | PK, FK |
| value | Json |  |

### publication

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| catalog_id | Long | FK |
| auto_publish | Boolean |  |
| supports_future_publishing | Boolean |  |

### refund

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | FK |
| user_id | Long | FK |
| created_at | Instant |  |
| note | String |  |
| processed_at | Instant |  |
| restock | Boolean |  |
| total_duties_set | Json |  |

### media_warning

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| media_id | Long | PK, FK |
| code | String |  |
| message | String |  |

### company_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| company_id | Long | FK |
| customer_id | Long | FK |
| created_at | Instant |  |
| is_main_contact | Boolean |  |
| locale | String |  |
| title | String |  |
| updated_at | Instant |  |

### order_line_duty

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_line_id | Long | PK, FK |
| country_code_of_origin | String |  |
| harmonized_system_code | String |  |
| price_pres_amount | Double |  |
| price_pres_currency_code | String |  |
| price_shop_amount | Double |  |
| price_shop_currency_code | String |  |

### metafield

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| owner_id | Long | PK |
| created_at | Instant |  |
| description | String |  |
| key | String |  |
| namespace | String |  |
| owner_resource | String |  |
| type | String |  |
| updated_at | Instant |  |
| value | String |  |

### inventory_quantity

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String | PK |
| inventory_item_id | Long | PK, FK |
| inventory_level_id | Long | PK, FK |
| quantity | Int |  |
| updated_at | Instant |  |

### discount_customer_buys_collection

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_resource | String | PK |
| collection_id | Long | PK, FK |

### product_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| product_id | Long | PK, FK |
| value | String |  |

### draft_order_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| draft_order_id | Long | PK, FK |
| product_id | Long | FK |
| variant_id | Long | FK |
| custom | Boolean |  |
| fulfillable_quantity | Long |  |
| gift_card | Boolean |  |
| grams | Long |  |
| name | String |  |
| price | Double |  |
| price_set | Json |  |
| properties | Json |  |
| quantity | Long |  |
| requires_shipping | Boolean |  |
| sku | String |  |
| taxable | Boolean |  |
| title | String |  |
| variant_title | String |  |
| vendor | String |  |
| applied_discount_** |  |  |

### discount_customer_gets_product_variant

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_resource | String | PK |
| product_variant_id | Long | PK, FK |

### search_result_product_variant_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK, FK |
| product_variant_id | Unknown | PK, FK |

### inventory_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| destination_location_id | Long | FK |
| origin_location_id | Long | FK |
| date_created | Instant |  |
| destination_name | String |  |
| destination_snapshotted_at | Instant |  |
| name | String |  |
| note | String |  |
| origin_name | String |  |
| origin_snapshotted_at | Instant |  |
| received_quantity | Int |  |
| reference_name | String |  |
| status | String |  |
| total_quantity | Int |  |

### collection_viewed_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| collection_id | String |  |
| event_client_id | String |  |
| event_timestamp | Instant |  |
| title | String |  |

### checkout_transaction_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| event_id | String | PK, FK |
| amount | Double |  |
| currency_code | String |  |
| gateway | String |  |
| payment_method_name | String |  |
| payment_method_type | String |  |

### sale

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| sales_agreement_id | Long | PK, FK |
| action_type | String |  |
| line_item_id | Long |  |
| line_type | String |  |
| quantity | Int |  |
| total_amount_pres_amount | Double |  |
| total_amount_pres_currency_code | String |  |
| total_amount_shop_amount | Double |  |
| total_amount_shop_currency_code | String |  |
| total_discount_amount_after_taxes_pres_amount | Double |  |
| total_discount_amount_after_taxes_pres_currency_code | String |  |
| total_discount_amount_after_taxes_shop_amount | Double |  |
| total_discount_amount_after_taxes_shop_currency_code | String |  |
| total_discount_amount_before_taxes_pres_amount | Double |  |
| total_discount_amount_before_taxes_pres_currency_code | String |  |
| total_discount_amount_before_taxes_shop_amount | Double |  |
| total_discount_amount_before_taxes_shop_currency_code | String |  |
| total_tax_amount_pres_amount | Double |  |
| total_tax_amount_pres_currency_code | String |  |
| total_tax_amount_shop_amount | Double |  |
| total_tax_amount_shop_currency_code | String |  |

### customer_segment_member

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Long | PK, FK |
| segment_id | Long | PK, FK |

### order_risk_summary

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Long | PK, FK |
| recommendation | String |  |

### discount_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| order_line_id | Long | PK, FK |
| discount_application_index | Long | FK |
| amount | Double |  |
| amount_set_presentment_money_amount | Double |  |
| amount_set_presentment_money_currency_code | String |  |
| amount_set_shop_money_amount | Double |  |
| amount_set_shop_money_currency_code | String |  |

### order_risk_fact

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| order_id | Long | PK, FK |
| order_risk_assessment_index | Int | PK, FK |
| description | String |  |
| sentiment | String |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| main_contact_id | Long | FK |
| created_at | Instant |  |
| default_role_id | Long |  |
| default_role_name | String |  |
| default_role_note | String |  |
| external_id | String |  |
| has_timeline_comment | Boolean |  |
| name | String |  |
| note | String |  |
| updated_at | Instant |  |

### checkout_discount_application_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| event_id | String | PK, FK |
| allocation_method | String |  |
| target_selection | String |  |
| target_type | String |  |
| title | String |  |
| type | String |  |
| value_amount | Double |  |
| value_currency_code | String |  |
| value_percentage | Double |  |

### abandoned_checkout_url_tag

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| checkout_id | Long | PK, FK |
| value | String |  |

### checkout_line_item_event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| event_id | String | PK, FK |
| final_line_price_amount | Double |  |
| final_line_price_currency_code | String |  |
| quantity | Int |  |
| selling_plan_allocation_id | Long |  |
| selling_plan_allocation_name | String |  |
| title | String |  |
| variant_id | Long |  |

### product_variant_media

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Long | PK, FK |
| product_variant_id | Long | PK, FK |

### inventory_transfer_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| inventory_transfer_id | Long | PK, FK |
| inventory_item_id | Long | FK |
| picked_for_shipment_quantity | Int |  |
| processable_quantity | Int |  |
| shippable_quantity | Int |  |
| shipped_quantity | Int |  |
| title | String |  |
| total_quantity | Int |  |

### bundle_component_option_selection

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| bundle_component_index | Long | PK, FK |
| product_id | Long | PK, FK |
| component_option_id | Long | FK |
| parent_option_id | Long | FK |
| values | Json |  |

### price_rule_prereq_variant

| Column | Type | Keys |
| --- | --- | --- |
| price_rule_id | Long | PK, FK |
| variant_id | Long | PK, FK |

### page_viewed_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| context_document_location_href | String |  |
| context_document_location_search | String |  |
| event_client_id | String |  |
| event_timestamp | Instant |  |

### discount_customer_segment_selection

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_type | String | PK |
| index | Int | PK |
| segment_id | Long | FK |

### order_line_duty_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| order_line_duty_id | Long | PK, FK |
| channel_liable | Boolean |  |
| price_set_pres_amount | Double |  |
| price_set_pres_currency_code | String |  |
| price_set_shop_amount | Double |  |
| price_set_shop_currency_code | String |  |
| rate | Double |  |
| rate_percentage | Double |  |
| source | String |  |
| title | String |  |

### search_submitted_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| event_client_id | String |  |
| event_timestamp | Instant |  |
| query | String |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| default_email_address_source_location_id | Long | FK |
| default_phone_number_source_location_id | Long | FK |
| created_at | Instant |  |
| currency | String |  |
| default_email_address | String |  |
| default_phone_number | String |  |
| default_phone_number_marketing_collected_from | String |  |
| default_phone_number_marketing_opt_in_level | String |  |
| default_phone_number_marketing_state | String |  |
| default_phone_number_marketing_updated_at | Instant |  |
| email | String |  |
| email_marketing_consent_consent_updated_at | Instant |  |
| email_marketing_consent_opt_in_level | String |  |
| email_marketing_consent_state | String |  |
| first_name | String |  |
| last_name | String |  |
| metafield | Json |  |
| multipass_identifier | String |  |
| note | String |  |
| orders_count | Long |  |
| phone | String |  |
| state | String |  |
| tax_exempt | Boolean |  |
| total_spent | Double |  |
| updated_at | Instant |  |
| verified_email | Boolean |  |
| sms_marketing_consent_** |  |  |

### fulfillment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| location_id | Long | FK |
| order_id | Long | FK |
| created_at | Instant |  |
| name | String |  |
| receipt_authorization | String |  |
| service | String |  |
| shipment_status | String |  |
| status | String |  |
| tracking_company | String |  |
| tracking_number | String |  |
| tracking_numbers | Json |  |
| tracking_urls | Json |  |
| updated_at | Instant |  |

### alert_displayed_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| event_client_id | String |  |
| event_timestamp | Instant |  |
| message | String |  |
| target | String |  |
| type | String |  |
| value | String |  |

### market_catalog

| Column | Type | Keys |
| --- | --- | --- |
| catalog_id | Long | PK, FK |
| market_id | Long | PK, FK |

### media

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| alt | String |  |
| created_at | Instant |  |
| file_status | String |  |
| media_content_type | String |  |
| preview_image_alt_text | String |  |
| preview_image_height | Long |  |
| preview_image_id | Long |  |
| preview_image_url | String |  |
| preview_image_width | Long |  |
| preview_status | String |  |
| status | String |  |
| updated_at | Instant |  |

### shop

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| address_1 | String |  |
| address_2 | String |  |
| auto_configure_tax_inclusivity | Boolean |  |
| checkout_api_supported | Boolean |  |
| city | String |  |
| cookie_consent_level | String |  |
| country | String |  |
| country_code | String |  |
| country_name | String |  |
| county_taxes | Boolean |  |
| created_at | Instant |  |
| currency | String |  |
| customer_email | String |  |
| domain | String |  |
| eligible_for_card_reader_giveaway | Boolean |  |
| eligible_for_payments | Boolean |  |
| email | String |  |
| enabled_presentment_currencies | Json |  |
| force_ssl | Boolean |  |
| google_apps_domain | String |  |
| google_apps_login_enabled | Boolean |  |
| has_discounts | Boolean |  |
| has_gift_cards | Boolean |  |
| has_storefront | Boolean |  |
| iana_timezone | String |  |
| latitude | Double |  |
| longitude | Double |  |
| money_format | String |  |
| money_in_emails_format | String |  |
| money_with_currency_format | String |  |
| money_with_currency_in_emails_format | String |  |
| multi_location_enabled | Boolean |  |
| myshopify_domain | String |  |
| name | String |  |
| password_enabled | Boolean |  |
| phone | String |  |
| plan_display_name | String |  |
| plan_name | String |  |
| pre_launch_enabled | Boolean |  |
| primary_locale | String |  |
| primary_location_id | Long |  |
| province | String |  |
| province_code | String |  |
| requires_extra_payments_agreement | Boolean |  |
| setup_required | Boolean |  |
| shop_owner | String |  |
| source | String |  |
| tax_shipping | Boolean |  |
| taxes_included | Boolean |  |
| timezone | String |  |
| updated_at | Instant |  |
| visitor_tracking_consent_preference | String |  |
| weight_unit | String |  |
| zip | String |  |

### price_rule_prereq_customer

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Long | PK, FK |
| price_rule_id | Long | PK, FK |

### collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| body_html | String |  |
| disjunctive | Boolean |  |
| handle | String |  |
| published_at | Instant |  |
| published_scope | String |  |
| rules | Json |  |
| sort_order | String |  |
| template_suffix | String |  |
| title | String |  |
| updated_at | Instant |  |

### market_condition

| Column | Type | Keys |
| --- | --- | --- |
| application_level | String | PK |
| condition_type | String | PK |
| market_id | Long | PK, FK |

### discount_customer_selection

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_type | String | PK |
| index | Int | PK |
| customer_id | Long | FK |

### ui_extension_errored_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| api_version | String |  |
| app_id | Long |  |
| app_name | String |  |
| app_version | String |  |
| event_client_id | String |  |
| event_timestamp | Instant |  |
| extension_name | String |  |
| extension_target | String |  |
| message | String |  |
| placement_reference | String |  |
| trace | String |  |
| type | String |  |

### translatable_resource

| Column | Type | Keys |
| --- | --- | --- |
| resource_id | Long | PK |
| resource_type | String | PK |

### adjustment_order_transaction

| Column | Type | Keys |
| --- | --- | --- |
| balance_transaction_id | Long | PK, FK |
| id | Long | PK, FK |
| order_id | Long | FK |
| amount | Double |  |
| order_name | String |  |

### discount_customer_buys_product_variant

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_resource | String | PK |
| product_variant_id | Long | PK, FK |

### abandoned_checkout_shipping_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| checkout_id | Long | PK, FK |
| api_client_id | Long |  |
| carrier_identifier | String |  |
| carrier_service_id | Long |  |
| code | String |  |
| delivery_category | String |  |
| delivery_expectation_range | String |  |
| delivery_expectation_range_max | Long |  |
| delivery_expectation_range_min | Long |  |
| delivery_expectation_type | String |  |
| discounted_price | Double |  |
| id | String |  |
| markup | Double |  |
| original_shop_markup | String |  |
| original_shop_price | String |  |
| phone | String |  |
| presentment_title | String |  |
| price | Double |  |
| requested_fulfillment_service_id | String |  |
| source | String |  |
| title | String |  |
| validation_context | String |  |

### tax_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| order_line_id | Long | PK, FK |
| price | Double |  |
| price_set | Json |  |
| rate | Double |  |
| title | String |  |

### checkout_line_item_property_event

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| checkout_line_item_id | String | PK, FK |
| event_id | String | PK, FK |
| value | String |  |

### company_location_catalog

| Column | Type | Keys |
| --- | --- | --- |
| catalog_id | Long | PK, FK |
| company_location_id | Long | PK, FK |

### draft_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | FK |
| order_id | Long | FK |
| admin_graphql_api_id | String |  |
| completed_at | Instant |  |
| created_at | Instant |  |
| currency | String |  |
| email | String |  |
| invoice_sent_at | Instant |  |
| invoice_url | String |  |
| name | String |  |
| note | String |  |
| status | String |  |
| subtotal_price | Double |  |
| subtotal_price_set | Json |  |
| tax_exempt | Boolean |  |
| tax_lines | Json |  |
| taxes_included | Boolean |  |
| total_price | Double |  |
| total_price_set | Json |  |
| total_tax | Double |  |
| total_tax_set | Json |  |
| updated_at | Instant |  |
| applied_discount_** |  |  |
| billing_address_** |  |  |
| shipping_address_** |  |  |
| shipping_line_** |  |  |

### cart_attribute_event

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| event_id | String | PK, FK |
| value | String |  |

### media_source

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| media_id | Long | PK, FK |
| file_size | Int |  |
| format | String |  |
| height | Int |  |
| mime_type | String |  |
| url | String |  |
| width | Int |  |

### draft_order_payment_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| draft_order_id | Long | PK, FK |
| order_id | Long | FK |
| due | Boolean |  |
| due_in_days | Int |  |
| overdue | Boolean |  |
| payment_terms_name | String |  |
| payment_terms_type | String |  |
| translated_name | String |  |

### abandoned_applied_discount

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| index | Long | PK |
| checkout_line_id | String | FK |
| checkout_shipping_line_id | String | FK |
| price_rule_id | Long | FK |
| amount | Double |  |
| applicable | Boolean |  |
| description | String |  |
| non_applicable_reason | String |  |
| script_version_id | Long |  |
| title | String |  |
| value | Double |  |
| value_type | String |  |

### market_condition_region

| Column | Type | Keys |
| --- | --- | --- |
| market_id | Long | PK, FK |
| region_id | Long | PK, FK |

### market

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| currency_settings_base_currency_currency_code | String |  |
| currency_settings_local_storefront_currency_enabled | Boolean |  |
| currency_settings_rounding_enabled | Boolean |  |
| handle | String |  |
| market_type | String |  |
| name | String |  |
| price_inclusions_inclusive_duties_pricing_strategy | String |  |
| price_inclusions_inclusive_tax_pricing_strategy | String |  |
| status | String |  |

### product_media

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Long | PK, FK |
| product_id | Long | PK, FK |

### customer_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| name | String |  |
| query | String |  |
| updated_at | Instant |  |

### draft_order_line_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| draft_order_id | Long | PK |
| index | Long | PK |
| draft_order_line_index | Long | PK, FK |
| price | Double |  |
| price_set | Json |  |
| rate | Double |  |
| title | String |  |

### discount_automatic_bxgy

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| async_usage_count | Long |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| discount_class | String |  |
| ends_at | Instant |  |
| starts_at | Instant |  |
| status | String |  |
| summary | String |  |
| title | String |  |
| updated_at | Instant |  |
| uses_per_order_limit | Long |  |
| customer_buys_** |  |  |
| customer_gets_** |  |  |

### draft_order_payment_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| draft_order_payment_term_id | Long | PK, FK |
| balance_due_amount | Double |  |
| balance_due_currency_code | String |  |
| completed_at | Instant |  |
| due | Boolean |  |
| due_at | Instant |  |
| issued_at | Instant |  |
| total_balance_amount | Double |  |
| total_balance_currency_code | String |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| compare_at_price_range_max_variant_compare_at_price_amount | Double |  |
| compare_at_price_range_max_variant_compare_at_price_currency_code | String |  |
| compare_at_price_range_min_variant_compare_at_price_amount | Double |  |
| compare_at_price_range_min_variant_compare_at_price_currency_code | String |  |
| created_at | Instant |  |
| description | String |  |
| description_html | String |  |
| featured_media_id | Long |  |
| gift_card_template_suffix | String |  |
| handle | String |  |
| has_only_default_variant | Boolean |  |
| has_out_of_stock_variants | Boolean |  |
| has_variants_that_requires_components | Boolean |  |
| is_gift_card | Boolean |  |
| legacy_resource_id | Long |  |
| max_variant_price_amount | Double |  |
| max_variant_price_currency_code | String |  |
| metafield | Json |  |
| min_variant_price_amount | Double |  |
| min_variant_price_currency_code | String |  |
| online_store_preview_url | String |  |
| product_type | String |  |
| published_at | Instant |  |
| requires_selling_plan | Boolean |  |
| seo_description | String |  |
| seo_title | String |  |
| status | String |  |
| template_suffix | String |  |
| title | String |  |
| total_inventory | Long |  |
| tracks_inventory | Boolean |  |
| updated_at | Instant |  |
| vendor | String |  |
| category_** |  |  |

### order_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| product_id | Long | FK |
| variant_id | Long | FK |
| fulfillable_quantity | Long |  |
| fulfillment_status | String |  |
| gift_card | Boolean |  |
| grams | Long |  |
| index | Long |  |
| name | String |  |
| price | Double |  |
| price_set | Json |  |
| product_exists | Boolean |  |
| properties | Json |  |
| quantity | Long |  |
| requires_shipping | Boolean |  |
| sku | String |  |
| tax_code | String |  |
| taxable | Boolean |  |
| title | String |  |
| total_discount | Double |  |
| total_discount_set | Json |  |
| variant_inventory_management | String |  |
| variant_title | String |  |
| vendor | String |  |

### discount_redeem_code

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_type | String | PK |
| id | Long | PK |
| created_by_id | Long | FK |
| code | String |  |

### checkout_attribute_event

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| event_id | String | PK, FK |
| value | String |  |

### customer_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | PK, FK |
| address_1 | String |  |
| address_2 | String |  |
| city | String |  |
| company | String |  |
| country | String |  |
| country_code | String |  |
| first_name | String |  |
| is_default | Boolean |  |
| last_name | String |  |
| latitude | String |  |
| longitude | String |  |
| name | String |  |
| phone | String |  |
| province | String |  |
| province_code | String |  |
| zip | String |  |

### order_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | FK |
| refund_id | Long | FK |
| amount | Double |  |
| amount_set | Json |  |
| kind | String |  |
| reason | String |  |
| tax_amount | Double |  |
| tax_amount_set | Json |  |

### bundle_component

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| product_id | Long | PK, FK |
| component_product_id | Long | FK |
| quantity_option_parent_option_id | Long | FK |
| quantity | Long |  |
| quantity_option_name | String |  |
| quantity_option_values | Json |  |

### market_condition_location

| Column | Type | Keys |
| --- | --- | --- |
| location_id | Long | PK, FK |
| market_id | Long | PK, FK |

### cart_viewed_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| cart_id | String |  |
| cost_amount | Double |  |
| cost_currency_code | String |  |
| event_client_id | String |  |
| event_timestamp | Instant |  |
| total_quantity | Int |  |

### order_line_refund

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| location_id | Long | FK |
| order_line_id | Long | FK |
| refund_id | Long | FK |
| quantity | Double |  |
| restock_type | String |  |
| subtotal | Double |  |
| subtotal_set | Json |  |
| total_tax | Double |  |
| total_tax_set | Json |  |

### price_rule_ent_variant

| Column | Type | Keys |
| --- | --- | --- |
| price_rule_id | Long | PK, FK |
| variant_id | Long | PK, FK |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_id | Long | PK, FK |
| inventory_item_id | Long | FK |
| available_for_sale | Boolean |  |
| barcode | String |  |
| compare_at_price | String |  |
| created_at | Instant |  |
| display_name | String |  |
| inventory_policy | String |  |
| inventory_quantity | Int |  |
| legacy_resource_id | Long |  |
| metafield | Json |  |
| position | Int |  |
| price | Double |  |
| requires_components | Boolean |  |
| sellable_online_quantity | Int |  |
| sku | String |  |
| tax_code | String |  |
| taxable | Boolean |  |
| title | String |  |
| updated_at | Instant |  |

### media_image

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Long | PK, FK |
| mime_type | String |  |
| original_source_file_size | Int |  |
| original_source_url | String |  |
| image_** |  |  |

### discount_destination_selection_country

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_type | String | PK |
| index | Int | PK |
| country_code | String |  |

### price_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| currency | String |  |
| name | String |  |
| parent_adjustment_type | String |  |
| parent_adjustment_value | Double |  |
| parent_settings_compare_at_mode | String |  |

### fulfillment_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| assigned_location_location_id | Long | FK |
| assigned_location_address_1 | String |  |
| assigned_location_address_2 | String |  |
| assigned_location_city | String |  |
| assigned_location_country_code | String |  |
| assigned_location_id | Long |  |
| assigned_location_name | String |  |
| assigned_location_phone | String |  |
| assigned_location_province | String |  |
| assigned_location_zip | String |  |
| created_at | Instant |  |
| fulfill_at | Instant |  |
| fulfill_by | Instant |  |
| international_duties_incoterm | String |  |
| request_status | String |  |
| status | String |  |
| supported_actions | Json |  |
| updated_at | Instant |  |
| delivery_method_** |  |  |
| destination_** |  |  |

### discount_customer_gets_product

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Long | PK |
| discount_resource | String | PK |
| product_id | Long | PK, FK |

### price_rule_prereq_product

| Column | Type | Keys |
| --- | --- | --- |
| price_rule_id | Long | PK, FK |
| product_id | Long | PK, FK |

### product_option_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_option_id | Long | PK, FK |
| has_variants | Boolean |  |
| linked_metafield_value | String |  |
| name | String |  |

### balance_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| payout_id | Long | FK |
| source_order_id | Long | FK |
| source_order_transaction_id | Long | FK |
| amount | Double |  |
| currency | String |  |
| fee | Double |  |
| net | Double |  |
| payout_status | String |  |
| processed_at | Instant |  |
| source_id | Long |  |
| source_type | String |  |
| test | Boolean |  |
| type | String |  |

### external_video

| Column | Type | Keys |
| --- | --- | --- |
| media_id | Long | PK, FK |
| embed_url | String |  |
| host | String |  |
| origin_url | String |  |

### discount_automatic_app

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| app_discount_type_app_id | Long | FK |
| app_discount_type_app_bridge_create_path | String |  |
| app_discount_type_app_bridge_details_path | String |  |
| app_discount_type_app_key | String |  |
| app_discount_type_description | String |  |
| app_discount_type_discount_class | String |  |
| app_discount_type_function_id | String |  |
| app_discount_type_target_type | String |  |
| app_discount_type_title | String |  |
| applies_on_one_time_purchase | Boolean |  |
| applies_on_subscription | Boolean |  |
| async_usage_count | Long |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| discount_class | String |  |
| discount_id | Long |  |
| ends_at | Instant |  |
| recurring_cycle_limit | Long |  |
| starts_at | Instant |  |
| status | String |  |
| title | String |  |
| updated_at | Instant |  |
| error_history_** |  |  |

### order_shipping_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| carrier_identifier | String |  |
| code | String |  |
| discounted_price | Double |  |
| discounted_price_set | Json |  |
| is_removed | Boolean |  |
| phone | String |  |
| price | Double |  |
| price_set | Json |  |
| requested_fulfillment_service_id | String |  |
| source | String |  |
| title | String |  |

### abandoned_checkout_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| checkout_id | Long | PK, FK |
| destination_location_id | Long | FK |
| origin_location_id | Long | FK |
| product_id | Long | FK |
| variant_id | Long | FK |
| compare_at_price | Double |  |
| gift_card | Boolean |  |
| grams | Long |  |
| id | String |  |
| key | String |  |
| line_price | Double |  |
| price | Double |  |
| properties | Json |  |
| quantity | Long |  |
| requires_shipping | Boolean |  |
| sku | String |  |
| tax_code | String |  |
| taxable | Boolean |  |
| title | String |  |
| variant_title | String |  |
| vendor | String |  |

### checkout_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK |
| buyer_accepts_email_marketing | Boolean |  |
| buyer_accepts_sms_marketing | Boolean |  |
| currency_code | String |  |
| discounts_amount | Double |  |
| discounts_currency_code | String |  |
| email | String |  |
| event_client_id | String |  |
| event_name | String |  |
| event_timestamp | Instant |  |
| localization_country_iso_code | String |  |
| localization_language_iso_code | String |  |
| localization_market_handle | String |  |
| localization_market_id | Long |  |
| order_customer_id | Long |  |
| order_customer_is_first_order | Boolean |  |
| order_id | Long |  |
| phone | String |  |
| shipping_line_price_amount | Double |  |
| shipping_line_price_currency_code | String |  |
| sms_marketing_phone | String |  |
| subtotal_price_amount | Double |  |
| subtotal_price_currency_code | String |  |
| token | String |  |
| total_price_amount | Double |  |
| total_price_currency_code | String |  |
| total_tax_amount | Double |  |
| total_tax_currency_code | String |  |
| billing_address_** |  |  |
| shipping_address_** |  |  |

### order_risk_assessment

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| order_id | Long | PK, FK |
| provider | Long |  |
| risk_level | String |  |

### sales_agreement

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| app_id | Long | FK |
| order_id | Long | FK |
| refund_id | Long | FK |
| return_id | Long | FK |
| user_id | Long | FK |
| happened_at | Instant |  |
| reason | String |  |

### tender_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | FK |
| user_id | Long | FK |
| amount | Double |  |
| currency | String |  |
| payment_details_credit_card_company | String |  |
| payment_details_credit_card_number | String |  |
| payment_method | String |  |
| processed_at | Instant |  |
| remote_reference | String |  |
| test | Boolean |  |

### price_rule_prereq_customer_segment

| Column | Type | Keys |
| --- | --- | --- |
| price_rule_id | Long | PK, FK |
| segment_id | Long | PK, FK |

### product_variant_option_value

| Column | Type | Keys |
| --- | --- | --- |
| option_value_id | Long | PK, FK |
| variant_id | Long | PK, FK |

### order

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| company_id | Long | FK |
| company_location_id | Long | FK |
| customer_id | Long | FK |
| location_id | Long | FK |
| user_id | Long | FK |
| app_id | Long |  |
| browser_ip | String |  |
| buyer_accepts_marketing | Boolean |  |
| cancel_reason | String |  |
| cancelled_at | Instant |  |
| cart_token | String |  |
| checkout_id | String |  |
| checkout_token | String |  |
| client_details_user_agent | String |  |
| closed_at | Instant |  |
| confirmed | Boolean |  |
| created_at | Instant |  |
| currency | String |  |
| current_subtotal_price | Double |  |
| current_subtotal_price_set | Json |  |
| current_total_discounts | Double |  |
| current_total_discounts_set | Json |  |
| current_total_duties_set | Json |  |
| current_total_price | Double |  |
| current_total_price_set | Json |  |
| current_total_tax | Double |  |
| current_total_tax_set | Json |  |
| customer_locale | String |  |
| device_id | String |  |
| email | String |  |
| financial_status | String |  |
| fulfillment_status | String |  |
| landing_site_base_url | String |  |
| landing_site_ref | String |  |
| name | String |  |
| note | String |  |
| note_attributes | Json |  |
| number | Long |  |
| order_number | Long |  |
| order_status_url | String |  |
| original_total_duties_set | Json |  |
| payment_gateway_names | Json |  |
| phone | String |  |
| presentment_currency | String |  |
| processed_at | Instant |  |
| reference | String |  |
| referring_site | String |  |
| source_identifier | String |  |
| source_name | String |  |
| source_url | String |  |
| subtotal_price | Double |  |
| subtotal_price_set | Json |  |
| taxes_included | Boolean |  |
| test | Boolean |  |
| token | String |  |
| total_discounts | Double |  |
| total_discounts_set | Json |  |
| total_line_items_price | Double |  |
| total_line_items_price_set | Json |  |
| total_outstanding | Double |  |
| total_price | Double |  |
| total_price_set | Json |  |
| total_shipping_price_set | Json |  |
| total_tax | Double |  |
| total_tax_set | Json |  |
| total_tip_received | Double |  |
| total_weight | Long |  |
| updated_at | Instant |  |
| billing_address_** |  |  |
| shipping_address_** |  |  |

### discount_application

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| order_id | Long | PK, FK |
| allocation_method | String |  |
| code | String |  |
| description | String |  |
| target_selection | String |  |
| target_type | String |  |
| title | String |  |
| type | String |  |
| value | Double |  |
| value_type | String |  |

### media_error

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| media_id | Long | PK, FK |
| code | String |  |
| details | String |  |
| message | String |  |

### market_region

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| code | String |  |
| currency_code | String |  |
| name | String |  |

### price_rule_ent_collection

| Column | Type | Keys |
| --- | --- | --- |
| collection_id | Long | PK, FK |
| price_rule_id | Long | PK, FK |

### user

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| bio | String |  |
| email | String |  |
| first_name | String |  |
| im_address | String |  |
| is_account_owner | Boolean |  |
| last_name | String |  |
| locale | String |  |
| permissions | Json |  |
| phone | String |  |
| receive_announcements | Long |  |
| url | String |  |
| user_type | String |  |

### fulfillment_order_line

| Column | Type | Keys |
| --- | --- | --- |
| order_line_id | Long | PK |
| fulfillment_id | Long | PK, FK |
| order_id | Long | FK |
| product_id | Long | FK |
| variant_id | Long | FK |
| fulfillable_quantity | Long |  |
| gift_card | Boolean |  |
| grams | Long |  |
| name | String |  |
| price | Double |  |
| price_set | Json |  |
| properties | Json |  |
| quantity | Long |  |
| requires_shipping | Boolean |  |
| sku | String |  |
| taxable | Boolean |  |
| title | String |  |
| variant_title | String |  |
| vendor | String |  |

### collection_viewed_product_variant_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | String | PK, FK |
| product_variant_id | Long | PK, FK |

### discount_code_basic

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| applies_once_per_customer | Boolean |  |
| async_usage_count | Int |  |
| codes_count | Int |  |
| codes_precision | String |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| customer_selection_all_customers | Boolean |  |
| discount_class | String |  |
| ends_at | Instant |  |
| has_timeline_comment | Boolean |  |
| minimum_requirement_greater_than_or_equal_to_quantity | Int |  |
| minimum_requirement_gte_subtotal_amount | Double |  |
| minimum_requirement_gte_subtotal_currency_code | String |  |
| recurring_cycle_limit | Int |  |
| short_summary | String |  |
| starts_at | Instant |  |
| status | String |  |
| summary | String |  |
| title | String |  |
| total_sales_amount | Double |  |
| total_sales_currency_code | String |  |
| updated_at | Instant |  |
| usage_limit | Long |  |
| customer_gets_** |  |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| location_id | Long | FK |
| order_id | Long | FK |
| parent_id | Long | FK |
| refund_id | Long | FK |
| user_id | String | FK |
| amount | Double |  |
| authorization | String |  |
| authorization_expires_at | Instant |  |
| created_at | Instant |  |
| currency | String |  |
| device_id | String |  |
| error_code | String |  |
| extended_authorization_extended_authorization_expires_at | Instant |  |
| extended_authorization_standard_authorization_expires_at | Instant |  |
| gateway | String |  |
| kind | String |  |
| message | String |  |
| processed_at | Instant |  |
| receipt | Json |  |
| source_name | String |  |
| status | String |  |
| test | Boolean |  |
| currency_exchange_** |  |  |
| payment_** |  |  |

### discount_code_bxgy

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| applies_once_per_customer | Boolean |  |
| async_usage_count | Int |  |
| codes_count | Int |  |
| codes_precision | String |  |
| combines_with_order_discounts | Boolean |  |
| combines_with_product_discounts | Boolean |  |
| combines_with_shipping_discounts | Boolean |  |
| created_at | Instant |  |
| customer_selection_all_customers | Boolean |  |
| discount_class | String |  |
| ends_at | Instant |  |
| has_timeline_comment | Boolean |  |
| starts_at | Instant |  |
| status | String |  |
| summary | String |  |
| title | String |  |
| total_sales_amount | Double |  |
| total_sales_currency_code | String |  |
| updated_at | Instant |  |
| usage_limit | Long |  |
| uses_per_order_limit | Int |  |
| customer_buys_** |  |  |
| customer_gets_** |  |  |

### abandoned_checkout_tax_line

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| index | Long | PK |
| checkout_id | Long | FK |
| checkout_line_id | String | FK |
| checkout_shipping_line_id | String | FK |
| compare_at | Double |  |
| position | Long |  |
| price | Double |  |
| rate | Double |  |
| source | String |  |
| title | String |  |
| zone | String |  |

## Relationships

- media_file_error(media_id) → media(id)
- price_rule_prereq_collection(price_rule_id) → price_rule(id)
- price_rule_prereq_collection(collection_id) → collection(id)
- company_location_tax_exemption(company_location_id) → company_location(id)
- draft_order_note_attribute(draft_order_id) → draft_order(id)
- order_tag(order_id) → order(id)
- fulfillment_order_line_item(fulfillment_order_id) → fulfillment_order(id)
- abandoned_checkout(user_id) → user(id)
- abandoned_checkout(location_id) → location(id)
- abandoned_checkout(customer_id) → customer(id)
- product_viewed_event(product_variant_id) → product_variant(id)
- price_rule_ent_product(price_rule_id) → price_rule(id)
- price_rule_ent_product(product_id) → product(id)
- customer_tax_exemption(customer_id) → customer(id)
- order_shipping_tax_line(order_shipping_line_id) → order_shipping_line(order_id)
- product_removed_from_cart_event(merchandise_id) → product_variant(id)
- product_publication(product_id) → product(id)
- product_publication(publication_id) → publication(id)
- customer_tag(customer_id) → customer(id)
- discount_customer_gets_collection(collection_id) → collection(id)
- gift_card(customer_id) → customer(id)
- gift_card(line_item_id) → order_line(id)
- gift_card(order_id) → order(id)
- gift_card(user_id) → user(id)
- bundle_component_variant(bundle_component_index) → bundle_component(index)
- bundle_component_variant(product_id) → product(id)
- bundle_component_variant(component_variant_id) → product_variant(id)
- discount_code_app(app_discount_type_app_id) → app(id)
- inventory_level(inventory_item_id) → inventory_item(id)
- inventory_level(location_id) → location(id)
- company_location(company_id) → company(id)
- collection_product(collection_id) → collection(id)
- collection_product(product_id) → product(id)
- customer_visit(order_id) → order(id)
- cart_line_event(event_id) → cart_viewed_event(event_id)
- cart_line_event(merchandise_id) → product_variant(id)
- discount_customer_buys_product(product_id) → product(id)
- marketing_event(app_id) → app(id)
- return_line_item(return_id) → return(id)
- return_line_item(order_line_id) → order_line(id)
- applied_gift_card(checkout_id) → abandoned_checkout(id)
- order_payment_term(order_id) → order(id)
- order_payment_term(draft_order_id) → draft_order(id)
- checkout_line_item_discount_allocation_event(event_id) → checkout_event(event_id)
- checkout_line_item_discount_allocation_event(checkout_line_item_id) → checkout_line_item_event(event_id)
- fulfillment_event(order_id) → order(id)
- fulfillment_event(fulfillment_id) → fulfillment(id)
- return_exchange_line_item_order_line(return_exchange_line_item_id) → return_exchange_line_item(id)
- return_exchange_line_item_order_line(order_line_item_id) → order_line(id)
- translatable_resource_translation(market_id) → market(id)
- translatable_resource_translation(resource_id) → translatable_resource(resource_id)
- discount_code(price_rule_id) → price_rule(id)
- order_url_tag(order_id) → order(id)
- video(media_id) → media(id)
- abandoned_checkout_discount_code(checkout_id) → abandoned_checkout(id)
- order_payment_schedule(order_payment_term_id) → order_payment_term(id)
- checkout_delivery_option_event(event_id) → checkout_event(event_id)
- draft_order_tag(draft_order_id) → draft_order(id)
- sale_tax(sale_id) → sale(id)
- dispute(order_id) → order(id)
- product_option(product_id) → product(id)
- return_shipping_fee(return_id) → return(id)
- product_added_to_cart_event(merchandise_id) → product_variant(id)
- return_exchange_line_item(return_id) → return(id)
- return_exchange_line_item(order_id) → order(id)
- return_exchange_line_item(variant_id) → product_variant(id)
- fulfillment_order_fulfillment_hold(fulfillment_order_id) → fulfillment_order(id)
- market_condition_company_location(market_id) → market(id)
- market_condition_company_location(company_location_id) → company_location(id)
- price_list_price(price_list_id) → price_list(id)
- price_list_price(variant_id) → product_variant(id)
- order_discount_code(order_id) → order(id)
- order_discount_code(code) → discount_code(id)
- model_3_d(media_id) → media(id)
- catalog_app(catalog_id) → catalog(id)
- catalog_app(app_id) → app(id)
- return(order_id) → order(id)
- translatable_resource_translatable_content(resource_id) → translatable_resource(resource_id)
- price_rule_ent_country(price_rule_id) → price_rule(id)
- order_note_attribute(order_id) → order(id)
- publication(catalog_id) → catalog(id)
- refund(user_id) → user(id)
- refund(order_id) → order(id)
- media_warning(media_id) → media(id)
- company_contact(company_id) → company(id)
- company_contact(customer_id) → customer(id)
- order_line_duty(order_line_id) → order_line(id)
- inventory_quantity(inventory_level_id) → inventory_level(id)
- inventory_quantity(inventory_item_id) → inventory_item(id)
- discount_customer_buys_collection(collection_id) → collection(id)
- product_tag(product_id) → product(id)
- draft_order_line(product_id) → product(id)
- draft_order_line(variant_id) → product_variant(id)
- draft_order_line(draft_order_id) → draft_order(id)
- discount_customer_gets_product_variant(product_variant_id) → product_variant(id)
- search_result_product_variant_event(event_id) → search_submitted_event(event_id)
- search_result_product_variant_event(product_variant_id) → product_variant(id)
- inventory_transfer(destination_location_id) → location(id)
- inventory_transfer(origin_location_id) → location(id)
- checkout_transaction_event(event_id) → checkout_event(event_id)
- sale(sales_agreement_id) → sales_agreement(id)
- customer_segment_member(segment_id) → customer_segment(id)
- customer_segment_member(customer_id) → customer(id)
- order_risk_summary(order_id) → order(id)
- discount_allocation(order_line_id) → order_line(id)
- discount_allocation(discount_application_index) → discount_application(index)
- order_risk_fact(order_id) → order(id)
- order_risk_fact(order_risk_assessment_index) → order_risk_assessment(index)
- company(main_contact_id) → company_contact(id)
- checkout_discount_application_event(event_id) → checkout_event(event_id)
- abandoned_checkout_url_tag(checkout_id) → abandoned_checkout(id)
- checkout_line_item_event(event_id) → checkout_event(event_id)
- product_variant_media(product_variant_id) → product_variant(id)
- product_variant_media(media_id) → media(id)
- inventory_transfer_line_item(inventory_item_id) → inventory_item(id)
- inventory_transfer_line_item(inventory_transfer_id) → inventory_transfer(id)
- bundle_component_option_selection(bundle_component_index) → bundle_component(index)
- bundle_component_option_selection(product_id) → product(id)
- bundle_component_option_selection(component_option_id) → product_option(id)
- bundle_component_option_selection(parent_option_id) → product_option(id)
- price_rule_prereq_variant(price_rule_id) → price_rule(id)
- price_rule_prereq_variant(variant_id) → product_variant(id)
- discount_customer_segment_selection(segment_id) → customer_segment(id)
- order_line_duty_tax_line(order_line_duty_id) → order_line_duty(id)
- customer(default_email_address_source_location_id) → location(id)
- customer(default_phone_number_source_location_id) → location(id)
- fulfillment(order_id) → order(id)
- fulfillment(location_id) → location(id)
- market_catalog(market_id) → market(id)
- market_catalog(catalog_id) → catalog(id)
- price_rule_prereq_customer(price_rule_id) → price_rule(id)
- price_rule_prereq_customer(customer_id) → customer(id)
- market_condition(market_id) → market(id)
- discount_customer_selection(customer_id) → customer(id)
- adjustment_order_transaction(id) → transaction(id)
- adjustment_order_transaction(balance_transaction_id) → balance_transaction(id)
- adjustment_order_transaction(order_id) → order(id)
- discount_customer_buys_product_variant(product_variant_id) → product_variant(id)
- abandoned_checkout_shipping_line(checkout_id) → abandoned_checkout(id)
- tax_line(order_line_id) → order_line(id)
- checkout_line_item_property_event(event_id) → checkout_event(event_id)
- checkout_line_item_property_event(checkout_line_item_id) → checkout_line_item_event(event_id)
- company_location_catalog(catalog_id) → catalog(id)
- company_location_catalog(company_location_id) → company_location(id)
- draft_order(order_id) → order(id)
- draft_order(customer_id) → customer(id)
- cart_attribute_event(event_id) → cart_viewed_event(event_id)
- media_source(media_id) → media(id)
- draft_order_payment_term(order_id) → order(id)
- draft_order_payment_term(draft_order_id) → draft_order(id)
- abandoned_applied_discount(checkout_line_id) → abandoned_checkout_line(index)
- abandoned_applied_discount(checkout_shipping_line_id) → abandoned_checkout_shipping_line(index)
- abandoned_applied_discount(price_rule_id) → price_rule(id)
- market_condition_region(market_id) → market(id)
- market_condition_region(region_id) → market_region(id)
- product_media(product_id) → product(id)
- product_media(media_id) → media(id)
- draft_order_line_tax_line(draft_order_line_index) → draft_order_line(index)
- draft_order_payment_schedule(draft_order_payment_term_id) → draft_order_payment_term(id)
- order_line(product_id) → product(id)
- order_line(variant_id) → product_variant(id)
- order_line(order_id) → order(id)
- discount_redeem_code(created_by_id) → app(id)
- checkout_attribute_event(event_id) → checkout_event(event_id)
- customer_address(customer_id) → customer(id)
- order_adjustment(order_id) → order(id)
- order_adjustment(refund_id) → refund(id)
- bundle_component(product_id) → product(id)
- bundle_component(component_product_id) → product(id)
- bundle_component(quantity_option_parent_option_id) → product_option(id)
- market_condition_location(market_id) → market(id)
- market_condition_location(location_id) → location(id)
- order_line_refund(location_id) → location(id)
- order_line_refund(refund_id) → refund(id)
- order_line_refund(order_line_id) → order_line(id)
- price_rule_ent_variant(price_rule_id) → price_rule(id)
- price_rule_ent_variant(variant_id) → product_variant(id)
- product_variant(product_id) → product(id)
- product_variant(inventory_item_id) → inventory_item(id)
- media_image(media_id) → media(id)
- fulfillment_order(order_id) → order(id)
- fulfillment_order(assigned_location_location_id) → location(id)
- discount_customer_gets_product(product_id) → product(id)
- price_rule_prereq_product(price_rule_id) → price_rule(id)
- price_rule_prereq_product(product_id) → product(id)
- product_option_value(product_option_id) → product_option(id)
- balance_transaction(payout_id) → payout(id)
- balance_transaction(source_order_id) → order(id)
- balance_transaction(source_order_transaction_id) → transaction(id)
- external_video(media_id) → media(id)
- discount_automatic_app(app_discount_type_app_id) → app(id)
- order_shipping_line(order_id) → order(id)
- abandoned_checkout_line(checkout_id) → abandoned_checkout(id)
- abandoned_checkout_line(variant_id) → product_variant(id)
- abandoned_checkout_line(product_id) → product(id)
- abandoned_checkout_line(origin_location_id) → location(id)
- abandoned_checkout_line(destination_location_id) → location(id)
- order_risk_assessment(order_id) → order(id)
- sales_agreement(order_id) → order(id)
- sales_agreement(app_id) → app(id)
- sales_agreement(refund_id) → refund(id)
- sales_agreement(return_id) → return(id)
- sales_agreement(user_id) → user(id)
- tender_transaction(order_id) → order(id)
- tender_transaction(user_id) → user(id)
- price_rule_prereq_customer_segment(price_rule_id) → price_rule(id)
- price_rule_prereq_customer_segment(segment_id) → customer_segment(id)
- product_variant_option_value(variant_id) → product_variant(id)
- product_variant_option_value(option_value_id) → product_option_value(id)
- order(customer_id) → customer(id)
- order(location_id) → location(id)
- order(user_id) → user(id)
- order(company_id) → company(id)
- order(company_location_id) → company_location(id)
- discount_application(order_id) → order(id)
- media_error(media_id) → media(id)
- price_rule_ent_collection(price_rule_id) → price_rule(id)
- price_rule_ent_collection(collection_id) → collection(id)
- fulfillment_order_line(product_id) → product(id)
- fulfillment_order_line(variant_id) → product_variant(id)
- fulfillment_order_line(fulfillment_id) → fulfillment(id)
- fulfillment_order_line(order_id) → order(id)
- collection_viewed_product_variant_event(event_id) → collection_viewed_event(event_id)
- collection_viewed_product_variant_event(product_variant_id) → product_variant(id)
- transaction(order_id) → order(id)
- transaction(refund_id) → refund(id)
- transaction(location_id) → location(id)
- transaction(parent_id) → transaction(id)
- transaction(user_id) → user(id)
- abandoned_checkout_tax_line(checkout_id) → abandoned_checkout(id)
- abandoned_checkout_tax_line(checkout_line_id) → abandoned_checkout_line(index)
- abandoned_checkout_tax_line(checkout_shipping_line_id) → abandoned_checkout_shipping_line(index)