Shopware 6.2.0 product_tag
Junction table linking products to tags.
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 |
| tag_id | binary(16) | NO | Primary Key Foreign Key → tag.id |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| fk.product_tag.tag_id | tag_id | No |
| PRIMARY | product_id,product_version_id,tag_id | Yes |