civicrm_domain


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_dashboard.domain_id FK_civicrm_dashboard_domain_id R
civicrm_job.domain_id FK_civicrm_job_domain_id R
civicrm_job_log.domain_id FK_civicrm_job_log_domain_id R
civicrm_mail_settings.domain_id FK_civicrm_mail_settings_domain_id R
civicrm_mailing.domain_id FK_civicrm_mailing_domain_id N
civicrm_membership_type.domain_id FK_civicrm_membership_type_domain_id R
civicrm_menu.domain_id FK_civicrm_menu_domain_id R
civicrm_navigation.domain_id FK_civicrm_navigation_domain_id R
civicrm_option_value.domain_id FK_civicrm_option_value_domain_id R
civicrm_payment_processor.domain_id FK_civicrm_payment_processor_domain_id R
civicrm_price_set.domain_id FK_civicrm_price_set_domain_id R
civicrm_report_instance.domain_id FK_civicrm_report_instance_domain_id R
civicrm_setting.domain_id FK_civicrm_setting_domain_id C
civicrm_sms_provider.domain_id FK_civicrm_sms_provider_domain_id N
civicrm_status_pref.domain_id FK_civicrm_status_pref_domain_id R
civicrm_uf_match.domain_id FK_civicrm_uf_match_domain_id R
civicrm_word_replacement.domain_id FK_civicrm_word_replacement_domain_id R

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_id R

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

Table contained 0 rows

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