# Pinpoint schema ERD

Table and field reference for the Fivetran Pinpoint connector.

## 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 | PK, FK |
| equality_monitoring_option_id | Unknown | PK, FK |

### 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 | PK, FK |
| question_id | Unknown | PK, FK |

### job_custom_attribute_data

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

### 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 | PK, FK |
| job_seeker_id | Unknown | PK, FK |

### job_seeker_answer_data

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK, FK |
| job_seeker_id | Unknown | PK, FK |

### 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 | PK, FK |
| custom_attribute_id | Unknown | PK, FK |

### application_answer_data

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK, FK |
| application_id | Unknown | PK, FK |

### application_scorecard_rating_data

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Unknown | PK, FK |
| scorecard_rating_id | Unknown | PK, FK |

### application_scorecard_note_data

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Unknown | PK, FK |
| scorecard_note_id | Unknown | PK, FK |

### application_scorecard_answer_data

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Unknown | PK, FK |
| scorecard_answer_id | Unknown | PK, FK |

### application_offer_data

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Unknown | PK, FK |
| offer_id | Unknown | PK, FK |

### application_comment_data

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Unknown | PK, FK |
| comment_id | Unknown | PK, FK |

### application_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_id | Unknown | PK, FK |
| context | Unknown |  |
| filename | Unknown |  |
| url | Unknown |  |

### application_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| application_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- offer(stage_id) → stage(id)
- offer(manager_id) → users(id)
- offer(creator_id) → users(id)
- scorecard_answer(user_id) → users(id)
- scorecard_note(user_id) → users(id)
- scorecard_rating(user_id) → users(id)
- equality_monitoring_options_data(equality_monitoring_option_id) → equality_monitoring_option(id)
- equality_monitoring_options_data(equality_monitoring_category_id) → equality_monitoring_category(id)
- onboarding_application(application_id) → application(id)
- job_question_data(question_id) → question(id)
- job_question_data(job_id) → job(id)
- job_custom_attribute_data(custom_attribute_id) → job_seeker_custom_attribute(id)
- job_custom_attribute_data(job_id) → job(id)
- job(department_id) → department(id)
- job(recruitment_manager_user_id) → users(id)
- job(division_id) → division(id)
- job(hiring_manager_user_id) → users(id)
- job(location_id) → location(id)
- job(structure_custom_group_one_id) → structure_custom_group_one(id)
- job_seeker_custom_attributes_data(custom_attribute_id) → job_seeker_custom_attribute(id)
- job_seeker_custom_attributes_data(job_seeker_id) → job_seeker(id)
- job_seeker_answer_data(answer_id) → answer(id)
- job_seeker_answer_data(job_seeker_id) → job_seeker(id)
- application_custom_attributes_data(custom_attribute_id) → job_seeker_custom_attribute(id)
- application_custom_attributes_data(application_id) → application(id)
- application_answer_data(answer_id) → answer(id)
- application_answer_data(application_id) → application(id)
- application_scorecard_rating_data(scorecard_rating_id) → scorecard_rating(id)
- application_scorecard_rating_data(application_id) → application(id)
- application_scorecard_note_data(scorecard_note_id) → scorecard_note(id)
- application_scorecard_note_data(application_id) → application(id)
- application_scorecard_answer_data(scorecard_answer_id) → scorecard_answer(id)
- application_scorecard_answer_data(application_id) → application(id)
- application_offer_data(offer_id) → offer(id)
- application_offer_data(application_id) → application(id)
- application_comment_data(comment_id) → comment(id)
- application_comment_data(application_id) → application(id)
- application_attachment(application_id) → application(id)
- application_tag(application_id) → application(id)
- application(job_id) → job(id)
- application(stage_id) → stage(id)
- location(equality_monitoring_template_id) → equality_monitoring_template(id)
- comment(user_id) → users(id)
- interview_part_data(interview_id) → interview(id)
- interview(stage_id) → stage(id)
- custom_attribute(custom_field_id) → custom_field(id)
- custom_attribute(custom_attributable_id) → custom_attribute(id)
- custom_attribute_included(id) → custom_attribute(id)
- candidate_survey(application_id) → application(id)
- candidates_survey_included(stage_id) → stage(id)
- candidates_survey_included(job_id) → job(id)