contacts


Description

A row in this table represents a candidate in your Lever account.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contact_id varchar 2147483647 null
contact_consent_events.contact_id contacts_consent_events_contact_id_fkeyN
contact_emails.contact_id contact_emails_contact_id_fkeyN
contact_location.contact_id contact_location_contact_id_fkeyN
contact_name.contact_id contact_name_contact_id_fkeyN
contact_organization_summary.contact_id contact_organization_summary_contact_id_fkeyN
contact_phones.contact_id contact_phones_contact_id_fkeyN
contact_residing_country.contact_id contact_residing_country_contact_id_fkeyN
contact_web_links.contact_id contact_web_links_contact_id_fkeyN
data_requests.contact_id data_requests_contact_id_fkeyN
email_events.contact_id emails_events_contact_id_fkeyN
external_message_participant_contacts.contact_id external_message_participant_contacts_contact_id_fkeyN
nurture_campaign_events.contact_id nurture_campaign_events_contact_id_fkeyN
offer_events.contact_id offer_events_contact_id_fkeyN
opportunities.contact_id opportunities_contact_id_fkeyN
opportunity_feedback_events.contact_id opportunity_feedback_events_contact_id_fkeyN
opportunity_form_events.contact_id opportunities_form_events_contact_id_fkeyN
opportunity_form_field_files.contact_id opportunity_form_field_files_contact_id_fkeyN
opportunity_form_field_scores.contact_id opportunity_form_field_scores_contact_id_fkeyN
opportunity_form_field_values.contact_id opportunity_form_field_values_contact_id_fkeyN
opportunity_form_fields.contact_id opportunity_form_fields_contact_id_fkeyN
opportunity_forms.contact_id opportunity_forms_contact_id_fkeyN
opportunity_progress_events.contact_id opportunity_progress_events_contact_id_fkeyN
opportunity_referrals.contact_id opportunity_referrals_contact_id_fkeyN

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.
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.
is_anonymized bool 1 √ null

TRUE if the contact has been anonymized, FALSE if it has not.

Indexes

Constraint Name Type Sort Column(s)
contacts_pkey Primary key Asc contact_id
contacts_account_id_index Performance Asc account_id

Relationships

Close relationships within degrees of separation