1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>EntityRole
</class>
6 <name>civicrm_acl_entity_role
</name>
7 <comment>Join table for Contacts and Groups to ACL Roles
</comment>
11 <type>int unsigned
</type>
12 <title>Entity Role
</title>
13 <required>true
</required>
14 <comment>Unique table ID
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>acl_role_id
</name>
23 <title>ACL Role ID
</title>
24 <type>int unsigned
</type>
25 <required>true
</required>
26 <comment>Foreign Key to ACL Role (which is an option value pair and hence an implicit FK)
</comment>
30 <name>entity_table
</name>
31 <title>Entity Table
</title>
34 <required>true
</required>
35 <comment>Table of the object joined to the ACL Role (Contact or Group)
</comment>
39 <name>entity_id
</name>
40 <title>ACL Entity ID
</title>
41 <type>int unsigned
</type>
42 <required>true
</required>
43 <comment>ID of the group/contact object being joined
</comment>
47 <idColumn>entity_id
</idColumn>
48 <typeColumn>entity_table
</typeColumn>
52 <name>is_active
</name>
53 <title>ACL Entity Role is Active
</title>
55 <comment>Is this property active?
</comment>
59 <name>index_role
</name>
60 <fieldName>acl_role_id
</fieldName>
64 <name>index_entity
</name>
65 <fieldName>entity_table
</fieldName>
66 <fieldName>entity_id
</fieldName>