8 rows


Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_dedupe_rule.dedupe_rule_group_id FK_civicrm_dedupe_rule_dedupe_rule_group_idR
civicrm_event.dedupe_rule_group_id FK_civicrm_event_dedupe_rule_group_idR

Unique dedupe rule group id

contact_type VARCHAR 12 null

The type of contacts this group applies to

threshold INT 10 null

The weight threshold the sum of the rule weights has to cross to consider two contacts the same

used VARCHAR 12 null

Whether the rule should be used for cases where usage is Unsupervised, Supervised OR General(programatically)

name VARCHAR 64 null

Name of the rule group

title VARCHAR 255 null

Label of the rule group

is_reserved TINYINT 3 null

Is this a reserved rule - a rule group that has been optimized and cannot be changed by the admin


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id