Skip to content

public.location_projects

Columns

Name Type Default Nullable Children Parents Comment
bc_project_number varchar(100) false
collective_agreement_id bigint true public.collective_agreements
id bigint false
location_id bigint false public.job_locations
salesforce_ref varchar(18) false

Constraints

Name Type Definition
location_projects_collective_agreement_b87ecb2b_fk_collectiv FOREIGN KEY FOREIGN KEY (collective_agreement_id) REFERENCES collective_agreements(id) DEFERRABLE INITIALLY DEFERRED
location_projects_location_id_9cc32fa9_fk_job_locations_id FOREIGN KEY FOREIGN KEY (location_id) REFERENCES job_locations(id) DEFERRABLE INITIALLY DEFERRED
location_projects_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
location_projects_collective_agreement_id_b87ecb2b CREATE INDEX location_projects_collective_agreement_id_b87ecb2b ON public.location_projects USING btree (collective_agreement_id)
location_projects_location_id_9cc32fa9 CREATE INDEX location_projects_location_id_9cc32fa9 ON public.location_projects USING btree (location_id)
location_projects_pkey CREATE UNIQUE INDEX location_projects_pkey ON public.location_projects USING btree (id)

Generated by tbls