crm_contact_informations

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