email_participants


Columns

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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

email_id varchar 2147483647 null
emails.email_id email_participants_email_id_fkeyN

ID of the email referred by this entity.

participant_type varchar 2147483647 null
email_participant_enum.email_participant_enum_id email_participants_participant_type_fkeyN

Type of email participant \(like from, to, cc, bcc\).

email_address varchar 2147483647 null

Email address of the participant.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

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)
email_participants_pkey Primary key Asc email_participant_id
email_participants_account_id_index Performance Asc account_id

Relationships