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>
107 <serialize>PHP
</serialize>
111 <name>where_tables
</name>
113 <title>Tables For Where Clause
</title>
114 <comment>the tables to be included in the count statement
</comment>
115 <serialize>PHP
</serialize>
119 <name>group_type
</name>
121 <title>Group Type
</title>
123 <comment>FK to group type
</comment>
125 <optionGroupName>group_type
</optionGroupName>
127 <serialize>SEPARATOR_BOOKEND
</serialize>
131 <name>cache_date
</name>
132 <type>timestamp
</type>
133 <title>Group Cache Date
</title>
134 <required>false
</required>
135 <comment>Date when we created the cache for a smart group
</comment>
139 <name>refresh_date
</name>
140 <type>timestamp
</type>
141 <title>Next Group Refresh Time
</title>
142 <required>false
</required>
143 <comment>Date and time when we need to refresh the cache next.
</comment>
149 <title>Group Parents
</title>
150 <comment>IDs of the parent(s)
</comment>
152 <serialize>COMMA
</serialize>
154 <callback>CRM_Core_PseudoConstant::allGroup
</callback>
158 <name>children
</name>
160 <title>Group Children
</title>
161 <comment>IDs of the child(ren)
</comment>
165 <name>is_hidden
</name>
167 <title>Group is Hidden
</title>
169 <comment>Is this group hidden?
</comment>
173 <name>is_reserved
</name>
175 <title>Group is Reserved
</title>
180 <name>index_group_type
</name>
181 <fieldName>group_type
</fieldName>
185 <name>UI_title
</name>
186 <fieldName>title
</fieldName>
187 <unique>true
</unique>
192 <fieldName>name
</fieldName>
193 <unique>true
</unique>
197 <name>created_id
</name>
198 <type>int unsigned
</type>
199 <title>Group Created By
</title>
200 <comment>FK to contact table.
</comment>
204 <name>created_id
</name>
205 <table>civicrm_contact
</table>
208 <onDelete>SET NULL
</onDelete>
211 <name>modified_id
</name>
212 <type>int unsigned
</type>
213 <title>Group Modified By
</title>
214 <comment>FK to contact table.
</comment>
218 <name>modified_id
</name>
219 <table>civicrm_contact
</table>
222 <onDelete>SET NULL
</onDelete>