Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id🔑
coordinator_id ➤ USER�recruiter_id ➤ USER
can_email
company�created_at�first_name
is_private�last_activity_at�last_name
photo_url�title
updated_at�custom_*
CANDIDATE ⇱
id🔑
user_id ➤ USER
froms�body�created_at�description�html_body
is_default�name
type�updated_at
EMAIL_TEMPLATE ⇱
email_template_id 🔑➤ EMAIL_TEMPLATE
email_id🔑
EMAIL_TEMPLATE_CC ⇱
id🔑
candidate_id 🔑➤ CANDIDATE�user_id ➤ USER�body�created_at
froms
subject�tos
EMAIL ⇱
id🔑
candidate_id 🔑➤ CANDIDATE�user_id ➤ USER�body�created_at
is_rivate
visibility
NOTE ⇱
id🔑
candidate_id 🔑➤ CANDIDATE�user_id ➤ USER�body�created_at
subject
ACTIVITY ⇱
candidate_id🔑 ➤ CANDIDATE
tag_id 🔑 ➤ TAG
CANDIDATE_TAG ⇱
id🔑
name
TAGS ⇱
id🔑
Job_stage_id ➤ JOB_STAGE�interview_kit_content�name
INTERVIEW ⇱
id 🔑
interview_id 🔑 ➤ INTERVIEW
question
INTERVIEW_QUESTION ⇱
id🔑�application_id ➤ APPLICATION
interview_id ➤ INTERVIEW
organizer_id ➤ USER�created_at�ends�location�start
status
updated_at
SCHEDULED_INTERVIEW ⇱
interviewer_id🔑➤ USER
scheduled_interview_id🔑➤ SCHEDULED_INTERVIEW
scorecard_id ➤ SCORECARD
response_status
SCHEDULED_INTERVIEWER ⇱
scorecard_id 🔑➤ SCORECARD
index 🔑
id
question �answer
SCORECARD_QNA ⇱
id🔑
closed_at�confidential�created_at�name
notes
opened_at�requisition_id
status
custom_*
JOB ⇱
id🔑
parent_id ➤ OFFICE�primary_contact_user_id ➤ USER�external_id�location_name�name
OFFICE ⇱
id🔑
external_id�name�parent_id ➤ OFFICE
DEPARTMENT ⇱
job_id🔑➤ JOB�office_id🔑➤ OFFICE
JOB_OFFICE ⇱
job_id🔑➤ JOB
department_id🔑➤ DEPARTMENT
JOB_DEPARTMENT ⇱
id🔑
job_id ➤ JOB�content�created_at
external
internal�internal_content
live
location�title
updated_at
JOB_POST ⇱
id🔑
candidate_id ➤ CANDIDATE
credited_to_user_id ➤ USER�current_stage_id ➤ JOB_STAGE
job_post_id ➤ JOB_POST�prospect_owner_id ➤ USER�prospect_pool_id ➤ PROSPECT_POOL
prospect_stage_id ➤ PROSPECT_STAGE�rejected_reason_id➤ REJECTION_REASON�source_id ➤ SOURCE
rejected_reason_id�applied_at�last_activity_at
location_address
prospect�rejected_at
status�custom_*
prospective_office
prospective_department
APPLICATION ⇱
id🔑
created_at�disabled�employee_id �first_name
last_name
primary_email_address�site_admin
updated_at
USER ⇱
id🔑
reason
rejection_reason_type
rejection_reason_type_id
REJECTION_REASON ⇱
id🔑
job_id ➤ JOB
active�created_at�name
Updated_at
priority
JOB_STAGE ⇱
id🔑
submitted_by_user_id ➤ USER�created_at
interviewed_at
overall_recommendation�submitted_at
updated_at
SCORECARD ⇱
id🔑
name
source_type
source_type_id
SOURCE ⇱
id🔑
job_id 🔑 ➤ JOB
application_id ➤ APPLICATION
close_reason_id ➤ CLOSE_REASON�opening_id
status
opened_at
closed_at
custom_*
JOB_OPENING ⇱
id🔑
name
CLOSE_REASON ⇱
application_id🔑➤ APPLICATION
job_id🔑➤ JOB
JOB_APPLICATION ⇱
Id🔑
application_id ➤ APPLICATION�updated_at
created_at�resolved_at
sent_at
starts_at
status�version
custom_*
OFFER ⇱
job_id 🔑➤ JOB�role 🔑
user_id🔑 ➤ USER
responsible
HIRING_TEAM ⇱
application_id 🔑 ➤ APPLICATION
updated_at 🔑
new_stage_id ➤ JOB_STAGE
new_status
APPLICATION_HISTORY ⇱
id🔑
name
priority
SCHOOL ⇱
id🔑
name
priority
DEGREE ⇱
id🔑
name
priority
DISCIPLINE ⇱
scorecard_id 🔑➤ SCORECARD
index 🔑
name
note
rating�type
SCORECARD_ATTRIBUTE ⇱
index🔑 �candidate_id 🔑➤ CANDIDATE
degree ➤ DEGREE.name
discipline ➤ DISCIPLINE.name�school_name ➤ SCHOOL.name
id�end_date�start_date
EDUCATION ⇱
index🔑
candidate_id🔑 ➤ CANDIDATE
id�company_name
end_date�title
start_date
EMPLOYMENT ⇱
candidate_id🔑 ➤ CANDIDATE
index 🔑�type
value
PHONE_NUMBER ⇱
candidate_id🔑 ➤ CANDIDATE
index 🔑�type
value
EMAIL_ADDRESS ⇱
candidate_id🔑 ➤ CANDIDATE
index 🔑�type
value
WEBSITE_ADDRESS ⇱
candidate_id🔑 ➤ CANDIDATE
index 🔑�filename
type�url
ATTACHMENT ⇱
candidate_id🔑 ➤ CANDIDATE
index 🔑�value
SOCIAL_MEDIA_ADDRESS ⇱
candidate_id🔑 ➤ CANDIDATE
index 🔑�type
value
ADDRESS ⇱
application_id🔑 ➤ APPLICATION
disability_status_description�disability_status_id�gender_description�gender_id
race_description
race_id
submitted_at�veteran_status_id
veteran_status_description
EEOC ⇱
id🔑
active�name
PROSPECT_POOL ⇱
prospect_pool_id 🔑➤ PROSPECT_POOL�id🔑
name
PROSPECT_STAGE ⇱
application_id 🔑➤ APPLICATION
index 🔑�question 🔑�answer
APPLICATION_QNA ⇱
job_id 🔑 ➤ JOB
updated_at 🔑�closed_at�confidential�name
notes�requisition_id
status
custom_*
JOB_HISTORY ⇱
updated_at 🔑
offer_id🔑➤ OFFER
application_id ➤ APPLICATION�resolved_at
sent_at
starts_at
status�version
OFFER_HISTORY ⇱
job_post_id🔑➤ JOB_POST
index 🔑
name
description�is_private�is_required
label
JOB_POST_QUESTION ⇱
email_id🔑 ➤ EMAIL
cc_email 🔑
EMAIL_CC ⇱
DEMOGRAPHIC_QUESTION_SET ⇱
DEMOGRAPHIC_QUESTIONS ⇱
id 🔑
demog_question_set_id ➤ DEMOGRAPHIC_QUESTION_SET
active
name
id 🔑
demog_question_id ➤ DEMOGRAPHIC_QUESTIONS
free_form
active
name
DEMOGRAPHIC_ANSWER_OPTION ⇱
id 🔑
title
description
active
APPLICATION ⇱
id🔑
name�type
USER_ROLE ⇱
id🔑
user_id 🔑➤ USER�job_id ➤ JOB�user_role_id ➤ USER_ROLE
USER_PERMISSION ⇱
email🔑
user_id 🔑➤ USER
USER_EMAIL ⇱
user_id 🔑➤ USER
candidate_id 🔑➤ CANDIDATE
USER_LINKED_CANDIDATE ⇱