role_permissions

283 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
roleId INT 10 null
roles.roleId Implied Constraint R
permissionId INT 10 null

Indexes

Constraint Name Type Sort Column(s)
role_permissions_s_pk Primary key Asc id
PRIMARY Must be unique Asc id
roleId Performance Asc roleId
roleId_2 Must be unique Asc/Asc roleId + permissionId

Relationships