nurture_campaign_step_archives


Description

A row in this table represents the archive reason configured for this specific campaign.

Columns

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

ID of the step in the nurture campaign.

archive_reason_id varchar 2147483647 null
archive_reasons.archive_reason_id nurture_campaign_step_archives_archive_reason_id_fkeyN

ID of the archive reason.

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_archives_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_archives_pkey Primary key Asc nurture_campaign_step_archive_id
nurture_campaign_step_archives_account_id_index Performance Asc account_id
nurture_campaign_step_archives_nurture_campaign_id_index Performance Asc nurture_campaign_id

Relationships