# crm_contact_relationships

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

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 |