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