civicrm_option_value_en_US - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

Option ID

option_group_id

INT UNSIGNED

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

√

null

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

is_default

TINYINT

√

Is this the default option for the group?

weight

INT UNSIGNED

null

Controls display sort order.

is_optgroup

TINYINT

√

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

√

Is this a predefined system object?

is_active

TINYINT

√

Is this option active?

component_id

INT UNSIGNED

√

null

Component that this option value belongs/caters to.

domain_id

INT UNSIGNED

√

null

Which Domain is this option value for

visibility_id

INT UNSIGNED

√

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

Showing 1 to 18 of 18 entries

View Definition

select `civicrm`.`civicrm_option_value`.`id` AS `id`,`civicrm`.`civicrm_option_value`.`option_group_id` AS `option_group_id`,`civicrm`.`civicrm_option_value`.`value` AS `value`,`civicrm`.`civicrm_option_value`.`name` AS `name`,`civicrm`.`civicrm_option_value`.`grouping` AS `grouping`,`civicrm`.`civicrm_option_value`.`filter` AS `filter`,`civicrm`.`civicrm_option_value`.`is_default` AS `is_default`,`civicrm`.`civicrm_option_value`.`weight` AS `weight`,`civicrm`.`civicrm_option_value`.`is_optgroup` AS `is_optgroup`,`civicrm`.`civicrm_option_value`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_option_value`.`is_active` AS `is_active`,`civicrm`.`civicrm_option_value`.`component_id` AS `component_id`,`civicrm`.`civicrm_option_value`.`domain_id` AS `domain_id`,`civicrm`.`civicrm_option_value`.`visibility_id` AS `visibility_id`,`civicrm`.`civicrm_option_value`.`icon` AS `icon`,`civicrm`.`civicrm_option_value`.`color` AS `color`,`civicrm`.`civicrm_option_value`.`label_en_US` AS `label`,`civicrm`.`civicrm_option_value`.`description_en_US` AS `description` from `civicrm`.`civicrm_option_value`

 
select `civicrm`.`civicrm_option_value`.`id` AS `id`,`civicrm`.`civicrm_option_value`.`option_group_id` AS `option_group_id`,`civicrm`.`civicrm_option_value`.`value` AS `value`,`civicrm`.`civicrm_option_value`.`name` AS `name`,`civicrm`.`civicrm_option_value`.`grouping` AS `grouping`,`civicrm`.`civicrm_option_value`.`filter` AS `filter`,`civicrm`.`civicrm_option_value`.`is_default` AS `is_default`,`civicrm`.`civicrm_option_value`.`weight` AS `weight`,`civicrm`.`civicrm_option_value`.`is_optgroup` AS `is_optgroup`,`civicrm`.`civicrm_option_value`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_option_value`.`is_active` AS `is_active`,`civicrm`.`civicrm_option_value`.`component_id` AS `component_id`,`civicrm`.`civicrm_option_value`.`domain_id` AS `domain_id`,`civicrm`.`civicrm_option_value`.`visibility_id` AS `visibility_id`,`civicrm`.`civicrm_option_value`.`icon` AS `icon`,`civicrm`.`civicrm_option_value`.`color` AS `color`,`civicrm`.`civicrm_option_value`.`label_en_US` AS `label`,`civicrm`.`civicrm_option_value`.`description_en_US` AS `description` from `civicrm`.`civicrm_option_value`

Possibly Referenced Tables/Views

civicrm_option_value