Fields (31)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | binary(16) | NO | PRI | NULL | |
| type_id | binary(16) | NO | MUL | NULL | |
| short_name | varchar(45) | YES | NULL | ||
| configuration | json | YES | NULL | ||
| access_key | varchar(255) | NO | UNI | NULL | |
| language_id | binary(16) | NO | MUL | NULL | |
| currency_id | binary(16) | NO | MUL | NULL | |
| payment_method_id | binary(16) | NO | MUL | NULL | |
| shipping_method_id | binary(16) | NO | MUL | NULL | |
| country_id | binary(16) | NO | MUL | NULL | |
| navigation_category_id | binary(16) | NO | MUL | NULL | |
| navigation_category_version_id | binary(16) | NO | NULL | ||
| navigation_category_depth | int | NO | 2 | ||
| home_cms_page_id | binary(16) | YES | MUL | NULL | |
| home_cms_page_version_id | binary(16) | YES | NULL | ||
| hreflang_active | tinyint unsigned | YES | 0 | ||
| hreflang_default_domain_id | binary(16) | YES | MUL | NULL | |
| footer_category_id | binary(16) | YES | MUL | NULL | |
| footer_category_version_id | binary(16) | YES | NULL | ||
| service_category_id | binary(16) | YES | MUL | NULL | |
| service_category_version_id | binary(16) | YES | NULL | ||
| active | tinyint(1) | NO | 1 | ||
| maintenance | tinyint(1) | NO | 0 | ||
| maintenance_ip_whitelist | json | YES | NULL | ||
| customer_group_id | binary(16) | NO | MUL | NULL | |
| mail_header_footer_id | binary(16) | YES | MUL | NULL | |
| payment_method_ids | json | YES | NULL | ||
| analytics_id | binary(16) | YES | MUL | NULL | |
| tax_calculation_type | varchar(50) | NO | horizontal | ||
| created_at | datetime(3) | NO | NULL | ||
| updated_at | datetime(3) | YES | NULL |
Indexes (16)
| 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 |