Greenhouse

Explore the interactive ERD

Table & Field Reference

demographic_answer_option

Column	Type	Keys
`id`	Long	PK
`demographic_question_id`	Long	FK
`active`	Boolean
`created_at`	Instant
`decline_to_answer`	Boolean
`free_form`	Boolean
`name`	String
`sort_order`	Int
`updated_at`	Instant

job_history

Column	Type	Keys
`updated_at`	Instant	PK
`job_id`	Long	PKFK
`closed_at`	Instant
`confidential`	Boolean
`name`	String
`notes`	String
`requisition_id`	String
`status`	String

application_history

Column	Type	Keys
`updated_at`	Instant	PK
`application_id`	Long	PKFK
`new_stage_id`	Long	FK
`new_status`	String

offer_history

Column	Type	Keys
`updated_at`	Instant	PK
`offer_id`	Long	PKFK
`application_id`	Long	FK
`resolved_at`	Instant
`sent_at`	LocalDate
`starts_at`	LocalDate
`status`	String
`version`	Long

demographic_question

Column	Type	Keys
`id`	Long	PK
`demographic_question_set_id`	Long	FK
`active`	Boolean
`answer_type`	String
`created_at`	Instant
`name`	String
`required`	Boolean
`sort_order`	Int
`updated_at`	Instant

rejection_detail

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`rejected_by_id`	Long	FK
`rejection_reason_id`	Long	FK
`created_at`	Instant
`rejected_at`	Instant
`rejection_note_id`	Long
`updated_at`	Instant
`custom_`

job_post_location

Column	Type	Keys
`id`	Long	PK
`job_post_id`	Long	FK
`office_id`	Long	FK
`created_at`	Instant
`custom_location_id`	Long
`plain_text_location`	String
`type`	String
`updated_at`	Instant

office

Column	Type	Keys
`id`	Long	PK
`parent_id`	Long	FK
`primary_in_house_contact_user_id`	Long	FK
`created_at`	Instant
`external_id`	String
`location`	String
`name`	String
`updated_at`	Instant

discipline

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`custom_field_id`	Long
`external_id`	String
`name`	String
`sort_order`	Int
`updated_at`	Instant

source

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`type_id`	Long
`type_name`	String
`updated_at`	Instant

demographic_question_set

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`description`	String
`enabled`	Boolean
`title`	String
`updated_at`	Instant

offer

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`candidate_id`	Long	FK
`job_id`	Long	FK
`opening_id`	Long	FK
`created_at`	Instant
`resolved_at`	Instant
`sent_on`	LocalDate
`starts_on`	LocalDate
`status`	String
`updated_at`	Instant
`version`	Long
`custom_`

school

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`custom_field_id`	Long
`external_id`	String
`name`	String
`sort_order`	Int
`updated_at`	Instant

rejection_reason

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`type_id`	Long
`type_key`	String
`type_name`	String
`updated_at`	Instant

user_email

Column	Type	Keys
`id`	Long	PK
`user_id`	Long	FK
`created_at`	Instant
`email`	String
`updated_at`	Instant
`verification_token_sent_at`	Instant
`verified`	Boolean

approval_flow

Column	Type	Keys
`id`	Long	PK
`job_id`	Long	FK
`offer_id`	Long	FK
`requested_by_id`	Long	FK
`approval_status`	String
`approval_type`	String
`created_at`	Instant
`sequential`	Boolean
`updated_at`	Instant
`version`	Int

degree

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`custom_field_id`	Long
`external_id`	String
`name`	String
`sort_order`	Int
`updated_at`	Instant

prospect_pool_department

Column	Type	Keys
`index`	Int	PK
`prospect_pool_id`	Long	PKFK
`department_id`	Long

prospect_pool_office

Column	Type	Keys
`index`	Int	PK
`prospect_pool_id`	Long	PKFK
`office_id`	Long

prospect_pool_job

Column	Type	Keys
`index`	Int	PK
`prospect_pool_id`	Long	PKFK
`job_id`	Long

prospect_pool

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`description`	String
`name`	String
`updated_at`	Instant

application_stage

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`job_interview_stage_id`	Long	FK
`created_at`	Instant
`current`	Boolean
`days_in_stage`	Int
`entered_at`	Instant
`exited_at`	Instant
`updated_at`	Instant

approver_group

Column	Type	Keys
`id`	Long	PK
`approval_flow_id`	Long	FK
`approvals_required`	Int
`created_at`	Instant
`required_for_exception`	Boolean
`resolved_at`	Instant
`sort_order`	Int
`updated_at`	Instant

user_linked_candidate

Column	Type	Keys
`index`	Int	PK
`user_id`	Long	PKFK
`candidate_id`	Long	FK

user_office

Column	Type	Keys
`index`	Int	PK
`user_id`	Long	PKFK
`office_id`	Long	FK

user_department

Column	Type	Keys
`index`	Int	PK
`user_id`	Long	PKFK
`department_id`	Long	FK

user_interviewer_tag

Column	Type	Keys
`index`	Int	PK
`user_id`	Long	PKFK
`name`	String
`tag_id`	Long

users

Column	Type	Keys
`id`	Long	PK
`agency_id`	Long
`created_at`	Instant
`deactivated`	Boolean
`employee_id`	String
`first_name`	String
`job_title`	String
`last_name`	String
`name`	String
`primary_email`	String
`site_admin`	Boolean
`updated_at`	Instant
`custom_`

candidate_employment

Column	Type	Keys
`id`	Long	PK
`candidate_id`	Long	FK
`company_name`	String
`created_at`	Instant
`end_date`	String
`latest`	Boolean
`start_date`	String
`title`	String
`updated_at`	Instant

job_owner

Column	Type	Keys
`id`	Long	PK
`job_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`responsible`	Boolean
`type`	String
`updated_at`	Instant

close_reason

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

candidate_tag

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

job_office

Column	Type	Keys
`index`	Int	PK
`job_id`	Long	PKFK
`office_id`	Long

job

Column	Type	Keys
`id`	Long	PK
`department_id`	Long	FK
`closed_at`	Instant
`confidential`	Boolean
`copied_from_id`	Long
`created_at`	Instant
`is_template`	Boolean
`name`	String
`notes`	String
`opened_at`	Instant
`requisition_id`	String
`status`	String
`updated_at`	Instant
`custom_`

email_template

Column	Type	Keys
`id`	Long	PK
`user_id`	Long	FK
`body`	String
`cc_coordinator`	Boolean
`cc_recruiter`	Boolean
`created_at`	Instant
`description`	String
`email_type`	String
`from_type`	String
`html_body`	String
`is_default`	Boolean
`name`	String
`office_anywhere`	Boolean
`recipients`	String
`subject`	String
`updated_at`	Instant

note

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`candidate_id`	Long	FK
`user_id`	Long	FK
`body`	String
`body_with_tags`	String
`created_at`	Instant
`email_attachment_file_names`	String
`email_cc`	Json
`email_from`	String
`email_to`	String
`import_hash`	String
`subject`	String
`type`	String
`updated_at`	Instant
`visibility`	String

prospect_pool_stage

Column	Type	Keys
`id`	Long	PK
`prospect_pool_id`	Long	FK
`created_at`	Instant
`name`	String
`sort_order`	Long
`updated_at`	Instant

job_interview_stage

Column	Type	Keys
`id`	Long	PK
`job_id`	Long	FK
`active`	Boolean
`created_at`	Instant
`name`	String
`sort_order`	Int
`updated_at`	Instant

scorecard

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`interviewer_id`	Long	FK
`submitter_id`	Long	FK
`candidate_rating`	String
`created_at`	Instant
`interview_kit_id`	Long
`interviewed_at`	Instant
`notes`	String
`notes_with_tags`	String
`private_notes`	String
`private_notes_with_tags`	String
`public_notes`	String
`public_notes_with_tags`	String
`status`	String
`submitted_at`	Instant
`updated_at`	Instant

user_role

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`role_type`	String
`updated_at`	Instant

candidate_phone_number

Column	Type	Keys
`index`	Int	PK
`candidate_id`	Long	PKFK
`type`	String
`value`	String

candidate_address

Column	Type	Keys
`index`	Int	PK
`candidate_id`	Long	PKFK
`type`	String
`value`	String

candidate_email_address

Column	Type	Keys
`index`	Int	PK
`candidate_id`	Long	PKFK
`type`	String
`value`	String

candidate_website_address

Column	Type	Keys
`index`	Int	PK
`candidate_id`	Long	PKFK
`type`	String
`value`	String

candidate_social_media_address

Column	Type	Keys
`index`	Int	PK
`candidate_id`	Long	PKFK
`value`	String

candidate_linked_user

Column	Type	Keys
`index`	Int	PK
`candidate_id`	Long	PKFK
`user_id`	Long

candidate_tag_link

Column	Type	Keys
`index`	Int	PK
`candidate_id`	Long	PKFK
`tag_name`	String

candidate

Column	Type	Keys
`id`	Long	PK
`can_email`	Boolean
`company`	String
`created_at`	Instant
`first_name`	String
`last_activity_at`	Instant
`last_name`	String
`preferred_name`	String
`private`	Boolean
`time_zone`	String
`title`	String
`updated_at`	Instant
`custom_`

attachment

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`candidate_id`	Long	FK
`created_at`	Instant
`filename`	String
`type`	String
`updated_at`	Instant
`url`	String

job_post_question_option

Column	Type	Keys
`index`	Int	PK
`job_post_id`	Long	PKFK
`job_post_question_index`	Int	PKFK
`label`	String
`option_id`	Long

job_post_question

Column	Type	Keys
`index`	Int	PK
`job_post_id`	Long	PKFK
`answer_type`	String
`description`	String
`label`	String
`name`	String
`private`	Boolean
`question_id`	Long
`required`	Boolean

job_post

Column	Type	Keys
`id`	Long	PK
`job_id`	Long	FK
`active`	Boolean
`content`	String
`created_at`	Instant
`demographic_question_set_id`	Long
`featured`	Boolean
`first_published_at`	Instant
`internal`	Boolean
`internal_content`	String
`job_board_id`	Long
`language_code`	String
`live`	Boolean
`public_url`	String
`title`	String
`updated_at`	Instant

eeoc

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`candidate_id`	Long	FK
`created_at`	Instant
`disability_status_description`	String
`disability_status_id`	Long
`gender_description`	String
`gender_id`	Long
`race_description`	String
`race_id`	Long
`submitted_at`	Instant
`updated_at`	Instant
`veteran_status_description`	String
`veteran_status_id`	Long

department

Column	Type	Keys
`id`	Long	PK
`parent_id`	Long	FK
`created_at`	Instant
`external_id`	String
`name`	String
`updated_at`	Instant

approver

Column	Type	Keys
`id`	Long	PK
`approver_group_id`	Long	FK
`reminder_sent_by_id`	Long	FK
`resolved_by_id`	Long	FK
`user_id`	Long	FK
`added_by_custom_field_id`	Long
`auto_reminders_sent`	Int
`created_at`	Instant
`reminder_sent_at`	Instant
`reminders_sent`	Int
`request_sent_at`	Instant
`resolved_at`	Instant
`send_auto_reminder_at`	String
`sort_order`	Int
`status`	String
`updated_at`	Instant
`version_sent`	Int

interviewer

Column	Type	Keys
`id`	Long	PK
`interview_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`email`	String
`response_status`	String
`scorecard_id`	Long
`updated_at`	Instant

scorecard_candidate_attribute

Column	Type	Keys
`id`	Long	PK
`scorecard_id`	Long	FK
`candidate_attribute_rating`	String
`created_at`	Instant
`job_candidate_attribute_id`	Long
`note`	String
`updated_at`	Instant

job_hiring_manager

Column	Type	Keys
`id`	Long	PK
`job_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`updated_at`	Instant

candidate_education

Column	Type	Keys
`id`	Long	PK
`candidate_id`	Long	FK
`degree_custom_field_option_id`	Long	FK
`discipline_custom_field_option_id`	Long	FK
`school_name_custom_field_option_id`	Long	FK
`created_at`	Instant
`end_at`	Instant
`end_date_month`	Int
`end_date_year`	Int
`latest`	Boolean
`start_at`	Instant
`start_date_month`	Int
`start_date_year`	Int
`updated_at`	Instant

opening

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`close_reason_id`	Long	FK
`job_id`	Long	FK
`closed_at`	Instant
`created_at`	Instant
`is_open`	Boolean
`opened_at`	Instant
`opening_id`	String
`sort_order`	Int
`target_start_on`	LocalDate
`updated_at`	Instant
`custom_`

demographic_answer

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`demographic_answer_option_id`	Long	FK
`demographic_question_id`	Long	FK
`created_at`	Instant
`free_form_text`	String
`updated_at`	Instant

user_job_permission

Column	Type	Keys
`id`	Long	PK
`job_id`	Long	FK
`role_id`	Long	FK
`user_id`	Long	FK
`automated`	Boolean
`created_at`	Instant
`updated_at`	Instant

scorecard_question_answer

Column	Type	Keys
`id`	Long	PK
`scorecard_id`	Long	FK
`answer`	String
`boolean_value`	Boolean
`created_at`	Instant
`scorecard_question_id`	Long
`updated_at`	Instant

application_answer

Column	Type	Keys
`index`	Int	PK
`application_id`	Long	PKFK
`answer`	String
`question`	String

application_prospective_job

Column	Type	Keys
`index`	Int	PK
`application_id`	Long	PKFK
`job_id`	Long

application

Column	Type	Keys
`id`	Long	PK
`candidate_id`	Long	FK
`coordinator_id`	Long	FK
`job_id`	Long	FK
`job_post_id`	Long	FK
`recruiter_id`	Long	FK
`source_id`	Long	FK
`stage_id`	Long	FK
`agency_note_id`	Long
`created_at`	Instant
`last_activity_at`	Instant
`location_address`	String
`needs_decision`	Boolean
`prospect`	Boolean
`referrer_id`	Long
`rejected_at`	Instant
`stage_name`	String
`status`	String
`updated_at`	Instant
`custom_`

interview

Column	Type	Keys
`id`	Long	PK
`application_id`	Long	FK
`job_id`	Long	FK
`organizer_id`	Long	FK
`all_day_end_on`	String
`all_day_start_on`	String
`availability_received_at`	Instant
`created_at`	Instant
`ends_at`	Instant
`external_event_id`	String
`job_interview_id`	Long
`location`	String
`scheduled_at`	Instant
`starts_at`	Instant
`status`	String
`updated_at`	Instant
`video_conferencing_url`	String