| id |
INT UNSIGNED |
10 |
|
√ |
null |
|
|
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 |
|
|
1 |
|
|
Is this option group active? |
| is_locked |
TINYINT |
3 |
|
|
0 |
|
|
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. |
