nurture_campaigns


Description

A row in this table represents a campaign involving a candidate tied to a specific opportunity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nurture_campaign_id varchar 2147483647 null
nurture_campaign_email_addresses.nurture_campaign_id nurture_campaign_email_addresses_nurture_campaign_id_fkeyN
nurture_campaign_events.nurture_campaign_id nurture_campaign_events_nurture_campaign_id_fkeyN
nurture_campaign_step_archives.nurture_campaign_id nurture_campaign_step_archives_nurture_campaign_id_fkeyN
nurture_campaign_step_delays.nurture_campaign_id nurture_campaign_step_delays_nurture_campaign_id_fkeyN
nurture_campaign_step_emails.nurture_campaign_id nurture_campaign_step_emails_nurture_campaign_id_fkeyN
nurture_campaign_step_snoozes.nurture_campaign_id nurture_campaign_step_snoozes_nurture_campaign_id_fkeyN
nurture_campaign_steps.nurture_campaign_id nurture_campaign_steps_nurture_campaign_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

nurture_template_id varchar 2147483647 null
nurture_templates.nurture_template_id nurture_campaigns_nurture_template_id_fkeyN

ID of the nurture template associated with this entity.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id nurture_campaigns_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

status varchar 2147483647 null
nurture_campaign_status_enum.nurture_campaign_status_id nurture_campaigns_status_fkeyN

Current status of the nurture campaign.

send_emails_as_replies bool 1 null

If TRUE, new emails in this campaign are sent as replies to the original email.

started_at timestamp 29,6 null

Date the campaign was started at.

completed_at timestamp 29,6 null

Date and time when the campaign was completed

failed_at timestamp 29,6 null

When the campaign failed.

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)
nurture_campaigns_pkey Primary key Asc nurture_campaign_id
nurture_campaigns_account_id_index Performance Asc account_id

Relationships