Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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 civicrm_option_value.id (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 | √ | 1 |
|
|
Is this property active? |
|||
| table_name | VARCHAR | 255 | √ | null |
|
|
Name of the table that holds the values for this group. |
|||
| is_multiple | TINYINT | 3 | √ | 0 |
|
|
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 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? |
Indexes
| 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 |
Relationships
Close relationships within degrees of separation
