# commercetools schema ERD

Table and field reference for the Fivetran commercetools connector.

## Table & Field Reference

### review

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | String | FK |
| author_name | String |  |
| created_at | Instant |  |
| customer_type_id | Unknown |  |
| included_in_statistics | Boolean |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| locale | Unknown |  |
| rating | Int |  |
| state_id | String |  |
| state_type_id | Unknown |  |
| target_id | String |  |
| target_type_id | Unknown |  |
| text | String |  |
| title | String |  |
| uniqeness_value | Unknown |  |
| version | Unknown |  |
| version_modified_at | Instant |  |
| custom_** |  |  |

### shipping_method_zone_shipping_rate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipping_method_zone_rate_shipping_method_id | Unknown | PK, FK |
| shipping_method_zone_rate_zone_id | Unknown | PK, FK |
| free_above_cent_amount | Unknown |  |
| free_above_currency_code | Unknown |  |
| free_above_fraction_digits | Unknown |  |
| free_above_precise_amount | Unknown |  |
| free_above_type | Unknown |  |
| is_matching | Unknown |  |
| price_cent_amount | Unknown |  |
| price_currency_code | Unknown |  |
| price_fraction_digits | Unknown |  |
| price_precise_amount | Unknown |  |
| price_type | Unknown |  |

### shipping_method_zone_rate

| Column | Type | Keys |
| --- | --- | --- |
| zone_id | Unknown | PK |
| shipping_method_id | Unknown | PK, FK |
| zone_type_id | Unknown |  |

### shipping_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| is_default | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |
| predicate | Unknown |  |
| tax_category_id | Unknown |  |
| tax_category_type_id | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |
| localized_description_** |  |  |
| localized_name_** |  |  |

### discount_code_reference

| Column | Type | Keys |
| --- | --- | --- |
| reference_id | Unknown | PK |
| discount_code_id | Unknown | PK, FK |
| reference_type_id | Unknown |  |

### cart_discount_code

| Column | Type | Keys |
| --- | --- | --- |
| cart_id | Unknown | PK |
| discount_code_id | Unknown | PK, FK |
| id | Unknown | FK |
| cart_type_id | Unknown |  |

### discount_code_group

| Column | Type | Keys |
| --- | --- | --- |
| group_name | Unknown | PK |
| discount_code_id | Unknown | PK, FK |

### discount_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_version | Unknown |  |
| cart_predicate | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| is_active | Unknown |  |
| last_modified_at | Instant |  |
| max_applications | Unknown |  |
| max_applications_per_customer | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |
| version | Unknown |  |
| version_modified_at | Unknown |  |
| custom_** |  |  |
| description_** |  |  |
| name_** |  |  |

### shopping_list_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shopping_list_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| added_at | Unknown |  |
| deactivated_at | Unknown |  |
| product_type_id | Unknown |  |
| product_type_type_id | Unknown |  |
| quantity | Unknown |  |
| variant_id | Unknown |  |
| custom_** |  |  |
| name_** |  |  |
| product_slug_** |  |  |

### shopping_list_text_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shopping_list_id | Unknown | PK, FK |
| added_at | Unknown |  |
| quantity | Unknown |  |
| custom_** |  |  |
| description_** |  |  |
| name_** |  |  |

### shopping_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| anonymous_id | Unknown |  |
| created_at | Unknown |  |
| customer_type_id | Unknown |  |
| delete_days_after_last_modification | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| store_id | Unknown |  |
| store_type_id | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |
| description_** |  |  |
| name_** |  |  |
| slug_** |  |  |

### business_unit_store

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| type_id | Unknown |  |

### business_unit_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| additional_address_info | Unknown |  |
| additional_street_info | Unknown |  |
| apartment | Unknown |  |
| building | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| key | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| phone | Unknown |  |
| po_box | Unknown |  |
| postal_code | Unknown |  |
| region | Unknown |  |
| salutation | Unknown |  |
| state | Unknown |  |
| street_name | Unknown |  |
| street_number | Unknown |  |
| title | Unknown |  |

### business_unit_associate_role

| Column | Type | Keys |
| --- | --- | --- |
| role | Unknown | PK |
| business_unit_associate_business_unit_id | Unknown | PK, FK |
| business_unit_associate_index | Unknown | PK, FK |

### business_unit_associate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| business_unit_id | Unknown | PK, FK |
| customer_id | Unknown |  |
| customer_type_id | Unknown |  |

### business_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_unit_key | Unknown | FK |
| top_level_unit_key | Unknown | FK |
| contact_email | Unknown |  |
| created_at | Unknown |  |
| default_billing_address_id | Unknown |  |
| default_shipping_address_id | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |
| parent_unit_type_id | Unknown |  |
| status | Unknown |  |
| store_mode | Unknown |  |
| top_level_unit_type_id | Unknown |  |
| unit_type | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

### customer_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

### standalone_price_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| standalone_price_id | Unknown | PK, FK |
| minimum_quantity | Unknown |  |
| value_cent_amount | Unknown |  |
| value_currency_code | Unknown |  |
| value_fraction_digits | Unknown |  |
| value_precise_amount | Unknown |  |
| value_type | Unknown |  |

### standalone_price

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| country | Unknown |  |
| create_at | Unknown |  |
| customer_group_id | Unknown |  |
| customer_group_type_id | Unknown |  |
| discount_id | Unknown |  |
| discount_type_id | Unknown |  |
| discount_value_cent_amount | Unknown |  |
| discount_value_currency_code | Unknown |  |
| discount_value_fraction_digits | Unknown |  |
| discount_value_precise_amount | Unknown |  |
| discount_value_type | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| sku | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |
| value_cent_amount | Unknown |  |
| value_currency_code | Unknown |  |
| value_fraction_digits | Unknown |  |
| value_precise_amount | Unknown |  |
| value_type | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

### cart_discount_reference

| Column | Type | Keys |
| --- | --- | --- |
| reference_id | Unknown | PK |
| cart_discount_id | Unknown | PK, FK |
| reference_type_id | Unknown |  |

### cart_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cart_predicate | Unknown |  |
| created_at | Unknown |  |
| is_active | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| requires_discount_code | Unknown |  |
| sort_order | Unknown |  |
| stacking_mode | Unknown |  |
| target_predicate | Unknown |  |
| target_type | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |
| value_money | Unknown |  |
| value_permyriad | Unknown |  |
| value_type | Unknown |  |
| version | Unknown |  |
| version_modified_at | Unknown |  |
| custom_** |  |  |
| description_** |  |  |
| name_** |  |  |

### product_discount_reference

| Column | Type | Keys |
| --- | --- | --- |
| reference_id | Unknown | PK |
| product_discount_id | Unknown | PK, FK |
| reference_type_id | Unknown |  |

### product_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| is_active | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| predicate | Unknown |  |
| sort_order | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |
| value_money | Unknown |  |
| value_permyriad | Unknown |  |
| value_type | Unknown |  |
| version | Unknown |  |
| version_modified_at | Unknown |  |
| description_** |  |  |
| name_** |  |  |

### tax_category_rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tax_category_id | Unknown | PK, FK |
| amount | Unknown |  |
| country | Unknown |  |
| included_in_price | Unknown |  |
| name | Unknown |  |

### tax_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |
| version | Unknown |  |
| version_modified_at | Instant |  |

### shipping_zone_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipping_zone_id | Unknown | PK, FK |
| country | Unknown |  |
| state | Unknown |  |

### shipping_zone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| name | Unknown |  |
| version | Unknown |  |

### category_ancestor

| Column | Type | Keys |
| --- | --- | --- |
| ancestor_id | Unknown | PK |
| category_id | Unknown | PK, FK |
| ancestory_type_id | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assets | Unknown |  |
| created_at | Unknown |  |
| key | Unknown |  |
| last_message_sequence_number | Unknown |  |
| last_modified_at | Instant |  |
| orders_hint | Unknown |  |
| parent_id | String |  |
| parent_type_id | Unknown |  |
| version | Unknown |  |
| version_modified_at | Unknown |  |
| custom_** |  |  |
| description_** |  |  |
| meta_description_** |  |  |
| meta_keywords_** |  |  |
| meta_title_** |  |  |
| name_** |  |  |
| slug_** |  |  |

### channel_role

| Column | Type | Keys |
| --- | --- | --- |
| role | Unknown | PK |
| channel_id | Unknown | PK, FK |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_email | Unknown |  |
| address_first_name | Unknown |  |
| address_key | Unknown |  |
| address_last_name | Unknown |  |
| address_mobile | Unknown |  |
| address_phone | Unknown |  |
| address_postal_code | Unknown |  |
| address_street_name | Unknown |  |
| address_street_number | Unknown |  |
| address_title | Unknown |  |
| created_at | Unknown |  |
| geo_location_coordinates | Json |  |
| geo_location_type | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| review_rating_statistics_average_rating | Unknown |  |
| review_rating_statistics_count | Unknown |  |
| review_rating_statistics_highest_rating | Unknown |  |
| review_rating_statistics_lowest_rating | Unknown |  |
| review_rating_statistics_ratings_distribution | Unknown |  |
| version | Unknown |  |
| version_modified_at | Unknown |  |
| custom_** |  |  |
| description_** |  |  |
| name_** |  |  |

### cart_line_item_state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| cart_line_item_id | Unknown | PK, FK |
| quantity | Unknown |  |
| state_id | Unknown |  |
| state_type_id | Unknown |  |

### cart_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cart_id | Unknown | PK, FK |
| added_at | Unknown |  |
| inventory_mode | Unknown |  |
| last_modified_at | Unknown |  |
| line_item_mode | Unknown |  |
| price_country | Unknown |  |
| price_id | Unknown |  |
| price_key | Unknown |  |
| price_mode | Unknown |  |
| price_valid_from | Unknown |  |
| price_valid_until | Unknown |  |
| price_value_cent_amount | Unknown |  |
| price_value_currency_code | Unknown |  |
| price_value_fraction_digits | Unknown |  |
| price_value_precise_amount | Unknown |  |
| price_value_type | Unknown |  |
| product_id | Unknown |  |
| product_key | Unknown |  |
| product_type_id | Unknown |  |
| product_type_type_id | Unknown |  |
| quantity | Unknown |  |
| shipping_details_targets | Unknown |  |
| shipping_details_valid | Unknown |  |
| tax_rate_amount | Unknown |  |
| tax_rate_country | Unknown |  |
| tax_rate_id | Unknown |  |
| tax_rate_included_in_price | Unknown |  |
| tax_rate_name | Unknown |  |
| tax_rate_state | Unknown |  |
| taxed_price_portions | Unknown |  |
| taxed_price_total_gross_cent_amount | Unknown |  |
| taxed_price_total_gross_currency_code | Unknown |  |
| taxed_price_total_gross_fraction_digits | Unknown |  |
| taxed_price_total_gross_type | Unknown |  |
| taxed_price_total_net_cent_amount | Unknown |  |
| taxed_price_total_net_currency_code | Unknown |  |
| taxed_price_total_net_fraction_digits | Unknown |  |
| taxed_price_total_net_type | Unknown |  |
| taxed_price_total_tax_cent_amount | Unknown |  |
| taxed_price_total_tax_currency_code | Unknown |  |
| taxed_price_total_tax_fraction_digits | Unknown |  |
| taxed_price_total_tax_type | Unknown |  |
| total_price_cent_amount | Unknown |  |
| total_price_currency_code | Unknown |  |
| total_price_fraction_digits | Unknown |  |
| total_price_type | Unknown |  |
| variant_id | Unknown |  |
| custom_** |  |  |
| name_** |  |  |
| product_slug_** |  |  |

### cart_custom_line_item_state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| cart_custom_line_item_id | Unknown | PK, FK |
| quantity | Unknown |  |
| state_id | Unknown |  |
| state_type_id | Unknown |  |

### cart_custom_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cart_id | Unknown | PK, FK |
| money_cent_amount | Unknown |  |
| money_currency_code | Unknown |  |
| money_fraction_digits | Unknown |  |
| money_precise_amount | Unknown |  |
| money_type | Unknown |  |
| price_mode | Unknown |  |
| quantity | Unknown |  |
| slug | Unknown |  |
| tax_category_id | Unknown |  |
| tax_category_type_id | Unknown |  |
| tax_rate_amount | Unknown |  |
| tax_rate_country | Unknown |  |
| tax_rate_id | Unknown |  |
| tax_rate_included_in_price | Unknown |  |
| tax_rate_name | Unknown |  |
| tax_rate_state | Unknown |  |
| taxed_price_total_gross_cent_amount | Unknown |  |
| taxed_price_total_gross_currency_code | Unknown |  |
| taxed_price_total_gross_fraction_digits | Unknown |  |
| taxed_price_total_gross_type | Unknown |  |
| taxed_price_total_net_cent_amount | Unknown |  |
| taxed_price_total_net_currency_code | Unknown |  |
| taxed_price_total_net_fraction_digits | Unknown |  |
| taxed_price_total_net_type | Unknown |  |
| taxed_price_total_tax_cent_amount | Unknown |  |
| taxed_price_total_tax_currency_code | Unknown |  |
| taxed_price_total_tax_fraction_digits | Unknown |  |
| taxed_price_total_tax_type | Unknown |  |
| total_price_cent_amount | Unknown |  |
| total_price_currency_code | Unknown |  |
| total_price_fraction_digits | Unknown |  |
| total_price_type | Unknown |  |
| custom_** |  |  |
| name_** |  |  |

### cart_shipping

| Column | Type | Keys |
| --- | --- | --- |
| shipping_key | Unknown | PK |
| cart_id | Unknown | PK, FK |
| shipping_info_pricecent_amount | Unknown |  |
| shipping_info_pricecurrency_code | Unknown |  |
| shipping_info_pricefraction_digits | Unknown |  |
| shipping_info_priceprecise_amount | Unknown |  |
| shipping_info_pricetype | Unknown |  |
| shipping_info_shipping_method_id | Unknown |  |
| shipping_info_shipping_method_name | Unknown |  |
| shipping_info_shipping_method_type_id | Unknown |  |
| shipping_info_tax_category_id | Unknown |  |
| shipping_info_tax_category_type_id | Unknown |  |
| shipping_rate_input_key | Unknown |  |
| shipping_rate_input_label | Unknown |  |
| shipping_rate_input_score | Unknown |  |
| shipping_rate_input_type | Unknown |  |
| custom_** |  |  |

### cart_item_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| cart_id | Unknown | PK, FK |
| id | Unknown | FK |

### cart

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_address_id | Unknown | FK |
| customer_id | Unknown | FK |
| shipping_address_id | Unknown | FK |
| anonymous_id | Unknown |  |
| cart_state | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| customer_email | Unknown |  |
| customer_group_id | Unknown |  |
| customer_group_type_id | Unknown |  |
| delete_days_after_last_modification | Unknown |  |
| inventory_mode | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| locale | Unknown |  |
| origin | Unknown |  |
| shipping_mode | Unknown |  |
| shipping_rate_inputkey | Unknown |  |
| shipping_rate_inputlabel | Unknown |  |
| shipping_rate_inputtype | Unknown |  |
| store_id | Unknown |  |
| store_type_id | Unknown |  |
| tax_calculation_mode | Unknown |  |
| tax_mode | Unknown |  |
| tax_rounding_mode | Unknown |  |
| taxed_price_total_gross_cent_amount | Unknown |  |
| taxed_price_total_gross_currency_code | Unknown |  |
| taxed_price_total_gross_fraction_digits | Unknown |  |
| taxed_price_total_gross_type | Unknown |  |
| taxed_price_total_net_cent_amount | Unknown |  |
| taxed_price_total_net_currency_code | Unknown |  |
| taxed_price_total_net_fraction_digits | Unknown |  |
| taxed_price_total_net_type | Unknown |  |
| taxed_price_total_tax_cent_amount | Unknown |  |
| taxed_price_total_tax_currency_code | Unknown |  |
| taxed_price_total_tax_fraction_digits | Unknown |  |
| taxed_price_total_tax_type | Unknown |  |
| taxed_shipping_price_total_gross_cent_amount | Unknown |  |
| taxed_shipping_price_total_gross_currency_code | Unknown |  |
| taxed_shipping_price_total_gross_fraction_digits | Unknown |  |
| taxed_shipping_price_total_gross_type | Unknown |  |
| taxed_shipping_price_total_net_cent_amount | Unknown |  |
| taxed_shipping_price_total_net_currency_code | Unknown |  |
| taxed_shipping_price_total_net_fraction_digits | Unknown |  |
| taxed_shipping_price_total_net_type | Unknown |  |
| taxed_shipping_price_total_tax_cent_amount | Unknown |  |
| taxed_shipping_price_total_tax_currency_code | Unknown |  |
| taxed_shipping_price_total_tax_fraction_digits | Unknown |  |
| taxed_shipping_price_total_tax_type | Unknown |  |
| total_line_item_quantity | Unknown |  |
| total_price_cent_amount | Unknown |  |
| total_price_currency_code | Unknown |  |
| total_price_fraction_digits | Unknown |  |
| total_price_type | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

### payment_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_id | Unknown | PK, FK |
| amount_cent_amount | Unknown |  |
| amount_currency_code | Unknown |  |
| amount_fraction_digits | Unknown |  |
| amount_type | Unknown |  |
| interaction_id | Unknown |  |
| state | Unknown |  |
| transaction_timestamp | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### payment_interface_interaction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payment_id | Unknown | PK, FK |
| custom_** |  |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| amount_planned_cent_amount | Unknown |  |
| amount_planned_currency_code | Unknown |  |
| amount_planned_fraction_digits | Unknown |  |
| amount_planned_type | Unknown |  |
| anonymous_id | Unknown |  |
| created_at | Unknown |  |
| customer_type_id | Unknown |  |
| interface_id | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| payment_method_info_method | Unknown |  |
| payment_method_info_payment_interface | Unknown |  |
| payment_status_interface_code | Unknown |  |
| payment_status_interface_text | Unknown |  |
| payment_status_state_id | Unknown |  |
| payment_status_state_type_id | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |
| payment_method_info_name_** |  |  |

### order_line_item_state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_line_item_id | Unknown | PK, FK |
| quantity | Unknown |  |
| state_id | Unknown |  |
| state_type_id | Unknown |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| variant_id | Unknown | FK |
| added_at | Unknown |  |
| inventory_mode | Unknown |  |
| last_modified_at | Unknown |  |
| line_item_mode | Unknown |  |
| price_country | Unknown |  |
| price_id | Unknown |  |
| price_key | Unknown |  |
| price_mode | Unknown |  |
| price_valid_from | Unknown |  |
| price_valid_until | Unknown |  |
| price_value_cent_amount | Unknown |  |
| price_value_currency_code | Unknown |  |
| price_value_fraction_digits | Unknown |  |
| price_value_precise_amount | Unknown |  |
| price_value_type | Unknown |  |
| product_key | Unknown |  |
| product_type_id | Unknown |  |
| product_type_type_id | Unknown |  |
| quantity | Unknown |  |
| shipping_details_targets | Unknown |  |
| shipping_details_valid | Unknown |  |
| tax_rate_amount | Unknown |  |
| tax_rate_country | Unknown |  |
| tax_rate_id | Unknown |  |
| tax_rate_included_in_price | Unknown |  |
| tax_rate_name | Unknown |  |
| tax_rate_state | Unknown |  |
| taxed_price_portions | Unknown |  |
| taxed_price_total_gross_cent_amount | Unknown |  |
| taxed_price_total_gross_currency_code | Unknown |  |
| taxed_price_total_gross_fraction_digits | Unknown |  |
| taxed_price_total_gross_type | Unknown |  |
| taxed_price_total_net_cent_amount | Unknown |  |
| taxed_price_total_net_currency_code | Unknown |  |
| taxed_price_total_net_fraction_digits | Unknown |  |
| taxed_price_total_net_type | Unknown |  |
| taxed_price_total_tax_cent_amount | Unknown |  |
| taxed_price_total_tax_currency_code | Unknown |  |
| taxed_price_total_tax_fraction_digits | Unknown |  |
| taxed_price_total_tax_type | Unknown |  |
| total_price_cent_amount | Unknown |  |
| total_price_currency_code | Unknown |  |
| total_price_fraction_digits | Unknown |  |
| total_price_type | Unknown |  |
| custom_** |  |  |
| name_** |  |  |
| product_slug_** |  |  |

### order_custom_line_item_state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_custom_line_item_id | Unknown | PK, FK |
| quantity | Unknown |  |
| state_id | Unknown |  |
| state_type_id | Unknown |  |

### order_custom_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders_id | Unknown | PK, FK |
| money_cent_amount | Unknown |  |
| money_currency_code | Unknown |  |
| money_fraction_digits | Unknown |  |
| money_precise_amount | Unknown |  |
| money_type | Unknown |  |
| price_mode | Unknown |  |
| quantity | Unknown |  |
| slug | Unknown |  |
| tax_category_id | Unknown |  |
| tax_category_type_id | Unknown |  |
| tax_rate_amount | Unknown |  |
| tax_rate_country | Unknown |  |
| tax_rate_id | Unknown |  |
| tax_rate_included_in_price | Unknown |  |
| tax_rate_name | Unknown |  |
| tax_rate_state | Unknown |  |
| taxed_price_total_gross_cent_amount | Unknown |  |
| taxed_price_total_gross_currency_code | Unknown |  |
| taxed_price_total_gross_fraction_digits | Unknown |  |
| taxed_price_total_gross_type | Unknown |  |
| taxed_price_total_net_cent_amount | Unknown |  |
| taxed_price_total_net_currency_code | Unknown |  |
| taxed_price_total_net_fraction_digits | Unknown |  |
| taxed_price_total_net_type | Unknown |  |
| taxed_price_total_tax_cent_amount | Unknown |  |
| taxed_price_total_tax_currency_code | Unknown |  |
| taxed_price_total_tax_fraction_digits | Unknown |  |
| taxed_price_total_tax_type | Unknown |  |
| total_price_cent_amount | Unknown |  |
| total_price_currency_code | Unknown |  |
| total_price_fraction_digits | Unknown |  |
| total_price_type | Unknown |  |
| custom_** |  |  |
| name_** |  |  |

### order_shipping

| Column | Type | Keys |
| --- | --- | --- |
| shipping_key | Unknown | PK |
| orders_id | Unknown | PK, FK |
| shipping_info_pricecent_amount | Unknown |  |
| shipping_info_pricecurrency_code | Unknown |  |
| shipping_info_pricefraction_digits | Unknown |  |
| shipping_info_priceprecise_amount | Unknown |  |
| shipping_info_pricetype | Unknown |  |
| shipping_info_shipping_method_id | Unknown |  |
| shipping_info_shipping_method_name | Unknown |  |
| shipping_info_shipping_method_type_id | Unknown |  |
| shipping_info_tax_category_id | Unknown |  |
| shipping_info_tax_category_type_id | Unknown |  |
| shipping_rate_input_key | Unknown |  |
| shipping_rate_input_label | Unknown |  |
| shipping_rate_input_score | Unknown |  |
| shipping_rate_input_type | Unknown |  |
| custom_** |  |  |

### order_sync_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| channel_id | Unknown | FK |
| channel_type_id | Unknown |  |
| external_id | Unknown |  |
| synced_at | Unknown |  |

### order_return_info_items

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_return_info_index | Unknown | PK, FK |
| order_return_info_order_id | Unknown | PK, FK |
| comment | Unknown |  |
| created_at | Unknown |  |
| last_modified_at | Unknown |  |
| line_item_id | Unknown |  |
| payment_state | Unknown |  |
| quantity | Unknown |  |
| shipment_state | Unknown |  |
| type | Unknown |  |

### order_return_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| return_date | Unknown |  |
| return_tracking_id | Unknown |  |

### order_discount_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| discount_code_id | Unknown |  |
| discount_code_type_id | Unknown |  |
| state | Unknown |  |

### order_payment_info

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| orders_id | Unknown | PK, FK |
| type_id | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_key | Unknown | FK |
| cart_id | Unknown | FK |
| customer_group_id | Unknown | FK |
| customer_id | Unknown | FK |
| anonymous_id | Unknown |  |
| billing_address_additional_address_info | Unknown |  |
| billing_address_additional_street_info | Unknown |  |
| billing_address_apartment | Unknown |  |
| billing_address_building | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_company | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_department | Unknown |  |
| billing_address_email | Unknown |  |
| billing_address_external_id | Unknown |  |
| billing_address_fax | Unknown |  |
| billing_address_first_name | Unknown |  |
| billing_address_id | Unknown |  |
| billing_address_key | Unknown |  |
| billing_address_last_name | Unknown |  |
| billing_address_mobile | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_po_box | Unknown |  |
| billing_address_postal_code | Unknown |  |
| billing_address_region | Unknown |  |
| billing_address_salutation | Unknown |  |
| billing_address_state | Unknown |  |
| billing_address_street_name | Unknown |  |
| billing_address_street_number | Unknown |  |
| billing_address_title | Unknown |  |
| business_unit_type_id | Unknown |  |
| cart_type_id | Unknown |  |
| completed_at | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| customer_email | Unknown |  |
| customer_group_type_id | Unknown |  |
| inventory_mode | Unknown |  |
| last_modified_at | Instant |  |
| locale | Unknown |  |
| order_number | Unknown |  |
| order_state | Unknown |  |
| origin | Unknown |  |
| payment_state | Unknown |  |
| quote_id | Unknown |  |
| quote_type_id | Unknown |  |
| shipment_state | Unknown |  |
| shipping_address_additional_address_info | Unknown |  |
| shipping_address_additional_street_info | Unknown |  |
| shipping_address_apartment | Unknown |  |
| shipping_address_building | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_department | Unknown |  |
| shipping_address_email | Unknown |  |
| shipping_address_external_id | Unknown |  |
| shipping_address_fax | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_id | Unknown |  |
| shipping_address_key | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_mobile | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_po_box | Unknown |  |
| shipping_address_postal_code | Unknown |  |
| shipping_address_region | Unknown |  |
| shipping_address_salutation | Unknown |  |
| shipping_address_state | Unknown |  |
| shipping_address_street_name | Unknown |  |
| shipping_address_street_number | Unknown |  |
| shipping_address_title | Unknown |  |
| shipping_info_pricecent_amount | Unknown |  |
| shipping_info_pricecurrency_code | Unknown |  |
| shipping_info_pricefraction_digits | Unknown |  |
| shipping_info_priceprecise_amount | Unknown |  |
| shipping_info_pricetype | Unknown |  |
| shipping_info_shipping_method_id | Unknown |  |
| shipping_info_shipping_method_name | Unknown |  |
| shipping_info_shipping_method_type_id | Unknown |  |
| shipping_info_tax_category_id | Unknown |  |
| shipping_info_tax_category_type_id | Unknown |  |
| shipping_mode | Unknown |  |
| shipping_rate_input | Unknown |  |
| state_id | Unknown |  |
| state_type_id | Unknown |  |
| store_key | Unknown |  |
| store_type_id | Unknown |  |
| tax_calculation_mode | Unknown |  |
| tax_mode | Unknown |  |
| tax_rounding_mode | Unknown |  |
| taxed_price_total_gross_cent_amount | Unknown |  |
| taxed_price_total_gross_currency_code | Unknown |  |
| taxed_price_total_gross_fraction_digits | Unknown |  |
| taxed_price_total_gross_type | Unknown |  |
| taxed_price_total_net_cent_amount | Unknown |  |
| taxed_price_total_net_currency_code | Unknown |  |
| taxed_price_total_net_fraction_digits | Unknown |  |
| taxed_price_total_net_type | Unknown |  |
| taxed_price_total_tax_cent_amount | Unknown |  |
| taxed_price_total_tax_currency_code | Unknown |  |
| taxed_price_total_tax_fraction_digits | Unknown |  |
| taxed_price_total_tax_type | Unknown |  |
| taxed_shipping_price_total_gross_cent_amount | Unknown |  |
| taxed_shipping_price_total_gross_currency_code | Unknown |  |
| taxed_shipping_price_total_gross_fraction_digits | Unknown |  |
| taxed_shipping_price_total_gross_type | Unknown |  |
| taxed_shipping_price_total_net_cent_amount | Unknown |  |
| taxed_shipping_price_total_net_currency_code | Unknown |  |
| taxed_shipping_price_total_net_fraction_digits | Unknown |  |
| taxed_shipping_price_total_net_type | Unknown |  |
| taxed_shipping_price_total_tax_cent_amount | Unknown |  |
| taxed_shipping_price_total_tax_currency_code | Unknown |  |
| taxed_shipping_price_total_tax_fraction_digits | Unknown |  |
| taxed_shipping_price_total_tax_type | Unknown |  |
| total_price_cent_amount | Unknown |  |
| total_price_currency_code | Unknown |  |
| total_price_fraction_digits | Unknown |  |
| total_price_type | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| available_quantity | Unknown |  |
| created_at | Unknown |  |
| expected_delivery | Unknown |  |
| key | Unknown |  |
| last_message_sequence_number | Unknown |  |
| last_modified_at | Instant |  |
| quantity_on_stock | Unknown |  |
| restockable_in_days | Unknown |  |
| sku | Unknown |  |
| version | Unknown |  |
| version_modified_at | Unknown |  |
| custom_** |  |  |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product_variant_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_variant_id | Unknown | PK, FK |
| dimensions_h | Unknown |  |
| dimensions_w | Unknown |  |
| label | Unknown |  |
| url | Unknown |  |

### product_variant_price_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_variant_prices_id | Unknown | PK, FK |
| minimum_quantity | Unknown |  |
| value_cent_amount | Unknown |  |
| value_currency_code | Unknown |  |
| value_fraction_digits | Unknown |  |
| value_precise_amount | Unknown |  |
| value_type | Unknown |  |

### product_variant_prices

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_variant_id | Unknown | PK, FK |
| country | Unknown |  |
| customer_group_id | Unknown |  |
| customer_group_type_id | Unknown |  |
| key | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |
| value_cent_amount | Unknown |  |
| value_currency_code | Unknown |  |
| value_fraction_digits | Unknown |  |
| value_precise_amount | Unknown |  |
| value_type | Unknown |  |
| custom_** |  |  |

### product_variant_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_variant_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| available_quantity | Unknown |  |
| channels | Unknown |  |
| is_matching_variant | Unknown |  |
| is_on_stock | Unknown |  |
| key | Unknown |  |
| restockable_in_days | Unknown |  |
| scoped_price_country | Unknown |  |
| scoped_price_current_value_cent_amount | Unknown |  |
| scoped_price_current_value_currency_code | Unknown |  |
| scoped_price_current_value_fraction_digits | Unknown |  |
| scoped_price_current_value_precise_amount | Unknown |  |
| scoped_price_current_value_type | Unknown |  |
| scoped_price_customer_group_id | Unknown |  |
| scoped_price_customer_group_type_id | Unknown |  |
| scoped_price_discounted | Unknown |  |
| scoped_price_id | Unknown |  |
| scoped_price_valid_from | Unknown |  |
| scoped_price_valid_until | Unknown |  |
| scoped_price_value_cent_amount | Unknown |  |
| scoped_price_value_currency_code | Unknown |  |
| scoped_price_value_fraction_digits | Unknown |  |
| scoped_price_value_precise_amount | Unknown |  |
| scoped_price_value_type | Unknown |  |
| sku | Unknown |  |

### master_variant_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| master_variant_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| dimensions_h | Unknown |  |
| dimensions_w | Unknown |  |
| label | Unknown |  |
| url | Unknown |  |

### master_variant_asset_source

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| master_variant_asset_id | Unknown | PK, FK |
| master_variant_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| content_type | Unknown |  |
| dimensions_h | Unknown |  |
| dimensions_w | Unknown |  |
| uri | Unknown |  |

### master_variant_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| master_variant_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| description | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| tags | Json |  |
| custom_** |  |  |

### master_variant_price_tier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| master_variant_id | Unknown | PK, FK |
| master_variant_price_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| minimum_quantity | Unknown |  |
| value_cent_amount | Unknown |  |
| value_currency_code | Unknown |  |
| value_fraction_digits | Unknown |  |
| value_precise_amount | Unknown |  |
| value_type | Unknown |  |

### master_variant_price

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| master_variant_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| channel_id | Unknown | FK |
| channel_type_id | Unknown |  |
| country | Unknown |  |
| customer_group_id | Unknown |  |
| customer_group_type_id | Unknown |  |
| discounted_value_cent_amount | Unknown |  |
| discounted_value_currency_code | Unknown |  |
| discounted_value_fraction_digits | Unknown |  |
| discounted_value_precise_amount | Unknown |  |
| discounted_value_type | Unknown |  |
| key | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |
| value_cent_amount | Unknown |  |
| value_currency_code | Unknown |  |
| value_fraction_digits | Unknown |  |
| value_precise_amount | Unknown |  |
| value_type | Unknown |  |
| custom_** |  |  |

### master_variant_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| master_variant_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### master_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| inventory_id | Unknown | FK |
| available_quantity | Unknown |  |
| channels | Json |  |
| is_matching_variant | Unknown |  |
| is_on_stock | Unknown |  |
| key | Unknown |  |
| restockable_in_days | Unknown |  |
| scoped_price_country | Unknown |  |
| scoped_price_current_value_cent_amount | Unknown |  |
| scoped_price_current_value_currency_code | Unknown |  |
| scoped_price_current_value_fraction_digits | Unknown |  |
| scoped_price_current_value_precise_amount | Unknown |  |
| scoped_price_current_value_type | Unknown |  |
| scoped_price_customer_group_id | Unknown |  |
| scoped_price_customer_group_type_id | Unknown |  |
| scoped_price_discount_id | Unknown |  |
| scoped_price_discount_obj | Json |  |
| scoped_price_discount_type_id | Unknown |  |
| scoped_price_discounted | Unknown |  |
| scoped_price_discounted_value_cent_amount | Unknown |  |
| scoped_price_discounted_value_currency_code | Unknown |  |
| scoped_price_discounted_value_fraction_digits | Unknown |  |
| scoped_price_discounted_value_precise_amount | Unknown |  |
| scoped_price_discounted_value_type | Unknown |  |
| scoped_price_id | Unknown |  |
| scoped_price_valid_from | Unknown |  |
| scoped_price_valid_until | Unknown |  |
| scoped_price_value_cent_amount | Unknown |  |
| scoped_price_value_currency_code | Unknown |  |
| scoped_price_value_fraction_digits | Unknown |  |
| scoped_price_value_precise_amount | Unknown |  |
| scoped_price_value_type | Unknown |  |
| sku | Unknown |  |
| custom_** |  |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tax_category_id | Unknown | FK |
| created_at | Unknown |  |
| current_category_order_hints | Unknown |  |
| current_published | Unknown |  |
| has_staged_changes | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| price_mode | Unknown |  |
| product_type_id | Unknown |  |
| product_type_type_id | Unknown |  |
| published | Unknown |  |
| review_rating_statistics_average_rating | Unknown |  |
| review_rating_statistics_count | Unknown |  |
| review_rating_statistics_highest_rating | Unknown |  |
| review_rating_statistics_lowest_rating | Unknown |  |
| review_rating_statistics_ratings_distribution | Unknown |  |
| state_id | Unknown |  |
| state_type_id | Unknown |  |
| tax_category_type_id | Unknown |  |
| version | Unknown |  |
| current_description_** |  |  |
| current_meta_description_** |  |  |
| current_meta_keywords_** |  |  |
| current_meta_title_** |  |  |
| current_name_** |  |  |
| current_slug_** |  |  |

### customer_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| additional_address_info | Unknown |  |
| additional_street_info | Unknown |  |
| apartment | Unknown |  |
| building | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| key | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| phone | Unknown |  |
| po_box | Unknown |  |
| postal_code | Unknown |  |
| region | Unknown |  |
| salutation | Unknown |  |
| state | Unknown |  |
| street_name | Unknown |  |
| street_number | Unknown |  |
| title | Unknown |  |

### customer_store

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| customer_id | Unknown | PK, FK |
| type_id | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_group_id | Unknown | FK |
| company_name | Unknown |  |
| created_at | Unknown |  |
| customer_group_type_id | Unknown |  |
| customer_number | Unknown |  |
| date_of_birth | Unknown |  |
| default_billing_address_id | Unknown |  |
| default_shipping_address_id | Unknown |  |
| email | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| is_email_verified | Unknown |  |
| key | Unknown |  |
| last_modified_at | Instant |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| middle_name | Unknown |  |
| password | Unknown |  |
| salutation | Unknown |  |
| title | Unknown |  |
| vat_id | Unknown |  |
| version | Unknown |  |
| custom_** |  |  |

## Relationships

- review(customer_id) → customer(id)
- shipping_method_zone_shipping_rate(shipping_method_zone_rate_shipping_method_id) → shipping_method_zone_rate(shipping_method_id)
- shipping_method_zone_shipping_rate(shipping_method_zone_rate_zone_id) → shipping_method_zone_rate(zone_id)
- shipping_method_zone_rate(shipping_method_id) → shipping_method(id)
- discount_code_reference(discount_code_id) → discount_code(id)
- cart_discount_code(id) → cart(id)
- cart_discount_code(discount_code_id) → discount_code(id)
- discount_code_group(discount_code_id) → discount_code(id)
- shopping_list_line_item(product_id) → product(id)
- shopping_list_line_item(shopping_list_id) → shopping_list(id)
- shopping_list_text_line_item(shopping_list_id) → shopping_list(id)
- shopping_list(customer_id) → customer(id)
- business_unit_store(business_unit_id) → business_unit(id)
- business_unit_address(business_unit_id) → business_unit(id)
- business_unit_associate_role(business_unit_associate_business_unit_id) → business_unit_associate(business_unit_id)
- business_unit_associate_role(business_unit_associate_index) → business_unit_associate(index)
- business_unit_associate(business_unit_id) → business_unit(id)
- business_unit(parent_unit_key) → business_unit(key)
- business_unit(top_level_unit_key) → business_unit(key)
- standalone_price_tier(standalone_price_id) → standalone_price(id)
- cart_discount_reference(cart_discount_id) → cart_discount(id)
- product_discount_reference(product_discount_id) → product_discount(id)
- tax_category_rate(tax_category_id) → tax_category(id)
- shipping_zone_location(shipping_zone_id) → shipping_zone(id)
- category_ancestor(category_id) → category(id)
- channel_role(channel_id) → channel(id)
- cart_line_item_state(cart_line_item_id) → cart_line_item(id)
- cart_line_item(cart_id) → cart(id)
- cart_custom_line_item_state(cart_custom_line_item_id) → cart_custom_line_item(id)
- cart_custom_line_item(cart_id) → cart(id)
- cart_shipping(cart_id) → cart(id)
- cart_item_shipping_address(id) → customer_address(id)
- cart_item_shipping_address(cart_id) → cart(id)
- cart(customer_id) → customer(id)
- cart(shipping_address_id) → customer_address(id)
- cart(billing_address_id) → customer_address(id)
- payment_transaction(payment_id) → payment(id)
- payment_interface_interaction(payment_id) → payment(id)
- payment(customer_id) → customer(id)
- order_line_item_state(order_line_item_id) → order_line_item(id)
- order_line_item(product_id) → product(id)
- order_line_item(variant_id) → product_variant(id)
- order_line_item(orders_id) → orders(id)
- order_custom_line_item_state(order_custom_line_item_id) → order_custom_line_item(id)
- order_custom_line_item(orders_id) → orders(id)
- order_shipping(orders_id) → orders(id)
- order_sync_info(channel_id) → channel(id)
- order_sync_info(orders_id) → orders(id)
- order_return_info_items(order_return_info_index) → order_return_info(index)
- order_return_info_items(order_return_info_order_id) → order_return_info(order_id)
- order_return_info(order_id) → orders(id)
- order_discount_code(orders_id) → orders(id)
- order_payment_info(id) → payment(id)
- order_payment_info(orders_id) → orders(id)
- orders(customer_id) → customer(id)
- orders(business_unit_key) → business_unit(id)
- orders(customer_group_id) → customer_group(id)
- orders(cart_id) → cart(id)
- product_category(category_id) → category(id)
- product_category(product_id) → product(id)
- product_variant_image(product_variant_id) → product_variant(id)
- product_variant_image(product_id) → product_variant(product_id)
- product_variant_price_tier(product_variant_prices_id) → product_variant_prices(id)
- product_variant_price_tier(product_id) → product_variant_prices(product_id)
- product_variant_prices(product_variant_id) → product_variant(id)
- product_variant_prices(product_id) → product_variant(product_id)
- product_variant_attribute(product_variant_id) → product_variant(id)
- product_variant_attribute(product_id) → product_variant(product_id)
- product_variant(product_id) → product(id)
- master_variant_image(product_id) → master_variant(product_id)
- master_variant_image(master_variant_id) → master_variant(id)
- master_variant_asset_source(product_id) → master_variant_asset(product_id)
- master_variant_asset_source(master_variant_id) → master_variant_asset(master_variant_id)
- master_variant_asset_source(master_variant_asset_id) → master_variant_asset(id)
- master_variant_asset(product_id) → master_variant(product_id)
- master_variant_asset(master_variant_id) → master_variant(id)
- master_variant_price_tier(product_id) → master_variant_price(product_id)
- master_variant_price_tier(master_variant_id) → master_variant_price(master_variant_id)
- master_variant_price_tier(master_variant_price_id) → master_variant_price(id)
- master_variant_price(channel_id) → channel(id)
- master_variant_price(product_id) → master_variant(product_id)
- master_variant_price(master_variant_id) → master_variant(id)
- master_variant_attribute(product_id) → master_variant(product_id)
- master_variant_attribute(master_variant_id) → master_variant(id)
- master_variant(inventory_id) → inventory(id)
- master_variant(product_id) → product(id)
- product(tax_category_id) → tax_category(id)
- customer_address(customer_id) → customer(id)
- customer_store(customer_id) → customer(id)
- customer(customer_group_id) → customer_group(id)