civicrm_dedupe_exception

0 rows


Columns

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

Unique dedupe exception id
contact_id1 INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_dedupe_exception_contact_id1C

FK to Contact ID
contact_id2 INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_dedupe_exception_contact_id2C

FK to Contact ID

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_dedupe_exception_contact_id2 Performance Asc contact_id2
UI_contact_id1_contact_id2 Must be unique Asc/Asc contact_id1 + contact_id2

Relationships

Close relationships within degrees of separation