Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| 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. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| UI_name | Must be unique | Asc | name |
Relationships
Close relationships within degrees of separation
