Shopware 6.7.7.1 sales_channel
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | binary(16) | NO | Primary Key |
| type_id | binary(16) | NO | Index Foreign Key → sales_channel_type.id |
| short_name | varchar(45) | YES | |
| configuration | json | YES | |
| access_key | varchar(255) | NO | Unique |
| language_id | binary(16) | NO | Index Foreign Key → language.id |
| currency_id | binary(16) | NO | Index Foreign Key → currency.id |
| payment_method_id | binary(16) | NO | Index Foreign Key → payment_method.id |
| shipping_method_id | binary(16) | NO | Index Foreign Key → shipping_method.id |
| country_id | binary(16) | NO | Index Foreign Key → country.id |
| navigation_category_id | binary(16) | NO | Index Foreign Key → category.id |
| navigation_category_version_id | binary(16) | NO | Foreign Key → category.version_id |
| navigation_category_depth | int | NO | Default: 2 |
| hreflang_active | tinyint unsigned | YES | Default: 0 |
| hreflang_default_domain_id | binary(16) | YES | Index Foreign Key → sales_channel_domain.id |
| footer_category_id | binary(16) | YES | Index Foreign Key → category.id |
| footer_category_version_id | binary(16) | YES | Foreign Key → category.version_id |
| service_category_id | binary(16) | YES | Index Foreign Key → category.id |
| service_category_version_id | binary(16) | YES | Foreign Key → category.version_id |
| active | tinyint(1) | NO | Default: 1 |
| maintenance | tinyint(1) | NO | Default: 0 |
| maintenance_ip_whitelist | json | YES | |
| customer_group_id | binary(16) | NO | Index Foreign Key → customer_group.id |
| mail_header_footer_id | binary(16) | YES | Index Foreign Key → mail_header_footer.id |
| payment_method_ids | json | YES | |
| analytics_id | binary(16) | YES | Index Foreign Key → sales_channel_analytics.id |
| tax_calculation_type | varchar(50) | NO | Default: horizontal |
| created_at | datetime(3) | NO | |
| updated_at | datetime(3) | YES | |
| home_cms_page_id | binary(16) | YES | Index Foreign Key → cms_page.id |
| home_cms_page_version_id | binary(16) | YES | Foreign Key → cms_page.version_id |
| measurement_units | json | YES |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| fk.sales_channel.analytics_id | analytics_id | No |
| fk.sales_channel.country_id | country_id | No |
| fk.sales_channel.currency_id | currency_id | No |
| fk.sales_channel.customer_group_id | customer_group_id | No |
| fk.sales_channel.footer_category_id | footer_category_id,footer_category_version_id | No |
| fk.sales_channel.header_footer_id | mail_header_footer_id | No |
| fk.sales_channel.home_cms_page | home_cms_page_id,home_cms_page_version_id | No |
| fk.sales_channel.hreflang_default_domain_id | hreflang_default_domain_id | No |
| fk.sales_channel.language_id | language_id | No |
| fk.sales_channel.navigation_category_id | navigation_category_id,navigation_category_version_id | No |
| fk.sales_channel.payment_method_id | payment_method_id | No |
| fk.sales_channel.service_category_id | service_category_id,service_category_version_id | No |
| fk.sales_channel.shipping_method_id | shipping_method_id | No |
| fk.sales_channel.type_id | type_id | No |
| PRIMARY | id | Yes |
| uniq.access_key | access_key | Yes |
Relations (from this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| analytics_id | sales_channel_analytics | id |
| country_id | country | id |
| currency_id | currency | id |
| customer_group_id | customer_group | id |
| footer_category_id | category | id |
| footer_category_version_id | category | version_id |
| mail_header_footer_id | mail_header_footer | id |
| home_cms_page_id | cms_page | id |
| home_cms_page_version_id | cms_page | version_id |
| hreflang_default_domain_id | sales_channel_domain | id |
| language_id | language | id |
| navigation_category_id | category | id |
| navigation_category_version_id | category | version_id |
| payment_method_id | payment_method | id |
| service_category_id | category | id |
| service_category_version_id | category | version_id |
| shipping_method_id | shipping_method | id |
| type_id | sales_channel_type | id |
Relations (to this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| id | customer | bound_sales_channel_id |
| id | customer | sales_channel_id |
| id | customer_group_registration_sales_channels | sales_channel_id |
| id | customer_wishlist | sales_channel_id |
| id | document_base_config_sales_channel | sales_channel_id |
| id | landing_page_sales_channel | sales_channel_id |
| id | main_category | sales_channel_id |
| id | newsletter_recipient | sales_channel_id |
| id | number_range_sales_channel | sales_channel_id |
| id | order | sales_channel_id |
| id | product_export | sales_channel_id |
| id | product_export | storefront_sales_channel_id |
| id | product_review | sales_channel_id |
| id | product_visibility | sales_channel_id |
| id | promotion_sales_channel | sales_channel_id |
| id | sales_channel_api_context | sales_channel_id |
| id | sales_channel_country | sales_channel_id |
| id | sales_channel_currency | sales_channel_id |
| id | sales_channel_domain | sales_channel_id |
| id | sales_channel_language | sales_channel_id |
| id | sales_channel_payment_method | sales_channel_id |
| id | sales_channel_shipping_method | sales_channel_id |
| id | sales_channel_translation | sales_channel_id |
| id | seo_url | sales_channel_id |
| id | seo_url_template | sales_channel_id |
| id | system_config | sales_channel_id |
| id | theme_sales_channel | sales_channel_id |