Pinpoint
Explore the interactive ERD
Table & Field Reference
offer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
manager_id | Unknown | FK |
stage_id | Unknown | FK |
comment | Unknown | |
created_at | Instant | |
expires_at | Unknown | |
paid_days_off | Unknown | |
result | Unknown | |
result_at | Instant | |
salary_amount | Unknown | |
salary_currency | Unknown | |
salary_period | Unknown | |
sent_at | Instant | |
signature_type | Unknown | |
start_on | LocalDate | |
status | Unknown | |
type | Unknown | |
updated_at | Instant | |
work_address | Unknown |
scorecard_answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
question_id | Unknown | |
text_answer | Unknown | |
type | Unknown |
scorecard_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
body | Unknown | |
scorecard_id | Unknown | |
type | Unknown |
scorecard_rating
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
score | Unknown | |
type | Unknown |
answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
additional_information | Unknown | |
boolean_answer | Unknown | |
created_at | Unknown | |
date_answer | Unknown | |
document_answer | Unknown | |
multiple_choice_answer | Unknown | |
question_type | Unknown | |
text_answer | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown | |
url_answer | Unknown |
equality_monitoring_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown |
division
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Instant |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Instant | |
custom_field_option_id | Unknown | |
description | Unknown | |
field_type | Unknown | |
name | Unknown | |
options | Json | |
position | Unknown | |
required | Unknown | |
resource_type | Unknown | |
sample_value | Unknown | |
unique_reference | Unknown | |
updated_at | Instant |
custom_fields_included
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Instant | |
label | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Instant | |
value | Unknown |
equality_monitoring_options_data
| Column | Type | Keys |
|---|---|---|
equality_monitoring_category_id | Unknown | PKFK |
equality_monitoring_option_id | Unknown | PKFK |
equality_monitoring_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
enabled | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Instant |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
time_zone | Unknown | |
type | Unknown | |
updated_at | Unknown |
onboarding_application
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
application_id | Unknown | FK |
created_at | Unknown | |
start_at | Unknown | |
status | Unknown | |
type | Unknown | |
updated_at | Instant |
job_seeker_custom_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
field_name | Unknown | |
type | Unknown | |
updated_at | Unknown | |
value | Unknown |
job_question_data
| Column | Type | Keys |
|---|---|---|
job_id | Unknown | PKFK |
question_id | Unknown | PKFK |
job_custom_attribute_data
| Column | Type | Keys |
|---|---|---|
custom_attribute_id | Unknown | PKFK |
job_id | Unknown | PKFK |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
division_id | Unknown | FK |
hiring_manager_user_id | Unknown | FK |
location_id | Unknown | FK |
recruitment_manager_user_id | Unknown | FK |
structure_custom_group_one_id | Unknown | FK |
application_form_url | Unknown | |
benefits | Unknown | |
benefits_header | Unknown | |
compensation | Unknown | |
compensation_currency | Unknown | |
compensation_frequency | Unknown | |
compensation_maximum | Unknown | |
compensation_minimum | Unknown | |
compensation_visible | Unknown | |
created_at | Unknown | |
deadline_at | Unknown | |
description | Unknown | |
employment_type | Unknown | |
employment_type_text | Unknown | |
key_responsibilities | Unknown | |
key_responsibilities_header | Unknown | |
opened_at | Unknown | |
path | Unknown | |
remote | Unknown | |
reporting_to | Unknown | |
requisition_id | Unknown | |
skills_knowledge_expertise | Unknown | |
skills_knowledge_expertise_header | Unknown | |
status | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Instant | |
url | Unknown | |
visibility | Unknown | |
workplace_type | Unknown | |
workplace_type_text | Unknown |
job_seeker_custom_attributes_data
| Column | Type | Keys |
|---|---|---|
custom_attribute_id | Unknown | PKFK |
job_seeker_id | Unknown | PKFK |
job_seeker_answer_data
| Column | Type | Keys |
|---|---|---|
answer_id | Unknown | PKFK |
job_seeker_id | Unknown | PKFK |
job_seeker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address_1 | Unknown | |
address_2 | Unknown | |
channel | Unknown | |
channel_source | Unknown | |
comments_data | Json | |
country | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
email | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
last_name | Unknown | |
locale | Unknown | |
phone | Unknown | |
phone_iso_2 | Unknown | |
pipeline_source | Unknown | |
postcode | Unknown | |
summary | Unknown | |
town | Unknown | |
type | Unknown | |
updated_at | Instant |
equality_monitoring_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
name | Unknown | |
position | Unknown | |
type | Unknown | |
updated_at | Unknown |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Instant |
question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
additional_information | Unknown | |
created_at | Unknown | |
max_num_required_answer_options | Unknown | |
multiple_choice_options | Unknown | |
num_required_answer_options | Unknown | |
question_type | Unknown | |
required | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Unknown |
stage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
basic_type | Unknown | |
created_at | Unknown | |
description | Unknown | |
external_name | Unknown | |
name | Unknown | |
position | Unknown | |
type | Unknown | |
updated_at | Unknown | |
visible | Unknown |
structure_custom_group_one
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
name | Unknown | |
title | Unknown | |
type | Unknown | |
updated_at | Instant |
application_custom_attributes_data
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
custom_attribute_id | Unknown | PKFK |
application_answer_data
| Column | Type | Keys |
|---|---|---|
answer_id | Unknown | PKFK |
application_id | Unknown | PKFK |
application_scorecard_rating_data
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
scorecard_rating_id | Unknown | PKFK |
application_scorecard_note_data
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
scorecard_note_id | Unknown | PKFK |
application_scorecard_answer_data
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
scorecard_answer_id | Unknown | PKFK |
application_offer_data
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
offer_id | Unknown | PKFK |
application_comment_data
| Column | Type | Keys |
|---|---|---|
application_id | Unknown | PKFK |
comment_id | Unknown | PKFK |
application_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
application_id | Unknown | PKFK |
context | Unknown | |
filename | Unknown | |
url | Unknown |
application_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
application_id | Unknown | PKFK |
context | Unknown | |
name | Unknown |
application
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
stage_id | Unknown | FK |
address_1 | Unknown | |
address_2 | Unknown | |
average_rating | Unknown | |
channel | Unknown | |
channel_source | Unknown | |
concealed | Unknown | |
country | Unknown | |
created_at | Unknown | |
date_of_birth | Unknown | |
email | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
hired_at | Unknown | |
internal_candidate | Unknown | |
is_demo | Unknown | |
last_name | Unknown | |
linkedin_url | Unknown | |
locale | Unknown | |
national_identifier | Unknown | |
onboarding_application_data | Unknown | |
phone | Unknown | |
phone_iso_2 | Unknown | |
postcode | Unknown | |
preferred_pronouns | Unknown | |
rejected_at | Unknown | |
start_on | Unknown | |
summary | Unknown | |
town | Unknown | |
type | Unknown | |
updated_at | Instant |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
equality_monitoring_template_id | Unknown | FK |
city | Unknown | |
country_code | Unknown | |
created_at | Unknown | |
name | Unknown | |
postal_code | Unknown | |
province | Unknown | |
street_address | Unknown | |
type | Unknown | |
updated_at | Instant |
comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
body_text | Unknown | |
commentable_id | Unknown | |
commentable_type | Unknown | |
created_at | Unknown | |
private_comment | Unknown | |
type | Unknown | |
updated_at | Instant |
interview_part_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interview_id | Unknown | PKFK |
type | Unknown |
interview
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
stage_id | Unknown | FK |
created_at | Unknown | |
end_at | Unknown | |
interviewable_id | Unknown | |
interviewable_type | Unknown | |
start_at | Unknown | |
status | Unknown | |
type | Unknown | |
updated_at | Instant |
custom_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_attributable_id | Unknown | FK |
custom_field_id | Unknown | FK |
created_at | Instant | |
custom_attributable_type | Unknown | |
field_name | Unknown | |
option_label | Unknown | |
option_value | Unknown | |
updated_at | Instant | |
value | Unknown |
custom_attribute_included
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
type | Unknown | |
custom_** |
candidate_survey
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
application_id | Unknown | FK |
comment | Unknown | |
created_at | Instant | |
rating | Unknown | |
responded_at | Instant | |
updated_at | Instant |
candidates_survey_included
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
stage_id | Unknown | FK |
address_1 | Unknown | |
address_2 | Unknown | |
attachments | Json | |
average_rating | Unknown | |
candidate_id | Unknown | |
channel | Unknown | |
channel_source | Unknown | |
concealed | Unknown | |
country | Unknown | |
country_code | Unknown | |
country_code_alpha_3 | Unknown | |
country_name | Unknown | |
created_at | Instant | |
date_of_birth | Unknown | |
days_in_current_stage | Unknown | |
email | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
hired_at | Instant | |
internal_candidate | Unknown | |
is_demo | Unknown | |
last_name | Unknown | |
locale | Unknown | |
national_identifier | Unknown | |
phone | Unknown | |
phone_iso_2 | Unknown | |
postcode | Unknown | |
preferred_pronouns | Unknown | |
rejected_at | Instant | |
start_on | LocalDate | |
summary | Unknown | |
tags | Json | |
town | Unknown | |
type | Unknown | |
updated_at | Instant |