# Lever schema ERD

Table and field reference for the Fivetran Lever connector.

## Table & Field Reference

### posting_distribution_channel

| Column | Type | Keys |
| --- | --- | --- |
| distribution_channel | String | PK |
| posting_id | String | PK, FK |

### posting_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| posting_id | String | PK, FK |

### posting_content_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| posting_id | String | PK, FK |
| 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 | PK, FK |
| requisition_id | String | PK, FK |

### requisition_posting

| Column | Type | Keys |
| --- | --- | --- |
| posting_id | String | PK, FK |
| requisition_id | String | PK, FK |

### 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 | PK, FK |

### opportunity_source

| Column | Type | Keys |
| --- | --- | --- |
| source | String | PK |
| opportunity_id | String | PK, FK |

### opportunity_stage_history

| Column | Type | Keys |
| --- | --- | --- |
| updated_at | Instant | PK |
| opportunity_id | String | PK, FK |
| stage_id | String | FK |
| updater_id | String | FK |
| to_stage_index | String |  |

### contact_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| contact_id | String | PK, FK |
| type | String |  |
| value | String |  |

### contact_email

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| contact_id | String | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| identifier | String |  |
| text | String |  |
| value | String |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| opportunity_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| download_url | String |  |
| ext | String |  |
| name | String |  |
| uploaded_at | Instant |  |

### interviewer_user

| Column | Type | Keys |
| --- | --- | --- |
| interview_id | String | PK, FK |
| user_id | String | PK, FK |

### interview_feedback

| Column | Type | Keys |
| --- | --- | --- |
| feedback_form_id | String | PK, FK |
| interview_id | String | PK, FK |

### posting_interview

| Column | Type | Keys |
| --- | --- | --- |
| interview_id | String | PK, FK |
| posting_id | String | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| id | String | PK, FK |
| 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 | PK, FK |
| panel_id | String | PK, FK |

### panel_interview

| Column | Type | Keys |
| --- | --- | --- |
| interview_id | String | PK, FK |
| panel_id | String | PK, FK |

### panel

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| opportunity_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| id | String | PK, FK |
| 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 |  |

## Relationships

- posting_distribution_channel(posting_id) → posting(id)
- posting_tag(posting_id) → posting(id)
- posting_content_list(posting_id) → posting(id)
- posting(owner_id) → users(id)
- posting(hiring_manager_id) → users(id)
- posting(creator_id) → users(id)
- requisition_offer(offer_id) → offer(id)
- requisition_offer(requisition_id) → requisition(id)
- requisition_posting(posting_id) → posting(id)
- requisition_posting(requisition_id) → requisition(id)
- requisition(owner_id) → users(id)
- requisition(hiring_manager_id) → users(id)
- requisition(creator_id) → users(id)
- opportunity_tag(opportunity_id) → opportunity(id)
- opportunity_source(opportunity_id) → opportunity(id)
- opportunity_stage_history(stage_id) → stage(id)
- opportunity_stage_history(updater_id) → users(id)
- opportunity_stage_history(opportunity_id) → opportunity(id)
- contact_phone(contact_id) → contact(id)
- contact_email(contact_id) → contact(id)
- contact_link(contact_id) → contact(id)
- opportunity(stage_id) → stage(id)
- opportunity(owner_id) → users(id)
- opportunity(contact) → contact(id)
- opportunity(archived_reason_id) → archive_reason(id)
- offer_field(offer_id) → offer(id)
- offer(creator_id) → users(id)
- offer(opportunity_id) → opportunity(id)
- feedback_form_field(value_file_id) → file(id)
- feedback_form_field(feedback_form_id) → feedback_form(id)
- feedback_form_score_card_sub_field(field_index) → feedback_form_template_field(field_index)
- feedback_form_score_card_sub_field(id) → feedback_form_template_field(id)
- feedback_form(template_id) → feedback_form_template_field(id)
- feedback_form(creator_id) → users(id)
- feedback_form(interview_id) → interview(id)
- feedback_form(opportunity_id) → opportunity(id)
- note_field(creator_id) → users(id)
- note_field(stage_id) → stage(id)
- note_field(note_id) → note(id)
- note(creator_id) → users(id)
- note(opportunity_id) → opportunity(id)
- file(contact_id) → contact(id)
- interviewer_user(user_id) → users(id)
- interviewer_user(interview_id) → interview(id)
- interview_feedback(feedback_form_id) → feedback_form(id)
- interview_feedback(interview_id) → interview(id)
- posting_interview(posting_id) → posting(id)
- posting_interview(interview_id) → interview(id)
- interview(stage_id) → stage(id)
- interview(creator_id) → users(id)
- interview(opportunity_id) → opportunity(id)
- referral_form_field(value_file_id) → file(id)
- referral_form_field(referral_form_id) → referral_form(id)
- referral_form_score_card_sub_field(field_index) → referral_form_template_field(field_index)
- referral_form_score_card_sub_field(id) → referral_form_template_field(id)
- referral_form(template_id) → referral_form_template_field(id)
- referral_form(stage_id) → stage(id)
- referral_form(application_id) → application(id)
- referral_form(referrer_id) → users(id)
- referral_form(creator_id) → users(id)
- referral_form(opportunity_id) → opportunity(id)
- panel_application(application_id) → application(id)
- panel_application(panel_id) → panel(id)
- panel_interview(interview_id) → interview(id)
- panel_interview(panel_id) → panel(id)
- panel(stage_id) → stage(id)
- panel(creator_id) → users(id)
- panel(opportunity_id) → opportunity(id)
- opportunity_position(resume_id) → resume(id)
- opportunity_school(resume_id) → resume(id)
- resume(opportunity_id) → opportunity(id)
- posting_form_field(value_file_id) → file(id)
- posting_form_field(posting_form_id) → posting_form(id)
- posting_form_score_card_sub_field(field_index) → posting_form_template_field(field_index)
- posting_form_score_card_sub_field(id) → posting_form_template_field(id)
- posting_form(creator_id) → users(id)
- posting_form(template_id) → posting_form_template_field(id)
- posting_form(application_id) → application(id)
- posting_form(opportunity_id) → opportunity(id)
- application(opportunity_id) → opportunity(id)
- application(posting_id) → posting(id)
- application(posting_owner_id) → users(id)
- application(referrer_id) → users(id)
- application(posting_hiring_manager_id) → users(id)
- application(requisition_for_hire_id) → requisition(id)
- application(archived_reason_id) → archive_reason(id)
- profile_form_field(value_file_id) → file(id)
- profile_form_field(profile_form_id) → profile_form(id)
- profile_form_score_card_sub_field(field_index) → profile_form_template_field(field_index)
- profile_form_score_card_sub_field(id) → profile_form_template_field(id)
- profile_form(template_id) → profile_form_template_field(id)
- profile_form(stage_id) → stage(id)
- profile_form(creator_id) → users(id)
- profile_form(opportunity_id) → opportunity(id)