Gem

Explore the interactive ERD

Table & Field Reference

project_value_option

Column	Type	Keys
`value_option_id`	Unknown	PK
`field_project_id`	Unknown	PKFK
`project_field_index`	Unknown	PKFK

project_field

Column	Type	Keys
`index`	Unknown	PK
`project_id`	Unknown	PKFK
`id`	Unknown
`name`	Unknown
`value`	Unknown
`value_type`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`context`	Unknown
`created_at`	Unknown
`description`	Unknown
`is_archived`	Unknown
`name`	Unknown
`privacy_type`	Unknown

candidate_custom_value_option

Column	Type	Keys
`candidate_custom_field_index`	Unknown	PKFK
`custom_field_candidate_id`	Unknown	PKFK
`custom_value_option_id`	Unknown	PKFK

candidate_custom_field

Column	Type	Keys
`index`	Unknown	PK
`candidate_id`	Unknown	PKFK
`id`	Unknown	FK
`project_id`	Unknown	FK

candidate_work_info

Column	Type	Keys
`_fivetran_id`	String	PK
`candidate_id`	Unknown	FK
`company`	Unknown
`is_current`	Unknown
`title`	Unknown
`work_end_date`	Unknown
`work_start_date`	Unknown

candidate_education_info

Column	Type	Keys
`_fivetran_id`	String	PK
`candidate_id`	Unknown	FK
`degree`	Unknown
`end_date`	Unknown
`field_of_study`	Unknown
`school`	Unknown
`start_date`	Unknown

candidate_profile

Column	Type	Keys
`_fivetran_id`	String	PK
`candidate_id`	Unknown	FK
`network`	Unknown
`url`	Unknown
`user_name`	Unknown

candidate_email

Column	Type	Keys
`_fivetran_id`	String	PK
`candidate_id`	Unknown	FK
`email_address`	Unknown
`is_primary`	Unknown

candidate_project

Column	Type	Keys
`candidate_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

candidate

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown	FK
`user_id`	Unknown	FK
`candidate_greenhouse_id`	Unknown
`company`	Unknown
`created_at`	Unknown
`due_date`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`linked_in_handle`	Unknown
`location`	Unknown
`nickname`	Unknown
`note`	Unknown
`phone_number`	Unknown
`school`	Unknown
`sourced_from`	Unknown
`title`	Unknown
`weblink`	Unknown

ats_office

Column	Type	Keys
`id`	Unknown	PK
`child_department_external_id`	Json
`child_id`	Json
`deleted_at`	Instant
`location_name`	Unknown
`name`	Unknown
`parent_id`	Unknown
`parent_office_external_id`	Unknown

custom_field_option

Column	Type	Keys
`id`	Unknown	PK
`custom_field_id`	Unknown	PKFK
`is_hidden`	Unknown
`value`	Unknown

custom_field

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`created_at`	Unknown
`is_hidden`	Unknown
`name`	Unknown
`scope`	Unknown
`value_type`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown
`name`	Unknown

sequence

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`created_at`	Instant
`name`	Unknown

candidate_note

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	FK
`user_id`	Unknown	FK
`content`	Unknown
`is_private`	Unknown
`time_stamp`	Unknown

candidate_uploaded_resumes

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`download_url`	Unknown
`file_name`	Unknown

ats_scheduled_interviewer

Column	Type	Keys
`id`	Unknown	PK
`ats_scheduled_interview_id`	Unknown	PKFK
`scorecard_id`	Unknown	FK
`email`	Unknown
`employee_id`	Unknown
`name`	Unknown
`response_status`	Unknown

ats_scheduled_interview_question

Column	Type	Keys
`id`	Unknown	PK
`ats_scheduled_interview_id`	Unknown	PKFK
`answer`	Unknown
`option`	Json
`question`	Unknown
`type`	Unknown

ats_scheduled_interview

Column	Type	Keys
`id`	Unknown	PK
`ats_application_id`	Unknown	FK
`ats_candidate_id`	Unknown	FK
`organizer_id`	Unknown	FK
`created_at`	Instant
`end_date_time`	Instant
`external_event_id`	Unknown
`interview_id`	Unknown
`interview_name`	Unknown
`job_stage_interview_item_id`	Unknown
`location`	Unknown
`start_date_time`	Instant
`status`	Unknown
`updated_at`	Instant
`video_conferencing_url`	Unknown

ats_application_job

Column	Type	Keys
`id`	Unknown	PK
`ats_application_id`	Unknown	PKFK
`name`	Unknown

ats_application

Column	Type	Keys
`id`	Unknown	PK
`ats_candidate_id`	Unknown	FK
`ats_job_post_id`	Unknown	FK
`applied_at`	Instant
`coordinator_email`	Unknown
`coordinator_id`	Unknown
`credited_to`	Unknown
`current_stage_id`	Unknown
`current_stage_name`	Unknown
`deleted_at`	Instant
`last_activity_at`	Instant
`recruiter_email`	Unknown
`recruiter_id`	Unknown
`rejected_at`	Instant
`rejection_reason_id`	Unknown
`rejection_reason_name`	Unknown
`rejection_reason_type`	Json
`source_public_name`	Unknown
`source_user_id`	Unknown
`sourcer_email`	Unknown
`sourcer_id`	Unknown
`status`	Unknown
`custom_fields_`

ats_opening

Column	Type	Keys
`id`	Unknown	PK
`ats_application_id`	Unknown	FK
`closed_at`	Instant
`deleted_at`	Instant
`opened_at`	Instant
`opening_id`	Unknown
`status`	Unknown
`target_hire_date`	LocalDate
`target_start_date`	LocalDate
`custom_fields_`

ats_scorecard_question

Column	Type	Keys
`id`	Unknown	PK
`ats_scorecard_id`	Unknown	PKFK
`answer`	Unknown
`option`	Json
`question`	Unknown
`type`	Unknown

ats_scorecard

Column	Type	Keys
`id`	Unknown	PK
`ats_application_id`	Unknown	FK
`ats_candidate_id`	Unknown	FK
`created_at`	Instant
`deleted_at`	Instant
`interview`	Unknown
`interview_id`	Unknown
`interview_step_id`	Unknown
`interview_step_name`	Unknown
`interviewed_at`	Instant
`interviewer_employee_id`	Unknown
`interviewer_first_name`	Unknown
`interviewer_id`	Unknown
`interviewer_last_name`	Unknown
`interviewer_name`	Unknown
`overall_feedback`	Unknown
`overall_recommendation`	Unknown
`submitted_at`	Instant
`submitted_by_employee_id`	Unknown
`submitted_by_first_name`	Unknown
`submitted_by_id`	Unknown
`submitted_by_last_name`	Unknown
`submitted_by_name`	Unknown
`updated_at`	Instant

ats_candidate_attachment

Column	Type	Keys
`index`	Unknown	PK
`ats_candidate_id`	Unknown	PKFK
`created_at`	Instant
`file_name`	Unknown
`type`	Unknown
`url`	Unknown

ats_candidate_education

Column	Type	Keys
`id`	Unknown	PK
`ats_candidate_id`	Unknown	PKFK
`degree`	Unknown
`discipline`	Unknown
`end_date`	LocalDate
`school_name`	Unknown
`start_date`	LocalDate

ats_candidate_employment

Column	Type	Keys
`id`	Unknown	PK
`ats_candidate_id`	Unknown	PKFK
`company_name`	Unknown
`end_date`	LocalDate
`start_date`	LocalDate
`title`	Unknown

ats_candidate

Column	Type	Keys
`id`	Unknown	PK
`company`	Unknown
`created_at`	Instant
`deleted_at`	Instant
`email_address`	Json
`first_name`	Unknown
`is_private`	Unknown
`last_activity`	Instant
`last_name`	Unknown
`linked_user_id`	Json
`phone_number`	Json
`social_media_address`	Json
`tags`	Json
`title`	Unknown
`updated_at`	Instant

ats_user_office

Column	Type	Keys
`ats_user_id`	Unknown	PKFK
`id`	Unknown	PKFK

ats_user_department

Column	Type	Keys
`ats_user_id`	Unknown	PKFK
`id`	Unknown	PKFK

ats_user

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Instant
`deleted_at`	Instant
`disabled`	Unknown
`email`	Json
`employee_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`linked_ats_candidate_id`	Json
`name`	Unknown
`primary_email_address`	Unknown
`site_admin`	Unknown
`updated_at`	Instant

ats_job_post

Column	Type	Keys
`id`	Unknown	PK
`ats_job_id`	Unknown	FK
`active`	Unknown
`content`	Unknown
`created_at`	Instant
`deleted_at`	Instant
`external`	Unknown
`first_published_at`	Instant
`internal`	Unknown
`internal_content`	Unknown
`listed`	Unknown
`live`	Unknown
`title`	Unknown
`updated_at`	Instant

ats_job_department

Column	Type	Keys
`id`	Unknown	PK
`ats_job_id`	Unknown	PKFK
`parent_id`	Unknown	FK
`child_department_external_id`	Json
`child_id`	Json
`deleted_at`	Instant
`name`	Unknown
`parent_department_external_id`	Unknown

ats_job_office

Column	Type	Keys
`ats_job_id`	Unknown	PKFK
`id`	Unknown	PKFK

ats_job_hiring_team_manager

Column	Type	Keys
`id`	Unknown	PK
`ats_job_id`	Unknown	PKFK
`employee_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`name`	Unknown

ats_job_hiring_team_recruiter

Column	Type	Keys
`id`	Unknown	PK
`ats_job_id`	Unknown	PKFK
`employee_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`name`	Unknown

ats_job_hiring_team_coordinator

Column	Type	Keys
`id`	Unknown	PK
`ats_job_id`	Unknown	PKFK
`employee_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`name`	Unknown

ats_job_hiring_team_sourcer

Column	Type	Keys
`id`	Unknown	PK
`ats_job_id`	Unknown	PKFK
`employee_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`name`	Unknown

ats_job

Column	Type	Keys
`id`	Unknown	PK
`closed_at`	Instant
`confidential`	Unknown
`created_at`	Instant
`deleted_at`	Instant
`is_template`	Unknown
`name`	Unknown
`opened_at`	Instant
`requisition_id`	Unknown
`status`	Unknown
`updated_at`	Instant
`custom_fields_`

ats_offer_compensation

Column	Type	Keys
`index`	Unknown	PK
`ats_offer_id`	Unknown	PKFK
`currency_code`	Unknown
`interval`	Unknown
`type`	Unknown
`unit`	Unknown
`value`	Unknown
`value_type`	Unknown

ats_offer

Column	Type	Keys
`id`	Unknown	PK
`ats_application_id`	Unknown	FK
`ats_candidate_id`	Unknown	FK
`ats_job_id`	Unknown	FK
`opening_id`	Unknown	FK
`created_at`	Instant
`deleted_at`	Instant
`sent_at`	LocalDate
`starts_at`	LocalDate
`status`	Unknown
`updated_at`	Instant

ats_job_stage_interview_default_interviewer_user

Column	Type	Keys
`id`	Unknown	PK
`ats_job_stage_id`	Unknown	PKFK
`ats_job_stage_interview_id`	Unknown	PKFK
`employee_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`name`	Unknown

ats_job_stage_interview_question

Column	Type	Keys
`id`	Unknown	PK
`ats_job_stage_id`	Unknown	PKFK
`ats_job_stage_interview_id`	Unknown	PKFK
`question`	Unknown

ats_job_stage_interview

Column	Type	Keys
`id`	Unknown	PK
`ats_job_stage_id`	Unknown	PKFK
`deleted_at`	Instant
`estimated_minutes`	Unknown
`interview_kit_content`	Unknown
`interview_kit_id`	Unknown
`item_id`	Unknown
`name`	Unknown
`schedulable`	Unknown

ats_job_stage

Column	Type	Keys
`id`	Unknown	PK
`ats_job_id`	Unknown	FK
`active`	Unknown
`created_at`	Instant
`deleted_at`	Instant
`name`	Unknown
`priority`	Unknown
`updated_at`	Instant