Table d45civi_b72v5.civicrm_relationship_type 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_mapping_field.relationship_type_id FK_civicrm_mapping_field_relationship_type_id R
civicrm_relationship.relationship_type_id FK_civicrm_relationship_relationship_type_id C
Primary key
name_a_b varchar 64  √  null name for relationship of contact_a to contact_b.
label_a_b varchar 64  √  null label for relationship of contact_a to contact_b.
name_b_a varchar 64  √  null Optional name for relationship of contact_b to contact_a.
label_b_a varchar 64  √  null Optional label for relationship of contact_b to contact_a.
description varchar 255  √  null Optional verbose description of the relationship type.
contact_type_a varchar 12  √  null If defined, contact_a in a relationship of this type must be a specific contact_type.
contact_type_b varchar 12  √  null If defined, contact_b in a relationship of this type must be a specific contact_type.
contact_sub_type_a varchar 64  √  null If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.
contact_sub_type_b varchar 64  √  null If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.
is_reserved tinyint 3  √  null Is this relationship type a predefined system type (can not be changed or de-activated)?
is_active tinyint 3  √  1 Is this relationship type currently active (i.e. can be used when creating or editing relationships)?

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
name_a_b Must be unique Asc UI_name_a_b This unique column is also nullable
name_b_a Must be unique Asc UI_name_b_a This unique column is also nullable

Close relationships  within of separation: