Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
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.

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 (for option group custom_data_type.)

extends_entity_column_value VARCHAR 255 null

linking custom group for dynamic object

style VARCHAR 15 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 ?

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 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?

title_en_US VARCHAR 64 null
help_pre_en_US TEXT 65535 null
help_post_en_US TEXT 65535 null
title_fr_CA VARCHAR 64 null
help_pre_fr_CA TEXT 65535 null
help_post_fr_CA TEXT 65535 null
is_public BIT 0 1

Is this property public?

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_custom_group_created_id Performance Asc created_id
UI_name_extends Must be unique Asc/Asc name + extends
UI_title_extends_en_US Must be unique Asc/Asc title_en_US + extends
UI_title_extends_fr_CA Must be unique Asc/Asc title_fr_CA + extends