# Workable schema ERD

Table and field reference for the Fivetran Workable connector.

## Table & Field Reference

### requisition_approver

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| requisition_approval_group_id | Unknown | FK |
| decision | Unknown |  |
| name | Unknown |  |

### requisition_approval_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| requisition_id | Unknown | FK |

### requisition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| department_id | Unknown | FK |
| hiring_manager_id | Unknown | FK |
| job_id | Unknown | FK |
| owner_id | Unknown | FK |
| codes | Unknown |  |
| employment_type | Unknown |  |
| location_city | Unknown |  |
| location_country | Unknown |  |
| location_country_code | Unknown |  |
| location_region | Unknown |  |
| location_region_code | Unknown |  |
| location_str | Unknown |  |
| location_zip_code | Unknown |  |
| plan_date | Unknown |  |
| reason | Unknown |  |
| requester_id | Unknown |  |
| requester_name | Unknown |  |
| salary_range_currency | Unknown |  |
| salary_range_frequency | Unknown |  |
| salary_range_salary_from | Unknown |  |
| salary_range_salary_to | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| requisition_custom_attributes_** |  |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| address | Unknown |  |
| avatar | Unknown |  |
| department_id | Unknown |  |
| division_id | Unknown |  |
| email | Unknown |  |
| employee_number | Unknown |  |
| first_name | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| legal_entity_id | Unknown |  |
| manager_id | Unknown |  |
| phone | Unknown |  |
| roles | Json |  |
| start_date | Unknown |  |
| state | Unknown |  |
| template_id | Unknown |  |
| work_email | Unknown |  |
| work_schedule_id | Unknown |  |

### candidate_education_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| degree | Unknown |  |
| end_date | Unknown |  |
| field_of_study | Unknown |  |
| school | Unknown |  |
| start_date | Unknown |  |

### candidate_experience_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| company | Unknown |  |
| current | Unknown |  |
| end_date | Unknown |  |
| industry | Unknown |  |
| start_date | Unknown |  |
| summary | Unknown |  |
| title | Unknown |  |

### candidate_social_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| username | Unknown |  |

### candidate_answer

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| candidate_id | Unknown | PK, FK |
| question | Unknown |  |
| custom_** |  |  |

### candidate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_shortcode | Unknown | FK |
| account_name | Unknown |  |
| account_sub_domain | Unknown |  |
| address | Unknown |  |
| cover_letter | Unknown |  |
| created_at | Unknown |  |
| disqualification_reason | Unknown |  |
| disqualified | Unknown |  |
| disqualified_at | Unknown |  |
| domain | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| head_line | Unknown |  |
| hired_at | Unknown |  |
| last_name | Unknown |  |
| location_city | Unknown |  |
| location_country | Unknown |  |
| location_country_code | Unknown |  |
| location_region | Unknown |  |
| location_region_code | Unknown |  |
| location_str | Unknown |  |
| location_zip_code | Unknown |  |
| name | Unknown |  |
| originating_candidate_id | Unknown |  |
| phone | Unknown |  |
| resume_url | Unknown |  |
| skills | Json |  |
| sourced | Unknown |  |
| stage | Unknown |  |
| summary | Unknown |  |
| updated_at | Unknown |  |
| uploader_id | Unknown |  |

### job_question_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_question_id | Unknown | PK, FK |
| body | Unknown |  |

### job_question_file_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_question_id | Unknown | PK, FK |
| file_type | Unknown |  |

### job_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| body | Unknown |  |
| max_file_size | Unknown |  |
| required | Unknown |  |
| single_answer | Unknown |  |
| type | Unknown |  |

### job_activity

| Column | Type | Keys |
| --- | --- | --- |
| action | Unknown | PK |
| job_id | Unknown | PK, FK |
| candidate_id | Unknown | FK |
| member_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| stage_name | Unknown |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| head_line | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |

### event_member

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| job_shortcode | Unknown | FK |
| description | Unknown |  |
| ends_at | Unknown |  |
| starts_at | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### job_application_supported_file_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_application_form_key | Unknown | PK, FK |
| job_id | Unknown | PK, FK |
| file_type | Unknown |  |

### job_application_field

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| job_application_form_key | Unknown | PK, FK |
| job_id | Unknown | PK, FK |
| label | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### job_application_form

| Column | Type | Keys |
| --- | --- | --- |
| key | Unknown | PK |
| job_id | Unknown | PK, FK |
| label | Unknown |  |
| max_file_size | Unknown |  |
| multiple | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### employee_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| created_at | Instant |  |
| created_by | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| files_path | Unknown |  |
| updated_at | Instant |  |

### job_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| job_id | Unknown | PK, FK |

### candidate_document_variable

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| candidate_offer_candidate_id | Unknown | FK |
| name | Unknown |  |
| slug | Unknown |  |
| custom_value_** |  |  |

### candidate_offer_document

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| candidate_offer_candidate_id | Unknown | FK |
| kind | Unknown |  |
| name | Unknown |  |
| preview_url | Unknown |  |

### candidate_offer

| Column | Type | Keys |
| --- | --- | --- |
| candidate_id | Unknown | PK, FK |
| created_at | Unknown |  |
| state | Unknown |  |

### candidate_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| member_id | Unknown | FK |
| action | Unknown |  |
| body | Unknown |  |
| created_at | Unknown |  |
| stage_name | Unknown |  |

### recruiter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| name | Unknown |  |

### employee_field_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_field_id | Unknown | PK, FK |
| account_id | Unknown |  |
| can_edit_mapping | Unknown |  |
| label | Unknown |  |
| position | Unknown |  |

### employee_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| approvable_by | Unknown |  |
| editable_by | Unknown |  |
| hint | Unknown |  |
| is_multiple | Unknown |  |
| keep_history | Unknown |  |
| label | Unknown |  |
| type | Unknown |  |
| viewable_by | Unknown |  |

### job_recruiter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| job_id | Unknown | PK, FK |

### stage

| Column | Type | Keys |
| --- | --- | --- |
| position | Unknown | PK |
| name | Unknown |  |
| slug | Unknown |  |

### job_custom_attribute_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_custom_attribute_id | Unknown | PK, FK |
| body | Unknown |  |

### job_custom_attribute_file_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_custom_attribute_id | Unknown | PK, FK |
| file_type | Unknown |  |

### job_custom_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| label | Unknown |  |
| max_file_size | Unknown |  |
| provider | Unknown |  |
| required | Unknown |  |
| single_answer | Unknown |  |
| type | Unknown |  |

### job_deparment_hierarchy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | FK |
| name | Unknown |  |

### job_keyword

| Column | Type | Keys |
| --- | --- | --- |
| keyword | Unknown | PK |
| job_id | Unknown | PK, FK |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| application_url | Unknown |  |
| benefits | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| department | Unknown |  |
| education | Unknown |  |
| employment_type | Unknown |  |
| experience | Unknown |  |
| full_description | Unknown |  |
| full_title | Unknown |  |
| function | Unknown |  |
| industry | Unknown |  |
| location_city | Unknown |  |
| location_country | Unknown |  |
| location_country_code | Unknown |  |
| location_region | Unknown |  |
| location_region_code | Unknown |  |
| location_str | Unknown |  |
| location_telecommuting | Unknown |  |
| location_zip_code | Unknown |  |
| requirements | Unknown |  |
| shortcode | Unknown |  |
| shortlink | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |

### job_stage

| Column | Type | Keys |
| --- | --- | --- |
| job_id | Unknown | PK, FK |
| position | Unknown | PK, FK |

## Relationships

- requisition_approver(id) → member(id)
- requisition_approver(requisition_approval_group_id) → requisition_approval_group(id)
- requisition_approval_group(requisition_id) → requisition(id)
- requisition(owner_id) → member(id)
- requisition(hiring_manager_id) → member(id)
- requisition(job_id) → job(id)
- requisition(department_id) → job_deparment_hierarchy(id)
- employee(candidate_id) → candidate(id)
- candidate_education_entry(candidate_id) → candidate(id)
- candidate_experience_entry(candidate_id) → candidate(id)
- candidate_social_profile(candidate_id) → candidate(id)
- candidate_answer(candidate_id) → candidate(id)
- candidate(job_shortcode) → job(shortcode)
- job_question_choice(job_question_id) → job_question(id)
- job_question_file_type(job_question_id) → job_question(id)
- job_question(job_id) → job(id)
- job_activity(candidate_id) → candidate(id)
- job_activity(member_id) → member(id)
- job_activity(job_id) → job(id)
- event_member(id) → member(id)
- event_member(event_id) → event(id)
- event(job_shortcode) → job(shortcode)
- event(candidate_id) → candidate(id)
- job_application_supported_file_type(job_application_form_key) → job_application_form(key)
- job_application_supported_file_type(job_id) → job_application_form(job_id)
- job_application_field(job_id) → job_application_form(job_id)
- job_application_field(job_application_form_key) → job_application_form(key)
- job_application_form(job_id) → job(id)
- employee_document(employee_id) → employee(id)
- job_member(id) → member(id)
- job_member(job_id) → job(id)
- candidate_document_variable(candidate_offer_candidate_id) → candidate_offer(candidate_id)
- candidate_offer_document(candidate_offer_candidate_id) → candidate_offer(candidate_id)
- candidate_offer(candidate_id) → candidate(id)
- candidate_activity(member_id) → member(id)
- candidate_activity(candidate_id) → candidate(id)
- employee_field_choice(employee_field_id) → employee_field(id)
- job_recruiter(id) → recruiter(id)
- job_recruiter(job_id) → job(id)
- job_custom_attribute_choice(job_custom_attribute_id) → job_custom_attribute(id)
- job_custom_attribute_file_type(job_custom_attribute_id) → job_custom_attribute(id)
- job_custom_attribute(job_id) → job(id)
- job_deparment_hierarchy(job_id) → job(id)
- job_keyword(job_id) → job(id)
- job_stage(position) → stage(position)
- job_stage(job_id) → job(id)