Lever

Explore the interactive ERD

Table & Field Reference

posting_distribution_channel

Column	Type	Keys
`distribution_channel`	String	PK
`posting_id`	String	PKFK

posting_tag

Column	Type	Keys
`tags`	String	PK
`posting_id`	String	PKFK

posting_content_list

Column	Type	Keys
`index`	Int	PK
`posting_id`	String	PKFK
`content`	String
`text`	String

posting

Column	Type	Keys
`id`	String	PK
`creator_id`	String	FK
`hiring_manager_id`	String	FK
`owner_id`	String	FK
`categories_commitment`	String
`categories_department`	String
`categories_level`	String
`categories_location`	String
`categories_team`	String
`content_closing`	String
`content_closing_html`	String
`content_description`	String
`content_description_html`	String
`created_at`	Instant
`requisition_code`	String
`state`	String
`text`	String
`updated_at`	Instant

requisition_offer

Column	Type	Keys
`offer_id`	String	PKFK
`requisition_id`	String	PKFK

requisition_posting

Column	Type	Keys
`posting_id`	String	PKFK
`requisition_id`	String	PKFK

requisition

Column	Type	Keys
`id`	String	PK
`creator_id`	String	FK
`hiring_manager_id`	String	FK
`owner_id`	String	FK
`approval_account_id`	String
`approval_approved_at`	Instant
`approval_created_by`	String
`approval_id`	String
`approval_image_format`	Unknown
`approval_started_at`	Instant
`approval_status`	String
`backfill`	Boolean
`closed_at`	Instant
`compensation_band_currency`	String
`compensation_band_interval`	String
`compensation_band_max`	String
`compensation_band_min`	String
`created_at`	Instant
`department`	String
`employment_status`	String
`head_count_hired`	String
`head_count_infinite`	String
`head_count_total`	String
`internal_notes`	String
`location`	String
`name`	String
`requisition_code`	String
`status`	String
`team`	String
`custom_fields_`

users

Column	Type	Keys
`id`	String	PK
`access_role`	String
`created_at`	Instant
`deactivated_at`	Instant
`email`	String
`external_directory_id`	String
`name`	String
`photo`	String
`username`	String

archive_reason

Column	Type	Keys
`id`	String	PK
`text`	String

stage

Column	Type	Keys
`id`	String	PK
`text`	String

opportunity_tag

Column	Type	Keys
`tags`	String	PK
`opportunity_id`	String	PKFK

opportunity_source

Column	Type	Keys
`source`	String	PK
`opportunity_id`	String	PKFK

opportunity_stage_history

Column	Type	Keys
`updated_at`	Instant	PK
`opportunity_id`	String	PKFK
`stage_id`	String	FK
`updater_id`	String	FK
`to_stage_index`	String

contact_phone

Column	Type	Keys
`index`	Int	PK
`contact_id`	String	PKFK
`type`	String
`value`	String

contact_email

Column	Type	Keys
`email`	String	PK
`contact_id`	String	PKFK

contact

Column	Type	Keys
`id`	String	PK
`headline`	String
`location`	String
`name`	String

contact_link

Column	Type	Keys
`_fivetran_id`	String	PK
`contact_id`	String	PKFK
`link`	String

opportunity

Column	Type	Keys
`id`	String	PK
`archived_reason_id`	String	FK
`contact`	String	FK
`owner_id`	String	FK
`stage_id`	String	FK
`archived_at`	Instant
`created_at`	Instant
`data_protection_contact_allowed`	Boolean
`data_protection_contact_expires_at`	Instant
`data_protection_store_allowed`	Boolean
`data_protection_store_expires_at`	Instant
`headline`	String
`is_anonymized`	Boolean
`last_advanced_at`	Instant
`last_interaction_at`	Instant
`location`	String
`name`	String
`origin`	String
`snoozed_until`	Instant
`sourced_by`	String
`updated_at`	Instant

offer_field

Column	Type	Keys
`index`	Int	PK
`offer_id`	String	PKFK
`identifier`	String
`text`	String
`value`	String

offer

Column	Type	Keys
`id`	String	PK
`opportunity_id`	String	PKFK
`creator_id`	String	FK
`created_at`	Instant
`sent_document_download_url`	String
`sent_document_file_name`	String
`sent_document_uploaded_at`	Instant
`signed_document_download_url`	String
`signed_document_file_name`	String
`signed_document_uploaded_at`	Instant
`status`	String

feedback_form_field

Column	Type	Keys
`field_index`	Int	PK
`value_index`	Int	PK
`feedback_form_id`	String	PKFK
`value_file_id`	String	FK
`code_language`	String
`currency`	String
`type`	String
`value_date`	Instant
`value_decimal`	String
`value_number`	Int
`value_text`	String

feedback_form_score_card_sub_field

Column	Type	Keys
`sub_field_index`	Int	PK
`field_index`	Int	PKFK
`id`	String	PKFK
`description`	String
`text`	String

feedback_form_template_field

Column	Type	Keys
`field_index`	Int	PK
`id`	String	PK
`description`	String
`required`	Boolean
`text`	String
`type`	String

feedback_form

Column	Type	Keys
`id`	String	PK
`creator_id`	String	FK
`interview_id`	String	FK
`opportunity_id`	String	FK
`template_id`	String	FK
`completed_at`	Instant
`created_at`	Instant
`deleted_at`	Instant
`instructions`	String
`score_system_value`	String
`text`	String
`type`	String

note_field

Column	Type	Keys
`index`	Int	PK
`note_id`	String	PKFK
`creator_id`	String	FK
`stage_id`	String	FK
`created_at`	Instant
`text`	String
`value`	String

note

Column	Type	Keys
`id`	String	PK
`creator_id`	String	FK
`opportunity_id`	String	FK
`completed_at`	Instant
`created_at`	Instant
`deleted_at`	Instant
`secret`	Boolean
`text`	String

file

Column	Type	Keys
`id`	String	PK
`contact_id`	String	PKFK
`download_url`	String
`ext`	String
`name`	String
`uploaded_at`	Instant

interviewer_user

Column	Type	Keys
`interview_id`	String	PKFK
`user_id`	String	PKFK

interview_feedback

Column	Type	Keys
`feedback_form_id`	String	PKFK
`interview_id`	String	PKFK

posting_interview

Column	Type	Keys
`interview_id`	String	PKFK
`posting_id`	String	PKFK

interview

Column	Type	Keys
`id`	String	PK
`creator_id`	String	FK
`opportunity_id`	String	FK
`stage_id`	String	FK
`canceled_at`	Instant
`created_at`	Instant
`date`	Instant
`duration`	Int
`feedback_reminder`	String
`gcal_event_url`	String
`location`	String
`note`	String
`panel_id`	String
`subject`	String
`timezone`	String

referral_form_field

Column	Type	Keys
`field_index`	Int	PK
`value_index`	Int	PK
`referral_form_id`	String	PKFK
`value_file_id`	String	FK
`code_language`	String
`currency`	String
`type`	String
`value_date`	Instant
`value_decimal`	String
`value_number`	Int
`value_text`	String

referral_form_score_card_sub_field

Column	Type	Keys
`sub_field_index`	Int	PK
`field_index`	Int	PKFK
`id`	String	PKFK
`description`	String
`text`	String

referral_form_template_field

Column	Type	Keys
`field_index`	Int	PK
`id`	String	PK
`description`	String
`required`	Boolean
`text`	String
`type`	String

referral_form

Column	Type	Keys
`id`	String	PK
`application_id`	String	FK
`creator_id`	String	FK
`opportunity_id`	String	FK
`referrer_id`	String	FK
`stage_id`	String	FK
`template_id`	String	FK
`completed_at`	Instant
`created_at`	Instant
`instructions`	String
`text`	String
`type`	String

panel_application

Column	Type	Keys
`application_id`	String	PKFK
`panel_id`	String	PKFK

panel_interview

Column	Type	Keys
`interview_id`	String	PKFK
`panel_id`	String	PKFK

panel

Column	Type	Keys
`id`	String	PK
`opportunity_id`	String	PKFK
`creator_id`	String	FK
`stage_id`	String	FK
`canceled_at`	Instant
`created_at`	Instant
`ends`	Instant
`external_url`	String
`externally_managed`	Boolean
`feedback_reminder`	String
`note`	String
`start`	Instant
`timezone`	String

opportunity_position

Column	Type	Keys
`index`	Int	PK
`resume_id`	String	PKFK
`end_month`	Int
`end_year`	Int
`location`	String
`org`	String
`start_month`	Int
`start_year`	Int
`summary`	String
`title`	String

opportunity_school

Column	Type	Keys
`index`	Int	PK
`resume_id`	String	PKFK
`degree`	String
`end_month`	Int
`end_year`	Int
`field`	String
`org`	String
`start_month`	Int
`start_year`	Int
`summary`	String

resume

Column	Type	Keys
`id`	String	PK
`opportunity_id`	String	FK
`created_at`	Instant
`file_download_url`	String
`file_ext`	String
`file_name`	String
`file_status`	String
`file_uploaded_at`	Instant

posting_form_field

Column	Type	Keys
`field_index`	Int	PK
`value_index`	Int	PK
`posting_form_id`	String	PKFK
`value_file_id`	String	FK
`code_language`	String
`currency`	String
`type`	String
`value_date`	Instant
`value_decimal`	String
`value_number`	Int
`value_text`	String

posting_form_score_card_sub_field

Column	Type	Keys
`sub_field_index`	Int	PK
`field_index`	Int	PKFK
`id`	String	PKFK
`description`	String
`text`	String

posting_form_template_field

Column	Type	Keys
`field_index`	Int	PK
`id`	String	PK
`description`	String
`required`	Boolean
`text`	String
`type`	String

posting_form

Column	Type	Keys
`id`	String	PK
`application_id`	String	FK
`creator_id`	String	FK
`opportunity_id`	String	FK
`template_id`	String	FK
`completed_at`	Instant
`created_at`	Instant
`text`	String
`type`	String

application

Column	Type	Keys
`id`	String	PK
`archived_reason_id`	String	FK
`opportunity_id`	String	FK
`posting_hiring_manager_id`	String	FK
`posting_id`	String	FK
`posting_owner_id`	String	FK
`referrer_id`	String	FK
`requisition_for_hire_id`	String	FK
`archived_at`	Instant
`comments`	String
`company`	String
`created_at`	Instant
`links`	Json
`requisition_for_hire_code`	String
`requisition_for_hire_manager`	String
`type`	String

profile_form_field

Column	Type	Keys
`field_index`	Int	PK
`value_index`	Int	PK
`profile_form_id`	String	PKFK
`value_file_id`	String	FK
`code_language`	String
`currency`	String
`type`	String
`value_date`	Instant
`value_decimal`	String
`value_number`	Int
`value_text`	String

profile_form_score_card_sub_field

Column	Type	Keys
`sub_field_index`	Int	PK
`field_index`	Int	PKFK
`id`	String	PKFK
`description`	String
`text`	String

profile_form_template_field

Column	Type	Keys
`field_index`	Int	PK
`id`	String	PK
`description`	String
`required`	Boolean
`text`	String
`type`	String

profile_form

Column	Type	Keys
`id`	String	PK
`creator_id`	String	FK
`opportunity_id`	String	FK
`stage_id`	String	FK
`template_id`	String	FK
`completed_at`	Instant
`created_at`	Instant
`deleted_at`	Instant
`instructions`	String
`text`	String
`type`	String