contact_web_links


Description

A row in this table represents a url link belonging to a candidate in your Lever account. Usually stores online profile, personal sites, portfolios and other useful info about the candidate.

Columns

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

url varchar 2147483647 null

URL of a link associated with a contact.

canonical_url varchar 2147483647 null

Canonical version URL of a link associated with the contact

name varchar 2147483647 null

Name of organization associated with the link \(e.g. LinkedIn, Github, etc\)

web_link_rank numeric 131089 null

Ordered rank of web links

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.

url_key varchar 2147483647 null

Unique hash of the url to serve as a key.

Indexes

Constraint Name Type Sort Column(s)
contact_web_links_pkey Primary key Asc/Asc contact_id + url_key
contact_web_links_account_id_index Performance Asc account_id

Relationships