interview_panel_interviewers


Description

A row in this table represents an interviewer on an individual interview. More than one interviewer can participate to any single interview.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
interview_panel_interviewer_id varchar 2147483647 null

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

interview_panel_interview_id varchar 2147483647 null
interview_panel_interviews.interview_panel_interview_id interview_panels_interviews_interviewers_interview_id_fkeyN

ID of the interview contained within its panel

timezone_name varchar 2147483647 null
start_at timestamp 29,6 null

Date the interview started at.

end_at timestamp 29,6 null

When the interviewer’s interview ends.

duration_seconds int8 19 null

Duration of the interview in seconds.

feedback_score numeric 131089 null

The overall feedback score provided by the interviewer.

feedback_completed_at timestamp 29,6 null

When the interviewer’s feedback was completed.

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.

user_id varchar 2147483647 null
users.user_id interview_panels_interviews_interviewers_user_id_fkeyN

ID of the user.

interview_panel_id varchar 2147483647 null
interview_panels.interview_panel_id interview_panels_interviews_interviewer_interview_panel_id_fkeyN

ID of the interview panel

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.

Indexes

Constraint Name Type Sort Column(s)
interview_panels_interviews_interviewers_pkey Primary key Asc interview_panel_interviewer_id
interview_panels_interviews_interviewers_account_id_index Performance Asc account_id
interview_panels_interviews_interviewers_interview_panel_id_ind Performance Asc interview_panel_id
interviewers_interview_id_idx Performance Asc interview_panel_interview_id
interviewers_user_id_idx Performance Asc user_id

Relationships