/**
* returns all the column names of this table
*
* @access public
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'required' => true), 'option_group_id' => array('name' => 'option_group_id', 'type' => CRM_Utils_Type::T_INT, 'required' => true, 'FKClassName' => 'CRM_Core_DAO_OptionGroup'), 'label' => array('name' => 'label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Label'), 'required' => true, 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'value' => array('name' => 'value', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Value'), 'required' => true, 'maxlength' => 512, 'size' => CRM_Utils_Type::HUGE), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Name'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_option_value.name', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'grouping' => array('name' => 'grouping', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Grouping Name'), 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'filter' => array('name' => 'filter', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Filter')), 'is_default' => array('name' => 'is_default', 'type' => CRM_Utils_Type::T_BOOLEAN), 'weight' => array('name' => 'weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Weight'), 'required' => true), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Description'), 'rows' => 8, 'cols' => 60), 'is_optgroup' => array('name' => 'is_optgroup', 'type' => CRM_Utils_Type::T_BOOLEAN), 'is_reserved' => array('name' => 'is_reserved', 'type' => CRM_Utils_Type::T_BOOLEAN), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'default' => ''), 'component_id' => array('name' => 'component_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_Component'), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'FKClassName' => 'CRM_Core_DAO_Domain'), 'visibility_id' => array('name' => 'visibility_id', 'type' => CRM_Utils_Type::T_INT, 'default' => 'UL'));
}
return self::$_fields;
}
/**
* Returns all the column names of this table
*
* @return array
*/
static function &fields()
{
if (!self::$_fields) {
self::$_fields = array('id' => array('name' => 'id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Option Value ID'), 'description' => 'Option ID', 'required' => true), 'option_group_id' => array('name' => 'option_group_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Option Group ID'), 'description' => 'Group which this option belongs to.', 'required' => true, 'FKClassName' => 'CRM_Core_DAO_OptionGroup', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_option_group', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'label' => array('name' => 'label', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Label'), 'description' => 'Option string as displayed to users - e.g. the label in an HTML OPTION tag.', 'required' => true, 'maxlength' => 512, 'size' => CRM_Utils_Type::HUGE), 'value' => array('name' => 'value', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Value'), 'description' => '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.', 'required' => true, 'maxlength' => 512, 'size' => CRM_Utils_Type::HUGE), 'name' => array('name' => 'name', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Name'), 'description' => 'Stores a fixed (non-translated) name for this option value. Lookup functions should use the name as the key for the option value row.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE, 'import' => true, 'where' => 'civicrm_option_value.name', 'headerPattern' => '', 'dataPattern' => '', 'export' => true), 'grouping' => array('name' => 'grouping', 'type' => CRM_Utils_Type::T_STRING, 'title' => ts('Option Grouping Name'), 'description' => '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.', 'maxlength' => 255, 'size' => CRM_Utils_Type::HUGE), 'filter' => array('name' => 'filter', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Filter'), 'description' => 'Bitwise logic can be used to create subsets of options within an option_group for different uses.'), 'is_default' => array('name' => 'is_default', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Option is Default?'), 'description' => 'Is this the default option for the group?'), 'weight' => array('name' => 'weight', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Order'), 'description' => 'Controls display sort order.', 'required' => true), 'description' => array('name' => 'description', 'type' => CRM_Utils_Type::T_TEXT, 'title' => ts('Option Description'), 'description' => 'Optional description.', 'rows' => 8, 'cols' => 60, 'html' => array('type' => 'TextArea')), 'is_optgroup' => array('name' => 'is_optgroup', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Option is Header?'), 'description' => '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' => array('name' => 'is_reserved', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Option Is Reserved?'), 'description' => 'Is this a predefined system object?'), 'is_active' => array('name' => 'is_active', 'type' => CRM_Utils_Type::T_BOOLEAN, 'title' => ts('Option Is Active'), 'description' => 'Is this option active?', 'default' => '1'), 'component_id' => array('name' => 'component_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Option Component'), 'description' => 'Component that this option value belongs/caters to.', 'FKClassName' => 'CRM_Core_DAO_Component', 'html' => array('type' => 'Select'), 'pseudoconstant' => array('table' => 'civicrm_component', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'domain_id' => array('name' => 'domain_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Option Domain'), 'description' => 'Which Domain is this option value for', 'FKClassName' => 'CRM_Core_DAO_Domain', 'pseudoconstant' => array('table' => 'civicrm_domain', 'keyColumn' => 'id', 'labelColumn' => 'name')), 'visibility_id' => array('name' => 'visibility_id', 'type' => CRM_Utils_Type::T_INT, 'title' => ts('Option Visibility'), 'default' => 'NULL'));
}
return self::$_fields;
}
