A row in this table represents the country of residence of a candidate in your Lever account.


Column Type Size Nulls Auto Default Children Parents Comments
contact_id varchar 2147483647 null
contacts.contact_id contact_residing_country_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.

country_code varchar 2147483647 null

2-letter country code of where the contact resides

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_residing_country_pkey Primary key Asc contact_id
contact_residing_country_account_id_index Performance Asc account_id