Table d47civi_0z3xa.civicrm_custom_field Generated by
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  √  Unique Custom Field ID
custom_group_id int unsigned 10 FK_civicrm_custom_field_custom_group_id C
FK to civicrm_custom_group.
name varchar 64  √  null Variable name/programmatic handle for this group.
label varchar 255 Text for form field label (also friendly name for administering this custom property).
data_type varchar 16 Controls location of data storage in extended_data table.
html_type varchar 32 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  √  null Is a value required for this property.
is_searchable tinyint 3  √  null 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.
help_pre text 65535  √  null Description and/or help text to display before this field.
help_post text 65535  √  null Description and/or help text to display after this field.
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  √  null Is this property active?
is_view tinyint 3  √  null 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

Table contained 12 rows at mer. avr. 13 16:52 EDT 2016

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
custom_group_id Performance Asc FK_civicrm_custom_field_custom_group_id
label + custom_group_id Must be unique Asc/Asc UI_label_custom_group_id
name + custom_group_id Must be unique Asc/Asc UI_name_custom_group_id

Close relationships  within of separation: