Table d47civi_0z3xa.civicrm_option_group Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_option_value.option_group_id FK_civicrm_option_value_option_group_id C
Option Group ID
name varchar 64 Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.
title varchar 255  √  null Option Group title.
description varchar 255  √  null Option group description.
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.

Table contained 98 rows at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: