civicrm_relationship

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_activity.relationship_id FK_civicrm_activity_relationship_idN

Relationship ID
contact_id_a INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_relationship_contact_id_aC

id of the first contact
contact_id_b INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_relationship_contact_id_bC

id of the second contact
relationship_type_id INT UNSIGNED 10 null
civicrm_relationship_type.id FK_civicrm_relationship_relationship_type_idC

id of the relationship
start_date DATE 10 √ null

date when the relationship started
end_date DATE 10 √ null

date when the relationship ended
is_active TINYINT 3 √ 1

is the relationship active ?
description VARCHAR 255 √ null

Optional verbose description for the relationship.
is_permission_a_b TINYINT 3 √ 0

is contact a has permission to view / edit contact and
related data for contact b ?
is_permission_b_a TINYINT 3 √ 0

is contact b has permission to view / edit contact and
related data for contact a ?
case_id INT UNSIGNED 10 √ null
civicrm_case.id FK_civicrm_relationship_case_idC

FK to civicrm_case

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_relationship_case_id Performance Asc case_id
FK_civicrm_relationship_contact_id_a Performance Asc contact_id_a
FK_civicrm_relationship_contact_id_b Performance Asc contact_id_b
FK_civicrm_relationship_relationship_type_id Performance Asc relationship_type_id

Relationships

Close relationships within degrees of separation