Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
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? |
|
| is_public | BIT | 0 | √ | 1 |
|
|
Is this property public? |
|
| title | VARCHAR | 64 | √ | null |
|
|
||
| help_pre | TEXT | 65535 | √ | null |
|
|
||
| help_post | TEXT | 65535 | √ | null |
|
|