# ChartHop schema ERD

Table and field reference for the Fivetran ChartHop connector.

## Table & Field Reference

### person_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| person_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### person_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| person_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### person

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| department_id | Unknown |  |
| department_name | Unknown |  |
| department_type | Unknown |  |
| first_name | Unknown |  |
| job_id | Unknown |  |
| last_name | Unknown |  |
| manager_id | Unknown |  |

### organization_onboard_step

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| name | Unknown |  |
| status | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active_at | Unknown |  |
| active_user_count | Unknown |  |
| adp_organization_o_i_d | Unknown |  |
| app_time | Unknown |  |
| approx_geo_coordinates | Json |  |
| approx_geo_type | Unknown |  |
| assessment_count | Unknown |  |
| city | Unknown |  |
| cordinate | Json |  |
| country | Unknown |  |
| create_at | Unknown |  |
| create_id | Unknown |  |
| customer_id | Unknown |  |
| dashboard_getting_started_hidden | Unknown |  |
| dashboard_need_help_hidden | Unknown |  |
| destroy_at | Unknown |  |
| destroy_id | Unknown |  |
| destroyed_at | Unknown |  |
| disable_import_events | Unknown |  |
| domain | Json |  |
| email | Unknown |  |
| enable_universal_sso | Unknown |  |
| est_employees | Unknown |  |
| est_revenue | Unknown |  |
| extra_fields | Json |  |
| file_upload_limit | Unknown |  |
| fiscal_start | Unknown |  |
| founded_year | Unknown |  |
| geo_coordinates | Json |  |
| geo_type | Unknown |  |
| head_count | Unknown |  |
| head_job_id | Unknown |  |
| image_path | Unknown |  |
| industry | Unknown |  |
| is_initial_data_synced | Unknown |  |
| low_priority_reports | Unknown |  |
| max_file_upload_size | Unknown |  |
| name | Unknown |  |
| onboarding | Unknown |  |
| phone | Unknown |  |
| postal | Unknown |  |
| self_serve_importing | Unknown |  |
| sequoia_org_id | Unknown |  |
| slug | Unknown |  |
| start_date | Unknown |  |
| state | Unknown |  |
| stock | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |
| street_3 | Unknown |  |
| time_zone | Unknown |  |
| tos_agreement | Unknown |  |
| type | Unknown |  |
| update_at | Unknown |  |
| update_id | Unknown |  |
| url | Unknown |  |
| user_count | Unknown |  |
| zone | Unknown |  |
| custom_** |  |  |

### job_location

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

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| person_id | Unknown | FK |
| department_id | Unknown |  |
| title | Unknown |  |

### export_roster

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| organization_id | Unknown | PK, FK |
| comp_base | Unknown |  |
| comp_currency | Unknown |  |
| comp_equity | Unknown |  |
| comp_variable | Unknown |  |
| employment_status | Unknown |  |
| first_name | Unknown |  |
| group_band | Unknown |  |
| group_department | Unknown |  |
| group_location | Unknown |  |
| group_team | Unknown |  |
| indirect_manager | Unknown |  |
| last_name | Unknown |  |
| manager | Unknown |  |
| middle_name | Unknown |  |
| person_birth_date | Unknown |  |
| person_ethnicity | Unknown |  |
| person_gender | Unknown |  |
| preferred_first_name | Unknown |  |
| start_date | Unknown |  |
| title | Unknown |  |

## Relationships

- person_team(person_id) → person(id)
- person_location(person_id) → person(id)
- person(organization_id) → organization(id)
- organization_onboard_step(organization_id) → organization(id)
- job_location(id) → person_location(id)
- job_location(job_id) → job(id)
- job(person_id) → person(id)
- job(organization_id) → organization(id)
- export_roster(organization_id) → organization(id)