Table d47civi_0z3xa.civicrm_group Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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.
title varchar 64  √  null 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 datetime 19  √  null Date when we created the cache for a smart group
refresh_date datetime 19  √  null Date and time when we need to refresh the cache next.
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.

Table contained 5 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
created_id Performance Asc FK_civicrm_group_created_id  
modified_id Performance Asc FK_civicrm_group_modified_id  
saved_search_id Performance Asc FK_civicrm_group_saved_search_id  
group_type Performance Asc index_group_type  
name Must be unique Asc UI_name This unique column is also nullable
title Must be unique Asc UI_title This unique column is also nullable

Close relationships  within of separation: