civicrm_group

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_action_schedule.group_id FK_civicrm_action_schedule_group_idN
civicrm_group_contact.group_id FK_civicrm_group_contact_group_idC
civicrm_group_contact_cache.group_id FK_civicrm_group_contact_cache_group_idC
civicrm_group_nesting.child_group_id FK_civicrm_group_nesting_child_group_idC
civicrm_group_nesting.parent_group_id FK_civicrm_group_nesting_parent_group_idC
civicrm_group_organization.group_id FK_civicrm_group_organization_group_idC
civicrm_mailing_event_subscribe.group_id FK_civicrm_mailing_event_subscribe_group_idC
civicrm_subscription_history.group_id FK_civicrm_subscription_history_group_idC
civicrm_uf_group.add_to_group_id FK_civicrm_uf_group_add_to_group_idN
civicrm_uf_group.limit_listings_group_id FK_civicrm_uf_group_limit_listings_group_idN

Group ID
name VARCHAR 64 √ null

Internal name of Group.
description TEXT 65535 √ null

Optional verbose description of the group.
source VARCHAR 64 √ null

Module or process which created this group.
saved_search_id INT UNSIGNED 10 √ null
civicrm_saved_search.id FK_civicrm_group_saved_search_idN

FK to saved search table.
is_active TINYINT 3 √ null

Is this entry active?
visibility VARCHAR 24 √ User and User Admin Only

In what context(s) is this field visible.
where_clause TEXT 65535 √ null

the sql where clause if a saved search acl
select_tables TEXT 65535 √ null

the tables to be included in a select data
where_tables TEXT 65535 √ null

the tables to be included in the count statement
group_type VARCHAR 128 √ null

FK to group type
cache_date TIMESTAMP 19 √ null
refresh_date TIMESTAMP 19 √ null
parents TEXT 65535 √ null

IDs of the parent(s)
children TEXT 65535 √ null

IDs of the child(ren)
is_hidden TINYINT 3 √ 0

Is this group hidden?
is_reserved TINYINT 3 √ 0
created_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_group_created_idN

FK to contact table.
modified_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_group_modified_idN

FK to contact table.
title_en_US VARCHAR 64 √ null
title_fr_CA VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_group_created_id Performance Asc created_id
FK_civicrm_group_modified_id Performance Asc modified_id
FK_civicrm_group_saved_search_id Performance Asc saved_search_id
index_group_type Performance Asc group_type
UI_name Must be unique Asc name
UI_title_en_US Must be unique Asc title_en_US
UI_title_fr_CA Must be unique Asc title_fr_CA

Relationships

Close relationships within degrees of separation