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>
43 <name>description
</name>
45 <title>Group Description
</title>
51 <comment>Optional verbose description of the group.
</comment>
57 <title>Group Source
</title>
59 <comment>Module or process which created this group.
</comment>
63 <name>saved_search_id
</name>
64 <type>int unsigned
</type>
65 <title>Saved Search ID
</title>
66 <comment>FK to saved search table.
</comment>
70 <name>saved_search_id
</name>
71 <table>civicrm_saved_search
</table>
74 <onDelete>SET NULL
</onDelete>
77 <name>is_active
</name>
79 <title>Group Enabled
</title>
80 <comment>Is this entry active?
</comment>
84 <name>visibility
</name>
87 <title>Group Visibility Setting
</title>
88 <default>'User and User Admin Only'
</default>
89 <comment>In what context(s) is this field visible.
</comment>
91 <callback>CRM_Core_SelectValues::groupVisibility
</callback>
99 <name>where_clause
</name>
101 <title>Group Where Clause
</title>
102 <comment>the sql where clause if a saved search acl
</comment>
106 <name>select_tables
</name>
108 <title>Tables For Select Clause
</title>
109 <comment>the tables to be included in a select data
</comment>
110 <serialize>PHP
</serialize>
114 <name>where_tables
</name>
116 <title>Tables For Where Clause
</title>
117 <comment>the tables to be included in the count statement
</comment>
118 <serialize>PHP
</serialize>
122 <name>group_type
</name>
124 <title>Group Type
</title>
126 <comment>FK to group type
</comment>
128 <optionGroupName>group_type
</optionGroupName>
130 <serialize>SEPARATOR_BOOKEND
</serialize>
134 <name>cache_date
</name>
135 <type>timestamp
</type>
136 <title>Group Cache Date
</title>
137 <required>false
</required>
138 <comment>Date when we created the cache for a smart group
</comment>
142 <name>refresh_date
</name>
143 <type>timestamp
</type>
144 <title>Next Group Refresh Time
</title>
145 <required>false
</required>
146 <comment>Date and time when we need to refresh the cache next.
</comment>
152 <title>Group Parents
</title>
153 <comment>IDs of the parent(s)
</comment>
155 <serialize>COMMA
</serialize>
157 <callback>CRM_Core_PseudoConstant::allGroup
</callback>
161 <name>children
</name>
163 <title>Group Children
</title>
164 <comment>IDs of the child(ren)
</comment>
168 <name>is_hidden
</name>
170 <title>Group is Hidden
</title>
172 <comment>Is this group hidden?
</comment>
176 <name>is_reserved
</name>
178 <title>Group is Reserved
</title>
183 <name>index_group_type
</name>
184 <fieldName>group_type
</fieldName>
188 <name>UI_title
</name>
189 <fieldName>title
</fieldName>
190 <unique>true
</unique>
195 <fieldName>name
</fieldName>
196 <unique>true
</unique>
200 <name>created_id
</name>
201 <type>int unsigned
</type>
202 <title>Group Created By
</title>
203 <comment>FK to contact table.
</comment>
207 <name>created_id
</name>
208 <table>civicrm_contact
</table>
211 <onDelete>SET NULL
</onDelete>
214 <name>modified_id
</name>
215 <type>int unsigned
</type>
216 <title>Group Modified By
</title>
217 <comment>FK to contact table.
</comment>
221 <name>modified_id
</name>
222 <table>civicrm_contact
</table>
225 <onDelete>SET NULL
</onDelete>