interview_panels


Description

A row in this table represents an interview panel, intended as an group of individual interviews administered \(usually\) by different users to the same candidate.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
interview_panel_id varchar 2147483647 null
interview_panel_interviewers.interview_panel_id interview_panels_interviews_interviewer_interview_panel_id_fkeyN
interview_panel_interviews.interview_panel_id interview_panel_interviews_interview_panel_id_fkeyN
opportunity_forms.interview_panel_id opportunity_forms_interview_panel_id_fkeyN

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
opportunity_id varchar 2147483647 √ null
opportunities.opportunity_id interview_panels_opportunity_id_fkeyC

ID of the opportunity connected to this entity.
timezone_name varchar 2147483647 √ null

Timezone used when communicating about the time of this interview panel.
start_at timestamp 29,6 √ null

Date the panel started at.
end_at timestamp 29,6 √ null

Date the interview_panel is scheduled to end at.
duration_seconds int8 19 √ null

Duration of the panel in seconds.
avg_feedback_score numeric 131089 √ null

average feedback across all interview of the same panel
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
updated_at timestamp 29,6 √ null

Date the object referred to in this entity was updated.
is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.
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.
creator_id varchar 2147483647 √ null
users.user_id interview_panels_creator_id_fkeyN

ID of the user that created the entity in this entity.
completed_at timestamp 29,6 √ null

Date and time when the panel was completed.
canceled_at timestamp 29,6 √ null

Date and time when the panel was canceled.
account_stage_id varchar 2147483647 √ null
account_stages.account_stage_id interview_panels_account_stage_id_fkeyC

Indexes

Constraint Name Type Sort Column(s)
interview_panels_pkey Primary key Asc interview_panel_id
interview_panels_account_id_index Performance Asc account_id
interview_panels_account_stage_id_idx Performance Asc account_stage_id
interview_panels_creator_id_idx Performance Asc creator_id

Relationships

Close relationships within degrees of separation