users


Description

A row in this table represents a user in your Lever account. Users can be recruiters, hiring managers, interviewers…

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id varchar 2147483647 null
api_credentials.creator_id api_credentials_creator_id_fkeyN
contact_consent_events.user_id contacts_consent_events_user_id_fkeyN
data_requests.assigned_user_id Implied ConstraintR
data_requests.closed_by_user_id Implied ConstraintR
form_templates.creator_id form_templates_creator_id_fkeyN
interview_panel_interviewers.user_id interview_panels_interviews_interviewers_user_id_fkeyN
interview_panels.creator_id interview_panels_creator_id_fkeyN
nurture_campaign_events.actor_id nurture_campaign_events_actor_id_fkey
nurture_campaign_step_emails.from_user_id nurture_campaign_step_emails_from_user_id_fkeyN
nurture_templates.owner_user_id nurture_templates_owner_user_id_fkeyN
offer_approvers.approver_id offer_approvers_approver_id_fkeyN
offer_events.actor_id offer_events_actor_id_fkeyN
offer_events.hiring_manager_user_id offer_events_hiring_manager_user_id_fkeyN
opportunities.archived_by_user_id opportunities_archived_by_user_id_fkeyN
opportunities.owner_user_id opportunities_owner_user_id_fkeyN
opportunities.sourced_by_user_id opportunities_sourced_by_user_id_fkeyN
opportunity_feedback_events.actor_id opportunities_feedback_events_actor_id_fkeyN
opportunity_form_events.actor_id opportunities_form_events_actor_id_fkeyN
opportunity_forms.user_id opportunity_forms_user_id_fkeyN
opportunity_progress_events.actor_id opportunities_progress_events_actor_id_fkeyN
opportunity_referrals.user_id opportunity_referrals_user_id_fkeyN
posting_approvers.approver_id posting_approvers_approver_id_fkeyN
posting_events.actor_id posting_events_actor_id_fkeyN
posting_followers.user_id posting_followers_user_id_fkeyC
postings.hiring_manager_user_id postings_hiring_manager_user_id_fkeyN
postings.owner_user_id postings_owner_user_id_fkeyN
requisition_approvers.approver_id requisition_approvers_approver_id_fkeyN
requisition_events.actor_id requisition_events_actor_id_fkeyN
requisition_events.creator_user_id requisition_events_creator_user_id_fkeyN
requisition_events.hiring_manager_user_id requisition_events_hiring_manager_user_id_fkeyN
requisition_events.owner_user_id requisition_events_owner_user_id_fkeyN
requisitions.creator_user_id requisitions_creator_user_id_fkeyN
requisitions.hiring_manager_user_id requisitions_hiring_manager_user_id_fkeyN
requisitions.owner_user_id requisitions_owner_user_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

name varchar 2147483647 null

Full name of the user

email varchar 2147483647 null

Email address associated with this entity.

username varchar 2147483647 null

Custom naming field to identify the user. Default falls to all lower case full name joined together

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

is_active bool 1 null

TRUE if the user is active, False if the user in inactive.

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.

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc user_id
users_account_id_index Performance Asc account_id

Relationships