opportunity_forms


Description

A row in this table represents a connection between an opportunity form event and a form. Forms in Lever are used to collect structured data about a candidacy.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
opportunity_form_id varchar 2147483647 null
opportunity_feedback_events.opportunity_form_id opportunities_feedback_events_opportunity_form_id_fkeyN
opportunity_form_events.opportunity_form_id opportunities_form_events_opportunity_form_id_fkeyN
opportunity_form_field_files.opportunity_form_id opportunity_form_field_files_form_id_fkeyN
opportunity_form_field_scores.opportunity_form_id opportunity_form_field_scores_form_id_fkeyN
opportunity_form_field_values.opportunity_form_id opportunity_form_field_values_form_id_fkeyN
opportunity_form_fields.opportunity_form_id opportunity_form_fields_opportunity_form_id_fkeyN
opportunity_referrals.opportunity_form_id opportunity_referrals_opportunity_form_id_fkeyC

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
form_template_version int4 10 √ null
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
form_template_id varchar 2147483647 √ null
form_templates.form_template_id opportunity_forms_form_template_id_fkeyN

ID of form template associated with this entity.
row_updated_at timestamp 29,6 √ CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.
is_deleted bool 1 false

TRUE if the opportunity form has been deleted.
opportunity_id varchar 2147483647 √ null
opportunities.opportunity_id opportunity_forms_opportunity_id_fkeyC

ID of the opportunity the record belongs to.
user_id varchar 2147483647 √ null
users.user_id opportunity_forms_user_id_fkeyN

ID of the user the record belongs to.
contact_id varchar 2147483647 √ null
contacts.contact_id opportunity_forms_contact_id_fkeyN

ID of the contact the record belongs to.
is_draft bool 1 √ null
interview_panel_id varchar 2147483647 √ null
interview_panels.interview_panel_id opportunity_forms_interview_panel_id_fkeyN

ID of the interview panel.
interview_panel_interview_id varchar 2147483647 √ null
interview_panel_interviews.interview_panel_interview_id opportunity_forms_interview_panel_interview_id_fkeyN

ID of the specific interview contained within its panel.
account_stage_id varchar 2147483647 √ null
account_stages.account_stage_id opportunity_forms_account_stage_id_fkeyN

ID of the stage associated with this record.
name varchar 2147483647 √ null

The name of related form template.
form_type_id varchar 2147483647 √ null
form_type_enum.form_type_id Implied ConstraintR

ID of the form type associated with this entity.

Indexes

Constraint Name Type Sort Column(s)
opportunity_forms_pkey Primary key Asc opportunity_form_id
opportunity_forms_account_id_index Performance Asc account_id
opportunity_forms_account_stage_id_index Performance Asc account_stage_id
opportunity_forms_contact_id_index Performance Asc contact_id
opportunity_forms_form_template_id_idx Performance Asc form_template_id
opportunity_forms_interview_panel_id_index Performance Asc interview_panel_id
opportunity_forms_interview_panel_interview_id_index Performance Asc interview_panel_interview_id
opportunity_forms_opportunity_id_idx Performance Asc opportunity_id
opportunity_forms_user_id_idx Performance Asc user_id

Relationships

Close relationships within degrees of separation