civicrm_relationship


Columns

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

Relationship ID

contact_id_a INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_relationship_contact_id_a C

id of the first contact

contact_id_b INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_relationship_contact_id_b C

id of the second contact

relationship_type_id INT UNSIGNED 10 null
civicrm_relationship_type.id FK_civicrm_relationship_relationship_type_id C

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_id C

FK to civicrm_case

Table contained 0 rows

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