A row in this table represents an email address a specific campaign was started for.


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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

nurture_campaign_id varchar 2147483647 null
nurture_campaigns.nurture_campaign_id nurture_campaign_email_addresses_nurture_campaign_id_fkeyN

The ID of a specific nurture campaign.

email_to varchar 2147483647 null

The recipient’s email address.

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.


Constraint Name Type Sort Column(s)
nurture_campaign_email_addresses_pkey Primary key Asc nurture_campaign_email_address_id
nurture_campaign_email_addresses_account_id_index Performance Asc account_id