Table d45civi_b72v5.civicrm_relationship 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_activity.relationship_id FK_civicrm_activity_relationship_id N
Relationship ID
contact_id_a int unsigned 10
civicrm_contact.id FK_civicrm_relationship_contact_id_a C
id of the first contact
contact_id_b int unsigned 10
civicrm_contact.id FK_civicrm_relationship_contact_id_b C
id of the second contact
relationship_type_id int unsigned 10
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 215 rows at Wed Nov 11 17:12 EST 2015

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

Close relationships  within of separation: