civicrm_group


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_id N
civicrm_group_contact.group_id FK_civicrm_group_contact_group_id C
civicrm_group_contact_cache.group_id FK_civicrm_group_contact_cache_group_id C
civicrm_group_nesting.child_group_id FK_civicrm_group_nesting_child_group_id C
civicrm_group_nesting.parent_group_id FK_civicrm_group_nesting_parent_group_id C
civicrm_group_organization.group_id FK_civicrm_group_organization_group_id C
civicrm_mailing_event_subscribe.group_id FK_civicrm_mailing_event_subscribe_group_id C
civicrm_subscription_history.group_id FK_civicrm_subscription_history_group_id C
civicrm_uf_group.add_to_group_id FK_civicrm_uf_group_add_to_group_id N
civicrm_uf_group.limit_listings_group_id FK_civicrm_uf_group_limit_listings_group_id N

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_id N

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_id N

FK to contact table.

modified_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_group_modified_id N

FK to contact table.

title_en_US VARCHAR 64 null
title_fr_CA VARCHAR 64 null

Table contained 0 rows

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