public.worker_job_distances¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| created_at | timestamp with time zone | false | ||||
| distance_km | numeric(8,2) | true | ||||
| id | bigint | false | ||||
| job_id | bigint | false | public.jobs | |||
| updated_at | timestamp with time zone | false | ||||
| worker_id | bigint | false | public.contacts |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| uniq_worker_job_distance | UNIQUE | UNIQUE (worker_id, job_id) |
| worker_job_distances_job_id_264ee8bf_fk_jobs_id | FOREIGN KEY | FOREIGN KEY (job_id) REFERENCES jobs(id) DEFERRABLE INITIALLY DEFERRED |
| worker_job_distances_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| worker_job_distances_worker_id_4677d1c0_fk_contacts_id | FOREIGN KEY | FOREIGN KEY (worker_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED |
Indexes¶
| Name | Definition |
|---|---|
| uniq_worker_job_distance | CREATE UNIQUE INDEX uniq_worker_job_distance ON public.worker_job_distances USING btree (worker_id, job_id) |
| worker_job__job_id_eac6ac_idx | CREATE INDEX worker_job__job_id_eac6ac_idx ON public.worker_job_distances USING btree (job_id, distance_km) |
| worker_job_distances_job_id_264ee8bf | CREATE INDEX worker_job_distances_job_id_264ee8bf ON public.worker_job_distances USING btree (job_id) |
| worker_job_distances_pkey | CREATE UNIQUE INDEX worker_job_distances_pkey ON public.worker_job_distances USING btree (id) |
| worker_job_distances_worker_id_4677d1c0 | CREATE INDEX worker_job_distances_worker_id_4677d1c0 ON public.worker_job_distances USING btree (worker_id) |
Generated by tbls