Skip to content

public.job_positions

Columns

Name Type Default Nullable Children Parents Comment
code varchar(100) false
collective_agreement_id bigint true public.collective_agreements
id bigint false public.jobs public.position_age_wages
name varchar(255) false
salesforce_ref varchar(18) false

Constraints

Name Type Definition
job_positions_collective_agreement_e8c74aeb_fk_collectiv FOREIGN KEY FOREIGN KEY (collective_agreement_id) REFERENCES collective_agreements(id) DEFERRABLE INITIALLY DEFERRED
job_positions_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
job_positio_name_f25c18_idx CREATE INDEX job_positio_name_f25c18_idx ON public.job_positions USING btree (name)
job_positio_salesfo_67f0d6_idx CREATE INDEX job_positio_salesfo_67f0d6_idx ON public.job_positions USING btree (salesforce_ref)
job_positions_collective_agreement_id_e8c74aeb CREATE INDEX job_positions_collective_agreement_id_e8c74aeb ON public.job_positions USING btree (collective_agreement_id)
job_positions_pkey CREATE UNIQUE INDEX job_positions_pkey ON public.job_positions USING btree (id)

Generated by tbls