← Shopware 6.7.10.0

Shopware 6.7.10.0 category_tag

Junction table linking categories to tags for categorization and filtering.

Columns

3 columns

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

Indexes

2 indexes

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