A row in this table represents the delay applied to an individual step of a nurture campaign. In product it’s called a “wait” step.


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

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

delay_type_id varchar 2147483647 null
nurture_campaign_delay_enum.nurture_campaign_delay_id nurture_campaign_step_delays_delay_type_id_fkeyN

The type of delay configured for the campaign step like dayOfWeek, nextWorkday, etc…

nurture_campaign_step_id varchar 2147483647 null
nurture_campaign_steps.nurture_campaign_step_id nurture_campaign_step_delays_nurture_campaign_step_id_fkeyN

ID of the step in the nurture campaign.

years int4 10 null

Number of years to apply to the delay.

months int4 10 null

Number of months to apply to the delay.

weeks int4 10 null

Number of weeks to apply to the delay.

created_at timestamp 29,6 null

When the object referred to in this entity was created.

days int4 10 null

Number of days to apply to the delay.

nurture_campaign_id varchar 2147483647 null
nurture_campaigns.nurture_campaign_id nurture_campaign_step_delays_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.


Constraint Name Type Sort Column(s)
nurture_campaign_step_delays_pkey Primary key Asc nurture_campaign_step_delay_id
nurture_campaign_step_delays_account_id_index Performance Asc account_id
nurture_campaign_step_delays_nurture_campaign_id_index Performance Asc nurture_campaign_id
nurture_campaign_step_delays_nurture_campaign_step_id_key Must be unique Asc nurture_campaign_step_id