civicrm_setting


Columns

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
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 150 rows

Indexes

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

Relationships