A row in this table represents an email belonging to a candidate in your Lever account.


Column Type Size Nulls Auto Default Children Parents Comments
contact_id varchar 2147483647 null
contacts.contact_id contact_emails_contact_id_fkeyN

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

account_id varchar 2147483647 null

ID of the account the record belongs to.

email varchar 2147483647 null

Email address associated with this entity.

email_rank numeric 131089 null

Ordered rank of preferred email. 0 indicates preferred email.

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)
contact_emails_pkey Primary key Asc/Asc contact_id + email
contact_emails_account_id_index Performance Asc account_id