SmartRecruiters
Explore the interactive ERD
Table & Field Reference
candidate_screening_answer_record_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_screening_answer_id | Unknown | PKFK |
candidate_screening_answer_record_id | Unknown | PKFK |
label | Unknown |
candidate_screening_answer_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_screening_answer_id | Unknown | PKFK |
label | Unknown |
candidate_screening_answer
| Column | Type | Keys |
|---|---|---|
candidate_primary_assignment_job_id | Unknown | PK |
id | Unknown | PK |
candidate_id | Unknown | PKFK |
category | Unknown | |
label | Unknown | |
name | Unknown | |
type | Unknown |
offer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | FK |
job_id | Unknown | FK |
created_on | Unknown | |
status | Unknown | |
updated_on | Unknown | |
properties_** |
candidate_status_history
| Column | Type | Keys |
|---|---|---|
changed_on | Unknown | PK |
candidate_id | Unknown | PKFK |
job_id | Unknown | PKFK |
status | Unknown | |
sub_status | Unknown |
candidate_education
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
candidate_id | Unknown | FK |
current | Unknown | |
degree | Unknown | |
description | Unknown | |
end_date | Unknown | |
institution | Unknown | |
location | Unknown | |
major | Unknown | |
start_date | Unknown |
candidate_experience
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
candidate_id | Unknown | FK |
company | Unknown | |
current | Unknown | |
description | Unknown | |
end_date | Unknown | |
location | Unknown | |
start_date | Unknown | |
title | Unknown |
candidate_secondary_assignment
| Column | Type | Keys |
|---|---|---|
candidate_id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_title | Unknown | |
reason_of_rejection_id | Unknown | |
reason_of_rejection_label | Unknown | |
reason_of_withdrawal_id | Unknown | |
reason_of_withdrawal_label | Unknown | |
source | Unknown | |
starts_on | Unknown | |
status | Unknown | |
sub_status | Unknown |
candidate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
primary_assignment_job_id | Unknown | FK |
created_on | Unknown | |
email | Unknown | |
first_name | Unknown | |
internal | Unknown | |
last_name | Unknown | |
location_city | Unknown | |
location_country | Unknown | |
location_country_code | Unknown | |
location_latitude | Unknown | |
location_longitude | Unknown | |
location_region | Unknown | |
location_region_code | Unknown | |
phone_number | Unknown | |
primary_assignment_job_title | Unknown | |
primary_assignment_reason_of_rejection_id | Unknown | |
primary_assignment_reason_of_rejection_label | Unknown | |
primary_assignment_reason_of_withdrawal_id | Unknown | |
primary_assignment_reason_of_withdrawal_label | Unknown | |
primary_assignment_source | Unknown | |
primary_assignment_starts_on | Unknown | |
primary_assignment_status | Unknown | |
primary_assignment_sub_status | Unknown | |
tags | Json | |
updated_on | Unknown | |
web_facebook | Unknown | |
web_linkedin | Unknown | |
web_skype | Unknown | |
web_twitter | Unknown | |
web_website | Unknown |
reviews
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | FK |
job_id | Unknown | FK |
reviewer_id | Unknown | FK |
comment | Unknown | |
created_on | Unknown | |
overall_rating | Unknown | |
updated_on | Unknown |
hiring_process_substatus_in_review
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
hiring_process_id | Unknown | PKFK |
value | Unknown |
hiring_process_substatus_interview
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
hiring_process_id | Unknown | PKFK |
value | Unknown |
hiring_process_substatus_offered
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
hiring_process_id | Unknown | PKFK |
value | Unknown |
hiring_process
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
name | Unknown |
company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
industry_id | Unknown | |
industry_label | Unknown | |
location_address | Unknown | |
location_city | Unknown | |
location_country | Unknown | |
location_country_code | Unknown | |
location_latitude | Unknown | |
location_longitude | Unknown | |
location_postal_code | Unknown | |
location_region | Unknown | |
location_region_code | Unknown | |
logo | Unknown | |
name | Unknown | |
website | Unknown |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
archived | Unknown | |
description | Unknown | |
label | Unknown |
candidate_application
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | FK |
job_id | Unknown | FK |
source | Unknown | FK |
reason_of_rejection_id | Unknown | |
reason_of_rejection_label | Unknown | |
reason_of_withdrawal_id | Unknown | |
reason_of_withdrawal_label | Unknown | |
start_on | Unknown | |
status | Unknown | |
sub_status | Unknown |
approval_step_approver
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
approval_id | Unknown | PKFK |
decided_on | Unknown | |
decision | Unknown |
approval_step
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
approval_id | Unknown | PKFK |
status | Unknown |
approval
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_approval_request_id | Unknown | PKFK |
decision_mode | Unknown | |
status | Unknown | |
subject_id | Unknown | |
subject_type | Unknown | |
type | Unknown |
job_position
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
created_on | Unknown | |
incumbent_name | Unknown | |
position_id | Unknown | |
position_open_date | Unknown | |
status | Unknown | |
target_start_date | Unknown | |
type | Unknown |
job_status_history
| Column | Type | Keys |
|---|---|---|
status | Unknown | PK |
job_id | Unknown | PKFK |
user_id | Unknown | FK |
changed_on | Unknown |
users_access_groups
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PK |
users_id | Unknown | PKFK |
users_seats
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
users_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
email | Unknown | |
exteral_data | Unknown | |
first_name | Unknown | |
language_code | Unknown | |
last_name | Unknown | |
sso_identifier | Unknown | |
sso_login_mode | Unknown | |
system_role_id | Unknown | |
system_role_name | Unknown | |
updated_on | Unknown |
candidate_source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
source_type_id | Unknown | PK |
label | Unknown | |
source_subtype_id | Unknown |
company_active_posting_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
company_active_posting_id | Unknown | PKFK |
field_id | Unknown | |
field_label | Unknown | |
value_id | Unknown | |
value_label | Unknown |
company_active_posting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
job_id | Unknown | FK |
creator_name | Unknown | |
default_job_ad | Unknown | |
name | Unknown | |
ref | Unknown | |
ref_number | Unknown | |
released_date | Unknown | |
uuid | Unknown | |
visibility | Unknown |
job_application
| Column | Type | Keys |
|---|---|---|
job_id | Unknown | PKFK |
profile_id | Unknown | PKFK |
create_date | Unknown | |
source_identifier | Unknown | |
status | Unknown | |
sub_status | Unknown |
job_approval_position
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
job_approval_request_id | Unknown | PKFK |
job_approval_request_job_id | Unknown | PKFK |
job_position_id | Unknown | FK |
job_approval_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
salary_range_currency | Unknown | |
salary_range_max | Unknown | |
salary_range_min | Unknown |
job_property
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
label | Unknown | |
value_id | Unknown | |
value_label | Unknown |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
department_id | Unknown | FK |
compensation_currency | Unknown | |
compensation_max | Unknown | |
compensation_min | Unknown | |
created_on | Unknown | |
eeo_category_id | Unknown | |
eeo_category_label | Unknown | |
employment_type_id | Unknown | |
employment_type_label | Unknown | |
experience_level_id | Unknown | |
experience_level_label | Unknown | |
function_id | Unknown | |
function_label | Unknown | |
industry_id | Unknown | |
industry_label | Unknown | |
job_ad_additionl_information_text | Unknown | |
job_ad_additionl_information_title | Unknown | |
job_ad_company_text | Unknown | |
job_ad_company_title | Unknown | |
job_ad_job_text | Unknown | |
job_ad_job_title | Unknown | |
job_ad_qualification_text | Unknown | |
job_ad_qualification_title | Unknown | |
job_ad_videos | Json | |
language_code | Unknown | |
language_label | Unknown | |
language_label_native | Unknown | |
last_activity_on | Unknown | |
location_address | Unknown | |
location_city | Unknown | |
location_country | Unknown | |
location_country_code | Unknown | |
location_latitude | Unknown | |
location_longitude | Unknown | |
location_manual | Unknown | |
location_postal_code | Unknown | |
location_region | Unknown | |
location_region_code | Unknown | |
location_remote | Unknown | |
posting_status | Unknown | |
ref_number | Unknown | |
status | Unknown | |
target_hiring_date | Unknown | |
template | Unknown | |
title | Unknown | |
updated_on | Unknown |
candidate_property
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | PKFK |
job_id | Unknown | PKFK |
label | Unknown | |
type | Unknown | |
value | Unknown | |
value_label | Unknown |
interviewer
| Column | Type | Keys |
|---|---|---|
interview_id | Unknown | PKFK |
interview_timeslot_id | Unknown | PKFK |
interviewer_id | Unknown | PKFK |
status | Unknown |
interview_timeslot
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interview_id | Unknown | PKFK |
candidate_status | Unknown | |
ends_on | Unknown | |
interview_type | Unknown | |
no_show | Unknown | |
place | Unknown | |
starts_on | Unknown | |
title | Unknown |
interview
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_application_id | Unknown | FK |
candidate_id | Unknown | FK |
job_id | Unknown | FK |
organizer_id | Unknown | FK |
created_on | Unknown | |
location | Unknown | |
ref_url | Unknown | |
source | Unknown | |
timezone | Unknown |
job_publication
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
job_id | Unknown | FK |
source_name | Unknown | FK |
posting_id | Unknown | |
published_on | Unknown | |
type | Unknown | |
unpublished_on | Unknown |
job_hiring_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
user_id | Unknown | FK |
role | Unknown |