external_messages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
external_message_id varchar 2147483647 null
external_message_participant_contacts.external_message_id external_message_participant_contacts_external_message_id_fkeyN
external_message_participant_id_names.external_message_id external_message_participant_id_names_external_message_id_fkeyN
external_message_participants.external_message_id external_message_participants_external_message_id_fkeyN
nurture_campaign_events.external_message_id nurture_campaign_events_external_message_id_fkeyN

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
opportunity_id varchar 2147483647 √ null
opportunities.opportunity_id external_messages_opportunity_id_fkeyC

ID of the opportunity connected to this entity.
external_message_service_id varchar 2147483647 √ null
external_message_service_enum.external_message_service_id external_messages_external_message_service_id_fkeyN
sent_at timestamp 29,6 √ null

Date the message was sent at.
subject varchar 2147483647 √ null
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.
row_updated_at timestamp 29,6 √ CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

Indexes

Constraint Name Type Sort Column(s)
external_messages_pkey Primary key Asc external_message_id
external_messages_account_id_index Performance Asc account_id

Relationships

Close relationships within degrees of separation