Shopware 6.7.10.0 category_tag
Junction table linking categories to tags for categorization and filtering.
| Column | Type | Nullable | Additional |
| category_id | binary(16) | NO | Primary Key
Foreign Key → category.id |
| category_version_id | binary(16) | NO | Primary Key
Foreign Key → category.version_id |
| tag_id | binary(16) | NO | Primary Key
Foreign Key → tag.id |
| Index Name | Columns | Unique |
| fk.category_tag.tag_id | tag_id | No |
| PRIMARY | category_id,category_version_id,tag_id | Yes |
Relations (from this table)
3 relations
| Local Field | Foreign Table | Foreign Field |
| category_id | category | id |
| category_version_id | category | version_id |
| tag_id | tag | id |
