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>
125 <name>cache_date
</name>
126 <type>datetime
</type>
127 <title>Group Cache Date
</title>
128 <comment>Date when we created the cache for a smart group
</comment>
132 <name>refresh_date
</name>
133 <type>datetime
</type>
134 <title>Next Group Refresh Time
</title>
135 <comment>Date and time when we need to refresh the cache next.
</comment>
141 <title>Group Parents
</title>
142 <comment>IDs of the parent(s)
</comment>
146 <name>children
</name>
148 <title>Group Children
</title>
149 <comment>IDs of the child(ren)
</comment>
153 <name>is_hidden
</name>
155 <title>Group is Hidden
</title>
157 <comment>Is this group hidden?
</comment>
161 <name>is_reserved
</name>
163 <title>Group is Reserved
</title>
168 <name>index_group_type
</name>
169 <fieldName>group_type
</fieldName>
173 <name>UI_title
</name>
174 <fieldName>title
</fieldName>
175 <unique>true
</unique>
180 <fieldName>name
</fieldName>
181 <unique>true
</unique>
185 <name>created_id
</name>
186 <type>int unsigned
</type>
187 <title>Group Created By
</title>
188 <comment>FK to contact table.
</comment>
192 <name>created_id
</name>
193 <table>civicrm_contact
</table>
196 <onDelete>SET NULL
</onDelete>
199 <name>modified_id
</name>
200 <type>int unsigned
</type>
201 <title>Group Modified By
</title>
202 <comment>FK to contact table.
</comment>
206 <name>modified_id
</name>
207 <table>civicrm_contact
</table>
210 <onDelete>SET NULL
</onDelete>