Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_option_value.option_group_id FK_civicrm_option_value_option_group_id C

Option Group ID

name VARCHAR 64 null

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

is_reserved TINYINT 3 1

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

is_active TINYINT 3 null

Is this option group active?

is_locked TINYINT 3 null

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

title_en_US VARCHAR 255 null
description_en_US VARCHAR 255 null
title_fr_CA VARCHAR 255 null
description_fr_CA VARCHAR 255 null
data_type VARCHAR 128 null

Data Type of Option Group.

Table contained 93 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UI_name Must be unique Asc name