Table d45civi_b72v5.civicrm_domain 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  √ 
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_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.
config_backend text 65535  √  null Backend configuration.
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 at Wed Nov 11 17:12 EST 2015

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
contact_id Performance Asc FK_civicrm_domain_contact_id  
name Must be unique Asc UI_name This unique column is also nullable

Close relationships  within of separation: