| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
Unique Custom Field ID |
||
| custom_group_id | INT UNSIGNED | 10 | null |
|
|
FK to civicrm_custom_group. |
||
| name | VARCHAR | 64 | √ | null |
|
|
Variable name/programmatic handle for this group. |
|
| data_type | VARCHAR | 16 | null |
|
|
Controls location of data storage in extended_data table. |
||
| html_type | VARCHAR | 32 | null |
|
|
HTML types plus several built-in extended types. |
||
| default_value | VARCHAR | 255 | √ | null |
|
|
Use form_options.is_default for field_types which use options. |
|
| is_required | TINYINT | 3 | √ | 0 |
|
|
Is a value required for this property. |
|
| is_searchable | TINYINT | 3 | √ | 0 |
|
|
Is this property searchable. |
|
| is_search_range | TINYINT | 3 | √ | 0 |
|
|
Is this property range searchable. |
|
| weight | INT | 10 | 1 |
|
|
Controls field display order within an extended property group. |
||
| mask | VARCHAR | 64 | √ | null |
|
|
Optional format instructions for specific field types, like date types. |
|
| attributes | VARCHAR | 255 | √ | null |
|
|
Store collection of type-appropriate attributes, e.g. textarea needs rows/cols attributes |
|
| javascript | VARCHAR | 255 | √ | null |
|
|
Optional scripting attributes for field. |
|
| is_active | TINYINT | 3 | √ | 1 |
|
|
Is this property active? |
|
| is_view | TINYINT | 3 | √ | 0 |
|
|
Is this property set by PHP Code? A code field is viewable but not editable |
|
| options_per_line | INT UNSIGNED | 10 | √ | null |
|
|
number of options per line for checkbox and radio |
|
| text_length | INT UNSIGNED | 10 | √ | null |
|
|
field length if alphanumeric |
|
| start_date_years | INT | 10 | √ | null |
|
|
Date may be up to start_date_years years prior to the current date. |
|
| end_date_years | INT | 10 | √ | null |
|
|
Date may be up to end_date_years years after the current date. |
|
| date_format | VARCHAR | 64 | √ | null |
|
|
date format for custom date |
|
| time_format | INT UNSIGNED | 10 | √ | null |
|
|
time format for custom date |
|
| note_columns | INT UNSIGNED | 10 | √ | null |
|
|
Number of columns in Note Field |
|
| note_rows | INT UNSIGNED | 10 | √ | null |
|
|
Number of rows in Note Field |
|
| column_name | VARCHAR | 255 | √ | null |
|
|
Name of the column that holds the values for this field. |
|
| option_group_id | INT UNSIGNED | 10 | √ | null |
|
|
For elements with options, the option group id that is used |
|
| filter | VARCHAR | 255 | √ | null |
|
|
Stores Contact Get API params contact reference custom fields. May be used for other filters in the future. |
|
| in_selector | TINYINT | 3 | √ | 0 |
|
|
Should the multi-record custom field values be displayed in tab table listing |
|
| label | VARCHAR | 255 | √ | null |
|
|
||
| help_pre | TEXT | 65535 | √ | null |
|
|
||
| help_post | TEXT | 65535 | √ | null |
|
|
select `civicrm`.`civicrm_custom_field`.`id` AS `id`,`civicrm`.`civicrm_custom_field`.`custom_group_id` AS `custom_group_id`,`civicrm`.`civicrm_custom_field`.`name` AS `name`,`civicrm`.`civicrm_custom_field`.`data_type` AS `data_type`,`civicrm`.`civicrm_custom_field`.`html_type` AS `html_type`,`civicrm`.`civicrm_custom_field`.`default_value` AS `default_value`,`civicrm`.`civicrm_custom_field`.`is_required` AS `is_required`,`civicrm`.`civicrm_custom_field`.`is_searchable` AS `is_searchable`,`civicrm`.`civicrm_custom_field`.`is_search_range` AS `is_search_range`,`civicrm`.`civicrm_custom_field`.`weight` AS `weight`,`civicrm`.`civicrm_custom_field`.`mask` AS `mask`,`civicrm`.`civicrm_custom_field`.`attributes` AS `attributes`,`civicrm`.`civicrm_custom_field`.`javascript` AS `javascript`,`civicrm`.`civicrm_custom_field`.`is_active` AS `is_active`,`civicrm`.`civicrm_custom_field`.`is_view` AS `is_view`,`civicrm`.`civicrm_custom_field`.`options_per_line` AS `options_per_line`,`civicrm`.`civicrm_custom_field`.`text_length` AS `text_length`,`civicrm`.`civicrm_custom_field`.`start_date_years` AS `start_date_years`,`civicrm`.`civicrm_custom_field`.`end_date_years` AS `end_date_years`,`civicrm`.`civicrm_custom_field`.`date_format` AS `date_format`,`civicrm`.`civicrm_custom_field`.`time_format` AS `time_format`,`civicrm`.`civicrm_custom_field`.`note_columns` AS `note_columns`,`civicrm`.`civicrm_custom_field`.`note_rows` AS `note_rows`,`civicrm`.`civicrm_custom_field`.`column_name` AS `column_name`,`civicrm`.`civicrm_custom_field`.`option_group_id` AS `option_group_id`,`civicrm`.`civicrm_custom_field`.`filter` AS `filter`,`civicrm`.`civicrm_custom_field`.`in_selector` AS `in_selector`,`civicrm`.`civicrm_custom_field`.`label_en_US` AS `label`,`civicrm`.`civicrm_custom_field`.`help_pre_en_US` AS `help_pre`,`civicrm`.`civicrm_custom_field`.`help_post_en_US` AS `help_post` from `civicrm`.`civicrm_custom_field`