Table d47civi_0z3xa.civicrm_option_value 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  √  Option ID
option_group_id int unsigned 10 FK_civicrm_option_value_option_group_id C
Group which this option belongs to.
label varchar 512 Option string as displayed to users - e.g. the label in an HTML OPTION tag.
value varchar 512 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 Controls display sort order.
description text 65535  √  null Optional description.
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 FK_civicrm_option_value_component_id R
Component that this option value belongs/caters to.
domain_id int unsigned 10  √  null FK_civicrm_option_value_domain_id R
Which Domain is this option value for
visibility_id int unsigned 10  √  null

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

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
component_id Performance Asc FK_civicrm_option_value_component_id
domain_id Performance Asc FK_civicrm_option_value_domain_id
option_group_id Performance Asc FK_civicrm_option_value_option_group_id
name + option_group_id Performance Asc/Asc index_option_group_id_name
value + option_group_id Performance Asc/Asc index_option_group_id_value

Close relationships  within of separation: