1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>OptionValue
</class>
6 <name>civicrm_option_value
</name>
11 <type>int unsigned
</type>
12 <required>true
</required>
13 <comment>Option ID
</comment>
18 <autoincrement>true
</autoincrement>
21 <name>option_group_id
</name>
22 <type>int unsigned
</type>
23 <required>true
</required>
24 <comment>Group which this option belongs to.
</comment>
28 <name>option_group_id
</name>
29 <table>civicrm_option_group
</table>
32 <onDelete>CASCADE
</onDelete>
36 <title>Option Label
</title>
38 <required>true
</required>
40 <localizable>true
</localizable>
41 <comment>Option string as displayed to users - e.g. the label in an HTML OPTION tag.
</comment>
46 <title>Option Value
</title>
49 <required>true
</required>
50 <comment>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.
</comment>
56 <title>Option Name
</title>
60 <comment>Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.
</comment>
65 <title>Option Grouping Name
</title>
68 <comment>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.
</comment>
73 <type>int unsigned
</type>
74 <comment>Bitwise logic can be used to create subsets of options within an option_group for different uses.
</comment>
78 <name>is_default
</name>
81 <comment>Is this the default option for the group?
</comment>
86 <type>int unsigned
</type>
87 <required>true
</required>
88 <comment>Controls display sort order.
</comment>
92 <name>description
</name>
94 <htmlType>textarea
</htmlType>
97 <localizable>true
</localizable>
98 <comment>Optional description.
</comment>
102 <name>is_optgroup
</name>
105 <comment>Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?
</comment>
109 <name>is_reserved
</name>
112 <comment>Is this a predefined system object?
</comment>
116 <name>is_active
</name>
119 <comment>Is this option active?
</comment>
123 <name>component_id
</name>
124 <type>int unsigned
</type>
125 <comment>Component that this option value belongs/caters to.
</comment>
129 <name>component_id
</name>
130 <table>civicrm_component
</table>
135 <name>domain_id
</name>
136 <type>int unsigned
</type>
137 <comment>Which Domain is this option value for
</comment>
141 <name>domain_id
</name>
142 <table>civicrm_domain
</table>
147 <name>visibility_id
</name>
148 <type>int unsigned
</type>
149 <default>NULL
</default>
153 <name>index_option_group_id_value
</name>
154 <fieldName>value
</fieldName>
155 <fieldName>option_group_id
</fieldName>
159 <name>index_option_group_id_name
</name>
160 <fieldName>option_group_id
</fieldName>
161 <fieldName>name
</fieldName>