created_atstring timestamp with time zone
updated_atstring timestamp with time zone
organisation_idstring uuid
full_namestring text nullable
ftsstring tsvector nullable
external_idstring text nullable
secondary_external_idstring text nullable
birthdaystring date nullable
salutationstring text nullable
emailstring text nullable
whatsappstring text nullable
instagramstring text nullable
facebookstring text nullable
display_namestring text nullable
Displayed name of contact in the Mateo app
google_business_messagingstring text nullable
Google business messaging account of contact
address_line1string text nullable
First line of the postal address
address_line2string text nullable
Second line of the postal address
citystring text nullable
City of the postal address
zipcodestring text nullable
Postal code or ZIP code of the address
countrystring text nullable
Country of the postal address
postalstring text nullable
Postal handle or identifier for the contact
number_of_marketing_opt_in_requestsinteger
Number of marketing opt in requests
latest_marketing_opt_in_request_sent_atstring timestamp with time zone nullable
Latest marketing opt in request sent at
campaign_messages_this_monthinteger
Campaign Messages this month
whatsapp_marketing_opt_inboolean
WhatsApp marketign opt in
sms_marketing_opt_inboolean
email_marketing_opt_inboolean
Email marketing opt in of contact
facebook_marketing_opt_inboolean
Facebook marketing opt in
instagram_marketing_opt_inboolean
Instagram marketing opt in
google_business_messaging_marketing_opt_inboolean
Google business messaging marketing opt in
postal_marketing_opt_inboolean
Postal marketing opt in status
whatsapp_transactional_opt_in'legitimate_interest' | 'contract_fulfillment' | 'consent_granted' public.opt_in_reason nullable
WhatsApp transactional opt in
sms_transactional_opt_in'legitimate_interest' | 'contract_fulfillment' | 'consent_granted' public.opt_in_reason nullable
email_transactional_opt_in'legitimate_interest' | 'contract_fulfillment' | 'consent_granted' public.opt_in_reason nullable
Email transactional opt in
facebook_transactional_opt_in'legitimate_interest' | 'contract_fulfillment' | 'consent_granted' public.opt_in_reason nullable
Facebook transactional opt in
instagram_transactional_opt_in'legitimate_interest' | 'contract_fulfillment' | 'consent_granted' public.opt_in_reason nullable
Instagram transactional opt in
google_business_messaging_transactional_opt_in'legitimate_interest' | 'contract_fulfillment' | 'consent_granted' public.opt_in_reason nullable
Google business messaging transactional opt in
postal_transactional_opt_in'legitimate_interest' | 'contract_fulfillment' | 'consent_granted' public.opt_in_reason nullable
Postal transactional opt in status