civicrm_uf_match


Columns

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

System generated ID.

domain_id INT UNSIGNED 10 null
civicrm_domain.id FK_civicrm_uf_match_domain_id R

Which Domain is this match entry for

uf_id INT UNSIGNED 10 null

UF ID

uf_name VARCHAR 128 null

UF Name

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_uf_match_contact_id C

FK to Contact ID

language VARCHAR 5 null

UI language preferred by the given user/contact

Table contained 3 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_uf_match_domain_id Performance Asc domain_id
I_civicrm_uf_match_uf_id Performance Asc uf_id
UI_contact_domain_id Must be unique Asc/Asc contact_id + domain_id
UI_uf_name_domain_id Must be unique Asc/Asc uf_name + domain_id

Relationships