← Shopware 6.1.0.rc1

Shopware 6.1.0.rc1 sales_channel_domain

Storefront domains (URLs) assigned to a Sales Channel, each with language and currency.

Columns

9 columns

Column	Type	Nullable	Additional
id	binary(16)	NO	Primary Key
sales_channel_id	binary(16)	NO	Index Foreign Key → sales_channel_language.sales_channel_id Foreign Key → sales_channel.id
language_id	binary(16)	NO	Foreign Key → sales_channel_language.language_id
url	varchar(255)	NO	Unique
currency_id	binary(16)	NO	Index Foreign Key → currency.id
snippet_set_id	binary(16)	NO	Index Foreign Key → snippet_set.id
custom_fields	longtext	YES
created_at	datetime(3)	NO
updated_at	datetime(3)	YES

Indexes

5 indexes

Index Name	Columns	Unique
fk.sales_channel_domain.currency_id	currency_id	No
fk.sales_channel_domain.language_id	sales_channel_id,language_id	No
fk.sales_channel_domain.snippet_set_id	snippet_set_id	No
PRIMARY	id	Yes
uniq.sales_channel_domain.url	url	Yes

Relations (from this table)

5 relations

Local Field	Foreign Table	Foreign Field
currency_id	currency	id
sales_channel_id	sales_channel_language	sales_channel_id
language_id	sales_channel_language	language_id
sales_channel_id	sales_channel	id
snippet_set_id	snippet_set	id

Relations (to this table)

1 relations

Local Field	Foreign Table	Foreign Field
id	product_export	sales_channel_domain_id