# crm_contact_informations

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

CRM contact details including names, emails, phones, and marketing consent records. Includes the emergency and trusted contacts of served contacts, so crm_contact_relationships.target_contact_information_id joins here.

| Column | Description |
| --- | --- |
| `id` | Unique identifier for the contact information record |
| `first_name` | Contact's first name |
| `last_name` | Contact's last name |
| `pronoun_uuid` | UUID reference to the contact's preferred pronouns |
| `date_of_birth` | Contact's date of birth |
| `nationality_uuid` | UUID reference to the contact's nationality |
| `crm_contact_entity_id` | Identifier linking to the CRM contact entity |
| `created_at` | Timestamp indicating when the record was created |
| `updated_at` | Timestamp indicating when the record was last updated |
| `source` | Source of the contact information |
| `title_uuid` | UUID reference to the contact's title |
| `unique_reference` | Unique reference identifier for the contact |
| `secondary_emails` | Additional email addresses |
| `primary_email` | Contact's primary email address |
| `primary_phone_number` | Contact's primary phone number |
| `secondary_phone_numbers` | Additional phone numbers |
| `marketing_by_email` | Timestamp when marketing consent status for email communications was set |
| `marketing_by_phone` | Timestamp when marketing consent status for phone communications was set |
| `privacy_policy` | Privacy policy acceptance status |
| `language_code` | Preferred language code for communications |
| `external_airbnb_profile_id` | External Airbnb profile identifier |
| `airbnb_profile_picture_thumbnail` | URL to Airbnb profile picture thumbnail |
| `airbnb_profile_picture_regular` | URL to Airbnb profile picture in regular size |
| `hometown` | Contact's hometown |
| `legacy` | Boolean flag indicating if this is a legacy record |
| `employment_status` | Contact's employment status |
| `known_as` | Alternative name or nickname |
| `notes` | Additional notes about the contact |
| `accepted_terms_at` | Timestamp of when terms were accepted |
| `timestamp` | Date when the table was last synchronized |