# Fountain schema ERD

Table and field reference for the Fivetran Fountain connector.

## Table & Field Reference

### worker_data_collection_check

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| worker_id | Unknown | FK |
| canceled_at | Unknown |  |
| confirmed_at | Unknown |  |
| confirmed_user | Unknown |  |
| rejected_at | Unknown |  |
| requested_at | Unknown |  |
| status | Unknown |  |
| uploaded_at | Unknown |  |

### worker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approved_at | Unknown |  |
| email | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicant_id | Unknown | FK |
| user_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### timestamp_funnel

| Column | Type | Keys |
| --- | --- | --- |
| funnel_id | Unknown | PK, FK |
| timestamp_id | Unknown | PK, FK |

### timestamp_data_key

| Column | Type | Keys |
| --- | --- | --- |
| data_key | Unknown | PK |
| timestamps_id | Unknown | PK, FK |

### timestamps

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| busy | Unknown |  |
| lower_bound | Unknown |  |
| number_of_days | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| upper_bound | Unknown |  |

### user_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicant_id | Unknown | FK |
| user_id | Unknown | FK |
| activity_field | Unknown |  |
| activity_funnel_id | Unknown |  |
| activity_funnel_title | Unknown |  |
| activity_stage_id | Unknown |  |
| activity_stage_title | Unknown |  |
| activity_type | Unknown |  |
| created_at | Unknown |  |
| key | Unknown |  |
| owner_id | Unknown |  |
| owner_type | Unknown |  |

### template_funnel

| Column | Type | Keys |
| --- | --- | --- |
| funnel_id | Unknown | PK, FK |
| template_id | Unknown | PK, FK |

### template_field

| Column | Type | Keys |
| --- | --- | --- |
| field | Unknown | PK |
| template_id | Unknown | PK, FK |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| title | Unknown |  |

### applicant_label

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| applicant_id | Unknown | FK |
| completed | Unknown |  |
| title | Unknown |  |

### interview_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicant_id | Unknown | FK |
| stage_title | Unknown | FK |
| booked_time | Unknown |  |
| end_time | Unknown |  |
| instructions | Unknown |  |
| location | Unknown |  |
| recruiter | Unknown |  |
| showed_up | Unknown |  |
| start_time | Unknown |  |

### applicant_background_check

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| applicant_id | Unknown | PK, FK |
| background_applicant_id | Unknown |  |
| candidate_id | Unknown |  |
| check_id | Unknown |  |
| report_id | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| vendor | Unknown |  |

### applicant_partner_data

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| applicant_id | Unknown | FK |
| description | Unknown |  |
| example | Json |  |
| type | Unknown |  |

### applicant_document_signature

| Column | Type | Keys |
| --- | --- | --- |
| signature_id | Unknown | PK |
| applicant_id | Unknown | FK |
| file_url | Unknown |  |
| status | Unknown |  |
| vendor | Unknown |  |

### applicant_lessonly_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| applicant_id | Unknown | PK, FK |
| completed_at | Unknown |  |
| lesson_name | Unknown |  |
| lesson_url | Unknown |  |
| report_card_url | Unknown |  |
| score_percent | Unknown |  |

### applicant_path_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| applicant_id | Unknown | PK, FK |
| goal | Unknown |  |
| path_name | Unknown |  |
| progress | Unknown |  |
| url | Unknown |  |

### applicant_course_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| applicant_id | Unknown | PK, FK |
| course_name | Unknown |  |
| goal | Unknown |  |
| progress | Unknown |  |
| url | Unknown |  |

### applicant_address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| applicant_id | Unknown | FK |
| address_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| state | Unknown |  |
| street_name | Unknown |  |
| zip_code | Unknown |  |

### applicant_file_upload_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicant_id | Unknown | FK |
| created_at | Unknown |  |
| document_name | Unknown |  |
| recollection_reason | Unknown |  |

### applicant_score_card_result_answer

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| applicant_id | Unknown | FK |
| applicant_score_card_result_user_id | Unknown | FK |
| note | Unknown |  |
| question_text | Unknown |  |
| question_weight | Unknown |  |
| score | Unknown |  |

### applicant_score_card_result

| Column | Type | Keys |
| --- | --- | --- |
| applicant_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| score | Unknown |  |
| template_name | Unknown |  |
| template_type | Unknown |  |
| template_weighted | Unknown |  |

### applicant_partner_language

| Column | Type | Keys |
| --- | --- | --- |
| languages | Unknown | PK |
| applicant_id | Unknown | PK, FK |

### applicant_data

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| applicant_id | Unknown | PK, FK |
| value | Unknown |  |

### applicant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| funnel_id | Unknown | FK |
| stage_id | Unknown | FK |
| bank_account_number | Unknown |  |
| bank_name | Unknown |  |
| bank_routing_number | Unknown |  |
| can_receive_sms | Unknown |  |
| can_work_in_us | Unknown |  |
| certifications_license | Unknown |  |
| citizenship | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| desired_employment_duration | Unknown |  |
| desired_hours_per_week | Unknown |  |
| did_apply_multiple_time | Unknown |  |
| driver_license_expiration_date | Unknown |  |
| driver_license_number | Unknown |  |
| driver_license_state | Unknown |  |
| earnings_expectations | Unknown |  |
| education | Unknown |  |
| email | Unknown |  |
| emergency_contact_name | Unknown |  |
| emergency_contact_phone | Unknown |  |
| emergency_contact_relationship | Unknown |  |
| ethnicity | Unknown |  |
| facebook | Unknown |  |
| first_language | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| have_prior_experience | Unknown |  |
| have_transportation | Unknown |  |
| income_income_tax_dollar_amount | Unknown |  |
| income_medicare_tax | Unknown |  |
| income_salary | Unknown |  |
| income_ss_tax | Unknown |  |
| income_taxpayer_identification_number | Unknown |  |
| insurance_benefactor_first_name | Unknown |  |
| insurance_benefactor_last_name | Unknown |  |
| insurance_benefactor_middle_name | Unknown |  |
| insurance_city_of_issue | Unknown |  |
| insurance_company_group_id | Unknown |  |
| insurance_company_of_issue | Unknown |  |
| insurance_country_of_issue | Unknown |  |
| insurance_expiration_date | Unknown |  |
| insurance_issue_date | Unknown |  |
| insurance_member_id | Unknown |  |
| insurance_type | Unknown |  |
| is_duplicate | Unknown |  |
| last_name | Unknown |  |
| last_transitioned_at | Unknown |  |
| linkedin | Unknown |  |
| name | Unknown |  |
| national_identification_number | Unknown |  |
| normalized_phone_number | Unknown |  |
| on_hold_reason | Unknown |  |
| passport_city_of_issue | Unknown |  |
| passport_country_of_issue | Unknown |  |
| passport_expiration_date | Unknown |  |
| passport_issue_date | Unknown |  |
| passport_number | Unknown |  |
| phone_number | Unknown |  |
| phone_number_country_code | Unknown |  |
| phone_platform | Unknown |  |
| previous_work | Unknown |  |
| receive_automated_email | Unknown |  |
| referral_source | Unknown |  |
| rejection_reason | Unknown |  |
| secure_data | Json |  |
| ssn | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| success_in_job | Unknown |  |
| team_or_solo | Unknown |  |
| twitter | Unknown |  |
| updated_at | Unknown |  |
| vehicle_make | Unknown |  |
| vehicle_model | Unknown |  |
| vehicle_registration_plate_number | Unknown |  |
| vehicle_vin_number | Unknown |  |
| vehicle_year | Unknown |  |
| w_4_federal_additional_properties | Unknown |  |
| w_4_federal_description | Unknown |  |
| w_4_federal_form_url | Unknown |  |
| w_4_federal_required | Json |  |
| w_4_federal_status | Unknown |  |
| w_4_federal_type | Unknown |  |
| w_4_state_additional_properties | Unknown |  |
| w_4_state_description | Unknown |  |
| w_4_state_form_url | Unknown |  |
| w_4_state_required | Json |  |
| w_4_state_status | Unknown |  |
| w_4_state_type | Unknown |  |
| why_should_we_hire_you | Unknown |  |
| work_availability | Unknown |  |
| zip_code | Unknown |  |

### transition

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| applicant_id | Unknown | FK |
| parent_stage_id | Unknown | FK |
| stage_id | Unknown | FK |
| sub_stage_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| transitioned_by | Unknown |  |

### funnel_field

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| funnel_id | Unknown | FK |
| key | Unknown |  |
| question | Unknown |  |
| type | Unknown |  |

### stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| funnel_id | Unknown | FK |
| parent_id | Unknown | FK |
| title | Unknown |  |
| type | Unknown |  |

### funnel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| active | Unknown |  |
| additional_info | Unknown |  |
| address | Unknown |  |
| apply_url | Unknown |  |
| brand | Unknown |  |
| compensation | Unknown |  |
| compensation_currency_code | Unknown |  |
| compensation_type | Unknown |  |
| created_at | Unknown |  |
| custom_id | Unknown |  |
| description | Unknown |  |
| is_private | Unknown |  |
| job_hours | Unknown |  |
| job_industry | Unknown |  |
| job_type | Unknown |  |
| location_group_id | Unknown |  |
| location_group_name | Unknown |  |
| location_id | Unknown |  |
| location_latitude | Unknown |  |
| location_longitude | Unknown |  |
| location_name | Unknown |  |
| name | Unknown |  |
| requirements | Unknown |  |
| time_zone | Unknown |  |
| title | Unknown |  |

### applicant_file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| applicant_id | Unknown | FK |
| stage_id | Unknown | FK |
| approved | Unknown |  |
| filename | Unknown |  |
| friendly_name | Unknown |  |
| name | Unknown |  |
| public_url | Unknown |  |
| size | Unknown |  |
| stage_form_description | Unknown |  |

### stage_label

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| stage_id | Unknown | FK |
| completed | Unknown |  |
| title | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| name | Unknown |  |

## Relationships

- worker_data_collection_check(worker_id) → worker(id)
- note(user_id) → users(id)
- note(applicant_id) → applicant(id)
- timestamp_funnel(funnel_id) → funnel(id)
- timestamp_funnel(timestamp_id) → timestamps(id)
- timestamp_data_key(timestamps_id) → timestamps(id)
- user_activity(applicant_id) → applicant(id)
- user_activity(user_id) → users(id)
- template_funnel(funnel_id) → funnel(id)
- template_funnel(template_id) → template(id)
- template_field(template_id) → template(id)
- applicant_label(applicant_id) → applicant(id)
- interview_session(stage_title) → stage(title)
- interview_session(applicant_id) → applicant(id)
- applicant_background_check(applicant_id) → applicant(id)
- applicant_partner_data(applicant_id) → applicant(id)
- applicant_document_signature(applicant_id) → applicant(id)
- applicant_lessonly_result(applicant_id) → applicant(id)
- applicant_path_result(applicant_id) → applicant(id)
- applicant_course_result(applicant_id) → applicant(id)
- applicant_address(applicant_id) → applicant(id)
- applicant_file_upload_request(applicant_id) → applicant(id)
- applicant_score_card_result_answer(applicant_score_card_result_user_id) → applicant_score_card_result(user_id)
- applicant_score_card_result_answer(applicant_id) → applicant(id)
- applicant_score_card_result(user_id) → users(id)
- applicant_score_card_result(applicant_id) → applicant(id)
- applicant_partner_language(applicant_id) → applicant(id)
- applicant_data(applicant_id) → applicant(id)
- applicant(stage_id) → stage(id)
- applicant(funnel_id) → funnel(id)
- transition(user_id) → users(id)
- transition(stage_id) → stage(id)
- transition(parent_stage_id) → stage(id)
- transition(sub_stage_id) → stage(id)
- transition(applicant_id) → applicant(id)
- funnel_field(funnel_id) → funnel(id)
- stage(parent_id) → stage(id)
- stage(funnel_id) → funnel(id)
- funnel(owner_id) → users(id)
- applicant_file(stage_id) → stage(id)
- applicant_file(applicant_id) → applicant(id)
- stage_label(stage_id) → stage(id)