Column Type Size Nulls Auto Default Children Parents Comments

Option ID

option_group_id INT UNSIGNED 10 null

Group which this option belongs to.

value VARCHAR 512 null

The actual value stored (as a foreign key) in the data record. Functions which need lookup option_value.title should use civicrm_option_value.option_group_id plus civicrm_option_value.value as the key.

name VARCHAR 255 null

Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.

grouping VARCHAR 255 null

Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.

filter INT UNSIGNED 10 null

Bitwise logic can be used to create subsets of options within an option_group for different uses.

is_default TINYINT 3 0

Is this the default option for the group?

weight INT UNSIGNED 10 null

Controls display sort order.

is_optgroup TINYINT 3 0

Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?

is_reserved TINYINT 3 0

Is this a predefined system object?

is_active TINYINT 3 1

Is this option active?

component_id INT UNSIGNED 10 null

Component that this option value belongs/caters to.

domain_id INT UNSIGNED 10 null

Which Domain is this option value for

visibility_id INT UNSIGNED 10 null
icon VARCHAR 255 null

crm-i icon class

color VARCHAR 255 null

Hex color value e.g. #ffffff

label VARCHAR 512 null
description TEXT 65535 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views