Fountain
Explore the interactive ERD
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 | PKFK |
timestamp_id | Unknown | PKFK |
timestamp_data_key
| Column | Type | Keys |
|---|---|---|
data_key | Unknown | PK |
timestamps_id | Unknown | PKFK |
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 | PKFK |
template_id | Unknown | PKFK |
template_field
| Column | Type | Keys |
|---|---|---|
field | Unknown | PK |
template_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
goal | Unknown | |
path_name | Unknown | |
progress | Unknown | |
url | Unknown |
applicant_course_result
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
applicant_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
applicant_data
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
applicant_id | Unknown | PKFK |
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 |