civicrm_dedupe_rule_group


Columns

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_id R
civicrm_event.dedupe_rule_group_id FK_civicrm_event_dedupe_rule_group_id R

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

Table contained 7 rows

Indexes

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

Relationships