Table d45civi_b72v5.civicrm_dedupe_rule 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  √  Unique dedupe rule id
dedupe_rule_group_id int unsigned 10
civicrm_dedupe_rule_group.id FK_civicrm_dedupe_rule_dedupe_rule_group_id R
The id of the rule group this rule belongs to
rule_table varchar 64 The name of the table this rule is about
rule_field varchar 64 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 The weight of the rule

Table contained 17 rows at Wed Nov 11 17:12 EST 2015

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

Close relationships  within of separation: