Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
name VARCHAR 255 null

Unique name for setting

value TEXT 65535 null

data associated with this group / name combo

domain_id INT UNSIGNED 10 null FK_civicrm_setting_domain_id C

Which Domain is this menu item for

contact_id INT UNSIGNED 10 null 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 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 FK_civicrm_setting_created_id N

FK to civicrm_contact, who created this setting

Table contained 150 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_setting_component_id Performance Asc component_id
FK_civicrm_setting_contact_id Performance Asc contact_id
FK_civicrm_setting_created_id Performance Asc created_id
FK_civicrm_setting_domain_id Performance Asc domain_id
index_domain_contact_name Must be unique Asc/Asc/Asc domain_id + contact_id + name