civicrm_domain

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_dashboard.domain_id FK_civicrm_dashboard_domain_idC
civicrm_job.domain_id FK_civicrm_job_domain_idR
civicrm_job_log.domain_id FK_civicrm_job_log_domain_idR
civicrm_mail_settings.domain_id FK_civicrm_mail_settings_domain_idR
civicrm_mailing.domain_id FK_civicrm_mailing_domain_idN
civicrm_membership_type.domain_id FK_civicrm_membership_type_domain_idR
civicrm_menu.domain_id FK_civicrm_menu_domain_idR
civicrm_navigation.domain_id FK_civicrm_navigation_domain_idR
civicrm_option_value.domain_id FK_civicrm_option_value_domain_idR
civicrm_payment_processor.domain_id FK_civicrm_payment_processor_domain_idR
civicrm_price_set.domain_id FK_civicrm_price_set_domain_idR
civicrm_report_instance.domain_id FK_civicrm_report_instance_domain_idR
civicrm_setting.domain_id FK_civicrm_setting_domain_idC
civicrm_sms_provider.domain_id FK_civicrm_sms_provider_domain_idN
civicrm_status_pref.domain_id FK_civicrm_status_pref_domain_idR
civicrm_uf_match.domain_id FK_civicrm_uf_match_domain_idR
civicrm_word_replacement.domain_id FK_civicrm_word_replacement_domain_idR

Domain ID
name VARCHAR 64 √ null

Name of Domain / Organization
description VARCHAR 255 √ null

Description of Domain.
version VARCHAR 32 √ null

The civicrm version this instance is running
contact_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_domain_contact_idR

FK to Contact ID. This is specifically not an FK to avoid circular constraints
locales TEXT 65535 √ null

list of locales supported by the current db state (NULL for single-lang install)
locale_custom_strings TEXT 65535 √ null

Locale specific string overrides

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_domain_contact_id Performance Asc contact_id
UI_name Must be unique Asc name

Relationships

Close relationships within degrees of separation