1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
6 <name>civicrm_group
</name>
7 <comment>Provide grouping of related contacts
</comment>
12 <type>int unsigned
</type>
13 <title>Group ID
</title>
14 <required>true
</required>
15 <comment>Group ID
</comment>
20 <autoincrement>true
</autoincrement>
25 <title>Group Name
</title>
27 <comment>Internal name of Group.
</comment>
33 <title>Group Title
</title>
35 <localizable>true
</localizable>
36 <comment>Name of Group.
</comment>
40 <name>description
</name>
42 <title>Group Description
</title>
48 <comment>Optional verbose description of the group.
</comment>
54 <title>Group Source
</title>
56 <comment>Module or process which created this group.
</comment>
60 <name>saved_search_id
</name>
61 <type>int unsigned
</type>
62 <title>Saved Search ID
</title>
63 <comment>FK to saved search table.
</comment>
67 <name>saved_search_id
</name>
68 <table>civicrm_saved_search
</table>
71 <onDelete>SET NULL
</onDelete>
74 <name>is_active
</name>
76 <title>Group Enabled
</title>
77 <comment>Is this entry active?
</comment>
81 <name>visibility
</name>
84 <title>Group Visibility Setting
</title>
85 <default>'User and User Admin Only'
</default>
86 <comment>In what context(s) is this field visible.
</comment>
88 <callback>CRM_Core_SelectValues::groupVisibility
</callback>
96 <name>where_clause
</name>
98 <title>Group Where Clause
</title>
99 <comment>the sql where clause if a saved search acl
</comment>
103 <name>select_tables
</name>
105 <title>Tables For Select Clause
</title>
106 <comment>the tables to be included in a select data
</comment>
110 <name>where_tables
</name>
112 <title>Tables For Where Clause
</title>
113 <comment>the tables to be included in the count statement
</comment>
117 <name>group_type
</name>
119 <title>Group Type
</title>
121 <comment>FK to group type
</comment>
123 <optionGroupName>group_type
</optionGroupName>
128 <name>cache_date
</name>
129 <type>timestamp
</type>
130 <title>Group Cache Date
</title>
131 <required>false
</required>
132 <comment>Date when we created the cache for a smart group
</comment>
136 <name>refresh_date
</name>
137 <type>timestamp
</type>
138 <title>Next Group Refresh Time
</title>
139 <required>false
</required>
140 <comment>Date and time when we need to refresh the cache next.
</comment>
146 <title>Group Parents
</title>
147 <comment>IDs of the parent(s)
</comment>
151 <name>children
</name>
153 <title>Group Children
</title>
154 <comment>IDs of the child(ren)
</comment>
158 <name>is_hidden
</name>
160 <title>Group is Hidden
</title>
162 <comment>Is this group hidden?
</comment>
166 <name>is_reserved
</name>
168 <title>Group is Reserved
</title>
173 <name>index_group_type
</name>
174 <fieldName>group_type
</fieldName>
178 <name>UI_title
</name>
179 <fieldName>title
</fieldName>
180 <unique>true
</unique>
185 <fieldName>name
</fieldName>
186 <unique>true
</unique>
190 <name>created_id
</name>
191 <type>int unsigned
</type>
192 <title>Group Created By
</title>
193 <comment>FK to contact table.
</comment>
197 <name>created_id
</name>
198 <table>civicrm_contact
</table>
201 <onDelete>SET NULL
</onDelete>
204 <name>modified_id
</name>
205 <type>int unsigned
</type>
206 <title>Group Modified By
</title>
207 <comment>FK to contact table.
</comment>
211 <name>modified_id
</name>
212 <table>civicrm_contact
</table>
215 <onDelete>SET NULL
</onDelete>