civicrm_relationship_type

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_mapping_field.relationship_type_id FK_civicrm_mapping_field_relationship_type_idR
civicrm_relationship.relationship_type_id FK_civicrm_relationship_relationship_type_idC

Primary key
name_a_b VARCHAR 64 √ null

name for relationship of contact_a to contact_b.
name_b_a VARCHAR 64 √ null

Optional name for relationship of contact_b to contact_a.
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)?
label_a_b_en_US VARCHAR 64 √ null
label_b_a_en_US VARCHAR 64 √ null
description_en_US VARCHAR 255 √ null
label_a_b_fr_CA VARCHAR 64 √ null
label_b_a_fr_CA VARCHAR 64 √ null
description_fr_CA VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UI_name_a_b Must be unique Asc name_a_b
UI_name_b_a Must be unique Asc name_b_a

Relationships

Close relationships within degrees of separation