← Shopware 6.7.8.0

Shopware 6.7.8.0 number_range_sales_channel

Links number ranges to Sales Channels (each channel can have its own numbering).

Columns

6 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
number_range_id binary(16) NO Index Foreign Key → number_range.id
sales_channel_id binary(16) YES Index Foreign Key → sales_channel.id
number_range_type_id binary(16) NO Index Foreign Key → number_range_type.id
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

4 indexes

Index Name Columns Unique
fk.number_range_sales_channel.number_range_type_id number_range_type_id No
fk.number_range_sales_channel.sales_channel_id sales_channel_id No
PRIMARY id Yes
uniq.numer_range_id__sales_channel_id number_range_id,sales_channel_id Yes

Relations (from this table)

3 relations

Local Field Foreign Table Foreign Field
number_range_id number_range id
number_range_type_id number_range_type id
sales_channel_id sales_channel id