nurture_campaign_step_emails


Description

A row in this table represents an individual email sent in the context of a campaign.

Columns

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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

nurture_campaign_step_id varchar 2147483647 null
nurture_campaign_steps.nurture_campaign_step_id nurture_campaign_step_emails_nurture_campaign_step_id_fkeyN

ID of the step in the nurture campaign.

email_id varchar 2147483647 null
emails.email_id nurture_campaign_step_emails_email_id_fkeyN

ID of the email referred by this entity.

from_user_id varchar 2147483647 null
users.user_id nurture_campaign_step_emails_from_user_id_fkeyN

ID of the user this email was sent for. Will be NOT_APPLICABLE for emails sent from the creator.

subject varchar 2147483647 null

Subject of the email that sent at this step.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

nurture_campaign_id varchar 2147483647 null
nurture_campaigns.nurture_campaign_id nurture_campaign_step_emails_nurture_campaign_id_fkeyN

The ID of a specific nurture campaign.

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)
nurture_campaign_step_emails_pkey Primary key Asc nurture_campaign_step_email_id
nurture_campaign_step_emails_account_id_index Performance Asc account_id
nurture_campaign_step_emails_nurture_campaign_id_index Performance Asc nurture_campaign_id

Relationships