role_has_permissions

742 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
permission_id BIGINT UNSIGNED 20 null
permissions.id role_has_permissions_permission_id_foreign C
role_id BIGINT UNSIGNED 20 null
roles.id role_has_permissions_role_id_foreign C

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc permission_id + role_id
role_has_permissions_role_id_foreign Performance Asc role_id

Relationships

Close relationships within degrees of separation