# FreshTeam schema ERD

Table and field reference for the Fivetran FreshTeam connector.

## Table & Field Reference

### candidate_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| skill | Unknown |  |

### candidate_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| tags | Unknown |  |

### candidate_profile_link

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

### candidate_qualification

| Column | Type | Keys |
| --- | --- | --- |
| degree | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| end_date | Unknown |  |
| field_of_study | Unknown |  |
| grade | Unknown |  |
| is_current | Unknown |  |
| school_name | Unknown |  |
| start_date | Unknown |  |
| summary | Unknown |  |

### candidate_position

| Column | Type | Keys |
| --- | --- | --- |
| title | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| company | Unknown |  |
| end_date | Unknown |  |
| is_current | Unknown |  |
| start_date | Unknown |  |
| summary | Unknown |  |

### candidate_resume

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| content_file_name | Unknown |  |
| content_file_size | Unknown |  |
| description | Unknown |  |
| url | Unknown |  |

### candidate_cover_letter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| content_file_name | Unknown |  |
| content_file_size | Unknown |  |
| description | Unknown |  |
| url | Unknown |  |

### candidate_portfolios

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | PK, FK |
| content_file_name | Unknown |  |
| content_file_size | Unknown |  |
| description | Unknown |  |
| url | Unknown |  |

### candidate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| owner_id | Unknown | FK |
| source_category_id | Unknown | FK |
| source_id | Unknown | FK |
| cool_off_date | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| eeo_disabled | Unknown |  |
| eeo_ethnicity | Unknown |  |
| eeo_gender | Unknown |  |
| eeo_veteran | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| last_name | Unknown |  |
| location_city | Unknown |  |
| location_country_code | Unknown |  |
| location_state | Unknown |  |
| location_street | Unknown |  |
| location_zip_code | Unknown |  |
| middle_name | Unknown |  |
| mobile | Unknown |  |
| other_attachment | Json |  |
| phone | Unknown |  |
| skype_id | Unknown |  |
| spam | Unknown |  |
| total_experience_in_month | Unknown |  |
| updated_at | Unknown |  |

### source_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| is_default | Unknown |  |
| label | Unknown |  |
| leads_count | Unknown |  |
| updated_at | Unknown |  |

### new_hire_work_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| name | Unknown |  |
| number | Unknown |  |

### new_hire_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| masked | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |

### new_hire_emergency_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| address | Unknown |  |
| contact_number | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| relationship | Unknown |  |

### new_hire_social_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### new_hire_time_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| availed | Unknown |  |
| credit | Unknown |  |
| name | Unknown |  |

### new_hire_dependent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| date_of_birth | Unknown |  |
| deleted | Unknown |  |
| gender | Unknown |  |
| name | Unknown |  |
| relationship | Unknown |  |

### new_hire_previous_employment_reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| previous_employment_id | Unknown | PK, FK |
| contact_number | Unknown |  |
| name | Unknown |  |

### new_hire_previous_employment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| company | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| job_type | Unknown |  |
| other_salary_components | Unknown |  |
| role | Unknown |  |
| salary_value | Unknown |  |
| start_date | Unknown |  |

### new_hire_qualification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| course | Unknown |  |
| degree | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| grade_average | Unknown |  |
| institue_name | Unknown |  |
| pass_out_date | Unknown |  |
| start_date | Unknown |  |

### new_hire_bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| account_number | Unknown |  |
| bank_name | Unknown |  |
| branch_code | Unknown |  |
| deleted | Unknown |  |
| name_as_per_account | Unknown |  |

### new_hire_compensation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| annual_amount | Unknown |  |
| cost_center_id | Unknown |  |
| cost_center_value | Unknown |  |
| currency | Unknown |  |
| current | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| effective_date | Unknown |  |
| eligible_work_hour | Unknown |  |
| other_component | Unknown |  |
| pay_factor | Unknown |  |
| pay_group_id | Unknown |  |
| pay_group_value | Unknown |  |
| pay_method_id | Unknown |  |
| pay_method_value | Unknown |  |
| pay_rate_id | Unknown |  |
| pay_rate_name | Unknown |  |
| pay_rate_value | Unknown |  |
| pay_schedule_id | Unknown |  |
| pay_schedule_name | Unknown |  |
| reason_id | Unknown |  |
| reason_value | Unknown |  |
| variable_pay | Unknown |  |
| variable_pay_detail | Unknown |  |
| variable_pay_frequency_id | Unknown |  |
| variable_pay_frequency_name | Unknown |  |
| work_hour_rate_id | Unknown |  |
| work_hour_rate_value | Unknown |  |

### new_hire_bonus

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| additional_detail | Unknown |  |
| bonus_type_id | Unknown |  |
| bonus_type_value | Unknown |  |
| currency | Unknown |  |
| deleted | Unknown |  |
| effective_date | Unknown |  |
| value | Unknown |  |

### new_hire_stock

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| currency | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| effective_date | Unknown |  |
| exercise_price | Unknown |  |
| exercise_price_discount | Unknown |  |
| expiration_date | Unknown |  |
| grant_date | Unknown |  |
| grant_number | Unknown |  |
| grant_reason_id | Unknown |  |
| grant_reason_value | Unknown |  |
| grant_type_id | Unknown |  |
| grant_type_value | Unknown |  |
| pay_rate_id | Unknown |  |
| pay_rate_name | Unknown |  |
| total_stock_units | Unknown |  |
| value_per_share | Unknown |  |
| vesting_period | Unknown |  |
| vesting_rate | Unknown |  |
| vesting_schedule | Unknown |  |
| vesting_type | Unknown |  |
| with_in_range | Unknown |  |

### new_hire_award

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| awarded_by | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |

### new_hire_honor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| awarded_by | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |

### new_hire_certificate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| awarded_by | Unknown |  |
| deleted | Unknown |  |
| grade | Unknown |  |
| name | Unknown |  |

### new_hire_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| deleted | Unknown |  |
| expiry_date | Unknown |  |
| name | Unknown |  |
| restrictions | Unknown |  |

### new_hire_background_verification_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| completion_date | Unknown |  |
| deleted | Unknown |  |
| initiation_date | Unknown |  |
| notes | Unknown |  |
| status | Unknown |  |
| vendor | Unknown |  |

### new_hire_visa

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| country_code | Unknown |  |
| deleted | Unknown |  |
| valid_from | Unknown |  |
| valid_to | Unknown |  |
| visa_number | Unknown |  |
| visa_type | Unknown |  |

### new_hire_government_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| new_hire_employee_id | Unknown | PK, FK |
| country_code | Unknown |  |
| deleted | Unknown |  |
| expiry_date | Unknown |  |
| issuing_authority | Unknown |  |
| issuing_date | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| type_id | Unknown |  |
| type_position | Unknown |  |
| type_value | Unknown |  |

### new_hire_role

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

### new_hire

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| business_unit_id | Unknown | FK |
| department_id | Unknown | FK |
| employee_id | Unknown | FK |
| hr_incharge_id | Unknown | FK |
| job_role_id | Unknown | FK |
| level_id | Unknown | FK |
| reporting_to_id | Unknown | FK |
| sub_department_id | Unknown | FK |
| team_id | Unknown | FK |
| user_function_id | Unknown | FK |
| actual_retirement_date | Unknown |  |
| additional_hr_manager | Json |  |
| additional_manager | Json |  |
| additional_team | Json |  |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| address_zip_code | Unknown |  |
| blood_group | Unknown |  |
| citizenship_status_id | Unknown |  |
| citizenship_status_value | Unknown |  |
| communication_address_city | Unknown |  |
| communication_address_country_code | Unknown |  |
| communication_address_same_as_residential | Unknown |  |
| communication_address_state | Unknown |  |
| communication_address_street | Unknown |  |
| communication_address_zip_code | Unknown |  |
| cost_center | Json |  |
| cost_center_id | Unknown |  |
| cost_center_value | Unknown |  |
| country_of_birth | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| deleted | Unknown |  |
| designation | Unknown |  |
| eeo_company_code | Unknown |  |
| eeo_disabled | Unknown |  |
| eeo_ethnicity | Unknown |  |
| eeo_job_category | Unknown |  |
| eeo_vetran | Unknown |  |
| employee_type | Unknown |  |
| employment_end_date | Unknown |  |
| end_time | Unknown |  |
| expected_retirement_date | Unknown |  |
| first_name | Unknown |  |
| flsa_required | Unknown |  |
| gender | Unknown |  |
| hereditary_last_name | Unknown |  |
| hire_reason | Unknown |  |
| id_card_detail | Unknown |  |
| im_address | Unknown |  |
| job_code | Unknown |  |
| job_exempt | Unknown |  |
| job_role_value | Unknown |  |
| joining_date | Unknown |  |
| languages | Json |  |
| last_name | Unknown |  |
| legal_name | Unknown |  |
| marital_status | Unknown |  |
| middle_name | Unknown |  |
| nick_name | Unknown |  |
| notice_end_date | Unknown |  |
| notice_period | Unknown |  |
| notice_start_date | Unknown |  |
| official_email | Unknown |  |
| personal_email | Unknown |  |
| place_of_birth | Unknown |  |
| previous_name | Unknown |  |
| previous_name_change_date | Unknown |  |
| probation_end_date | Unknown |  |
| probation_start_date | Unknown |  |
| retirement_eligibility_date | Unknown |  |
| retirement_status_id | Unknown |  |
| retirement_status_value | Unknown |  |
| scheduled_weekly_hour | Unknown |  |
| secondary_business_email | Unknown |  |
| secondary_last_name | Unknown |  |
| shift_id | Unknown |  |
| shift_value | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| termination_category_id | Unknown |  |
| termination_category_value | Unknown |  |
| termination_date | Unknown |  |
| termination_reason | Unknown |  |
| updated_at | Instant |  |
| user_academic_suffix_id | Unknown |  |
| user_academic_suffix_value | Unknown |  |
| user_honorary_suffix_id | Unknown |  |
| user_honorary_suffix_value | Unknown |  |
| user_professional_suffix_id | Unknown |  |
| user_professional_suffix_value | Unknown |  |
| user_suffix_id | Unknown |  |
| user_suffix_value | Unknown |  |
| user_title_id | Unknown |  |
| user_title_value | Unknown |  |
| work_hour | Unknown |  |
| workstation_number | Unknown |  |
| custom_** |  |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### level

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### business_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| is_deault | Unknown |  |
| label | Unknown |  |
| leads_count | Unknown |  |
| updated_at | Unknown |  |

### time_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applied_by_id | Unknown | FK |
| approved_by_id | Unknown | FK |
| cancelled_by_id | Unknown | FK |
| rejected_by_id | Unknown | FK |
| time_off_type_id | Unknown | FK |
| user_id | Unknown | FK |
| cancelled_at | Unknown |  |
| comments | Unknown |  |
| created_at | Unknown |  |
| end_date | LocalDate |  |
| leave_units | Unknown |  |
| optional_leave_units | Unknown |  |
| rejected_at | Unknown |  |
| start_date | LocalDate |  |
| status | Unknown |  |
| status_comments | Unknown |  |
| updated_at | Unknown |  |

### time_off_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicable_for | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| is_default | Unknown |  |
| marital_status | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### job_posting_field_picklist_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| field_id | Unknown | PK, FK |
| pickable_id | Unknown |  |
| pickable_type | Unknown |  |
| position | Unknown |  |
| value | Unknown |  |

### job_posting_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| field_type | Unknown |  |
| is_default | Unknown |  |
| job_form_id | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| public | Unknown |  |
| required | Unknown |  |
| restricted | Unknown |  |
| updated_at | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| sensitive | Unknown |  |
| updated_at | Unknown |  |

### user_function

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### sub_department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### branch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| city | Unknown |  |
| contact_info | Unknown |  |
| country_code | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| date_format | Unknown |  |
| deleted | Unknown |  |
| languages | Unknown |  |
| main_office | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| time_zone | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### employee_work_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |
| number | Unknown |  |

### employee_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| masked | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |

### employee_emergency_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| address | Unknown |  |
| contact_number | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| relationship | Unknown |  |

### employee_social_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### employee_time_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| availed | Unknown |  |
| credit | Unknown |  |
| name | Unknown |  |

### employee_dependent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| date_of_birth | Unknown |  |
| deleted | Unknown |  |
| gender | Unknown |  |
| name | Unknown |  |
| relationship | Unknown |  |

### employee_previous_employment_reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| previous_employment_id | Unknown | PK, FK |
| contact_number | Unknown |  |
| name | Unknown |  |

### employee_previous_employment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| company | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| job_type | Unknown |  |
| other_salary_components | Unknown |  |
| role | Unknown |  |
| salary_value | Unknown |  |
| start_date | Unknown |  |

### employee_qualification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| course | Unknown |  |
| degree | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| grade_average | Unknown |  |
| institue_name | Unknown |  |
| pass_out_date | Unknown |  |
| start_date | Unknown |  |

### employee_bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| account_number | Unknown |  |
| bank_name | Unknown |  |
| branch_code | Unknown |  |
| deleted | Unknown |  |
| name_as_per_account | Unknown |  |

### employee_compensation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| annual_amount | Unknown |  |
| cost_center_id | Unknown |  |
| cost_center_value | Unknown |  |
| currency | Unknown |  |
| current | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| effective_date | Unknown |  |
| eligible_work_hour | Unknown |  |
| other_component | Unknown |  |
| pay_factor | Unknown |  |
| pay_group_id | Unknown |  |
| pay_group_value | Unknown |  |
| pay_method_id | Unknown |  |
| pay_method_value | Unknown |  |
| pay_rate_id | Unknown |  |
| pay_rate_name | Unknown |  |
| pay_rate_value | Unknown |  |
| pay_schedule_id | Unknown |  |
| pay_schedule_name | Unknown |  |
| reason_id | Unknown |  |
| reason_value | Unknown |  |
| variable_pay | Unknown |  |
| variable_pay_detail | Unknown |  |
| variable_pay_frequency_id | Unknown |  |
| variable_pay_frequency_name | Unknown |  |
| work_hour_rate_id | Unknown |  |
| work_hour_rate_value | Unknown |  |

### employee_bonus

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| additional_detail | Unknown |  |
| bonus_type_id | Unknown |  |
| bonus_type_value | Unknown |  |
| currency | Unknown |  |
| deleted | Unknown |  |
| effective_date | Unknown |  |
| value | Unknown |  |

### employee_stock

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| currency | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| effective_date | Unknown |  |
| exercise_price | Unknown |  |
| exercise_price_discount | Unknown |  |
| expiration_date | Unknown |  |
| grant_date | Unknown |  |
| grant_number | Unknown |  |
| grant_reason_id | Unknown |  |
| grant_reason_value | Unknown |  |
| grant_type_id | Unknown |  |
| grant_type_value | Unknown |  |
| pay_rate_id | Unknown |  |
| pay_rate_name | Unknown |  |
| total_stock_units | Unknown |  |
| value_per_share | Unknown |  |
| vesting_period | Unknown |  |
| vesting_rate | Unknown |  |
| vesting_schedule | Unknown |  |
| vesting_type | Unknown |  |
| with_in_range | Unknown |  |

### employee_award

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| awarded_by | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |

### employee_honor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| awarded_by | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |

### employee_certificate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| awarded_by | Unknown |  |
| deleted | Unknown |  |
| grade | Unknown |  |
| name | Unknown |  |

### employee_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| deleted | Unknown |  |
| expiry_date | Unknown |  |
| name | Unknown |  |
| restrictions | Unknown |  |

### employee_background_verification_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| completion_date | Unknown |  |
| deleted | Unknown |  |
| initiation_date | Unknown |  |
| notes | Unknown |  |
| status | Unknown |  |
| vendor | Unknown |  |

### employee_visa

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| country_code | Unknown |  |
| deleted | Unknown |  |
| valid_from | Unknown |  |
| valid_to | Unknown |  |
| visa_number | Unknown |  |
| visa_type | Unknown |  |

### employee_government_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| country_code | Unknown |  |
| deleted | Unknown |  |
| expiry_date | Unknown |  |
| issuing_authority | Unknown |  |
| issuing_date | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| type_id | Unknown |  |
| type_position | Unknown |  |
| type_value | Unknown |  |

### employee_role

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

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| business_unit_id | Unknown | FK |
| department_id | Unknown | FK |
| hr_incharge_id | Unknown | FK |
| job_role_id | Unknown | FK |
| level_id | Unknown | FK |
| reporting_to_id | Unknown | FK |
| sub_department_id | Unknown | FK |
| team_id | Unknown | FK |
| user_function_id | Unknown | FK |
| actual_retirement_date | Unknown |  |
| additional_hr_manager | Json |  |
| additional_manager | Json |  |
| additional_team | Json |  |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| address_zip_code | Unknown |  |
| blood_group | Unknown |  |
| citizenship_status_id | Unknown |  |
| citizenship_status_value | Unknown |  |
| communication_address_city | Unknown |  |
| communication_address_country_code | Unknown |  |
| communication_address_same_as_residential | Unknown |  |
| communication_address_state | Unknown |  |
| communication_address_street | Unknown |  |
| communication_address_zip_code | Unknown |  |
| cost_center | Json |  |
| cost_center_id | Unknown |  |
| cost_center_value | Unknown |  |
| country_of_birth | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| deleted | Unknown |  |
| designation | Unknown |  |
| draft | Unknown |  |
| eeo_company_code | Unknown |  |
| eeo_disabled | Unknown |  |
| eeo_ethnicity | Unknown |  |
| eeo_job_category | Unknown |  |
| eeo_vetran | Unknown |  |
| employee_id | Unknown |  |
| employee_type | Unknown |  |
| employment_end_date | Unknown |  |
| end_time | Unknown |  |
| expected_retirement_date | Unknown |  |
| first_name | Unknown |  |
| flsa_required | Unknown |  |
| gender | Unknown |  |
| hereditary_last_name | Unknown |  |
| hire_reason | Unknown |  |
| hired_on | Unknown |  |
| id_card_detail | Unknown |  |
| im_address | Unknown |  |
| job_code | Unknown |  |
| job_exempt | Unknown |  |
| job_role_value | Unknown |  |
| joining_date | Unknown |  |
| languages | Json |  |
| last_name | Unknown |  |
| legal_name | Unknown |  |
| marital_status | Unknown |  |
| middle_name | Unknown |  |
| nick_name | Unknown |  |
| notice_end_date | Unknown |  |
| notice_period | Unknown |  |
| notice_start_date | Unknown |  |
| official_email | Unknown |  |
| personal_email | Unknown |  |
| place_of_birth | Unknown |  |
| previous_name | Unknown |  |
| previous_name_change_date | Unknown |  |
| probation_end_date | Unknown |  |
| probation_start_date | Unknown |  |
| retirement_eligibility_date | Unknown |  |
| retirement_status_id | Unknown |  |
| retirement_status_value | Unknown |  |
| scheduled_weekly_hour | Unknown |  |
| secondary_business_email | Unknown |  |
| secondary_last_name | Unknown |  |
| shift_id | Unknown |  |
| shift_value | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| termination_category_id | Unknown |  |
| termination_category_value | Unknown |  |
| termination_date | Unknown |  |
| termination_reason | Unknown |  |
| updated_at | Instant |  |
| user_academic_suffix_id | Unknown |  |
| user_academic_suffix_value | Unknown |  |
| user_honorary_suffix_id | Unknown |  |
| user_honorary_suffix_value | Unknown |  |
| user_professional_suffix_id | Unknown |  |
| user_professional_suffix_value | Unknown |  |
| user_suffix_id | Unknown |  |
| user_suffix_value | Unknown |  |
| user_title_id | Unknown |  |
| user_title_value | Unknown |  |
| work_hour | Unknown |  |
| workstation_number | Unknown |  |
| custom_** |  |  |

### applicant_follower

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicant_id | Unknown | PK, FK |
| user_id | Unknown | FK |

### applicant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| job_id | Unknown | FK |
| requisition_id | Unknown | FK |
| source_category_id | Unknown | FK |
| source_id | Unknown | FK |
| sub_stage_id | Unknown | FK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| job_title | Unknown |  |
| moved_at | Unknown |  |
| on_hold_at | Unknown |  |
| on_hold_till | Unknown |  |
| rejected_at | Unknown |  |
| stage | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| custom_** |  |  |

### employee_field_scope

| Column | Type | Keys |
| --- | --- | --- |
| scopable_id | Unknown | PK |
| employee_field_id | Unknown | PK, FK |
| scopable_lable | Unknown |  |
| scopable_type | Unknown |  |

### employee_field_picklist

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_field_id | Unknown | PK, FK |
| pickable_id | Unknown |  |
| pickable_type | Unknown |  |
| position | Unknown |  |
| value | Unknown |  |

### employee_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| editable_by | Unknown |  |
| employee_form_id | Unknown |  |
| field_type | Json |  |
| is_default | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| required | Unknown |  |
| section_label | Unknown |  |
| tab | Unknown |  |
| updated_at | Unknown |  |
| viewable_by | Unknown |  |

### job_post_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_posting_id | Unknown | PK, FK |
| skill | Unknown |  |

### job_remote_branch

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_posting_id | Unknown | PK, FK |
| remote_branch | Unknown |  |

### recruiter

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| job_posting_id | Unknown | PK, FK |
| requisition_id | Unknown | PK, FK |

### hiring_manager

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| job_posting_id | Unknown | PK, FK |
| requisition_id | Unknown | PK, FK |

### panel_member

| Column | Type | Keys |
| --- | --- | --- |
| employee_id | Unknown | PK, FK |
| job_posting_id | Unknown | PK, FK |
| requisition_id | Unknown | PK, FK |

### job_post_requisition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_posting_id | Unknown | PK, FK |
| deleted | Unknown |  |
| title | Unknown |  |

### job_post_sub_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_posting_id | Unknown | PK, FK |
| deleted | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| stage | Unknown |  |

### job_posting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| department_id | Unknown | FK |
| applicant_access_type | Unknown |  |
| applicant_apply_link | Unknown |  |
| closing_date | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| description | Unknown |  |
| experience | Unknown |  |
| interview_process_id | Unknown |  |
| interview_process_name | Unknown |  |
| remote | Unknown |  |
| salary_currency | Unknown |  |
| salary_max | Unknown |  |
| salary_min | Unknown |  |
| show_pursue_as_career | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### applicant_field_picklist_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| field_id | Unknown | FK |
| job_posting_id | Unknown | FK |
| pickable_id | Unknown |  |
| pickable_type | Unknown |  |
| position | Unknown |  |
| value | Unknown |  |

### applicant_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_posting_id | Unknown | PK, FK |
| applicant_form_id | Unknown |  |
| base_model | Unknown |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| external_field | Unknown |  |
| field_type | Unknown |  |
| group_label | Unknown |  |
| group_name | Unknown |  |
| group_position | Unknown |  |
| is_default | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| recruiter_field | Unknown |  |
| required_in_external_form | Unknown |  |
| required_in_recruiter_form | Unknown |  |
| required_in_vendor_form | Unknown |  |
| updated_at | Unknown |  |
| vendor_field | Unknown |  |
| viewable_by | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| deleted | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- candidate_skill(candidate_id) → candidate(id)
- candidate_tag(candidate_id) → candidate(id)
- candidate_profile_link(candidate_id) → candidate(id)
- candidate_qualification(candidate_id) → candidate(id)
- candidate_position(candidate_id) → candidate(id)
- candidate_resume(candidate_id) → candidate(id)
- candidate_cover_letter(candidate_id) → candidate(id)
- candidate_portfolios(candidate_id) → candidate(id)
- candidate(source_category_id) → source_category(id)
- candidate(id) → applicant(candidate_id)
- candidate(owner_id) → employee(id)
- candidate(source_id) → source(id)
- new_hire_work_number(new_hire_employee_id) → new_hire(id)
- new_hire_phone_number(new_hire_employee_id) → new_hire(id)
- new_hire_emergency_contact(new_hire_employee_id) → new_hire(id)
- new_hire_social_profile(new_hire_employee_id) → new_hire(id)
- new_hire_time_off(new_hire_employee_id) → new_hire(id)
- new_hire_dependent(new_hire_employee_id) → new_hire(id)
- new_hire_previous_employment_reference(new_hire_employee_id) → new_hire_previous_employment(new_hire_employee_id)
- new_hire_previous_employment_reference(previous_employment_id) → new_hire_previous_employment(id)
- new_hire_previous_employment(new_hire_employee_id) → new_hire(id)
- new_hire_qualification(new_hire_employee_id) → new_hire(id)
- new_hire_bank_account(new_hire_employee_id) → new_hire(id)
- new_hire_compensation(new_hire_employee_id) → new_hire(id)
- new_hire_bonus(new_hire_employee_id) → new_hire(id)
- new_hire_stock(new_hire_employee_id) → new_hire(id)
- new_hire_award(new_hire_employee_id) → new_hire(id)
- new_hire_honor(new_hire_employee_id) → new_hire(id)
- new_hire_certificate(new_hire_employee_id) → new_hire(id)
- new_hire_license(new_hire_employee_id) → new_hire(id)
- new_hire_background_verification_detail(new_hire_employee_id) → new_hire(id)
- new_hire_visa(new_hire_employee_id) → new_hire(id)
- new_hire_government_document(new_hire_employee_id) → new_hire(id)
- new_hire_role(new_hire_employee_id) → new_hire(id)
- new_hire(hr_incharge_id) → employee(id)
- new_hire(reporting_to_id) → employee(id)
- new_hire(job_role_id) → role(id)
- new_hire(department_id) → department(id)
- new_hire(team_id) → team(id)
- new_hire(user_function_id) → user_function(id)
- new_hire(business_unit_id) → business_unit(id)
- new_hire(level_id) → level(id)
- new_hire(sub_department_id) → sub_department(id)
- new_hire(employee_id) → employee(id)
- new_hire(branch_id) → branch(id)
- time_off(user_id) → employee(id)
- time_off(applied_by_id) → employee(id)
- time_off(approved_by_id) → employee(id)
- time_off(time_off_type_id) → time_off_type(id)
- time_off(rejected_by_id) → employee(id)
- time_off(cancelled_by_id) → employee(id)
- job_posting_field_picklist_value(field_id) → job_posting_field(id)
- employee_work_number(employee_id) → employee(id)
- employee_phone_number(employee_id) → employee(id)
- employee_emergency_contact(employee_id) → employee(id)
- employee_social_profile(employee_id) → employee(id)
- employee_time_off(employee_id) → employee(id)
- employee_dependent(employee_id) → employee(id)
- employee_previous_employment_reference(employee_id) → employee_previous_employment(employee_id)
- employee_previous_employment_reference(previous_employment_id) → employee_previous_employment(id)
- employee_previous_employment(employee_id) → employee(id)
- employee_qualification(employee_id) → employee(id)
- employee_bank_account(employee_id) → employee(id)
- employee_compensation(employee_id) → employee(id)
- employee_bonus(employee_id) → employee(id)
- employee_stock(employee_id) → employee(id)
- employee_award(employee_id) → employee(id)
- employee_honor(employee_id) → employee(id)
- employee_certificate(employee_id) → employee(id)
- employee_license(employee_id) → employee(id)
- employee_background_verification_detail(employee_id) → employee(id)
- employee_visa(employee_id) → employee(id)
- employee_government_document(employee_id) → employee(id)
- employee_role(employee_id) → employee(id)
- employee(hr_incharge_id) → employee(id)
- employee(reporting_to_id) → employee(id)
- employee(job_role_id) → role(id)
- employee(department_id) → department(id)
- employee(team_id) → team(id)
- employee(user_function_id) → user_function(id)
- employee(business_unit_id) → business_unit(id)
- employee(level_id) → level(id)
- employee(sub_department_id) → sub_department(id)
- employee(branch_id) → branch(id)
- applicant_follower(user_id) → employee(id)
- applicant_follower(applicant_id) → applicant(id)
- applicant(source_category_id) → source(id)
- applicant(job_id) → job_posting(id)
- applicant(candidate_id) → candidate(id)
- applicant(sub_stage_id) → job_post_sub_stage(id)
- applicant(source_id) → source(id)
- applicant(requisition_id) → job_post_requisition(id)
- employee_field_scope(employee_field_id) → employee_field(id)
- employee_field_picklist(employee_field_id) → employee_field(id)
- job_post_skill(job_posting_id) → job_posting(id)
- job_remote_branch(job_posting_id) → job_posting(id)
- recruiter(employee_id) → employee(id)
- recruiter(job_posting_id) → job_post_requisition(job_posting_id)
- recruiter(requisition_id) → job_post_requisition(id)
- hiring_manager(employee_id) → employee(id)
- hiring_manager(job_posting_id) → job_post_requisition(job_posting_id)
- hiring_manager(requisition_id) → job_post_requisition(id)
- panel_member(employee_id) → employee(id)
- panel_member(job_posting_id) → job_post_requisition(job_posting_id)
- panel_member(requisition_id) → job_post_requisition(id)
- job_post_requisition(job_posting_id) → job_posting(id)
- job_post_sub_stage(job_posting_id) → job_posting(id)
- job_posting(department_id) → department(id)
- job_posting(branch_id) → branch(id)
- applicant_field_picklist_value(job_posting_id) → applicant_field(job_posting_id)
- applicant_field_picklist_value(field_id) → applicant_field(id)
- applicant_field(job_posting_id) → job_posting(id)