Shopware 5.7.12 s_product_streams_articles
Manually assigned products within a product stream (static additions to dynamic groups).
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | int(11) unsigned | NO | Primary Key, auto_increment |
| stream_id | int(11) unsigned | NO | Index Foreign Key → s_product_streams.id |
| article_id | int(11) unsigned | NO | Index Foreign Key → s_articles.id |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| PRIMARY | id | Yes |
| stream_id | stream_id,article_id | Yes |
| s_product_streams_articles_fk_article_id | article_id | No |
Relations (from this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| article_id | s_articles | id |
| stream_id | s_product_streams | id |