18 rows


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

Unique dedupe rule id

dedupe_rule_group_id INT UNSIGNED 10 null FK_civicrm_dedupe_rule_dedupe_rule_group_idR

The id of the rule group this rule belongs to

rule_table VARCHAR 64 null

The name of the table this rule is about

rule_field VARCHAR 64 null

The name of the field of the table referenced in rule_table

rule_length INT UNSIGNED 10 null

The lenght of the matching substring

rule_weight INT 10 null

The weight of the rule


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