# SmartRecruiters schema ERD

Table and field reference for the Fivetran SmartRecruiters connector.

## Table & Field Reference

### candidate_screening_answer_record_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_screening_answer_id | Unknown | PK, FK |
| candidate_screening_answer_record_id | Unknown | PK, FK |
| label | Unknown |  |

### candidate_screening_answer_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_screening_answer_id | Unknown | PK, FK |
| label | Unknown |  |

### candidate_screening_answer

| Column | Type | Keys |
| --- | --- | --- |
| candidate_primary_assignment_job_id | Unknown | PK |
| id | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| 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 | PK, FK |
| job_id | Unknown | PK, FK |
| 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 | PK, FK |
| job_id | Unknown | PK, FK |
| 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 | PK, FK |
| value | Unknown |  |

### hiring_process_substatus_interview

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| hiring_process_id | Unknown | PK, FK |
| value | Unknown |  |

### hiring_process_substatus_offered

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| hiring_process_id | Unknown | PK, FK |
| 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 | PK, FK |
| decided_on | Unknown |  |
| decision | Unknown |  |

### approval_step

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| approval_id | Unknown | PK, FK |
| status | Unknown |  |

### approval

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_approval_request_id | Unknown | PK, FK |
| decision_mode | Unknown |  |
| status | Unknown |  |
| subject_id | Unknown |  |
| subject_type | Unknown |  |
| type | Unknown |  |

### job_position

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | FK |
| changed_on | Unknown |  |

### users_access_groups

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK |
| users_id | Unknown | PK, FK |

### users_seats

| Column | Type | Keys |
| --- | --- | --- |
| value | Unknown | PK |
| users_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| profile_id | Unknown | PK, FK |
| 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 | PK, FK |
| job_approval_request_job_id | Unknown | PK, FK |
| job_position_id | Unknown | FK |

### job_approval_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| salary_range_currency | Unknown |  |
| salary_range_max | Unknown |  |
| salary_range_min | Unknown |  |

### job_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| 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 | PK, FK |
| job_id | Unknown | PK, FK |
| label | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |
| value_label | Unknown |  |

### interviewer

| Column | Type | Keys |
| --- | --- | --- |
| interview_id | Unknown | PK, FK |
| interview_timeslot_id | Unknown | PK, FK |
| interviewer_id | Unknown | PK, FK |
| status | Unknown |  |

### interview_timeslot

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| interview_id | Unknown | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | FK |
| role | Unknown |  |

## Relationships

- candidate_screening_answer_record_value(candidate_screening_answer_id) → candidate_screening_answer_record(candidate_screening_answer_id)
- candidate_screening_answer_record_value(candidate_screening_answer_record_id) → candidate_screening_answer_record(id)
- candidate_screening_answer_record(candidate_screening_answer_id) → candidate_screening_answer(id)
- candidate_screening_answer(candidate_id) → candidate(id)
- offer(candidate_id) → candidate(id)
- offer(job_id) → job(id)
- candidate_status_history(candidate_id) → candidate(id)
- candidate_status_history(job_id) → job(id)
- candidate_education(candidate_id) → candidate(id)
- candidate_experience(candidate_id) → candidate(id)
- candidate_secondary_assignment(job_id) → job(id)
- candidate_secondary_assignment(candidate_id) → candidate(id)
- candidate(primary_assignment_job_id) → job(id)
- reviews(candidate_id) → candidate(id)
- reviews(job_id) → job(id)
- reviews(reviewer_id) → users(id)
- hiring_process_substatus_in_review(hiring_process_id) → hiring_process(id)
- hiring_process_substatus_interview(hiring_process_id) → hiring_process(id)
- hiring_process_substatus_offered(hiring_process_id) → hiring_process(id)
- candidate_application(source) → candidate_source(label)
- candidate_application(candidate_id) → candidate(id)
- candidate_application(job_id) → job(id)
- approval_step_approver(approval_id) → approval_step(approval_id)
- approval_step(approval_id) → approval(id)
- approval(job_approval_request_id) → job_approval_request(id)
- job_position(job_id) → job(id)
- job_status_history(user_id) → users(id)
- job_status_history(job_id) → job(id)
- users_access_groups(users_id) → users(id)
- users_seats(users_id) → users(id)
- company_active_posting_custom_field(company_active_posting_id) → company_active_posting(id)
- company_active_posting(job_id) → job(id)
- company_active_posting(company_id) → company(id)
- job_application(profile_id) → candidate_application(id)
- job_application(job_id) → job(id)
- job_approval_position(job_position_id) → job_position(id)
- job_approval_position(job_approval_request_job_id) → job_approval_request(job_id)
- job_approval_position(job_approval_request_id) → job_approval_request(id)
- job_approval_request(job_id) → job(id)
- job_property(job_id) → job(id)
- job(department_id) → department(id)
- job(creator_id) → users(id)
- candidate_property(candidate_id) → candidate(id)
- candidate_property(job_id) → job(id)
- interviewer(interviewer_id) → users(id)
- interviewer(interview_timeslot_id) → interview_timeslot(id)
- interviewer(interview_id) → interview_timeslot(interview_id)
- interview_timeslot(interview_id) → interview(id)
- interview(organizer_id) → users(id)
- interview(job_id) → job(id)
- interview(candidate_id) → candidate(id)
- interview(candidate_application_id) → candidate_application(id)
- job_publication(source_name) → candidate_source(label)
- job_publication(job_id) → job(id)
- job_hiring_team(user_id) → users(id)
- job_hiring_team(job_id) → job(id)