Table d47civi_0z3xa.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
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 The weight threshold the sum of the rule weights has to cross to consider two contacts the same
used varchar 12 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 mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: