A row in this table represents an individual interview performed in the context of an interview panel.


Column Type Size Nulls Auto Default Children Parents Comments
interview_panel_interview_id varchar 2147483647 null
interview_panel_interviewers.interview_panel_interview_id interview_panels_interviews_interviewers_interview_id_fkeyN
opportunity_feedback_events.interview_panel_interview_id opportunities_feedback_events_interview_panel_interview_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

interview_panel_id varchar 2147483647 null
interview_panels.interview_panel_id interview_panel_interviews_interview_panel_id_fkeyN

ID of the interview panel

instructions varchar 2147483647 null

Instructions for the interviewer conducting the interview.

timezone_name varchar 2147483647 null

Timezone used when communicating about the time of this interview.

start_at timestamp 29,6 null

Date the interview started at.

end_at timestamp 29,6 null

Date the interview is scheduled to end at.

duration_seconds int8 19 null

Duration of the interview 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.

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.

form_template_id varchar 2147483647 null
form_templates.form_template_id interview_panel_interviews_form_template_id_fkeyN

The template id for interview feedback for the interview, or “no-feedback” if no feedback is requested.


Constraint Name Type Sort Column(s)
interview_panel_interviews_pkey Primary key Asc interview_panel_interview_id
interview_panel_interviews_account_id_index Performance Asc account_id
interview_panel_interviews_form_template_id_idx Performance Asc form_template_id
interview_panel_interviews_panel_id_idx Performance Asc interview_panel_id