civicrm_dedupe_rule

18 rows


Columns

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
civicrm_dedupe_rule_group.id 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

Indexes

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

Relationships