external_message_participants


Columns

Column Type Size Nulls Auto Default Children Parents Comments
external_message_participant_id varchar 2147483647 null
external_message_participant_contacts.external_message_participant_id external_message_participant_external_message_participant_fkey1N
external_message_participant_id_names.external_message_participant_id external_message_participant__external_message_participant_fkeyN

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
external_message_service_id varchar 2147483647 √ null
external_message_service_enum.external_message_service_id external_message_participants_external_message_service_id_fkeyN
external_message_participant_enum_id varchar 2147483647 √ null
external_message_participant_enum.external_message_participant_id external_message_participants_external_message_participant_fkeyN
external_message_entity_id varchar 2147483647 √ null
external_message_entity_enum.external_message_entity_id external_message_participants_external_message_entity_id_fkeyN
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
external_message_id varchar 2147483647 √ null
external_messages.external_message_id external_message_participants_external_message_id_fkeyN
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_message_participants_pkey Primary key Asc external_message_participant_id
external_message_participants_account_id_index Performance Asc account_id
external_message_participants_external_message_id_index Performance Asc external_message_id

Relationships

Close relationships within degrees of separation