public.worker_interview_results¶

Columns¶

Name	Type	Nullable	Children	Parents
ai_analysis	text	false
ai_analysis_recruiter	text	false
ai_analysis_recruiter_score	numeric(5,2)	true
ai_analysis_recruiter_why_hire	varchar(255)[]	false
ai_analysis_recruiter_why_not_hire	varchar(255)[]	false
end	timestamp with time zone	true
external_ref	varchar(255)	false
id	bigint	false	public.worker_interview_result_transcriptions
interview_id	bigint	false		public.worker_interviews
processing_status	varchar(20)	false
result_data	jsonb	false
score	numeric(5,2)	true
score_answer	numeric(5,2)	true
score_pronunciation	numeric(5,2)	true
score_sentiment	numeric(5,2)	true
score_words_per_minute	numeric(5,2)	true
start	timestamp with time zone	true

Name	Type	Definition
worker_interview_res_interview_id_ceb4c2b1_fk_worker_in	FOREIGN KEY	FOREIGN KEY (interview_id) REFERENCES worker_interviews(id) DEFERRABLE INITIALLY DEFERRED
worker_interview_results_external_ref_key	UNIQUE	UNIQUE (external_ref)
worker_interview_results_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
worker_inte_externa_94d9bf_idx	CREATE INDEX worker_inte_externa_94d9bf_idx ON public.worker_interview_results USING btree (external_ref)
worker_inte_process_bf5819_idx	CREATE INDEX worker_inte_process_bf5819_idx ON public.worker_interview_results USING btree (processing_status)
worker_interview_results_external_ref_53f3b84f_like	CREATE INDEX worker_interview_results_external_ref_53f3b84f_like ON public.worker_interview_results USING btree (external_ref varchar_pattern_ops)
worker_interview_results_external_ref_key	CREATE UNIQUE INDEX worker_interview_results_external_ref_key ON public.worker_interview_results USING btree (external_ref)
worker_interview_results_interview_id_ceb4c2b1	CREATE INDEX worker_interview_results_interview_id_ceb4c2b1 ON public.worker_interview_results USING btree (interview_id)
worker_interview_results_pkey	CREATE UNIQUE INDEX worker_interview_results_pkey ON public.worker_interview_results USING btree (id)

Generated by tbls