civicrm_custom_field_en_US

0 rows


Columns

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

View Definition


Possibly Referenced Tables/Views