public.worker_interviews¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | public.worker_interview_results | |||
| interview_id | bigint | false | public.interviews | |||
| invite_link | varchar(200) | false | ||||
| last_obtained | timestamp with time zone | false | ||||
| worker_id | bigint | false | public.contacts |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| worker_interviews_interview_id_d224f42f_fk_interviews_id | FOREIGN KEY | FOREIGN KEY (interview_id) REFERENCES interviews(id) DEFERRABLE INITIALLY DEFERRED |
| worker_interviews_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| worker_interviews_worker_id_194a3d96_fk_contacts_id | FOREIGN KEY | FOREIGN KEY (worker_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED |
Indexes¶
| Name | Definition |
|---|---|
| worker_interviews_interview_id_d224f42f | CREATE INDEX worker_interviews_interview_id_d224f42f ON public.worker_interviews USING btree (interview_id) |
| worker_interviews_pkey | CREATE UNIQUE INDEX worker_interviews_pkey ON public.worker_interviews USING btree (id) |
| worker_interviews_worker_id_194a3d96 | CREATE INDEX worker_interviews_worker_id_194a3d96 ON public.worker_interviews USING btree (worker_id) |
Generated by tbls