# Greenhouse schema ERD

Table and field reference for the Fivetran Greenhouse connector.

## Table & Field Reference

### demographic_answer_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| demographic_question_id | Long | FK |
| active | Boolean |  |
| created_at | Instant |  |
| decline_to_answer | Boolean |  |
| free_form | Boolean |  |
| name | String |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### job_history

| Column | Type | Keys |
| --- | --- | --- |
| updated_at | Instant | PK |
| job_id | Long | PK, FK |
| closed_at | Instant |  |
| confidential | Boolean |  |
| name | String |  |
| notes | String |  |
| requisition_id | String |  |
| status | String |  |

### application_history

| Column | Type | Keys |
| --- | --- | --- |
| updated_at | Instant | PK |
| application_id | Long | PK, FK |
| new_stage_id | Long | FK |
| new_status | String |  |

### offer_history

| Column | Type | Keys |
| --- | --- | --- |
| updated_at | Instant | PK |
| offer_id | Long | PK, FK |
| application_id | Long | FK |
| resolved_at | Instant |  |
| sent_at | LocalDate |  |
| starts_at | LocalDate |  |
| status | String |  |
| version | Long |  |

### demographic_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| demographic_question_set_id | Long | FK |
| active | Boolean |  |
| answer_type | String |  |
| created_at | Instant |  |
| name | String |  |
| required | Boolean |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### rejection_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| rejected_by_id | Long | FK |
| rejection_reason_id | Long | FK |
| created_at | Instant |  |
| rejected_at | Instant |  |
| rejection_note_id | Long |  |
| updated_at | Instant |  |
| custom_** |  |  |

### job_post_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_post_id | Long | FK |
| office_id | Long | FK |
| created_at | Instant |  |
| custom_location_id | Long |  |
| plain_text_location | String |  |
| type | String |  |
| updated_at | Instant |  |

### office

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_id | Long | FK |
| primary_in_house_contact_user_id | Long | FK |
| created_at | Instant |  |
| external_id | String |  |
| location | String |  |
| name | String |  |
| updated_at | Instant |  |

### discipline

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| created_at | Instant |  |
| custom_field_id | Long |  |
| external_id | String |  |
| name | String |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### source

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| name | String |  |
| type_id | Long |  |
| type_name | String |  |
| updated_at | Instant |  |

### demographic_question_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| enabled | Boolean |  |
| title | String |  |
| updated_at | Instant |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| candidate_id | Long | FK |
| job_id | Long | FK |
| opening_id | Long | FK |
| created_at | Instant |  |
| resolved_at | Instant |  |
| sent_on | LocalDate |  |
| starts_on | LocalDate |  |
| status | String |  |
| updated_at | Instant |  |
| version | Long |  |
| custom_** |  |  |

### job_candidate_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| active | Boolean |  |
| candidate_attribute_type_id | Long |  |
| created_at | Instant |  |
| name | String |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### school

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| created_at | Instant |  |
| custom_field_id | Long |  |
| external_id | String |  |
| name | String |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### rejection_reason

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| name | String |  |
| type_id | Long |  |
| type_key | String |  |
| type_name | String |  |
| updated_at | Instant |  |

### user_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| user_id | Long | FK |
| created_at | Instant |  |
| email | String |  |
| updated_at | Instant |  |
| verification_token_sent_at | Instant |  |
| verified | Boolean |  |

### approval_flow

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| offer_id | Long | FK |
| requested_by_id | Long | FK |
| approval_status | String |  |
| approval_type | String |  |
| created_at | Instant |  |
| sequential | Boolean |  |
| updated_at | Instant |  |
| version | Int |  |

### prospect_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| department_id | Long | FK |
| office_id | Long | FK |
| pool_id | Long | FK |
| pool_stage_id | Long | FK |
| prospect_owner_id | Long | FK |
| created_at | Instant |  |
| updated_at | Instant |  |

### scorecard_question_answer_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| scorecard_question_answer_id | Long | FK |
| scorecard_question_option_id | Long | FK |
| created_at | Instant |  |
| updated_at | Instant |  |

### degree

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| created_at | Instant |  |
| custom_field_id | Long |  |
| external_id | String |  |
| name | String |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### prospect_pool_department

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| prospect_pool_id | Long | PK, FK |
| department_id | Long |  |

### prospect_pool_office

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| prospect_pool_id | Long | PK, FK |
| office_id | Long |  |

### prospect_pool_job

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| prospect_pool_id | Long | PK, FK |
| job_id | Long |  |

### prospect_pool

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| updated_at | Instant |  |

### application_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| job_interview_stage_id | Long | FK |
| created_at | Instant |  |
| current | Boolean |  |
| days_in_stage | Int |  |
| entered_at | Instant |  |
| exited_at | Instant |  |
| updated_at | Instant |  |

### approver_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| approval_flow_id | Long | FK |
| approvals_required | Int |  |
| created_at | Instant |  |
| required_for_exception | Boolean |  |
| resolved_at | Instant |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### user_linked_candidate

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| user_id | Long | PK, FK |
| candidate_id | Long | FK |

### user_office

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| user_id | Long | PK, FK |
| office_id | Long | FK |

### user_department

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| user_id | Long | PK, FK |
| department_id | Long | FK |

### user_interviewer_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| user_id | Long | PK, FK |
| name | String |  |
| tag_id | Long |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| agency_id | Long |  |
| created_at | Instant |  |
| deactivated | Boolean |  |
| employee_id | String |  |
| first_name | String |  |
| job_title | String |  |
| last_name | String |  |
| name | String |  |
| primary_email | String |  |
| site_admin | Boolean |  |
| updated_at | Instant |  |
| custom_** |  |  |

### candidate_employment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| candidate_id | Long | FK |
| company_name | String |  |
| created_at | Instant |  |
| end_date | String |  |
| latest | Boolean |  |
| start_date | String |  |
| title | String |  |
| updated_at | Instant |  |

### job_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| user_id | Long | FK |
| created_at | Instant |  |
| responsible | Boolean |  |
| type | String |  |
| updated_at | Instant |  |

### close_reason

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |

### scorecard_question_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| scorecard_question_id | Long | FK |
| active | Boolean |  |
| created_at | Instant |  |
| name | String |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### candidate_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |

### job_office

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| job_id | Long | PK, FK |
| office_id | Long |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| department_id | Long | FK |
| closed_at | Instant |  |
| confidential | Boolean |  |
| copied_from_id | Long |  |
| created_at | Instant |  |
| is_template | Boolean |  |
| name | String |  |
| notes | String |  |
| opened_at | Instant |  |
| requisition_id | String |  |
| status | String |  |
| updated_at | Instant |  |
| custom_** |  |  |

### email_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| user_id | Long | FK |
| body | String |  |
| cc_coordinator | Boolean |  |
| cc_recruiter | Boolean |  |
| created_at | Instant |  |
| description | String |  |
| email_type | String |  |
| from_type | String |  |
| html_body | String |  |
| is_default | Boolean |  |
| name | String |  |
| office_anywhere | Boolean |  |
| recipients | String |  |
| subject | String |  |
| updated_at | Instant |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| candidate_id | Long | FK |
| user_id | Long | FK |
| body | String |  |
| body_with_tags | String |  |
| created_at | Instant |  |
| email_attachment_file_names | String |  |
| email_cc | Json |  |
| email_from | String |  |
| email_to | String |  |
| import_hash | String |  |
| subject | String |  |
| type | String |  |
| updated_at | Instant |  |
| visibility | String |  |

### prospect_pool_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| prospect_pool_id | Long | FK |
| created_at | Instant |  |
| name | String |  |
| sort_order | Long |  |
| updated_at | Instant |  |

### job_interview_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| active | Boolean |  |
| created_at | Instant |  |
| name | String |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### scorecard

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| interviewer_id | Long | FK |
| submitter_id | Long | FK |
| candidate_rating | String |  |
| created_at | Instant |  |
| interview_kit_id | Long |  |
| interviewed_at | Instant |  |
| notes | String |  |
| notes_with_tags | String |  |
| private_notes | String |  |
| private_notes_with_tags | String |  |
| public_notes | String |  |
| public_notes_with_tags | String |  |
| status | String |  |
| submitted_at | Instant |  |
| updated_at | Instant |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| name | String |  |
| role_type | String |  |
| updated_at | Instant |  |

### candidate_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| candidate_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### candidate_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| candidate_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### candidate_email_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| candidate_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### candidate_website_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| candidate_id | Long | PK, FK |
| type | String |  |
| value | String |  |

### candidate_social_media_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| candidate_id | Long | PK, FK |
| value | String |  |

### candidate_linked_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| candidate_id | Long | PK, FK |
| user_id | Long |  |

### candidate_tag_link

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| candidate_id | Long | PK, FK |
| tag_name | String |  |

### candidate

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| can_email | Boolean |  |
| company | String |  |
| created_at | Instant |  |
| first_name | String |  |
| last_activity_at | Instant |  |
| last_name | String |  |
| preferred_name | String |  |
| private | Boolean |  |
| time_zone | String |  |
| title | String |  |
| updated_at | Instant |  |
| custom_** |  |  |

### attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| candidate_id | Long | FK |
| created_at | Instant |  |
| filename | String |  |
| type | String |  |
| updated_at | Instant |  |
| url | String |  |

### job_post_question_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| job_post_id | Long | PK, FK |
| job_post_question_index | Int | PK, FK |
| label | String |  |
| option_id | Long |  |

### job_post_question

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| job_post_id | Long | PK, FK |
| answer_type | String |  |
| description | String |  |
| label | String |  |
| name | String |  |
| private | Boolean |  |
| question_id | Long |  |
| required | Boolean |  |

### job_post

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| active | Boolean |  |
| content | String |  |
| created_at | Instant |  |
| demographic_question_set_id | Long |  |
| featured | Boolean |  |
| first_published_at | Instant |  |
| internal | Boolean |  |
| internal_content | String |  |
| job_board_id | Long |  |
| language_code | String |  |
| live | Boolean |  |
| public_url | String |  |
| title | String |  |
| updated_at | Instant |  |

### eeoc

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| candidate_id | Long | FK |
| created_at | Instant |  |
| disability_status_description | String |  |
| disability_status_id | Long |  |
| gender_description | String |  |
| gender_id | Long |  |
| race_description | String |  |
| race_id | Long |  |
| submitted_at | Instant |  |
| updated_at | Instant |  |
| veteran_status_description | String |  |
| veteran_status_id | Long |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_id | Long | FK |
| created_at | Instant |  |
| external_id | String |  |
| name | String |  |
| updated_at | Instant |  |

### approver

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| approver_group_id | Long | FK |
| reminder_sent_by_id | Long | FK |
| resolved_by_id | Long | FK |
| user_id | Long | FK |
| added_by_custom_field_id | Long |  |
| auto_reminders_sent | Int |  |
| created_at | Instant |  |
| reminder_sent_at | Instant |  |
| reminders_sent | Int |  |
| request_sent_at | Instant |  |
| resolved_at | Instant |  |
| send_auto_reminder_at | String |  |
| sort_order | Int |  |
| status | String |  |
| updated_at | Instant |  |
| version_sent | Int |  |

### interviewer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| interview_id | Long | FK |
| user_id | Long | FK |
| created_at | Instant |  |
| email | String |  |
| response_status | String |  |
| scorecard_id | Long |  |
| updated_at | Instant |  |

### scorecard_candidate_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_candidate_attribute_id | Long | FK |
| scorecard_id | Long | FK |
| candidate_attribute_rating | String |  |
| created_at | Instant |  |
| note | String |  |
| updated_at | Instant |  |

### job_hiring_manager

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| user_id | Long | FK |
| created_at | Instant |  |
| updated_at | Instant |  |

### candidate_education

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| candidate_id | Long | FK |
| degree_custom_field_option_id | Long | FK |
| discipline_custom_field_option_id | Long | FK |
| school_name_custom_field_option_id | Long | FK |
| created_at | Instant |  |
| end_at | Instant |  |
| end_date_month | Int |  |
| end_date_year | Int |  |
| latest | Boolean |  |
| start_at | Instant |  |
| start_date_month | Int |  |
| start_date_year | Int |  |
| updated_at | Instant |  |

### interview_kit

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| job_interview_id | Long | FK |
| anonymize_candidate | Boolean |  |
| anonymize_resumes | Boolean |  |
| created_at | Instant |  |
| exercises | String |  |
| updated_at | Instant |  |

### opening

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| close_reason_id | Long | FK |
| job_id | Long | FK |
| closed_at | Instant |  |
| created_at | Instant |  |
| is_open | Boolean |  |
| opened_at | Instant |  |
| opening_id | String |  |
| sort_order | Int |  |
| target_start_on | LocalDate |  |
| updated_at | Instant |  |
| custom_** |  |  |

### job_interview

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| job_interview_stage_id | Long | FK |
| active | Boolean |  |
| created_at | Instant |  |
| duration | Int |  |
| instruction | String |  |
| name | String |  |
| require_scorecard | Boolean |  |
| scheduling_type | String |  |
| sort_order | Int |  |
| summary | String |  |
| updated_at | Instant |  |

### demographic_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| demographic_answer_option_id | Long | FK |
| demographic_question_id | Long | FK |
| created_at | Instant |  |
| free_form_text | String |  |
| updated_at | Instant |  |

### referrer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| user_id | Long | FK |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |

### user_job_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| job_id | Long | FK |
| role_id | Long | FK |
| user_id | Long | FK |
| automated | Boolean |  |
| created_at | Instant |  |
| updated_at | Instant |  |

### scorecard_question_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| scorecard_id | Long | FK |
| scorecard_question_id | Long | FK |
| answer | String |  |
| answer_with_tag | String |  |
| boolean_value | Boolean |  |
| created_at | Instant |  |
| updated_at | Instant |  |
| value | Json |  |

### application_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| application_id | Long | PK, FK |
| answer | String |  |
| question | String |  |

### application_prospective_job

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| application_id | Long | PK, FK |
| job_id | Long |  |

### application

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| candidate_id | Long | FK |
| coordinator_id | Long | FK |
| job_id | Long | FK |
| job_post_id | Long | FK |
| recruiter_id | Long | FK |
| referrer_id | Long | FK |
| source_id | Long | FK |
| stage_id | Long | FK |
| agency_note_id | Long |  |
| created_at | Instant |  |
| last_activity_at | Instant |  |
| location_address | String |  |
| needs_decision | Boolean |  |
| prospect | Boolean |  |
| rejected_at | Instant |  |
| stage_name | String |  |
| status | String |  |
| updated_at | Instant |  |
| custom_** |  |  |

### scorecard_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| interview_kit_id | Long | FK |
| active | Boolean |  |
| answer_type | String |  |
| created_at | Instant |  |
| question | String |  |
| required | Boolean |  |
| sort_order | Int |  |
| updated_at | Instant |  |

### interview

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| application_id | Long | FK |
| job_id | Long | FK |
| organizer_id | Long | FK |
| all_day_end_on | String |  |
| all_day_start_on | String |  |
| availability_received_at | Instant |  |
| created_at | Instant |  |
| ends_at | Instant |  |
| external_event_id | String |  |
| job_interview_id | Long |  |
| location | String |  |
| scheduled_at | Instant |  |
| starts_at | Instant |  |
| status | String |  |
| updated_at | Instant |  |
| video_conferencing_url | String |  |

## Relationships

- demographic_answer_option(demographic_question_id) → demographic_question(id)
- job_history(job_id) → job(id)
- application_history(application_id) → application(id)
- application_history(new_stage_id) → job_interview_stage(id)
- offer_history(offer_id) → offer(id)
- offer_history(application_id) → application(id)
- demographic_question(demographic_question_set_id) → demographic_question_set(id)
- rejection_detail(application_id) → application(id)
- rejection_detail(rejected_by_id) → users(id)
- rejection_detail(rejection_reason_id) → rejection_reason(id)
- job_post_location(job_post_id) → job_post(id)
- job_post_location(office_id) → office(id)
- office(primary_in_house_contact_user_id) → users(id)
- office(parent_id) → office(id)
- offer(application_id) → application(id)
- offer(opening_id) → opening(id)
- offer(job_id) → job(id)
- offer(candidate_id) → candidate(id)
- job_candidate_attribute(job_id) → job(id)
- user_email(user_id) → users(id)
- approval_flow(requested_by_id) → users(id)
- approval_flow(job_id) → job(id)
- approval_flow(offer_id) → offer(id)
- prospect_detail(prospect_owner_id) → users(id)
- prospect_detail(application_id) → application(id)
- prospect_detail(department_id) → department(id)
- prospect_detail(pool_id) → prospect_pool(id)
- prospect_detail(office_id) → office(id)
- prospect_detail(pool_stage_id) → prospect_pool_stage(id)
- scorecard_question_answer_option(scorecard_question_answer_id) → scorecard_question_answer(id)
- scorecard_question_answer_option(scorecard_question_option_id) → scorecard_question_option(id)
- prospect_pool_department(prospect_pool_id) → prospect_pool(id)
- prospect_pool_office(prospect_pool_id) → prospect_pool(id)
- prospect_pool_job(prospect_pool_id) → prospect_pool(id)
- application_stage(job_interview_stage_id) → job_interview_stage(id)
- application_stage(application_id) → application(id)
- approver_group(approval_flow_id) → approval_flow(id)
- user_linked_candidate(candidate_id) → candidate(id)
- user_linked_candidate(user_id) → users(id)
- user_office(office_id) → office(id)
- user_office(user_id) → users(id)
- user_department(department_id) → department(id)
- user_department(user_id) → users(id)
- user_interviewer_tag(user_id) → users(id)
- candidate_employment(candidate_id) → candidate(id)
- job_owner(job_id) → job(id)
- job_owner(user_id) → users(id)
- scorecard_question_option(scorecard_question_id) → scorecard_question(id)
- job_office(job_id) → job(id)
- job(department_id) → department(id)
- email_template(user_id) → users(id)
- note(user_id) → users(id)
- note(application_id) → application(id)
- note(candidate_id) → candidate(id)
- prospect_pool_stage(prospect_pool_id) → prospect_pool(id)
- job_interview_stage(job_id) → job(id)
- scorecard(application_id) → application(id)
- scorecard(interviewer_id) → interviewer(id)
- scorecard(submitter_id) → users(id)
- candidate_phone_number(candidate_id) → candidate(id)
- candidate_address(candidate_id) → candidate(id)
- candidate_email_address(candidate_id) → candidate(id)
- candidate_website_address(candidate_id) → candidate(id)
- candidate_social_media_address(candidate_id) → candidate(id)
- candidate_linked_user(candidate_id) → candidate(id)
- candidate_tag_link(candidate_id) → candidate(id)
- attachment(application_id) → application(id)
- attachment(candidate_id) → candidate(id)
- job_post_question_option(job_post_id) → job_post_question(job_post_id)
- job_post_question_option(job_post_question_index) → job_post_question(index)
- job_post_question(job_post_id) → job_post(id)
- job_post(job_id) → job(id)
- eeoc(application_id) → application(id)
- eeoc(candidate_id) → candidate(id)
- department(parent_id) → department(id)
- approver(approver_group_id) → approver_group(id)
- approver(user_id) → users(id)
- approver(resolved_by_id) → users(id)
- approver(reminder_sent_by_id) → users(id)
- interviewer(interview_id) → interview(id)
- interviewer(user_id) → users(id)
- scorecard_candidate_attribute(job_candidate_attribute_id) → job_candidate_attribute(id)
- scorecard_candidate_attribute(scorecard_id) → scorecard(id)
- job_hiring_manager(job_id) → job(id)
- job_hiring_manager(user_id) → users(id)
- candidate_education(degree_custom_field_option_id) → degree(id)
- candidate_education(school_name_custom_field_option_id) → school(id)
- candidate_education(candidate_id) → candidate(id)
- candidate_education(discipline_custom_field_option_id) → discipline(id)
- interview_kit(job_id) → job(id)
- interview_kit(job_interview_id) → job_interview(id)
- opening(application_id) → application(id)
- opening(job_id) → job(id)
- opening(close_reason_id) → close_reason(id)
- job_interview(job_interview_stage_id) → job_interview_stage(id)
- job_interview(job_id) → job(id)
- demographic_answer(application_id) → application(id)
- demographic_answer(demographic_answer_option_id) → demographic_answer_option(id)
- demographic_answer(demographic_question_id) → demographic_question(id)
- referrer(user_id) → users(id)
- user_job_permission(job_id) → job(id)
- user_job_permission(role_id) → user_role(id)
- user_job_permission(user_id) → users(id)
- scorecard_question_answer(scorecard_id) → scorecard(id)
- scorecard_question_answer(scorecard_question_id) → scorecard_question(id)
- application_answer(application_id) → application(id)
- application_prospective_job(application_id) → application(id)
- application(stage_id) → application_stage(id)
- application(job_post_id) → job_post(id)
- application(coordinator_id) → users(id)
- application(referrer_id) → referrer(id)
- application(job_id) → job(id)
- application(candidate_id) → candidate(id)
- application(source_id) → source(id)
- application(recruiter_id) → users(id)
- scorecard_question(interview_kit_id) → interview_kit(id)
- interview(application_id) → application(id)
- interview(organizer_id) → users(id)
- interview(job_id) → job(id)