# SmartHR schema ERD

Table and field reference for the Fivetran SmartHR connector.

## Table & Field Reference

### employment_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| preset_type | Unknown |  |
| updated_at | Unknown |  |

### employee_department

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

### employee_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| template_created_at | Unknown |  |
| template_element | Unknown |  |
| template_group_id | Unknown |  |
| template_hint | Unknown |  |
| template_id | Unknown |  |
| template_name | Unknown |  |
| template_position | Unknown |  |
| template_scale | Unknown |  |
| template_separated_by_commas | Unknown |  |
| template_type | Unknown |  |
| template_updated_at | Unknown |  |
| value | Unknown |  |

### employee_profile_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| height | Unknown |  |
| size_type | Unknown |  |
| url | Unknown |  |
| width | Unknown |  |

### employee_bank_account

| Column | Type | Keys |
| --- | --- | --- |
| account_number | Unknown | PK |
| employee_id | Unknown | PK, FK |
| account_holder_name | Unknown |  |
| account_type | Unknown |  |
| bank_account_setting_id | Unknown |  |
| bank_branch_code | Unknown |  |
| bank_code | Unknown |  |
| bankbook_image_content | Unknown |  |
| bankbook_image_file_name | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employment_type_id | Unknown | FK |
| address | Json |  |
| address_head_of_family | Unknown |  |
| address_image | Json |  |
| address_relation_name | Unknown |  |
| basic_pension_number | Unknown |  |
| basic_pension_number_unknown_reason_type | Unknown |  |
| birth_at | Unknown |  |
| business_first_name | Unknown |  |
| business_first_name_yomi | Unknown |  |
| business_income_flag | Unknown |  |
| business_last_name | Unknown |  |
| business_last_name_yomi | Unknown |  |
| commutation_1_expenses | Unknown |  |
| commutation_1_period | Unknown |  |
| commutation_1_single_fare | Unknown |  |
| commutation_2_expenses | Unknown |  |
| commutation_2_period | Unknown |  |
| commutation_2_single_fare | Unknown |  |
| contract_end_on | Unknown |  |
| contract_renewal_type | Unknown |  |
| contract_start_on | Unknown |  |
| contract_type | Unknown |  |
| created_at | Unknown |  |
| department | Unknown |  |
| devidend_income_flag | Unknown |  |
| email | Unknown |  |
| emergency_first_name | Unknown |  |
| emergency_first_name_yomi | Unknown |  |
| emergency_last_name | Unknown |  |
| emergency_last_name_yomi | Unknown |  |
| emergency_relation_name | Unknown |  |
| emergency_tel_number | Unknown |  |
| emp_code | Unknown |  |
| emp_ins_disqualified_at | Unknown |  |
| emp_ins_insured_person_number | Unknown |  |
| emp_ins_insured_person_number_unknown_reason_type | Unknown |  |
| emp_ins_qualified_at | Unknown |  |
| emp_status | Unknown |  |
| employment_income_flag | Unknown |  |
| enrolled_at | Unknown |  |
| entered_at | Unknown |  |
| estate_income_flag | Unknown |  |
| first_employment_end_on | Unknown |  |
| first_employment_start_on | Unknown |  |
| first_enrolling_in_emp_pns_ins_flag | Unknown |  |
| first_name | Unknown |  |
| first_name_yomi | Unknown |  |
| first_workplace | Unknown |  |
| first_workplace_address_text | Unknown |  |
| foreign_resident_card_number | Unknown |  |
| foreign_resident_first_name | Unknown |  |
| foreign_resident_last_name | Unknown |  |
| foreign_resident_middle_name | Unknown |  |
| gender | Unknown |  |
| handicapped_note_delivery_at | Unknown |  |
| handicapped_note_type | Unknown |  |
| handicapped_type | Unknown |  |
| having_ex_activity_permission | Unknown |  |
| having_spouse | Unknown |  |
| hel_ins_insured_person_number | Unknown |  |
| identity_card_image_2 | Json |  |
| last_employment_end_on | Unknown |  |
| last_employment_start_on | Unknown |  |
| last_name | Unknown |  |
| last_name_yomi | Unknown |  |
| last_workplace | Unknown |  |
| last_workplace_address_text | Unknown |  |
| monthly_income_currency | Unknown |  |
| monthly_income_goods | Unknown |  |
| monthly_standard_income_hel | Unknown |  |
| monthly_standard_income_pns | Unknown |  |
| monthly_standard_income_updated_at | Unknown |  |
| nationality_code | Unknown |  |
| nearest_station_and_line | Unknown |  |
| occupation | Unknown |  |
| other_be_workable_type | Unknown |  |
| position | Unknown |  |
| previous_employment_end_on | Unknown |  |
| previous_employment_start_on | Unknown |  |
| previous_workplace | Unknown |  |
| resident_card_address_head_of_family | Unknown |  |
| resident_card_address_relation_name | Unknown |  |
| resident_end_at | Unknown |  |
| resident_status_other_reason | Unknown |  |
| resident_status_type | Unknown |  |
| resigned_at | Unknown |  |
| resigned_reason | Unknown |  |
| school_name | Unknown |  |
| soc_ins_disqualified_at | Unknown |  |
| soc_ins_insured_person_number | Unknown |  |
| soc_ins_qualified_at | Unknown |  |
| spouse_yearly_income | Unknown |  |
| tax_cd | Unknown |  |
| tel_number | Unknown |  |
| updated_at | Unknown |  |
| user_id | Unknown |  |
| widow_memo | Unknown |  |
| widow_reason_type | Unknown |  |
| widow_type | Unknown |  |
| working_student_flag | Unknown |  |
| working_student_income | Unknown |  |
| biz_establishment_** |  |  |

### job_title

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| rank | Unknown |  |
| updated_at | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| children | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| full_name | Unknown |  |
| name | Unknown |  |
| parent | Json |  |
| position | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- employee_department(department_id) → department(id)
- employee_department(employee_id) → employee(id)
- employee_custom_field(employee_id) → employee(id)
- employee_profile_image(employee_id) → employee(id)
- employee_bank_account(employee_id) → employee(id)
- employee(employment_type_id) → employment_type(id)