acl_roles_actions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
role_id CHAR 36 null
acl_roles.id Defined in XMLR
action_id CHAR 36 null
acl_actions.id Defined in XMLR
access_override INT 10 null
date_modified DATETIME 26 null
deleted BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_acl_action_id Performance Asc action_id
idx_acl_role_id Performance Asc role_id
idx_aclrole_action Performance Asc/Asc role_id + action_id
idx_del_override Performance Asc/Asc/Asc/Asc role_id + deleted + action_id + access_override

Relationships