ERD for HiBob

5 tables

Loading diagram…

entity_names

string

entity_type

string

name

string

value

string

archived

boolean

parent_id

string

_weld_synced

date

time_off

string

_weld_synced

date

employee_work_history

string

employee_id

string

can_be_deleted

boolean

work_change_type

string

change_reason

string

change_changed_by

string

change_changed_by_id

string

reports_to_id

string

reports_to_first_name

string

reports_to_surname

string

reports_to_email

string

reports_to_display_name

string

creation_date

string

title

string

is_current

boolean

modification_date

date

site

string

site_id

string

end_effective_date

date

active_effective_date

date

department

string

effective_date

date

custom_columns

string

_weld_synced

date

employee_lifecycle_history

string

employee_id

string

can_be_deleted

boolean

work_change_type

string

change_reason

string

change_changed_by

string

change_changed_by_id

string

creation_date

string

is_current

boolean

modification_date

date

end_effective_date

date

active_effective_date

date

department

string

effective_date

date

custom_columns

string

reports_to_id

string

leave_reason

string

reason_type

string

status

string

employee_status

string

_weld_synced

date

employee

string

full_name

string

about_avatar_value

string

display_name

string

work_reports_to_email_value

string

root_first_name_value

string

work_tenure_duration_years_value

double

about_food_preferences_value

string

work_site_value

string

personal_short_birth_date

string

work_tenure_years_value

double

creation_date_time

date

about_hobbies_value

string

root_email_value

string

employee_org_level

string

work_title_value

string

work_short_start_date

string

work_start_date

date

work_manager

string

work_tenure_duration_period_iso

string

work_tenure_duration_sort_factor

double

work_tenure_duration_humanize

string

work_duration_of_employment_period_iso

string

work_duration_of_employment_sort_factor

double

work_duration_of_employment_humanize

string

work_reports_to_id_in_company

string

work_employee_id_in_company

string

work_reports_to_display_name

string

work_reports_to_email

string

work_reports_to_surname

string

work_reports_to_first_name

string

work_reports_to_id

string

work_indirect_reports

double

work_site_id

string

work_tenure_duration_years

double

work_department

string

work_tenure_years

double

work_is_manager

boolean

work_title

string

work_site

string

work_original_start_date

date

work_active_effective_date

date

work_direct_reports

double

work_second_level_manager

string

work_days_of_previous_service

double

work_years_of_service

double

root_creation_date_time_value

date

employee_org_level_value

string

avatar_url

string

second_name

string

work_start_date_value

date

about_food_preferences

string

about_social_data_linkedin

string

about_social_data_twitter

string

about_social_data_facebook

string

about_superpowers

string

about_hobbies

string

about_about

string

about_avatar

string

root_full_name_value

string

company_id

string

root_cover_image_url_value

string

work_second_level_manager_value

string

work_years_of_service_value

double

work_days_of_previous_service_value

double

root_surname_value

string

work_short_start_date_value

string

work_active_effective_date_value

date

root_id_value

string

work_manager_value

string

surname

string

work_reports_to_value_display_name

string

work_reports_to_value_email

string

work_reports_to_value_surname

string

work_reports_to_value_first_name

string

work_reports_to_value_id

string

root_company_id_value

double

root_display_name_value

string

work_is_manager_value

boolean

work_department_value

string

work_original_start_date_value

date

cover_image_url

string

work_tenure_duration_value_period_iso

string

work_tenure_duration_value_sort_factor

double

work_tenure_duration_value_humanize

string

about_superpowers_value

string

work_site_id_value

double

first_name

string

work_duration_of_employment_value_period_iso

string

work_duration_of_employment_value_sort_factor

double

work_duration_of_employment_value_humanize

string

about_social_data_linkedin_value

string

work_employee_id_in_company_value

double

about_about_value

string

root_avatar_url_value

string

personal_short_birth_date_value

string

work_reports_to_id_in_company_value

double

work_indirect_reports_value

double

work_direct_reports_value

double

root_second_name_value

string

about_social_data_facebook_value

string

work_reports_to

string

human_readable_work_manager

string

human_readable_work_department

string

human_readable_work_site_id

string

human_readable_work_title

string

human_readable_work_site

string

human_readable_about_food_preferences

string

human_readable_about_superpowers

string

human_readable_about_hobbies

string

_weld_synced

date

Table

Sub table