email_events


Description

A row in this table represents an event related to a specific message. The type of events are listed in “email_event_enum”. Useful to create reports around emails sent, opened or had a link clicked.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
email_id varchar 2147483647 null
emails.email_id emails_events_email_id_fkeyN

ID of the email referred by this entity.

email_event_id varchar 2147483647 null
email_event_enum.email_event_id emails_events_email_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.

account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id emails_events_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

contact_id varchar 2147483647 null
contacts.contact_id emails_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 emails_events_posting_id_fkeyN

ID of the posting connected to this entity.

requisition_id varchar 2147483647 null
requisitions.requisition_id emails_events_requisition_id_fkeyN

ID of the requisition associated with this entity.

account_stage_id varchar 2147483647 null
account_stages.account_stage_id emails_events_account_stage_id_fkeyN

ID of the stage associated with this record.

event_date_id varchar 2147483647 null
dates.date_id emails_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.

event_key varchar 2147483647 null
previous_event_at timestamp 29,6 null

Date and time of the previous event for the same email_id, either the previous open event with the same email_event_id or the time the email was sent.

next_event_at timestamp 29,6 null

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

Indexes

Constraint Name Type Sort Column(s)
email_events_pkey Primary key Asc event_key
email_events_email_id_idx Performance Asc email_id
email_events_opportunity_id_index Performance Asc opportunity_id
emails_events_account_id_index Performance Asc account_id

Relationships