civicrm_option_group_en_US - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

Option Group ID

name

VARCHAR

null

Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.

is_reserved

TINYINT

Is this a predefined system option group (i.e. it can not be deleted)?

is_active

TINYINT

Is this option group active?

is_locked

TINYINT

A lock to remove the ability to add new options via the UI.

data_type

VARCHAR

128

√

null

Data Type of Option Group.

title

VARCHAR

255

√

null

description

VARCHAR

255

√

null

Showing 1 to 8 of 8 entries

View Definition

 
select `civicrm`.`civicrm_option_group`.`id` AS `id`,`civicrm`.`civicrm_option_group`.`name` AS `name`,`civicrm`.`civicrm_option_group`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_option_group`.`is_active` AS `is_active`,`civicrm`.`civicrm_option_group`.`is_locked` AS `is_locked`,`civicrm`.`civicrm_option_group`.`data_type` AS `data_type`,`civicrm`.`civicrm_option_group`.`title_en_US` AS `title`,`civicrm`.`civicrm_option_group`.`description_en_US` AS `description` from `civicrm`.`civicrm_option_group`

Possibly Referenced Tables/Views

civicrm_option_group