external_message_participant_contacts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
external_message_participant_contacts_id varchar 2147483647 null

Primary key.

external_message_participant_contact varchar 2147483647 null
account_id varchar 2147483647 null

ID of the account the record belongs to.

contact_id varchar 2147483647 null
contacts.contact_id external_message_participant_contacts_contact_id_fkeyN

ID of the contact that represents the personal information of a candidate independent from opportunities.

external_message_participant_id varchar 2147483647 null
external_message_participants.external_message_participant_id external_message_participant_external_message_participant_fkey1N
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_participant_contacts_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_participant_contacts_pkey Primary key Asc external_message_participant_contacts_id
external_message_participant_contacts_account_id_index Performance Asc account_id
external_message_participant_contacts_external_message_id_index Performance Asc external_message_id

Relationships