nurture_campaign_events


Description

A row in this table represents an event regarding a specific campaign. The possible values are listed in “nurture_campaign_event_enum”.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nurture_template_id varchar 2147483647 null
nurture_templates.nurture_template_id nurture_campaign_events_nurture_template_id_fkeyN

ID of the nurture template associated with this entity.

nurture_campaign_event_id varchar 2147483647 null
nurture_campaign_event_enum.nurture_campaign_event_id nurture_campaign_events_nurture_campaign_event_id_fkeyN

ID of the event type represented by this entity. See connected “enum” table for a list of the possible types.

event_at timestamp 29,6 null

Date and time when the event occurred.

nurture_campaign_id varchar 2147483647 null
nurture_campaigns.nurture_campaign_id nurture_campaign_events_nurture_campaign_id_fkeyN

The ID of a specific nurture campaign.

account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id nurture_campaign_events_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

contact_id varchar 2147483647 null
contacts.contact_id nurture_campaign_events_contact_id_fkeyN

ID of the contact that represents the personal information of a candidate independent from opportunities.

posting_id varchar 2147483647 null
postings.posting_id nurture_campaign_events_posting_id_fkeyN

ID of the posting connected to this entity.

requisition_id varchar 2147483647 null
requisitions.requisition_id nurture_campaign_events_requisition_id_fkeyN

ID of the requisition associated with this entity.

email_id varchar 2147483647 null
emails.email_id nurture_campaign_events_email_id_fkeyN

ID of the email referred by this entity.

external_message_id varchar 2147483647 null
external_messages.external_message_id nurture_campaign_events_external_message_id_fkeyN
archive_reason_id varchar 2147483647 null
archive_reasons.archive_reason_id nurture_campaign_events_archive_reason_id_fkeyN

ID of the archive reason.

account_stage_id varchar 2147483647 null
account_stages.account_stage_id nurture_campaign_events_account_stage_id_fkeyN

ID of the stage associated with this record.

event_date_id varchar 2147483647 null
dates.date_id nurture_campaign_events_event_date_id_fkeyN

ID of the date and time when the event occurred. It’s used in combination with the datetime dimension table to simplify the creation of temporal queries.

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.

actor_id varchar 2147483647 'NOT_APPLICABLE'::character varying
users.user_id nurture_campaign_events_actor_id_fkey
is_confidential bool 1 false

TRUE if the posting related to the opportunity is confidential.

event_key varchar 2147483647 null
previous_event_at timestamp 29,6 null

Date and time of the previous event for the same nurture_campaign_id. Is the same as event_at for the first event.

next_event_at timestamp 29,6 null

Date and time of the next event for the same nurture_campaign_id. Is 9999-09-09T12:00:00Z if last event.

Indexes

Constraint Name Type Sort Column(s)
nurture_campaign_events_pkey Primary key Asc event_key
nurture_campaign_events_account_id_index Performance Asc account_id
nurture_campaign_events_actor_id_idx Performance Asc actor_id
nurture_campaign_events_nurture_campaign_id_idx Performance Asc nurture_campaign_id
nurture_campaign_events_nurture_template_id_idx Performance Asc nurture_template_id
nurture_campaign_events_opportunity_id_index Performance Asc opportunity_id

Relationships