ChartHop
Explore the interactive ERD
Table & Field Reference
person_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
person_id | Unknown | PKFK |
name | Unknown | |
type | Unknown |
person_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
person_id | Unknown | PKFK |
name | Unknown | |
type | Unknown |
person
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
job_id | Unknown | PKFK |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | PKFK |
person_id | Unknown | FK |
department_id | Unknown | |
title | Unknown |
export_roster
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
organization_id | Unknown | PKFK |
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 |