Table d44civi_9xzwf.civicrm_dedupe_rule_group Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_dedupe_rule.dedupe_rule_group_id FK_civicrm_dedupe_rule_dedupe_rule_group_id R
Unique dedupe rule group id
contact_type enum 12  √  null The type of contacts this group applies to
threshold int 10 The weight threshold the sum of the rule weights has to cross to consider two contacts the same
used enum 13 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 at Wed Nov 11 17:14 EST 2015

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

Close relationships: