civicrm_acl_entity_role


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Unique table ID

acl_role_id INT UNSIGNED 10 null

Foreign Key to ACL Role (which is an option value pair and hence an implicit FK)

entity_table VARCHAR 64 null

Table of the object joined to the ACL Role (Contact or Group)

entity_id INT UNSIGNED 10 null

ID of the group/contact object being joined

is_active TINYINT 3 null

Is this property active?

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
index_entity Performance Asc/Asc entity_table + entity_id
index_role Performance Asc acl_role_id