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 <required>true
</required>
38 <comment>Name of Group.
</comment>
45 <name>description
</name>
47 <title>Group Description
</title>
53 <comment>Optional verbose description of the group.
</comment>
59 <title>Group Source
</title>
61 <comment>Module or process which created this group.
</comment>
65 <name>saved_search_id
</name>
66 <type>int unsigned
</type>
67 <title>Saved Search ID
</title>
68 <comment>FK to saved search table.
</comment>
72 <name>saved_search_id
</name>
73 <table>civicrm_saved_search
</table>
76 <onDelete>SET NULL
</onDelete>
79 <name>is_active
</name>
81 <title>Group Enabled
</title>
82 <comment>Is this entry active?
</comment>
86 <name>visibility
</name>
89 <title>Group Visibility Setting
</title>
90 <default>'User and User Admin Only'
</default>
91 <comment>In what context(s) is this field visible.
</comment>
93 <callback>CRM_Core_SelectValues::groupVisibility
</callback>
101 <name>where_clause
</name>
103 <title>Group Where Clause
</title>
104 <comment>the sql where clause if a saved search acl
</comment>
108 <name>select_tables
</name>
110 <title>Tables For Select Clause
</title>
111 <comment>the tables to be included in a select data
</comment>
112 <serialize>PHP
</serialize>
116 <name>where_tables
</name>
118 <title>Tables For Where Clause
</title>
119 <comment>the tables to be included in the count statement
</comment>
120 <serialize>PHP
</serialize>
124 <name>group_type
</name>
126 <title>Group Type
</title>
128 <comment>FK to group type
</comment>
130 <optionGroupName>group_type
</optionGroupName>
132 <serialize>SEPARATOR_BOOKEND
</serialize>
136 <name>cache_date
</name>
137 <type>timestamp
</type>
138 <title>Group Cache Date
</title>
139 <required>false
</required>
140 <comment>Date when we created the cache for a smart group
</comment>
144 <name>refresh_date
</name>
145 <type>timestamp
</type>
146 <title>Next Group Refresh Time
</title>
147 <required>false
</required>
148 <comment>Date and time when we need to refresh the cache next.
</comment>
154 <title>Group Parents
</title>
155 <comment>IDs of the parent(s)
</comment>
157 <serialize>COMMA
</serialize>
159 <callback>CRM_Core_PseudoConstant::allGroup
</callback>
163 <name>children
</name>
165 <title>Group Children
</title>
166 <comment>IDs of the child(ren)
</comment>
170 <name>is_hidden
</name>
172 <title>Group is Hidden
</title>
174 <comment>Is this group hidden?
</comment>
178 <name>is_reserved
</name>
180 <title>Group is Reserved
</title>
185 <name>index_group_type
</name>
186 <fieldName>group_type
</fieldName>
190 <name>UI_title
</name>
191 <fieldName>title
</fieldName>
192 <unique>true
</unique>
197 <fieldName>name
</fieldName>
198 <unique>true
</unique>
202 <name>created_id
</name>
203 <type>int unsigned
</type>
204 <title>Group Created By
</title>
205 <comment>FK to contact table.
</comment>
209 <name>created_id
</name>
210 <table>civicrm_contact
</table>
213 <onDelete>SET NULL
</onDelete>
216 <name>modified_id
</name>
217 <type>int unsigned
</type>
218 <title>Group Modified By
</title>
219 <comment>FK to contact table.
</comment>
223 <name>modified_id
</name>
224 <table>civicrm_contact
</table>
227 <onDelete>SET NULL
</onDelete>
230 <name>frontend_title
</name>
232 <title>Public Group Title
</title>
234 <localizable>true
</localizable>
235 <comment>Alternative public title for this Group.
</comment>
236 <default>NULL
</default>
243 <name>frontend_description
</name>
245 <title>Public Group Description
</title>
247 <type>TextArea
</type>
251 <comment>Alternative public description of the group.
</comment>
252 <localizable>true
</localizable>
253 <default>NULL
</default>