public.worker_interview_result_transcriptions¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | ||||
| interview_result_id | bigint | false | public.worker_interview_results | |||
| transcript | jsonb[] | false | ||||
| video | varchar(100) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| worker_interview_res_interview_result_id_04ad0e5c_fk_worker_in | FOREIGN KEY | FOREIGN KEY (interview_result_id) REFERENCES worker_interview_results(id) DEFERRABLE INITIALLY DEFERRED |
| worker_interview_result_transcriptions_interview_result_id_key | UNIQUE | UNIQUE (interview_result_id) |
| worker_interview_result_transcriptions_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| worker_interview_result_transcriptions_interview_result_id_key | CREATE UNIQUE INDEX worker_interview_result_transcriptions_interview_result_id_key ON public.worker_interview_result_transcriptions USING btree (interview_result_id) |
| worker_interview_result_transcriptions_pkey | CREATE UNIQUE INDEX worker_interview_result_transcriptions_pkey ON public.worker_interview_result_transcriptions USING btree (id) |
Generated by tbls