# Shopware schema ERD

Table and field reference for the Fivetran Shopware connector.

## Table & Field Reference

### order_delivery_tracking_code

| Column | Type | Keys |
| --- | --- | --- |
| tracking_code | Unknown | PK |
| order_delivery_id | Unknown | PK, FK |

### order_delivery_calculated_tax

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_delivery_id | Unknown | FK |
| extensions | Json |  |
| price | Unknown |  |
| tax | Unknown |  |
| tax_rate | Unknown |  |

### order_delivery_tax_rule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_delivery_id | Unknown | FK |
| extensions | Json |  |
| percentage | Unknown |  |
| tax_rate | Unknown |  |

### order_delivery_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| order_delivery_id | Unknown | PK, FK |
| value | Unknown |  |

### order_delivery_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| order_delivery_id | Unknown | PK, FK |
| value | Unknown |  |

### order_delivery

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| shipping_method_id | Unknown | FK |
| shipping_order_address_id | Unknown | FK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| shipping_costs_extensions | Json |  |
| shipping_costs_list_price | Unknown |  |
| shipping_costs_quantity | Unknown |  |
| shipping_costs_reference_price | Unknown |  |
| shipping_costs_regulation_price | Unknown |  |
| shipping_costs_total_price | Unknown |  |
| shipping_costs_unit_price | Unknown |  |
| shipping_date_ear_liest | Unknown |  |
| shipping_date_latest | Unknown |  |
| shipping_order_address_version_id | Unknown |  |
| state_id | Unknown |  |
| updated_at | Unknown |  |
| version_id | Unknown |  |

### delivery_time_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| delivery_time_id | Unknown | PK, FK |
| value | Unknown |  |

### delivery_time_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| delivery_time_id | Unknown | PK, FK |
| value | Unknown |  |

### delivery_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| maximum | Unknown |  |
| minimum | Unknown |  |
| name | Unknown |  |
| unit | Unknown |  |
| updated_at | Unknown |  |

### property_group_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| property_group_id | Unknown | PK, FK |
| value | Unknown |  |

### property_group_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| property_group_id | Unknown | PK, FK |
| value | Unknown |  |

### property_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| display_type | Unknown |  |
| filterable | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| sorting_type | Unknown |  |
| translated_description | Unknown |  |
| translated_name | Unknown |  |
| translated_position | Unknown |  |
| updated_at | Unknown |  |
| visible_on_product_detail_page | Unknown |  |

### order_line_item_property

| Column | Type | Keys |
| --- | --- | --- |
| property_id | Unknown | PK |
| order_line_item_id | Unknown | PK, FK |

### order_line_item_option

| Column | Type | Keys |
| --- | --- | --- |
| option_id | Unknown | PK |
| order_line_item_id | Unknown | PK, FK |

### order_line_item_stream

| Column | Type | Keys |
| --- | --- | --- |
| stream_id | Unknown | PK |
| order_line_item_id | Unknown | PK, FK |

### order_line_item_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | Unknown | PK |
| object_id | Unknown | PK, FK |

### order_line_item_category

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

### order_line_item_payload_option_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| order_line_item_payload_option_index | Unknown | PK, FK |
| order_line_item_payload_option_order_line_item_id | Unknown | PK, FK |
| value | Unknown |  |

### order_line_item_payload_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_line_item_id | Unknown | PK, FK |
| groups | Unknown |  |
| option | Unknown |  |

### order_line_item_calculated_tax

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_line_item_id | Unknown | FK |
| extensions | Json |  |
| price | Unknown |  |
| tax | Unknown |  |
| tax_rate | Unknown |  |

### order_line_item_tax_rule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_line_item_id | Unknown | FK |
| extensions | Json |  |
| percentage | Unknown |  |
| tax_rate | Unknown |  |

### order_line_item_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| order_line_item_id | Unknown | PK, FK |
| value | Unknown |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| parent_id | Unknown | FK |
| payload_tax_id | Unknown | FK |
| product_id | Unknown | FK |
| promotion_id | Unknown | FK |
| api_alias | Unknown |  |
| cover_id | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| good | Unknown |  |
| identifier | Unknown |  |
| label | Unknown |  |
| parent_version_id | Unknown |  |
| payload_created_at | Unknown |  |
| payload_custom_field | Unknown |  |
| payload_features | Json |  |
| payload_is_close_out | Unknown |  |
| payload_is_new | Unknown |  |
| payload_manufacturer_id | Unknown |  |
| payload_mark_as_top_seller | Unknown |  |
| payload_parent_id | Unknown |  |
| payload_product_number | Unknown |  |
| payload_purchase_prices | Unknown |  |
| payload_releasedate | Unknown |  |
| payload_stock | Unknown |  |
| position | Unknown |  |
| price_definition_extensions | Json |  |
| price_definition_is_calculated | Unknown |  |
| price_definition_list_price | Unknown |  |
| price_definition_price | Unknown |  |
| price_definition_quantity | Unknown |  |
| price_definition_reference_price_definition | Unknown |  |
| price_definition_regulation_price | Unknown |  |
| price_definition_type | Unknown |  |
| price_extensions | Json |  |
| price_list_price | Unknown |  |
| price_quantity | Unknown |  |
| price_reference_price | Unknown |  |
| price_regulation_price | Unknown |  |
| price_total_price | Unknown |  |
| price_unit_price | Unknown |  |
| product_version_id | Unknown |  |
| quantity | Unknown |  |
| referenced_id | Unknown |  |
| removable | Unknown |  |
| stackable | Unknown |  |
| total_price | Unknown |  |
| type | Unknown |  |
| unit_price | Unknown |  |
| updated_at | Unknown |  |
| version_id | Unknown |  |

### customer_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | Unknown | PK |
| customer_id | Unknown | PK, FK |

### customer_vat

| Column | Type | Keys |
| --- | --- | --- |
| vat_id | Unknown | PK |
| customer_id | Unknown | PK, FK |

### customer_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| customer_id | Unknown | PK, FK |
| value | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_billing_address_id | Unknown | FK |
| default_payment_method_id | Unknown | FK |
| default_shipping_address_id | Unknown | FK |
| group_id | Unknown | FK |
| language_id | Unknown | FK |
| sales_channel_id | Unknown | FK |
| active | Unknown |  |
| affiliate_code | Unknown |  |
| api_alias | Unknown |  |
| auto_increment | Unknown |  |
| birthday | Unknown |  |
| bound_sales_channel_id | Unknown |  |
| campaign_code | Unknown |  |
| company | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| customer_number | Unknown |  |
| double_opt_in_confirm_date | Unknown |  |
| double_opt_in_email_sent_date | Unknown |  |
| double_opt_in_registration | Unknown |  |
| email | Unknown |  |
| first_login | Unknown |  |
| first_name | Unknown |  |
| guest | Unknown |  |
| hash | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| last_order_date | Unknown |  |
| last_payment_method_id | Unknown |  |
| news_letter | Unknown |  |
| order_count | Unknown |  |
| order_total_amount | Unknown |  |
| remote_address | Unknown |  |
| requested_group_id | Unknown |  |
| salutation_id | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| updated_by_id | Unknown |  |

### promotion_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | FK |
| api_alias | Unknown |  |
| applier_key | Unknown |  |
| consider_advanced_rules | Unknown |  |
| created_at | Unknown |  |
| maximum_value | Unknown |  |
| picker_key | Unknown |  |
| scope | Unknown |  |
| sorter_key | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| usage_key | Unknown |  |
| value | Unknown |  |

### order_transaction_calculated_tax

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_transaction_id | Unknown | FK |
| extensions | Json |  |
| price | Unknown |  |
| tax | Unknown |  |
| tax_rate | Unknown |  |

### order_transaction_tax_rule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_transaction_id | Unknown | FK |
| extensions | Json |  |
| percentage | Unknown |  |
| tax_rate | Unknown |  |

### order_transaction_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| order_transaction_id | Unknown | PK, FK |
| value | Unknown |  |

### order_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| payment_method_id | Unknown | FK |
| shipping_method_id | Unknown | FK |
| state_id | Unknown | FK |
| amount_list_price | Unknown |  |
| amount_quantity | Unknown |  |
| amount_reference_price | Unknown |  |
| amount_regulation_price | Unknown |  |
| amount_total_price | Unknown |  |
| amount_unit_extensions | Json |  |
| amount_unit_price | Unknown |  |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |
| version_id | Unknown |  |

### payment_method_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| payment_method_id | Unknown | PK, FK |
| value | Unknown |  |

### payment_method_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| payment_method_id | Unknown | PK, FK |
| value | Unknown |  |

### payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| availability_rule_id | Unknown | FK |
| media_id | Unknown | FK |
| active | Unknown |  |
| after_order_enabled | Unknown |  |
| api_alias | Unknown |  |
| asynchronous | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| distinguishable_name | Unknown |  |
| formatted_handler_identifier | Unknown |  |
| handler_identifier | Unknown |  |
| name | Unknown |  |
| plugin_id | Unknown |  |
| position | Unknown |  |
| prepared | Unknown |  |
| refundable | Unknown |  |
| synchronous | Unknown |  |
| translated_description | Unknown |  |
| translated_distinguishable_name | Unknown |  |
| translated_name | Unknown |  |
| updated_at | Unknown |  |

### user_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| users_id | Unknown | PK, FK |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| admin | Unknown |  |
| api_alias | Unknown |  |
| avatar_id | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| last_updated_password_at | Unknown |  |
| locale_id | Unknown |  |
| timezone | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| username | Unknown |  |

### order_customer_vat

| Column | Type | Keys |
| --- | --- | --- |
| vat_id | Unknown | PK |
| order_customer_id | Unknown | PK, FK |

### order_customer_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| order_customer_id | Unknown | PK, FK |
| value | Unknown |  |

### order_customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| order_id | Unknown | FK |
| api_alias | Unknown |  |
| company | Unknown |  |
| created_at | Unknown |  |
| customer_number | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| remote_address | Unknown |  |
| salutation_id | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| version_id | Unknown |  |

### customer_address_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| customer_address_id | Unknown | PK, FK |
| value | Unknown |  |

### customer_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| additional_address_line_1 | Unknown |  |
| additional_address_line_2 | Unknown |  |
| api_alias | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country_id | Unknown |  |
| country_state_id | Unknown |  |
| created_at | Unknown |  |
| department | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |
| salutation_id | Unknown |  |
| street | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| zip_code | Unknown |  |

### analytics

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| anonymize_ip | Unknown |  |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| track_orders | Unknown |  |
| tracking_id | Unknown |  |
| updated_at | Unknown |  |

### sales_channel_payment_method

| Column | Type | Keys |
| --- | --- | --- |
| payment_method_id | Unknown | PK, FK |
| sales_channel_id | Unknown | PK, FK |

### promotion_sales_channel_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| sales_channel_id | Unknown | PK, FK |
| value | Unknown |  |

### promotion_sales_channel_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| sales_channel_id | Unknown | PK, FK |
| value | Unknown |  |

### sales_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| analytics_id | Unknown | FK |
| country_id | Unknown | FK |
| currency_id | Unknown | FK |
| customer_group_id | Unknown | FK |
| footer_category_id | Unknown | FK |
| language_id | Unknown | FK |
| navigation_category_id | Unknown | FK |
| payment_method_id | Unknown | FK |
| service_category_id | Unknown | FK |
| shipping_method_id | Unknown | FK |
| access_key | Unknown |  |
| active | Unknown |  |
| api_alias | Unknown |  |
| configuration | Unknown |  |
| created_at | Unknown |  |
| footer_category_version_id | Unknown |  |
| home_cms_page_id | Unknown |  |
| home_cms_page_version_id | Unknown |  |
| home_enabled | Unknown |  |
| home_keywords | Unknown |  |
| home_meta_description | Unknown |  |
| home_meta_title | Unknown |  |
| home_name | Unknown |  |
| home_slot_config | Unknown |  |
| hreflang_active | Unknown |  |
| hreflang_default_domain_id | Unknown |  |
| mail_header_footer_id | Unknown |  |
| maintenance | Unknown |  |
| maintenance_ip_white_list | Unknown |  |
| name | Unknown |  |
| navigation_category_depth | Unknown |  |
| navigation_category_version_id | Unknown |  |
| service_category_version_id | Unknown |  |
| short_name | Unknown |  |
| tax_calculation_type | Unknown |  |
| translated_home_enabled | Unknown |  |
| translated_home_keywords | Unknown |  |
| translated_home_meta_description | Unknown |  |
| translated_home_meta_title | Unknown |  |
| translated_home_name | Unknown |  |
| translated_home_slot_config | Unknown |  |
| translated_name | Unknown |  |
| type_id | Unknown |  |
| updated_at | Unknown |  |

### category_breadcrumb

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

### category_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| category_id | Unknown | PK, FK |
| value | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| after_category_id | Unknown | FK |
| media_id | Unknown | FK |
| parent_id | Unknown | FK |
| active | Unknown |  |
| after_category_version_id | Unknown |  |
| api_alias | Unknown |  |
| auto_increment | Unknown |  |
| child_count | Unknown |  |
| cms_page_id | Unknown |  |
| cms_page_version_id | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| display_nested_products | Unknown |  |
| external_link | Unknown |  |
| internal_link | Unknown |  |
| keywords | Unknown |  |
| level | Unknown |  |
| link_new_tab | Unknown |  |
| link_type | Unknown |  |
| meta_description | Unknown |  |
| meta_title | Unknown |  |
| name | Unknown |  |
| parent_version_id | Unknown |  |
| path | Unknown |  |
| product_assignment_type | Unknown |  |
| product_stream_id | Unknown |  |
| slot_config | Json |  |
| translated_description | Unknown |  |
| translated_external_link | Unknown |  |
| translated_internal_link | Unknown |  |
| translated_keywords | Unknown |  |
| translated_link_new_tab | Unknown |  |
| translated_link_type | Unknown |  |
| translated_meta_description | Unknown |  |
| translated_meta_title | Unknown |  |
| translated_name | Unknown |  |
| translated_slot_config | Json |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| version_id | Unknown |  |
| visible | Unknown |  |

### language_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| languages_id | Unknown | PK, FK |
| value | Unknown |  |

### languages

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| locale_id | Unknown |  |
| name | Unknown |  |
| translation_code_id | Unknown |  |
| updated_at | Unknown |  |

### manufacturer_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| manufacturer_id | Unknown | PK, FK |
| value | Unknown |  |

### manufacturer_transalated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| manufacturer_id | Unknown | PK, FK |
| value | Unknown |  |

### manufacturer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| media_id | Unknown | FK |
| apia_lias | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| link | Unknown |  |
| name | Unknown |  |
| translated_description | Unknown |  |
| translated_name | Unknown |  |
| updated_at | Unknown |  |
| version_id | Unknown |  |

### shipping_method_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| shipping_method_id | Unknown | PK, FK |
| value | Unknown |  |

### shipping_method_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| shipping_method_id | Unknown | PK, FK |
| value | Unknown |  |

### shipping_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| availability_rule_id | Unknown | FK |
| delivery_time_id | Unknown | FK |
| media_id | Unknown | FK |
| tax_id | Unknown | FK |
| active | Unknown |  |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| tax_type | Unknown |  |
| tracking_url | Unknown |  |
| translated_description | Unknown |  |
| translated_name | Unknown |  |
| translated_trackingurl | Unknown |  |
| updated_at | Unknown |  |

### order_address_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| order_address_id | Unknown | PK, FK |
| value | Unknown |  |

### order_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| additional_address_line_1 | Unknown |  |
| additional_address_line_2 | Unknown |  |
| api_alias | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country_id | Unknown |  |
| country_state_id | Unknown |  |
| created_at | Unknown |  |
| department | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |
| salutation_id | Unknown |  |
| street | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| vat_id | Unknown |  |
| version_id | Unknown |  |
| zip_code | Unknown |  |

### tax_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| tax_id | Unknown | PK, FK |
| value | Unknown |  |

### tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| tax_rate | Unknown |  |
| updated_at | Unknown |  |

### country_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| country_id | Unknown | PK, FK |
| value | Unknown |  |

### country_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| country_id | Unknown | PK, FK |
| value | Unknown |  |

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_tax_currency_id | Unknown | FK |
| customer_tax_currency_id | Unknown | FK |
| active | Unknown |  |
| advanced_postal_code_pattern | Unknown |  |
| api_alias | Unknown |  |
| check_advanced_postal_code_pattern | Unknown |  |
| check_postal_code_pattern | Unknown |  |
| check_vatid_pattern | Unknown |  |
| company_tax_amount | Unknown |  |
| company_tax_enabled | Unknown |  |
| company_tax_extensions | Json |  |
| company_tax_free | Unknown |  |
| created_at | Unknown |  |
| customer_tax_amount | Unknown |  |
| customer_tax_enabled | Unknown |  |
| customer_tax_extensions | Json |  |
| default_postal_code_pattern | Unknown |  |
| display_state_in_registration | Unknown |  |
| force_state_in_registration | Unknown |  |
| iso | Unknown |  |
| iso_3 | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| postal_code_required | Unknown |  |
| shippingavailable | Unknown |  |
| tax_free | Unknown |  |
| translated_name | Unknown |  |
| updated_at | Unknown |  |
| vat_id_pattern | Unknown |  |
| vat_id_required | Unknown |  |

### product_property

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

### product_option

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

### product_stream

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

### product_tag

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

### product_category

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

### product_attribute_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| currency_id | Unknown | FK |
| extensions | Json |  |
| gross | Unknown |  |
| linked | Unknown |  |
| list_price | Unknown |  |
| net | Unknown |  |
| percentage | Unknown |  |
| regulation_price | Unknown |  |

### product_attribute_cheapest_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| currency_id | Unknown | FK |
| extensions | Json |  |
| gross | Unknown |  |
| linked | Unknown |  |
| list_price | Unknown |  |
| net | Unknown |  |
| percentage | Unknown |  |
| regulation_price | Unknown |  |

### product_custom_field

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

### product_translated_custom_field

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

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| delivery_time_id | Unknown | FK |
| manufacturer_id | Unknown | FK |
| parent_id | Unknown | FK |
| tax_id | Unknown | FK |
| active | Unknown |  |
| api_alias | Unknown |  |
| auto_increment | Unknown |  |
| available | Unknown |  |
| available_stock | Unknown |  |
| canonical_product_id | Unknown |  |
| category_tree | Unknown |  |
| cheapest_price_extensions | Json |  |
| cheapest_price_hasrange | Unknown |  |
| cheapest_price_parentid | Unknown |  |
| cheapest_price_purchase | Unknown |  |
| cheapest_price_reference | Unknown |  |
| cheapest_price_rule_id | Unknown |  |
| cheapest_price_unit_id | Unknown |  |
| cheapest_price_variant_id | Unknown |  |
| child_count | Unknown |  |
| cms_page_id | Unknown |  |
| cms_page_version_id | Unknown |  |
| configurator_group_config | Unknown |  |
| cover_id | Unknown |  |
| created_at | Unknown |  |
| custom_field_set_selection_active | Unknown |  |
| custom_search_keywords | Unknown |  |
| description | Unknown |  |
| display_group | Unknown |  |
| display_parent | Unknown |  |
| ean | Unknown |  |
| feature_set_id | Unknown |  |
| height | Unknown |  |
| is_closeout | Unknown |  |
| keywords | Unknown |  |
| length | Unknown |  |
| main_variant_id | Unknown |  |
| manufacturer_number | Unknown |  |
| mark_as_to_pseller | Unknown |  |
| maximum_purchase | Unknown |  |
| meta_description | Unknown |  |
| meta_title | Unknown |  |
| minimum_purchase | Unknown |  |
| name | Unknown |  |
| pack_unit | Unknown |  |
| pack_unit_plural | Unknown |  |
| parent_version_id | Unknown |  |
| product_manufacturer_version_id | Unknown |  |
| product_media_version_id | Unknown |  |
| product_number | Unknown |  |
| purchase_prices | Unknown |  |
| purchase_steps | Unknown |  |
| purchase_unit | Unknown |  |
| rating_average | Unknown |  |
| reference_unit | Unknown |  |
| release_date | Unknown |  |
| restock_time | Unknown |  |
| sales | Unknown |  |
| shipping_free | Unknown |  |
| slot_config | Unknown |  |
| stock | Unknown |  |
| translated_custom_search_keywords | Unknown |  |
| translated_description | Unknown |  |
| translated_keywords | Unknown |  |
| translated_meta_description | Unknown |  |
| translated_metatitle | Unknown |  |
| translated_name | Unknown |  |
| translated_pack_unit | Unknown |  |
| translated_pack_unit_plural | Unknown |  |
| translated_slot_config | Unknown |  |
| unit_id | Unknown |  |
| updated_at | Unknown |  |
| variant_listing_config | Unknown |  |
| variant_restrictions | Unknown |  |
| version_id | Unknown |  |
| weight | Unknown |  |
| width | Unknown |  |

### order_calculated_tax

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_id | Unknown | FK |
| extensions | Json |  |
| price | Unknown |  |
| tax | Unknown |  |
| tax_rate | Unknown |  |

### order_tax_rule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_id | Unknown | FK |
| extensions | Json |  |
| percentage | Unknown |  |
| tax_rate | Unknown |  |

### order_rule

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK, FK |
| rule_id | Unknown | PK, FK |

### order_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| orders_id | Unknown | PK, FK |
| value | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_address_id | Unknown | FK |
| currency_id | Unknown | FK |
| language_id | Unknown | FK |
| order_customer_id | Unknown | FK |
| sales_channel_id | Unknown | FK |
| state_id | Unknown | FK |
| affiliate_code | Unknown |  |
| amount_net | Unknown |  |
| amount_total | Unknown |  |
| api_alias | Unknown |  |
| auto_increment | Unknown |  |
| billing_address_version_id | Unknown |  |
| campaign_code | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| currency_factor | Unknown |  |
| customer_comment | Unknown |  |
| deep_link_code | Unknown |  |
| item_rounding_decimals | Unknown |  |
| item_rounding_extension | Json |  |
| item_rounding_interval | Unknown |  |
| item_rounding_roundfor_net | Unknown |  |
| order_date | Unknown |  |
| order_date_time | Unknown |  |
| order_number | Unknown |  |
| position_price | Unknown |  |
| price_extensions | Json |  |
| price_net_price | Unknown |  |
| price_position_price | Unknown |  |
| price_raw_total | Unknown |  |
| price_tax_status | Unknown |  |
| price_total_price | Unknown |  |
| shipping_costs_list_price | Unknown |  |
| shipping_costs_quantity | Unknown |  |
| shipping_costs_reference_price | Unknown |  |
| shipping_costs_regulation_price | Unknown |  |
| shipping_costs_total_price | Unknown |  |
| shipping_costs_unit_price | Unknown |  |
| shipping_total | Unknown |  |
| tax_status | Unknown |  |
| total_rounding_decimals | Unknown |  |
| total_rounding_extensions | Json |  |
| total_rounding_interval | Unknown |  |
| total_rounding_roundfornet | Unknown |  |
| updated_at | Unknown |  |
| updated_by_id | Unknown |  |
| version_id | Unknown |  |

### media_flag

| Column | Type | Keys |
| --- | --- | --- |
| flag | Unknown | PK |
| media_id | Unknown | PK, FK |

### media_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| media_id | Unknown | PK, FK |
| value | Unknown |  |

### media_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| media_id | Unknown | PK, FK |
| value | Unknown |  |

### media_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| media_id | Unknown | PK, FK |
| value | Unknown |  |

### media

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| media_folder_id | Unknown | FK |
| user_id | Unknown | FK |
| alt | Unknown |  |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| file_extension | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| has_file | Unknown |  |
| media_type_extensions | Json |  |
| media_type_name | Unknown |  |
| mime_type | Unknown |  |
| private | Unknown |  |
| title | Unknown |  |
| translated_alt | Unknown |  |
| translated_title | Unknown |  |
| updated_at | Unknown |  |
| uploaded_at | Unknown |  |
| url | Unknown |  |

### state_machine_state_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| state_machine_state_id | Unknown | PK, FK |
| value | Unknown |  |

### state_machine_state_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| state_machine_state_id | Unknown | PK, FK |
| value | Unknown |  |

### state_machine_state

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| state_machine_id | Unknown | FK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| technical_name | Unknown |  |
| translated_name | Unknown |  |
| updated_at | Unknown |  |

### customer_group_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| customer_group_id | Unknown | PK, FK |
| value | Unknown |  |

### customer_group_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| customer_group_id | Unknown | PK, FK |
| value | Unknown |  |

### customer_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| display_gross | Unknown |  |
| name | Unknown |  |
| registration_active | Unknown |  |
| registration_introduction | Unknown |  |
| registration_only_company_registration | Unknown |  |
| registration_seo_meta_description | Unknown |  |
| registration_title | Unknown |  |
| translated_name | Unknown |  |
| translated_registration_only_company_registration | Unknown |  |
| translated_registration_seo_meta_description | Unknown |  |
| translated_registration_title | Unknown |  |
| translated_registrationin_troduction | Unknown |  |
| updated_at | Unknown |  |

### state_machine_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| state_machine_id | Unknown | PK, FK |
| value | Unknown |  |

### state_machine_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| state_machine_id | Unknown | PK, FK |
| value | Unknown |  |

### state_machine

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initial_state_id | Unknown | FK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| technical_name | Unknown |  |
| translated_name | Unknown |  |
| updated_at | Unknown |  |

### product_media_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| product_media_id | Unknown | PK, FK |
| value | Unknown |  |

### product_media

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| media_id | Unknown | FK |
| product_id | Unknown | FK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| position | Unknown |  |
| product_version_id | Unknown |  |
| updated_at | Unknown |  |
| version_id | Unknown |  |

### rule_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| rule_id | Unknown | PK, FK |
| value | Unknown |  |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| invalid | Unknown |  |
| module_types | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| updated_at | Unknown |  |

### currency_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| currency_id | Unknown | PK, FK |
| value | Unknown |  |

### currency_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| currency_id | Unknown | PK, FK |
| value | Unknown |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| factor | Unknown |  |
| is_system_default | Unknown |  |
| iso_code | Unknown |  |
| item_rounding_decimals | Unknown |  |
| item_rounding_extensions | Json |  |
| item_rounding_interval | Unknown |  |
| item_rounding_roundfornet | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| short_name | Unknown |  |
| symbol | Unknown |  |
| tax_free_from | Unknown |  |
| total_rounding_decimals | Unknown |  |
| total_rounding_extensions | Json |  |
| total_rounding_interval | Unknown |  |
| total_rounding_roundfornet | Unknown |  |
| translated_name | Unknown |  |
| translated_short_name | Unknown |  |
| updated_at | Unknown |  |

### media_folder_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| media_folder_id | Unknown | PK, FK |
| value | Unknown |  |

### media_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| api_alias | Unknown |  |
| child_count | Unknown |  |
| configuration_id | Unknown |  |
| created_at | Unknown |  |
| default_folder_id | Unknown |  |
| name | Unknown |  |
| path | Unknown |  |
| updated_at | Unknown |  |
| use_parent_configuration | Unknown |  |

### promotion_sales_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | FK |
| sales_channel_id | Unknown | FK |
| api_alias | Unknown |  |
| created_at | Unknown |  |
| priority | Unknown |  |
| updated_at | Unknown |  |

### promotion_exclusion

| Column | Type | Keys |
| --- | --- | --- |
| exclusion_id | Unknown | PK |
| promotion_id | Unknown | PK, FK |

### promotion_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| value | Unknown |  |

### promotion_translated_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| value | Unknown |  |

### promotion_order_per_customer

| Column | Type | Keys |
| --- | --- | --- |
| order_per_customer | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| count | Unknown |  |

### promotion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| active | Unknown |  |
| api_alias | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| customer_restriction | Unknown |  |
| exclusive | Unknown |  |
| individual_code_pattern | Unknown |  |
| maximum_redemptions_global | Unknown |  |
| maximum_redemptions_per_customer | Unknown |  |
| name | Unknown |  |
| order_count | Unknown |  |
| prevent_combination | Unknown |  |
| priority | Unknown |  |
| translated_name | Unknown |  |
| updated_at | Unknown |  |
| use_codes | Unknown |  |
| use_individual_codes | Unknown |  |
| use_set_groups | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |

## Relationships

- order_delivery_tracking_code(order_delivery_id) → order_delivery(id)
- order_delivery_calculated_tax(order_delivery_id) → order_delivery(id)
- order_delivery_tax_rule(order_delivery_id) → order_delivery(id)
- order_delivery_custom_field(order_delivery_id) → order_delivery(id)
- order_delivery_translated_custom_field(order_delivery_id) → order_delivery(id)
- order_delivery(shipping_order_address_id) → order_address(id)
- order_delivery(order_id) → orders(id)
- order_delivery(shipping_method_id) → shipping_method(id)
- delivery_time_custom_field(delivery_time_id) → delivery_time(id)
- delivery_time_translated_custom_field(delivery_time_id) → delivery_time(id)
- property_group_custom_field(property_group_id) → property_group(id)
- property_group_translated_custom_field(property_group_id) → property_group(id)
- order_line_item_property(order_line_item_id) → order_line_item(id)
- order_line_item_option(order_line_item_id) → order_line_item(id)
- order_line_item_stream(order_line_item_id) → order_line_item(id)
- order_line_item_tag(object_id) → order_line_item(id)
- order_line_item_category(order_line_item_id) → order_line_item(id)
- order_line_item_payload_option_custom_field(order_line_item_payload_option_index) → order_line_item_payload_option(index)
- order_line_item_payload_option_custom_field(order_line_item_payload_option_order_line_item_id) → order_line_item_payload_option(order_line_item_id)
- order_line_item_payload_option(order_line_item_id) → order_line_item(id)
- order_line_item_calculated_tax(order_line_item_id) → order_line_item(id)
- order_line_item_tax_rule(order_line_item_id) → order_line_item(id)
- order_line_item_custom_field(order_line_item_id) → order_line_item(id)
- order_line_item(product_id) → product(id)
- order_line_item(payload_tax_id) → tax(id)
- order_line_item(order_id) → orders(id)
- order_line_item(parent_id) → order_line_item(id)
- order_line_item(promotion_id) → promotion(id)
- customer_tag(customer_id) → customer(id)
- customer_vat(customer_id) → customer(id)
- customer_custom_field(customer_id) → customer(id)
- customer(group_id) → customer_group(id)
- customer(default_payment_method_id) → payment_method(id)
- customer(default_shipping_address_id) → customer_address(id)
- customer(language_id) → languages(id)
- customer(default_billing_address_id) → customer_address(id)
- customer(sales_channel_id) → sales_channel(id)
- promotion_discount(promotion_id) → promotion(id)
- order_transaction_calculated_tax(order_transaction_id) → order_transaction(id)
- order_transaction_tax_rule(order_transaction_id) → order_transaction(id)
- order_transaction_custom_field(order_transaction_id) → order_transaction(id)
- order_transaction(payment_method_id) → payment_method(id)
- order_transaction(order_id) → orders(id)
- order_transaction(state_id) → state_machine_state(id)
- order_transaction(shipping_method_id) → shipping_method(id)
- payment_method_custom_field(payment_method_id) → payment_method(id)
- payment_method_translated_custom_field(payment_method_id) → payment_method(id)
- payment_method(availability_rule_id) → rule(id)
- payment_method(media_id) → media(id)
- user_custom_field(users_id) → users(id)
- order_customer_vat(order_customer_id) → order_customer(id)
- order_customer_custom_field(order_customer_id) → order_customer(id)
- order_customer(order_id) → orders(id)
- order_customer(customer_id) → customer(id)
- customer_address_custom_field(customer_address_id) → customer_address(id)
- customer_address(customer_id) → customer(id)
- sales_channel_payment_method(payment_method_id) → payment_method(id)
- sales_channel_payment_method(sales_channel_id) → sales_channel(id)
- promotion_sales_channel_custom_field(sales_channel_id) → sales_channel(id)
- promotion_sales_channel_translated_custom_field(sales_channel_id) → sales_channel(id)
- sales_channel(payment_method_id) → payment_method(id)
- sales_channel(customer_group_id) → customer_group(id)
- sales_channel(currency_id) → currency(id)
- sales_channel(analytics_id) → analytics(id)
- sales_channel(service_category_id) → category(id)
- sales_channel(footer_category_id) → category(id)
- sales_channel(navigation_category_id) → category(id)
- sales_channel(language_id) → languages(id)
- sales_channel(shipping_method_id) → shipping_method(id)
- sales_channel(country_id) → country(id)
- category_breadcrumb(category_id) → category(id)
- category_custom_field(category_id) → category(id)
- category(after_category_id) → category(id)
- category(parent_id) → category(id)
- category(media_id) → media(id)
- language_custom_field(languages_id) → languages(id)
- languages(parent_id) → languages(id)
- manufacturer_custom_field(manufacturer_id) → manufacturer(id)
- manufacturer_transalated_custom_field(manufacturer_id) → manufacturer(id)
- manufacturer(media_id) → media(id)
- shipping_method_custom_field(shipping_method_id) → shipping_method(id)
- shipping_method_translated_custom_field(shipping_method_id) → shipping_method(id)
- shipping_method(delivery_time_id) → delivery_time(id)
- shipping_method(tax_id) → tax(id)
- shipping_method(availability_rule_id) → rule(id)
- shipping_method(media_id) → media(id)
- order_address_custom_field(order_address_id) → order_address(id)
- order_address(order_id) → orders(id)
- tax_custom_field(tax_id) → tax(id)
- country_custom_field(country_id) → country(id)
- country_translated_custom_field(country_id) → country(id)
- country(company_tax_currency_id) → currency(id)
- country(customer_tax_currency_id) → currency(id)
- product_property(product_id) → product(id)
- product_option(product_id) → product(id)
- product_stream(product_id) → product(id)
- product_tag(product_id) → product(id)
- product_category(product_id) → product(id)
- product_attribute_price(currency_id) → currency(id)
- product_attribute_price(product_id) → product(id)
- product_attribute_cheapest_price(currency_id) → currency(id)
- product_attribute_cheapest_price(product_id) → product(id)
- product_custom_field(product_id) → product(id)
- product_translated_custom_field(product_id) → product(id)
- product(delivery_time_id) → delivery_time(id)
- product(tax_id) → tax(id)
- product(manufacturer_id) → manufacturer(id)
- product(parent_id) → product(id)
- order_calculated_tax(order_id) → orders(id)
- order_tax_rule(order_id) → orders(id)
- order_rule(rule_id) → rule(id)
- order_rule(order_id) → orders(id)
- order_custom_field(orders_id) → orders(id)
- orders(order_customer_id) → order_customer(id)
- orders(currency_id) → currency(id)
- orders(billing_address_id) → customer_address(id)
- orders(language_id) → languages(id)
- orders(state_id) → state_machine_state(id)
- orders(sales_channel_id) → sales_channel(id)
- media_flag(media_id) → media(id)
- media_custom_field(media_id) → media(id)
- media_metadata(media_id) → media(id)
- media_translated_custom_field(media_id) → media(id)
- media(user_id) → users(id)
- media(media_folder_id) → media_folder(id)
- state_machine_state_custom_field(state_machine_state_id) → state_machine_state(id)
- state_machine_state_translated_custom_field(state_machine_state_id) → state_machine_state(id)
- state_machine_state(state_machine_id) → state_machine(id)
- customer_group_custom_field(customer_group_id) → customer_group(id)
- customer_group_translated_custom_field(customer_group_id) → customer_group(id)
- state_machine_custom_field(state_machine_id) → state_machine(id)
- state_machine_translated_custom_field(state_machine_id) → state_machine(id)
- state_machine(initial_state_id) → state_machine_state(id)
- product_media_custom_field(product_media_id) → product_media(id)
- product_media(product_id) → product(id)
- product_media(media_id) → media(id)
- rule_custom_field(rule_id) → rule(id)
- currency_custom_field(currency_id) → currency(id)
- currency_translated_custom_field(currency_id) → currency(id)
- media_folder_custom_field(media_folder_id) → media_folder(id)
- media_folder(parent_id) → media_folder(id)
- promotion_sales_channel(promotion_id) → promotion(id)
- promotion_sales_channel(sales_channel_id) → sales_channel(id)
- promotion_exclusion(promotion_id) → promotion(id)
- promotion_custom_field(promotion_id) → promotion(id)
- promotion_translated_custom_field(promotion_id) → promotion(id)
- promotion_order_per_customer(promotion_id) → promotion(id)
- promotion(product_id) → product(id)