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>
13 <type>int unsigned
</type>
14 <title>Group ID
</title>
15 <required>true
</required>
16 <comment>Group ID
</comment>
21 <autoincrement>true
</autoincrement>
26 <title>Group Name
</title>
28 <comment>Internal name of Group.
</comment>
34 <title>Group Title
</title>
36 <localizable>true
</localizable>
37 <comment>Name of Group.
</comment>
44 <name>description
</name>
46 <title>Group Description
</title>
52 <comment>Optional verbose description of the group.
</comment>
58 <title>Group Source
</title>
60 <comment>Module or process which created this group.
</comment>
64 <name>saved_search_id
</name>
65 <type>int unsigned
</type>
66 <title>Saved Search ID
</title>
67 <comment>FK to saved search table.
</comment>
71 <name>saved_search_id
</name>
72 <table>civicrm_saved_search
</table>
75 <onDelete>SET NULL
</onDelete>
78 <name>is_active
</name>
80 <title>Group Enabled
</title>
81 <comment>Is this entry active?
</comment>
85 <name>visibility
</name>
88 <title>Group Visibility Setting
</title>
89 <default>'User and User Admin Only'
</default>
90 <comment>In what context(s) is this field visible.
</comment>
92 <callback>CRM_Core_SelectValues::groupVisibility
</callback>
100 <name>where_clause
</name>
102 <title>Group Where Clause
</title>
103 <comment>the sql where clause if a saved search acl
</comment>
107 <name>select_tables
</name>
109 <title>Tables For Select Clause
</title>
110 <comment>the tables to be included in a select data
</comment>
111 <serialize>PHP
</serialize>
115 <name>where_tables
</name>
117 <title>Tables For Where Clause
</title>
118 <comment>the tables to be included in the count statement
</comment>
119 <serialize>PHP
</serialize>
123 <name>group_type
</name>
125 <title>Group Type
</title>
127 <comment>FK to group type
</comment>
129 <optionGroupName>group_type
</optionGroupName>
131 <serialize>SEPARATOR_BOOKEND
</serialize>
135 <name>cache_date
</name>
136 <type>timestamp
</type>
137 <title>Group Cache Date
</title>
138 <required>false
</required>
139 <comment>Date when we created the cache for a smart group
</comment>
143 <name>refresh_date
</name>
144 <type>timestamp
</type>
145 <title>Next Group Refresh Time
</title>
146 <required>false
</required>
147 <comment>Date and time when we need to refresh the cache next.
</comment>
153 <title>Group Parents
</title>
154 <comment>IDs of the parent(s)
</comment>
156 <serialize>COMMA
</serialize>
158 <callback>CRM_Core_PseudoConstant::allGroup
</callback>
162 <name>children
</name>
164 <title>Group Children
</title>
165 <comment>IDs of the child(ren)
</comment>
169 <name>is_hidden
</name>
171 <title>Group is Hidden
</title>
173 <comment>Is this group hidden?
</comment>
177 <name>is_reserved
</name>
179 <title>Group is Reserved
</title>
184 <name>index_group_type
</name>
185 <fieldName>group_type
</fieldName>
189 <name>UI_title
</name>
190 <fieldName>title
</fieldName>
191 <unique>true
</unique>
196 <fieldName>name
</fieldName>
197 <unique>true
</unique>
201 <name>created_id
</name>
202 <type>int unsigned
</type>
203 <title>Group Created By
</title>
204 <comment>FK to contact table.
</comment>
208 <name>created_id
</name>
209 <table>civicrm_contact
</table>
212 <onDelete>SET NULL
</onDelete>
215 <name>modified_id
</name>
216 <type>int unsigned
</type>
217 <title>Group Modified By
</title>
218 <comment>FK to contact table.
</comment>
222 <name>modified_id
</name>
223 <table>civicrm_contact
</table>
226 <onDelete>SET NULL
</onDelete>