nurture_campaign_step_snoozes


Description

A row in this table represents tracks the duration of the snooze selected for a specific campaign.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nurture_campaign_step_snooze_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_snoozes_nurture_campaign_step_id_fkeyN

ID of the step in the nurture campaign.

snooze_duration numeric 131089 null

The number of milliseconds to snooze the candidate if this step is reached.

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_snoozes_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_snoozes_pkey Primary key Asc nurture_campaign_step_snooze_id
nurture_campaign_step_snoozes_account_id_index Performance Asc account_id
nurture_campaign_step_snoozes_nurture_campaign_id_index Performance Asc nurture_campaign_id
nurture_campaign_step_snoozes_nurture_campaign_step_id_idx Performance Asc nurture_campaign_step_id

Relationships