Skip to content

public.job_locations

Columns

Name Type Default Nullable Children Parents Comment
company_id bigint true public.companies
geocoded_at timestamp with time zone true
id bigint false public.jobs public.location_projects
latitude numeric(9,6) true
longitude numeric(9,6) true
name varchar(255) false
salesforce_ref varchar(18) false

Constraints

Name Type Definition
job_locations_company_id_a0a718d7_fk_companies_id FOREIGN KEY FOREIGN KEY (company_id) REFERENCES companies(id) DEFERRABLE INITIALLY DEFERRED
job_locations_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
job_locatio_name_e0d1fa_idx CREATE INDEX job_locatio_name_e0d1fa_idx ON public.job_locations USING btree (name)
job_locatio_salesfo_3e5367_idx CREATE INDEX job_locatio_salesfo_3e5367_idx ON public.job_locations USING btree (salesforce_ref)
job_locations_company_id_a0a718d7 CREATE INDEX job_locations_company_id_a0a718d7 ON public.job_locations USING btree (company_id)
job_locations_pkey CREATE UNIQUE INDEX job_locations_pkey ON public.job_locations USING btree (id)

Generated by tbls