Workable

Explore the interactive ERD

Table & Field Reference

requisition_approver

Column	Type	Keys
`id`	Unknown	PKFK
`requisition_approval_group_id`	Unknown	FK
`decision`	Unknown
`name`	Unknown

requisition_approval_group

Column	Type	Keys
`id`	Unknown	PK
`requisition_id`	Unknown	FK

requisition

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`hiring_manager_id`	Unknown	FK
`job_id`	Unknown	FK
`owner_id`	Unknown	FK
`codes`	Unknown
`employment_type`	Unknown
`location_city`	Unknown
`location_country`	Unknown
`location_country_code`	Unknown
`location_region`	Unknown
`location_region_code`	Unknown
`location_str`	Unknown
`location_zip_code`	Unknown
`plan_date`	Unknown
`reason`	Unknown
`requester_id`	Unknown
`requester_name`	Unknown
`salary_range_currency`	Unknown
`salary_range_frequency`	Unknown
`salary_range_salary_from`	Unknown
`salary_range_salary_to`	Unknown
`start_date`	Unknown
`state`	Unknown
`requisition_custom_attributes_`

employee

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	FK
`address`	Unknown
`avatar`	Unknown
`department_id`	Unknown
`division_id`	Unknown
`email`	Unknown
`employee_number`	Unknown
`first_name`	Unknown
`job_title`	Unknown
`last_name`	Unknown
`legal_entity_id`	Unknown
`manager_id`	Unknown
`phone`	Unknown
`roles`	Json
`start_date`	Unknown
`state`	Unknown
`template_id`	Unknown
`work_email`	Unknown
`work_schedule_id`	Unknown

candidate_education_entry

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	PKFK
`degree`	Unknown
`end_date`	Unknown
`field_of_study`	Unknown
`school`	Unknown
`start_date`	Unknown

candidate_experience_entry

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	PKFK
`company`	Unknown
`current`	Unknown
`end_date`	Unknown
`industry`	Unknown
`start_date`	Unknown
`summary`	Unknown
`title`	Unknown

candidate_social_profile

Column	Type	Keys
`index`	Unknown	PK
`candidate_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown
`url`	Unknown
`username`	Unknown

candidate_answer

Column	Type	Keys
`_fivetran_id`	String	PK
`candidate_id`	Unknown	PKFK
`question`	Unknown
`custom_`

candidate

Column	Type	Keys
`id`	Unknown	PK
`job_shortcode`	Unknown	FK
`account_name`	Unknown
`account_sub_domain`	Unknown
`address`	Unknown
`cover_letter`	Unknown
`created_at`	Unknown
`disqualification_reason`	Unknown
`disqualified`	Unknown
`disqualified_at`	Unknown
`domain`	Unknown
`email`	Unknown
`first_name`	Unknown
`head_line`	Unknown
`hired_at`	Unknown
`last_name`	Unknown
`location_city`	Unknown
`location_country`	Unknown
`location_country_code`	Unknown
`location_region`	Unknown
`location_region_code`	Unknown
`location_str`	Unknown
`location_zip_code`	Unknown
`name`	Unknown
`originating_candidate_id`	Unknown
`phone`	Unknown
`resume_url`	Unknown
`skills`	Json
`sourced`	Unknown
`stage`	Unknown
`summary`	Unknown
`updated_at`	Unknown
`uploader_id`	Unknown

job_question_choice

Column	Type	Keys
`id`	Unknown	PK
`job_question_id`	Unknown	PKFK
`body`	Unknown

job_question_file_type

Column	Type	Keys
`index`	Unknown	PK
`job_question_id`	Unknown	PKFK
`file_type`	Unknown

job_question

Column	Type	Keys
`id`	Unknown	PK
`job_id`	Unknown	PKFK
`body`	Unknown
`max_file_size`	Unknown
`required`	Unknown
`single_answer`	Unknown
`type`	Unknown

job_activity

Column	Type	Keys
`action`	Unknown	PK
`job_id`	Unknown	PKFK
`candidate_id`	Unknown	FK
`member_id`	Unknown	FK
`body`	Unknown
`created_at`	Unknown
`stage_name`	Unknown

member

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

event_member

Column	Type	Keys
`event_id`	Unknown	PKFK
`id`	Unknown	PKFK

event

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	FK
`job_shortcode`	Unknown	FK
`description`	Unknown
`ends_at`	Unknown
`starts_at`	Unknown
`title`	Unknown
`type`	Unknown

job_application_supported_file_type

Column	Type	Keys
`index`	Unknown	PK
`job_application_form_key`	Unknown	PKFK
`job_id`	Unknown	PKFK
`file_type`	Unknown

job_application_field

Column	Type	Keys
`key`	Unknown	PK
`job_application_form_key`	Unknown	PKFK
`job_id`	Unknown	PKFK
`label`	Unknown
`required`	Unknown
`type`	Unknown

job_application_form

Column	Type	Keys
`key`	Unknown	PK
`job_id`	Unknown	PKFK
`label`	Unknown
`max_file_size`	Unknown
`multiple`	Unknown
`required`	Unknown
`type`	Unknown

employee_document

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`created_at`	Instant
`created_by`	Unknown
`file_name`	Unknown
`file_size`	Unknown
`files_path`	Unknown
`updated_at`	Instant

job_member

Column	Type	Keys
`id`	Unknown	PKFK
`job_id`	Unknown	PKFK

candidate_document_variable

Column	Type	Keys
`_fivetran_id`	String	PK
`candidate_offer_candidate_id`	Unknown	FK
`name`	Unknown
`slug`	Unknown
`custom_value_`

candidate_offer_document

Column	Type	Keys
`_fivetran_id`	String	PK
`candidate_offer_candidate_id`	Unknown	FK
`kind`	Unknown
`name`	Unknown
`preview_url`	Unknown

candidate_offer

Column	Type	Keys
`candidate_id`	Unknown	PKFK
`created_at`	Unknown
`state`	Unknown

candidate_activity

Column	Type	Keys
`id`	Unknown	PK
`candidate_id`	Unknown	PKFK
`member_id`	Unknown	FK
`action`	Unknown
`body`	Unknown
`created_at`	Unknown
`stage_name`	Unknown

recruiter

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

employee_field_choice

Column	Type	Keys
`id`	Unknown	PK
`employee_field_id`	Unknown	PKFK
`account_id`	Unknown
`can_edit_mapping`	Unknown
`label`	Unknown
`position`	Unknown

employee_field

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown
`approvable_by`	Unknown
`editable_by`	Unknown
`hint`	Unknown
`is_multiple`	Unknown
`keep_history`	Unknown
`label`	Unknown
`type`	Unknown
`viewable_by`	Unknown

job_recruiter

Column	Type	Keys
`id`	Unknown	PKFK
`job_id`	Unknown	PKFK

stage

Column	Type	Keys
`position`	Unknown	PK
`name`	Unknown
`slug`	Unknown

job_custom_attribute_choice

Column	Type	Keys
`id`	Unknown	PK
`job_custom_attribute_id`	Unknown	PKFK
`body`	Unknown

job_custom_attribute_file_type

Column	Type	Keys
`index`	Unknown	PK
`job_custom_attribute_id`	Unknown	PKFK
`file_type`	Unknown

job_custom_attribute

Column	Type	Keys
`id`	Unknown	PK
`job_id`	Unknown	PKFK
`label`	Unknown
`max_file_size`	Unknown
`provider`	Unknown
`required`	Unknown
`single_answer`	Unknown
`type`	Unknown

job_deparment_hierarchy

Column	Type	Keys
`id`	Unknown	PK
`job_id`	Unknown	FK
`name`	Unknown

job_keyword

Column	Type	Keys
`keyword`	Unknown	PK
`job_id`	Unknown	PKFK

job

Column	Type	Keys
`id`	Unknown	PK
`application_url`	Unknown
`benefits`	Unknown
`code`	Unknown
`created_at`	Unknown
`department`	Unknown
`education`	Unknown
`employment_type`	Unknown
`experience`	Unknown
`full_description`	Unknown
`full_title`	Unknown
`function`	Unknown
`industry`	Unknown
`location_city`	Unknown
`location_country`	Unknown
`location_country_code`	Unknown
`location_region`	Unknown
`location_region_code`	Unknown
`location_str`	Unknown
`location_telecommuting`	Unknown
`location_zip_code`	Unknown
`requirements`	Unknown
`shortcode`	Unknown
`shortlink`	Unknown
`state`	Unknown
`title`	Unknown

job_stage

Column	Type	Keys
`job_id`	Unknown	PKFK
`position`	Unknown	PKFK