Table d47civi_0z3xa.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  √ 
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 12 rows at mer. avr. 13 16:52 EDT 2016

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 + contact_id + name Must be unique Asc/Asc/Asc index_domain_contact_name

Close relationships  within of separation: