Table d44civi_9xzwf.civicrm_custom_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_custom_field.custom_group_id FK_civicrm_custom_field_custom_group_id C
Unique Custom Group ID
name varchar 64  √  null Variable name/programmatic handle for this group.
title varchar 64 Friendly Name.
extends varchar 255  √  Contact Type of object this group extends (can add other options later e.g. contact_address, etc.).
extends_entity_column_id int unsigned 10  √  null FK to civicrm_option_value.id (for option group custom_data_type.)
extends_entity_column_value varchar 255  √  null linking custom group for dynamic object
style enum 6  √  null Visual relationship between this form and its parent.
collapse_display int unsigned 10  √  0 Will this group be in collapsed or expanded mode on initial display ?
help_pre text 65535  √  null Description and/or help text to display before fields in form.
help_post text 65535  √  null Description and/or help text to display after fields in form.
weight int 10 1 Controls display order when multiple extended property groups are setup for the same class.
is_active tinyint 3  √  null Is this property active?
table_name varchar 255  √  null Name of the table that holds the values for this group.
is_multiple tinyint 3  √  null Does this group hold multiple values?
min_multiple int unsigned 10  √  null minimum number of multiple records (typically 0?)
max_multiple int unsigned 10  √  null maximum number of multiple records, if 0 - no max
collapse_adv_display int unsigned 10  √  0 Will this group be in collapsed or expanded mode on advanced search display ?
created_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_custom_group_created_id N
FK to civicrm_contact, who created this custom group
created_date datetime 19  √  null Date and time this custom group was created.
is_reserved tinyint 3  √  0 Is this a reserved Custom Group?

Table contained 3 rows at Wed Nov 11 17:14 EST 2015

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
created_id Performance Asc FK_civicrm_custom_group_created_id  
name + extends Must be unique Asc/Asc UI_name_extends These unique columns are also nullable
title + extends Must be unique Asc/Asc UI_title_extends  

Close relationships  within of separation: