A row in this table represents a phone number 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_phones_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.

phone varchar 2147483647 null

Phone number

label varchar 2147483647 null

Type of phone \(home, mobile, etc\)

phone_rank numeric 131089 null

Ordered rank of preferred phone. 0 indicates preferred phone

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_phones_pkey Primary key Asc/Asc contact_id + phone
contact_phones_account_id_index Performance Asc account_id