Shopware 6.7.8.1 acl_user_role
Junction table linking admin users (integrations/users) to their assigned ACL roles.
| Column | Type | Nullable | Additional |
| user_id | binary(16) | NO | Primary Key
Foreign Key → user.id |
| acl_role_id | binary(16) | NO | Primary Key
Foreign Key → acl_role.id |
| created_at | datetime(3) | NO | |
| updated_at | datetime(3) | YES | |
| Index Name | Columns | Unique |
| fk.acl_user_role.acl_role_id | acl_role_id | No |
| PRIMARY | user_id,acl_role_id | Yes |
Relations (from this table)
2 relations
| Local Field | Foreign Table | Foreign Field |
| acl_role_id | acl_role | id |
| user_id | user | id |
