🔐 Magento_Authorization · engine innodb

authorization_role

Admin Role Table

Neighbourhood (1-hop foreign-key graph — showing 1 of 1)

flowchart LR
  c["authorization_role"]:::center
  n0["authorization_rule"]
  click n0 "/schema/table/authorization_rule"
  c -- role_id --> n0
  click c "/schema/table/authorization_role"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (1)

authorization_rule → role_id

Columns (8)

Name	Type	Null	Default	Comment
role_id PK	int unsigned	no		Role ID
parent_id	int unsigned	no	0	Parent Role ID
tree_level	smallint unsigned	no	0	Role Tree Level
sort_order	smallint unsigned	no	0	Role Sort Order
role_type	varchar(1)	no	0	Role Type
user_id	int unsigned	no	0	User ID
user_type	varchar(16)	yes		User Type
role_name	varchar(50)	yes		Role Name

Keys & indexes

Primary key: role_id

Indexes

AUTHORIZATION_ROLE_PARENT_ID_SORT_ORDER (parent_id, sort_order) btree
AUTHORIZATION_ROLE_TREE_LEVEL (tree_level) btree

Referenced by (1)

authorization_rule .role_id → .role_id (on delete CASCADE)