Ashby
Explore the interactive ERD
Table & Field Reference
source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
is_archived | Unknown | |
source_type_id | Unknown | |
source_type_is_archived | Unknown | |
source_type_title | Unknown | |
title | Unknown |
offer_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
offer_id | Unknown | PKFK |
value | Unknown |
offer_file_handle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
offer_id | Unknown | PKFK |
handle | Unknown | |
name | Unknown |
offer_version_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
offer_id | Unknown | PKFK |
offer_version_id | Unknown | PKFK |
value | Unknown |
offer_version_file_handle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
offer_id | Unknown | PKFK |
offer_version_id | Unknown | PKFK |
handle | Unknown | |
name | Unknown |
offer_version
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
offer_id | Unknown | PKFK |
author_id | Unknown | FK |
created_at | Unknown | |
salary_currency_code | Unknown | |
salary_value | Unknown | |
start_date | Unknown |
offer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
application_id | Unknown | FK |
author_id | Unknown | FK |
acceptance_status | Unknown | |
decided_at | Unknown | |
latest_version_created_at | Unknown | |
latest_version_id | Unknown | |
latest_version_salary_currency_code | Unknown | |
latest_version_salary_value | Unknown | |
latest_version_start_date | Unknown | |
status | Unknown |
application_feedback_form_definition_section_field_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
application_feedback_id | Unknown | PKFK |
section_field_index | Unknown | PKFK |
section_field_value_index | Unknown | PKFK |
label | Unknown | |
value | Unknown |
application_feedback_form_definition_section_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
section_field_index | Unknown | PK |
application_feedback_id | Unknown | PKFK |
description_html | Unknown | |
description_plain | Unknown | |
field_human_readable_path | Unknown | |
field_id | Unknown | |
field_is_nullable | Unknown | |
field_path | Unknown | |
field_title | Unknown | |
field_type | Unknown | |
is_required | Unknown | |
section_description_html | Unknown | |
section_description_plain | Unknown | |
title | Unknown |
application_feedback_submitted_value
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
application_feedback_id | Unknown | PKFK |
value | Unknown |
application_feedback
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
application_history_id | Unknown | FK |
application_id | Unknown | FK |
interview_id | Unknown | FK |
submitted_by_user_id | Unknown | FK |
feedback_form_definition_id | Unknown | |
submitted_at | Unknown |
source_tracking_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
source_id | Unknown | FK |
code | Unknown | |
enabled | Unknown | |
link | Unknown |
application_history_allowed_action
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
application_history_id | Unknown | PKFK |
application_id | Unknown | PKFK |
action | Unknown |
application_history
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
application_id | Unknown | PKFK |
actor_id | Unknown | FK |
entered_stage_at | Unknown | |
left_stage_at | Unknown | |
stage_id | Unknown | |
stage_number | Unknown | |
title | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
email | Unknown | |
first_name | Unknown | |
global_role | Unknown | |
is_enabled | Unknown | |
last_name | Unknown | |
updated_at | Unknown |
job_board
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
is_internal | Unknown | |
title | Unknown |
interview_schedule_event_user_id
| Column | Type | Keys |
|---|---|---|
interview_schedule_event_id | Unknown | PKFK |
interview_schedule_id | Unknown | PKFK |
user_id | Unknown | PKFK |
interview_schedule_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interview_schedule_id | Unknown | PKFK |
interview_id | Unknown | FK |
created_at | Unknown | |
end_time | Unknown | |
feedback_link | Unknown | |
has_submitted_feedback | Unknown | |
location | Unknown | |
meeting_link | Unknown | |
start_time | Unknown | |
updated_at | Unknown |
interview_schedule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
application_id | Unknown | FK |
interview_stage_id | Unknown | FK |
job_posting_location
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
job_posting_id | Unknown | PKFK |
location_id | Unknown | FK |
job_posting
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
primary_location_id | Unknown | FK |
application_deadline | Unknown | |
apply_link | Unknown | |
compensation_tier_summary | Unknown | |
department_name | Unknown | |
employment_type | Unknown | |
external_link | Unknown | |
is_listed | Unknown | |
location_name | Unknown | |
published_date | Unknown | |
should_display_compensation_on_job_board | Unknown | |
team_name | Unknown | |
title | Unknown | |
updated_at | Unknown |
job_opening
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_interview_plan_id
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
job_posting_id
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
value | Unknown |
job_hiring_team
| Column | Type | Keys |
|---|---|---|
job_id | Unknown | PKFK |
user_id | Unknown | PKFK |
role | Unknown |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
department_id | Unknown | FK |
location_id | Unknown | FK |
brand_id | Unknown | |
closed_at | Unknown | |
confidential | Unknown | |
created_at | Unknown | |
custom_requisition_id | Unknown | |
default_interview_plan_id | Unknown | |
employment_type | Unknown | |
opened_at | Unknown | |
status | Unknown | |
title | Unknown | |
updated_at | Unknown |
interview_stage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interview_stage_group_id | Unknown | FK |
interview_plan_id | Unknown | |
order_in_interview_plan | Unknown | |
title | Unknown | |
type | Unknown |
application_hiring_team_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
candidate_email_address
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
candidate_id | Unknown | PKFK |
is_primary | Unknown | |
type | Unknown | |
value | Unknown |
candidate_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
candidate_id | Unknown | PKFK |
is_primary | Unknown | |
type | Unknown | |
value | Unknown |
candidate_social_link
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
candidate_id | Unknown | PKFK |
type | Unknown | |
url | Unknown |
candidate_application_id
| Column | Type | Keys |
|---|---|---|
candidate_id | Unknown | PKFK |
id | Unknown | PKFK |
candidate_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | PKFK |
is_archived | Unknown | |
title | Unknown |
candidate_file_hadle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | PKFK |
handle | Unknown | |
name | Unknown |
candidate_custom_field
| Column | Type | Keys |
|---|---|---|
candidate_id | Unknown | PKFK |
id | Unknown | PKFK |
value | Unknown |
candidate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
credited_to_user_id | Unknown | FK |
primary_location_id | Unknown | FK |
source_id | Unknown | FK |
company | Unknown | |
created_at | Unknown | |
name | Unknown | |
position | Unknown | |
primary_location_summary | Unknown | |
profile_url | Unknown | |
resume_file_handle_handle | Unknown | |
resume_file_handle_id | Unknown | |
resume_file_handle_name | Unknown | |
school | Unknown | |
timezone | Unknown | |
updated_at | Unknown | |
primary_location_component_** |
interview_stage_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
orders | Unknown | |
stage_type | Unknown | |
title | Unknown |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
is_archived | Unknown | |
name | Unknown |
custom_field_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
custom_field_id | Unknown | PKFK |
is_archived | Unknown | |
label | Unknown | |
value | Unknown |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
field_type | Unknown | |
is_archived | Unknown | |
is_private | Unknown | |
object_type | Unknown | |
title | Unknown |
hiring_team_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
title | Unknown |
opening_job_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
opening_id | Unknown | PKFK |
job_id | Unknown | FK |
opening_location_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
opening_id | Unknown | PKFK |
location_id | Unknown | FK |
opening_hiring_team
| Column | Type | Keys |
|---|---|---|
opening_id | Unknown | PKFK |
user_id | Unknown | PKFK |
role | Unknown |
opening_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
opening_id | Unknown | PKFK |
value | Unknown |
opening
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
archived_at | Unknown | |
closed_at | Unknown | |
is_archived | Unknown | |
latest_version_author_id | Unknown | |
latest_version_created_at | Unknown | |
latest_version_description | Unknown | |
latest_version_employment_type | Unknown | |
latest_version_id | Unknown | |
latest_version_identifier | Unknown | |
latest_version_is_backfill | Unknown | |
latest_version_target_hire_date | Unknown | |
latest_version_target_start_date | Unknown | |
latest_version_team_id | Unknown | |
opened_at | Unknown | |
opening_state | Unknown |
candidate_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | PKFK |
author_id | Unknown | FK |
content | Unknown | |
created_at | Unknown |
application_custom_field
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
id | Unknown | PKFK |
value | Unknown |
application_hiring_team
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
user_id | Unknown | PKFK |
role | Unknown |
application_opening
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
id | Unknown | PKFK |
application
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
candidate_id | Unknown | FK |
credit_to_user_id | Unknown | FK |
job_id | Unknown | FK |
source_id | Unknown | FK |
applied_via_job_posting_id | Unknown | |
archive_reason_id | Unknown | |
archive_reason_is_archived | Unknown | |
archive_reason_text | Unknown | |
archive_reason_type | Unknown | |
archived_at | Unknown | |
created_at | Unknown | |
current_interview_stage_group_id | Unknown | |
current_interview_stage_id | Unknown | |
current_interview_stage_order_in_interview_plan | Unknown | |
current_interview_stage_plan_id | Unknown | |
current_interview_stage_title | Unknown | |
current_interview_stage_type | Unknown | |
status | Unknown | |
updated_at | Unknown |
interview_pool_training_stage_approval
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
interview_pool_id | Unknown | PKFK |
interview_pool_training_stage_id | Unknown | PKFK |
interview_pool_training_stage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interview_pool_id | Unknown | PKFK |
approval_required | Unknown | |
interviewer_required | Unknown | |
interviewer_role | Unknown |
interview_pool
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
is_archived | Unknown | |
title | Unknown | |
training_path_enabled | Unknown | |
training_path_id | Unknown |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_location_id | Unknown | FK |
is_archived | Unknown | |
is_remote | Unknown | |
name | Unknown | |
postal_address_country | Unknown | |
postal_address_locality | Unknown | |
postal_address_region | Unknown | |
title | Unknown | |
type | Unknown |
interview
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
feedback_form_definition_id | Unknown | |
instruction_html | Unknown | |
instruction_plain | Unknown | |
is_archived | Unknown | |
is_debrief | Unknown | |
title | Unknown |