Shopware 6.7.8.1 order_tag
Junction table linking orders to tags for internal organization and Flow Builder conditions.
| Column | Type | Nullable | Additional |
| order_id | binary(16) | NO | Primary Key
Foreign Key → order.id |
| order_version_id | binary(16) | NO | Primary Key
Foreign Key → order.version_id |
| tag_id | binary(16) | NO | Primary Key
Foreign Key → tag.id |
| Index Name | Columns | Unique |
| fk.order_tag.tag_id | tag_id | No |
| PRIMARY | order_id,order_version_id,tag_id | Yes |
Relations (from this table)
3 relations
| Local Field | Foreign Table | Foreign Field |
| order_id | order | id |
| order_version_id | order | version_id |
| tag_id | tag | id |
