Table d47civi_0z3xa.civicrm_word_replacement Generated by
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  √  Word replacement ID
find_word varchar 255  √  null Word which need to be replaced
replace_word varchar 255  √  null Word which will replace the word in find
is_active tinyint 3  √  1 Is this entry active?
match_type varchar 16  √  wildcardMatch
domain_id int unsigned 10  √  null FK_civicrm_word_replacement_domain_id R
FK to Domain ID. This is for Domain specific word replacement

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
domain_id + find_word Must be unique Asc/Asc UI_domain_find These unique columns are also nullable

Close relationships  within of separation: