1 of 1

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_idREJECTION_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