Shopware 6.1.3 product_tag
Junction table linking products to tags.
| 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 |
| Index Name | Columns | Unique |
| fk.product_tag.tag_id | tag_id | No |
| PRIMARY | product_id,product_version_id,tag_id | Yes |
Relations (from this table)
3 relations
| Local Field | Foreign Table | Foreign Field |
| product_id | product | id |
| product_version_id | product | version_id |
| tag_id | tag | id |