crm_contact_relationships
Emergency and trusted contacts: one row per relationship from a contact (usually a guest) to the contact they have nominated, for every contact in the client’s CRM namespaces. Join source_contact_information_id and target_contact_information_id to crm_contact_informations.id; an id does not resolve when that contact is not served there (crm_contact_informations serves contacts on the client’s leads and bookings and their related contacts).
| Column | Description |
|---|---|
id |
Unique identifier for the relationship |
source_contact_information_id |
Identifier of the contact who has the relationship (e.g. the guest); matches crm_contact_informations.id |
target_contact_information_id |
Identifier of the related contact (e.g. the emergency contact); matches crm_contact_informations.id |
relationship_type |
Type of relationship; currently always emergency_contact |
sub_type |
Who the related contact is to the source contact: parent, step_parent, grandparent, guardian, spouse_partner, sibling, other_relative, friend, carer_support_worker, university_sponsor, university_guarantor, care_leavers_covenant or other. Null when not set |
note |
Free-text description of the relationship, up to 100 characters; set only when sub_type is other |
created_at |
Timestamp when the relationship was created |
updated_at |
Timestamp when the relationship was last updated |
timestamp |
Date when the table was last synchronized |