# Zoho Recruit schema ERD

Table and field reference for the Fivetran Zoho Recruit connector.

## Table & Field Reference

### account_tag_draft

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

### account_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_manger_id | Unknown | FK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| created_time | Unknown |  |
| currency | Unknown |  |
| currency_symbol | Unknown |  |
| delegate | Unknown |  |
| department_name | Unknown |  |
| editable | Unknown |  |
| exchange_rate | Unknown |  |
| followed | Unknown |  |
| is_attachment_present | Unknown |  |
| last_activity_time | Unknown |  |
| last_mailed_time | Unknown |  |
| modified_time | Instant |  |
| process_flow | Unknown |  |
| reject | Unknown |  |
| resubmit | Unknown |  |
| state | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| created_by_id | Unknown | FK |
| job_opening_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| note_owner_id | Unknown | FK |
| action_from_status | Unknown |  |
| action_is_system_action | Unknown |  |
| action_to_status | Unknown |  |
| attachment | Unknown |  |
| created_time | Unknown |  |
| editable | Unknown |  |
| is_delete_allowed | Unknown |  |
| is_edit_allowed | Unknown |  |
| is_shared_to_client | Unknown |  |
| modified_time | Instant |  |
| note_content | Unknown |  |
| note_title | Unknown |  |
| parent_id | Unknown |  |
| parent_module | Unknown |  |
| parent_name | Unknown |  |
| se_module | Unknown |  |
| size | Unknown |  |
| source_name | Unknown |  |
| source_type | Unknown |  |
| type_id | Unknown |  |
| voice_note | Unknown |  |

### account_tag_save

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

### account_save

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_manger_id | Unknown | FK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| created_time | Unknown |  |
| currency | Unknown |  |
| currency_symbol | Unknown |  |
| delegate | Unknown |  |
| department_name | Unknown |  |
| editable | Unknown |  |
| exchange_rate | Unknown |  |
| followed | Unknown |  |
| is_attachment_present | Unknown |  |
| last_activity_time | Unknown |  |
| last_mailed_time | Unknown |  |
| modified_time | Instant |  |
| process_flow | Unknown |  |
| reject | Unknown |  |
| resubmit | Unknown |  |
| state | Unknown |  |

### job_opening_tag_draft

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

### job_opening_assigned_recruiter_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| job_opening_draft_id | Unknown | PK, FK |
| photo_src | Unknown |  |

### job_opening_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_manager_id | Unknown | FK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created_time | Unknown |  |
| currency_symbol | Unknown |  |
| date_1 | Unknown |  |
| date_opened | Unknown |  |
| delegate | Unknown |  |
| department_id | Unknown |  |
| department_name | Unknown |  |
| editable | Unknown |  |
| followed | Unknown |  |
| industry | Unknown |  |
| is_attachment_present | Unknown |  |
| is_hot_job_opening | Unknown |  |
| is_locked | Unknown |  |
| job_description | Unknown |  |
| job_opening_id | Unknown |  |
| job_opening_name | Unknown |  |
| job_opening_status | Unknown |  |
| job_type | Unknown |  |
| keep_on_career_site | Unknown |  |
| last_activity_time | Unknown |  |
| modified_time | Instant |  |
| n_1_no_sati_automation | Unknown |  |
| no_of_candidates_associated | Unknown |  |
| no_of_candidates_hired | Unknown |  |
| number_of_positions | Unknown |  |
| opal_no_sat_automation | Unknown |  |
| posting_title | Unknown |  |
| process_flow | Unknown |  |
| publish | Unknown |  |
| reject | Unknown |  |
| remote_job | Unknown |  |
| resubmit | Unknown |  |
| salary | Unknown |  |
| sati | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| tech_non_tech | Unknown |  |
| zip_code | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reporting_to_id | Unknown | FK |
| display_label | Unknown |  |
| name | Unknown |  |
| reporting_to_name | Unknown |  |
| share_with_peer | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| color_code | Unknown |  |
| created_time | Unknown |  |
| modified_time | Unknown |  |
| module | Unknown |  |
| name | Unknown |  |

### job_opening_tag_save

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

### job_opening_assigned_recruiter_save

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| job_opening_save_id | Unknown | PK, FK |
| photo_src | Unknown |  |

### job_opening_save

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_manager_id | Unknown | FK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created_time | Unknown |  |
| currency_symbol | Unknown |  |
| date_1 | Unknown |  |
| date_opened | Unknown |  |
| delegate | Unknown |  |
| department_id | Unknown |  |
| department_name | Unknown |  |
| editable | Unknown |  |
| followed | Unknown |  |
| industry | Unknown |  |
| is_attachment_present | Unknown |  |
| is_hot_job_opening | Unknown |  |
| is_locked | Unknown |  |
| job_description | Unknown |  |
| job_opening_id | Unknown |  |
| job_opening_name | Unknown |  |
| job_opening_status | Unknown |  |
| job_type | Unknown |  |
| keep_on_career_site | Unknown |  |
| last_activity_time | Unknown |  |
| modified_time | Instant |  |
| n_1_no_sati_automation | Unknown |  |
| no_of_candidates_associated | Unknown |  |
| no_of_candidates_hired | Unknown |  |
| number_of_positions | Unknown |  |
| opal_no_sat_automation | Unknown |  |
| posting_title | Unknown |  |
| process_flow | Unknown |  |
| publish | Unknown |  |
| reject | Unknown |  |
| remote_job | Unknown |  |
| resubmit | Unknown |  |
| salary | Unknown |  |
| sati | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| tech_non_tech | Unknown |  |
| zip_code | Unknown |  |

### vendor_tag_draft

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

### vendor_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| city | Unknown |  |
| comments | Unknown |  |
| country | Unknown |  |
| created_time | Unknown |  |
| currency_symbol | Unknown |  |
| delegate | Unknown |  |
| editable | Unknown |  |
| email | Unknown |  |
| email_opt_out | Unknown |  |
| exchange_rate | Unknown |  |
| followed | Unknown |  |
| is_attachment_present | Unknown |  |
| login_status | Unknown |  |
| modified_time | Instant |  |
| phone | Unknown |  |
| process_flow | Unknown |  |
| reject | Unknown |  |
| resubmit | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| vendor_login_status | Unknown |  |
| vendor_name | Unknown |  |
| website | Unknown |  |
| zipcode | Unknown |  |

### interview_tag_draft

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

### interviewer_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| interview_draft_id | Unknown | PK, FK |
| photo_src | Unknown |  |
| status | Unknown |  |
| status_value | Unknown |  |
| type | Unknown |  |

### interview_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| cancellation_reason | Unknown |  |
| candidate_confirmed | Unknown |  |
| candidate_number | Unknown |  |
| created_time | Unknown |  |
| currency_symbol | Unknown |  |
| delegate | Unknown |  |
| department_id | Unknown |  |
| department_name | Unknown |  |
| editable | Unknown |  |
| end_date_time | Unknown |  |
| feedback | Unknown |  |
| followed | Unknown |  |
| ignore_under_construction | Unknown |  |
| interview_duration_days | Unknown |  |
| interview_duration_hrs | Unknown |  |
| interview_duration_mins | Unknown |  |
| interview_enableevaluation | Unknown |  |
| interview_evaluation_done | Unknown |  |
| interview_name | Unknown |  |
| interview_start_time | Unknown |  |
| interview_status | Unknown |  |
| interview_type | Unknown |  |
| interviewer | Unknown |  |
| is_attachment_present | Unknown |  |
| is_locked | Unknown |  |
| job_opening_name | Unknown |  |
| last_activity_time | Unknown |  |
| link | Unknown |  |
| meeting_provider | Unknown |  |
| modified_time | Instant |  |
| password_new | Unknown |  |
| posting_title | Unknown |  |
| process_flow | Unknown |  |
| questionnaire_name | Unknown |  |
| reject | Unknown |  |
| rejection_reason | Unknown |  |
| reminder | Unknown |  |
| resubmit | Unknown |  |
| reviewed_by | Unknown |  |
| reviewed_time | Unknown |  |
| role | Unknown |  |
| schedule_comments | Unknown |  |
| start_date_time | Unknown |  |
| state | Unknown |  |
| taxable | Unknown |  |
| video_interview_is_reviewed | Unknown |  |
| video_interview_is_submitted | Unknown |  |
| video_interview_stage | Unknown |  |

### candidate_associate_tag_draft

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

### candidate_draft

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| application_type | Unknown |  |
| applied_with_linkedin | Unknown |  |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| associated_any_social_profiles | Unknown |  |
| blueprint_trigger | Unknown |  |
| by_pre_screen_form | Unknown |  |
| candidate_id | Unknown |  |
| candidate_status | Unknown |  |
| career_page_invite_status | Unknown |  |
| city | Unknown |  |
| company_info_from_close | Unknown |  |
| converted | Unknown |  |
| country | Unknown |  |
| created_time | Unknown |  |
| currency | Unknown |  |
| currency_symbol | Unknown |  |
| data_processing_basis_details | Unknown |  |
| date_of_1_st_interview | Unknown |  |
| date_of_2_nd_hoo_interview | Unknown |  |
| date_of_final_interview | Unknown |  |
| date_sati_received | Unknown |  |
| delegate | Unknown |  |
| editable | Unknown |  |
| eligible_for_referral_bonus | Unknown |  |
| email | Unknown |  |
| email_opt_out | Unknown |  |
| experience_in_years | Unknown |  |
| facebook | Unknown |  |
| first_name | Unknown |  |
| followed | Unknown |  |
| full_name | Unknown |  |
| full_time_internship_graduate_program | Unknown |  |
| gdpr_eu_applicant | Unknown |  |
| github | Unknown |  |
| github_score | Unknown |  |
| have_you_worked_with_them_before | Unknown |  |
| highest_qualification_held_major | Unknown |  |
| how_do_you_know_this_person | Unknown |  |
| interviewer_1 | Unknown |  |
| interviewer_1_3 | Unknown |  |
| interviewer_2 | Unknown |  |
| interviewer_2_1 | Unknown |  |
| interviewer_2_2 | Unknown |  |
| interviewer_2_3 | Unknown |  |
| interviewer_f_1 | Unknown |  |
| interviewer_f_2 | Unknown |  |
| interviewer_f_3 | Unknown |  |
| is_attachment_present | Unknown |  |
| is_locked | Unknown |  |
| is_unqualified | Unknown |  |
| last_activity_time | Unknown |  |
| last_mailed_time | Unknown |  |
| last_name | Unknown |  |
| latest_job_title_in_sati | Unknown |  |
| latest_monthly_salary | Unknown |  |
| latest_monthly_salary_end | Unknown |  |
| linked_in | Unknown |  |
| linked_in_template | Unknown |  |
| military_status | Unknown |  |
| mobile | Unknown |  |
| nationality_new | Unknown |  |
| origin | Unknown |  |
| other_info | Unknown |  |
| plagiarism_checked | Unknown |  |
| portfolio | Unknown |  |
| position_dropdown | Unknown |  |
| privacy_policy | Unknown |  |
| process_flow | Unknown |  |
| rating | Unknown |  |
| reject | Unknown |  |
| resubmit | Unknown |  |
| salary_type | Unknown |  |
| salutation | Unknown |  |
| sati | Unknown |  |
| scheduled_email | Unknown |  |
| secondary_email | Unknown |  |
| skill_set | Unknown |  |
| skype_id | Unknown |  |
| social | Unknown |  |
| social_media_checked | Unknown |  |
| social_profiles | Unknown |  |
| source | Unknown |  |
| source_code_dropdown | Unknown |  |
| source_codes_close | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| temp_team_name | Unknown |  |
| university_institution_graduated | Unknown |  |
| updated_on | Instant |  |
| vendor_name | Unknown |  |
| website | Unknown |  |
| what_are_their_skills_capabilities_competencies | Unknown |  |
| what_position_do_you_think_he_she_would_fit | Unknown |  |
| whatsapp_available | Unknown |  |
| willing_to_relocate | Unknown |  |
| zipcode | Unknown |  |

### interviewer_save

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| interview_save_id | Unknown | PK, FK |
| photo_src | Unknown |  |
| status | Unknown |  |
| status_value | Unknown |  |
| type | Unknown |  |

### interview_save

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| candidate_id | Unknown | FK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| cancellation_reason | Unknown |  |
| candidate_confirmed | Unknown |  |
| candidate_number | Unknown |  |
| created_time | Unknown |  |
| currency_symbol | Unknown |  |
| delegate | Unknown |  |
| department_id | Unknown |  |
| department_name | Unknown |  |
| editable | Unknown |  |
| end_date_time | Unknown |  |
| feedback | Unknown |  |
| followed | Unknown |  |
| ignore_under_construction | Unknown |  |
| interview_duration_days | Unknown |  |
| interview_duration_hrs | Unknown |  |
| interview_duration_mins | Unknown |  |
| interview_enableevaluation | Unknown |  |
| interview_evaluation_done | Unknown |  |
| interview_name | Unknown |  |
| interview_start_time | Unknown |  |
| interview_status | Unknown |  |
| interview_type | Unknown |  |
| interviewer | Unknown |  |
| is_attachment_present | Unknown |  |
| is_locked | Unknown |  |
| job_opening_name | Unknown |  |
| last_activity_time | Unknown |  |
| link | Unknown |  |
| meeting_provider | Unknown |  |
| modified_time | Instant |  |
| password_new | Unknown |  |
| posting_title | Unknown |  |
| process_flow | Unknown |  |
| questionnaire_name | Unknown |  |
| reject | Unknown |  |
| rejection_reason | Unknown |  |
| reminder | Unknown |  |
| resubmit | Unknown |  |
| reviewed_by | Unknown |  |
| reviewed_time | Unknown |  |
| role | Unknown |  |
| schedule_comments | Unknown |  |
| start_date_time | Unknown |  |
| state | Unknown |  |
| taxable | Unknown |  |
| video_interview_is_reviewed | Unknown |  |
| video_interview_is_submitted | Unknown |  |
| video_interview_stage | Unknown |  |

### vendor_tag_save

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

### vendor_save

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| city | Unknown |  |
| comments | Unknown |  |
| country | Unknown |  |
| created_time | Unknown |  |
| currency_symbol | Unknown |  |
| delegate | Unknown |  |
| editable | Unknown |  |
| email | Unknown |  |
| email_opt_out | Unknown |  |
| exchange_rate | Unknown |  |
| followed | Unknown |  |
| is_attachment_present | Unknown |  |
| login_status | Unknown |  |
| modified_time | Instant |  |
| phone | Unknown |  |
| process_flow | Unknown |  |
| reject | Unknown |  |
| resubmit | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| vendor_login_status | Unknown |  |
| vendor_name | Unknown |  |
| website | Unknown |  |
| zipcode | Unknown |  |

### candidate_associate_tag_save

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

### candidate_save

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| application_type | Unknown |  |
| applied_with_linkedin | Unknown |  |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| associated_any_social_profiles | Unknown |  |
| blueprint_trigger | Unknown |  |
| by_pre_screen_form | Unknown |  |
| candidate_id | Unknown |  |
| candidate_status | Unknown |  |
| career_page_invite_status | Unknown |  |
| city | Unknown |  |
| company_info_from_close | Unknown |  |
| converted | Unknown |  |
| country | Unknown |  |
| created_time | Unknown |  |
| currency | Unknown |  |
| currency_symbol | Unknown |  |
| data_processing_basis_details | Unknown |  |
| date_of_1_st_interview | Unknown |  |
| date_of_2_nd_hoo_interview | Unknown |  |
| date_of_final_interview | Unknown |  |
| date_sati_received | Unknown |  |
| delegate | Unknown |  |
| editable | Unknown |  |
| eligible_for_referral_bonus | Unknown |  |
| email | Unknown |  |
| email_opt_out | Unknown |  |
| experience_in_years | Unknown |  |
| facebook | Unknown |  |
| first_name | Unknown |  |
| followed | Unknown |  |
| full_name | Unknown |  |
| full_time_internship_graduate_program | Unknown |  |
| gdpr_eu_applicant | Unknown |  |
| github | Unknown |  |
| github_score | Unknown |  |
| have_you_worked_with_them_before | Unknown |  |
| highest_qualification_held_major | Unknown |  |
| how_do_you_know_this_person | Unknown |  |
| interviewer_1 | Unknown |  |
| interviewer_1_3 | Unknown |  |
| interviewer_2 | Unknown |  |
| interviewer_2_1 | Unknown |  |
| interviewer_2_2 | Unknown |  |
| interviewer_2_3 | Unknown |  |
| interviewer_f_1 | Unknown |  |
| interviewer_f_2 | Unknown |  |
| interviewer_f_3 | Unknown |  |
| is_attachment_present | Unknown |  |
| is_locked | Unknown |  |
| is_unqualified | Unknown |  |
| last_activity_time | Unknown |  |
| last_mailed_time | Unknown |  |
| last_name | Unknown |  |
| latest_job_title_in_sati | Unknown |  |
| latest_monthly_salary | Unknown |  |
| latest_monthly_salary_end | Unknown |  |
| linked_in | Unknown |  |
| linked_in_template | Unknown |  |
| military_status | Unknown |  |
| mobile | Unknown |  |
| nationality_new | Unknown |  |
| origin | Unknown |  |
| other_info | Unknown |  |
| plagiarism_checked | Unknown |  |
| portfolio | Unknown |  |
| position_dropdown | Unknown |  |
| privacy_policy | Unknown |  |
| process_flow | Unknown |  |
| rating | Unknown |  |
| reject | Unknown |  |
| resubmit | Unknown |  |
| salary_type | Unknown |  |
| salutation | Unknown |  |
| sati | Unknown |  |
| scheduled_email | Unknown |  |
| secondary_email | Unknown |  |
| skill_set | Unknown |  |
| skype_id | Unknown |  |
| social | Unknown |  |
| social_media_checked | Unknown |  |
| social_profiles | Unknown |  |
| source | Unknown |  |
| source_code_dropdown | Unknown |  |
| source_codes_close | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| temp_team_name | Unknown |  |
| university_institution_graduated | Unknown |  |
| updated_on | Instant |  |
| vendor_name | Unknown |  |
| website | Unknown |  |
| what_are_their_skills_capabilities_competencies | Unknown |  |
| what_position_do_you_think_he_she_would_fit | Unknown |  |
| whatsapp_available | Unknown |  |
| willing_to_relocate | Unknown |  |
| zipcode | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| created_by | Unknown |  |
| created_time | Unknown |  |
| description | Unknown |  |
| is_custom | Unknown |  |
| modified_time | Unknown |  |
| name | Unknown |  |

### questionnary_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| questionnary_id | Unknown | PK, FK |
| hint | Unknown |  |
| is_mandatory | Unknown |  |
| is_unassociate | Unknown |  |
| question | Unknown |  |
| section_name | Unknown |  |
| sequence | Unknown |  |
| type | Unknown |  |

### questionnary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| name | Unknown |  |
| ori_category | Unknown |  |
| rating_type | Unknown |  |
| rating_type_info | Unknown |  |
| type | Unknown |  |

### user_territory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| is_manager | Unknown |  |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | FK |
| role_id | Unknown | FK |
| active | Unknown |  |
| alias | Unknown |  |
| city | Unknown |  |
| confirm | Unknown |  |
| country | Unknown |  |
| country_locale | Unknown |  |
| date_format | Unknown |  |
| date_of_birth | Unknown |  |
| decimal_separator | Unknown |  |
| default_tab_group | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| mobile | Unknown |  |
| name_format | Unknown |  |
| personal_account | Unknown |  |
| phone | Unknown |  |
| report_to | Unknown |  |
| signature | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| theme_background | Unknown |  |
| theme_new_background | Unknown |  |
| theme_normal_tab_background | Unknown |  |
| theme_normal_tab_font_color | Unknown |  |
| theme_screen | Unknown |  |
| theme_selected_tab_background | Unknown |  |
| theme_selected_tab_font_color | Unknown |  |
| theme_type | Unknown |  |
| time_format | Unknown |  |
| time_zone | Unknown |  |
| url | Unknown |  |
| website | Unknown |  |
| zip | Unknown |  |
| zuid | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| alias | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| description | Unknown |  |
| editor_mode | Unknown |  |
| employee_count | Unknown |  |
| fax | Unknown |  |
| hipaa_compliance_enabled | Unknown |  |
| iam_portal_name | Unknown |  |
| is_portal_exist | Unknown |  |
| license_expiry | Unknown |  |
| license_no_of_users | Unknown |  |
| license_paid | Unknown |  |
| license_paid_type | Unknown |  |
| license_plan_type | Unknown |  |
| mc_status | Unknown |  |
| mobile | Unknown |  |
| phone | Unknown |  |
| primary_email | Unknown |  |
| primary_user_id | Unknown |  |
| staffing_type | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| time_zone | Unknown |  |
| type | Unknown |  |
| website | Unknown |  |
| zip | Unknown |  |

### submission

| Column | Type | Keys |
| --- | --- | --- |
| submission_id | Unknown | PK |
| candidate_id | Unknown | FK |
| job_opening_id | Unknown | FK |
| modified_by_id | Unknown | FK |
| submission_owner_id | Unknown | FK |
| submitted_by_id | Unknown | FK |
| approval_state | Unknown |  |
| approve | Unknown |  |
| approved | Unknown |  |
| client_name | Unknown |  |
| created_time | Unknown |  |
| delegate | Unknown |  |
| department_id | Unknown |  |
| department_name | Unknown |  |
| description | Unknown |  |
| editable | Unknown |  |
| followed | Unknown |  |
| id | Unknown |  |
| last_activity_time | Unknown |  |
| modified_time | Instant |  |
| name | Unknown |  |
| posting_title_id | Unknown |  |
| posting_title_name | Unknown |  |
| process_flow | Unknown |  |
| rating | Unknown |  |
| reject | Unknown |  |
| resubmit | Unknown |  |
| reviewed_by | Unknown |  |
| submission_medium | Unknown |  |
| submission_status | Unknown |  |
| submitted_to | Unknown |  |

## Relationships

- account_tag_draft(id) → tags(id)
- account_tag_draft(account_draft_id) → account_draft(id)
- account_draft(modified_by_id) → users(id)
- account_draft(created_by_id) → users(id)
- account_draft(account_manger_id) → users(id)
- note(note_owner_id) → users(id)
- note(modified_by_id) → users(id)
- note(job_opening_id) → job_opening_draft(id)
- note(created_by_id) → users(id)
- note(candidate_id) → candidate_draft(id)
- account_tag_save(id) → tags(id)
- account_tag_save(account_save_id) → account_save(id)
- account_save(modified_by_id) → users(id)
- account_save(created_by_id) → users(id)
- account_save(account_manger_id) → users(id)
- job_opening_tag_draft(id) → tags(id)
- job_opening_tag_draft(job_opening_draft_id) → job_opening_draft(id)
- job_opening_assigned_recruiter_draft(id) → users(id)
- job_opening_assigned_recruiter_draft(job_opening_draft_id) → job_opening_draft(id)
- job_opening_draft(account_manager_id) → users(id)
- job_opening_draft(modified_by_id) → users(id)
- job_opening_draft(created_by_id) → users(id)
- role(reporting_to_id) → role(id)
- tags(created_by_id) → users(id)
- tags(modified_by_id) → users(id)
- job_opening_tag_save(id) → tags(id)
- job_opening_tag_save(job_opening_save_id) → job_opening_save(id)
- job_opening_assigned_recruiter_save(id) → users(id)
- job_opening_assigned_recruiter_save(job_opening_save_id) → job_opening_save(id)
- job_opening_save(account_manager_id) → users(id)
- job_opening_save(modified_by_id) → users(id)
- job_opening_save(created_by_id) → users(id)
- vendor_tag_draft(id) → tags(id)
- vendor_tag_draft(vendor_draft_id) → vendor_draft(id)
- vendor_draft(modified_by_id) → users(id)
- vendor_draft(owner_id) → users(id)
- vendor_draft(created_by_id) → users(id)
- interview_tag_draft(id) → tags(id)
- interview_tag_draft(interview_draft_id) → interview_draft(id)
- interviewer_draft(id) → users(id)
- interviewer_draft(interview_draft_id) → interview_draft(id)
- interview_draft(modified_by_id) → users(id)
- interview_draft(owner_id) → users(id)
- interview_draft(created_by_id) → users(id)
- interview_draft(candidate_id) → candidate_draft(id)
- candidate_associate_tag_draft(id) → tags(id)
- candidate_associate_tag_draft(candidate_draft_id) → candidate_draft(id)
- candidate_draft(modified_by_id) → users(id)
- candidate_draft(owner_id) → users(id)
- candidate_draft(created_by_id) → users(id)
- interviewer_save(id) → users(id)
- interviewer_save(interview_save_id) → interview_save(id)
- interview_save(modified_by_id) → users(id)
- interview_save(owner_id) → users(id)
- interview_save(created_by_id) → users(id)
- interview_save(candidate_id) → candidate_draft(id)
- vendor_tag_save(id) → tags(id)
- vendor_tag_save(vendor_save_id) → vendor_save(id)
- vendor_save(modified_by_id) → users(id)
- vendor_save(owner_id) → users(id)
- vendor_save(created_by_id) → users(id)
- candidate_associate_tag_save(id) → tags(id)
- candidate_associate_tag_save(candidate_save_id) → candidate_save(id)
- candidate_save(modified_by_id) → users(id)
- candidate_save(owner_id) → users(id)
- candidate_save(created_by_id) → users(id)
- profile(modified_by_id) → users(id)
- profile(created_by_id) → users(id)
- questionnary_question(questionnary_id) → questionnary(id)
- user_territory(users_id) → users(id)
- users(profile_id) → profile(id)
- users(role_id) → role(id)
- submission(modified_by_id) → users(id)
- submission(candidate_id) → candidate_draft(id)
- submission(submitted_by_id) → users(id)
- submission(submission_owner_id) → users(id)
- submission(job_opening_id) → job_opening_draft(id)