emails


Description

A row in this table represents an email sent to a candidate. Note: we don’t currently connect emails to templates as the latter are not currently versioned.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
email_id varchar 2147483647 null
email_events.email_id emails_events_email_id_fkeyN
email_participants.email_id email_participants_email_id_fkeyN
nurture_campaign_events.email_id nurture_campaign_events_email_id_fkeyN
nurture_campaign_step_emails.email_id nurture_campaign_step_emails_email_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

subject varchar 2147483647 null

Subject line of the email.

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)
emails_pkey Primary key Asc email_id
emails_account_id_index Performance Asc account_id

Relationships