Table d44civi_9xzwf.civicrm_setting 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  √ 
group_name varchar 64 group name for setting element, useful in caching setting elements
name varchar 255  √  null Unique name for setting
value text 65535  √  null data associated with this group / name combo
domain_id int unsigned 10
civicrm_domain.id FK_civicrm_setting_domain_id C
Which Domain is this menu item for
contact_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_setting_contact_id C
FK to Contact ID if the setting is localized to a contact
is_domain tinyint 3  √  null Is this setting a contact specific or site wide setting?
component_id int unsigned 10  √  null
civicrm_component.id FK_civicrm_setting_component_id R
Component that this menu item belongs to
created_date datetime 19  √  null When was the setting created
created_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_setting_created_id N
FK to civicrm_contact, who created this setting

Table contained 60 rows at Wed Nov 11 17:14 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
component_id Performance Asc FK_civicrm_setting_component_id
contact_id Performance Asc FK_civicrm_setting_contact_id
created_id Performance Asc FK_civicrm_setting_created_id
domain_id Performance Asc FK_civicrm_setting_domain_id
group_name + name Performance Asc/Asc index_group_name

Close relationships  within of separation: