Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | 0 |
|
|
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. |
||
| data_type | VARCHAR | 128 | √ | null |
|
|
Data Type of Option Group. |
|
| title | VARCHAR | 255 | √ | null |
|
|
||
| description | VARCHAR | 255 | √ | null |
|
|