← Shopware 6.7.8.1

Shopware 6.7.8.1 product_stream_mapping

Cached/materialized mapping of products matching a product stream (for performance).

Columns

3 columns

Column Type Nullable Additional
product_id binary(16) NO Primary Key Foreign Key → product.id
product_version_id binary(16) NO Primary Key Foreign Key → product.version_id
product_stream_id binary(16) NO Primary Key Foreign Key → product_stream.id

Indexes

2 indexes

Index Name Columns Unique
fk.product_stream_mapping.product_stream_id product_stream_id No
PRIMARY product_id,product_version_id,product_stream_id Yes

Relations (from this table)

3 relations

Local Field Foreign Table Foreign Field
product_id product id
product_version_id product version_id
product_stream_id product_stream id