Skip to content

public.work_experiences

Columns

Name Type Default Nullable Children Parents Comment
company varchar(255) false
contact_id bigint false public.contacts
description text false
end_date date true
id bigint false
is_current boolean false
job_title varchar(255) false
job_type_id bigint true public.job_types
location varchar(255) false
salesforce_ref varchar(255) false
sector_id bigint true public.job_sectors
start_date date false

Constraints

Name Type Definition
uniq_work_experience_per_contact UNIQUE UNIQUE (contact_id, job_title, company, start_date)
work_experiences_contact_id_6aeaea28_fk_contacts_id FOREIGN KEY FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED
work_experiences_job_type_id_bcef01ba_fk_job_types_id FOREIGN KEY FOREIGN KEY (job_type_id) REFERENCES job_types(id) DEFERRABLE INITIALLY DEFERRED
work_experiences_pkey PRIMARY KEY PRIMARY KEY (id)
work_experiences_sector_id_e6d74e2e_fk_job_sectors_id FOREIGN KEY FOREIGN KEY (sector_id) REFERENCES job_sectors(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
uniq_work_experience_per_contact CREATE UNIQUE INDEX uniq_work_experience_per_contact ON public.work_experiences USING btree (contact_id, job_title, company, start_date)
work_experi_salesfo_b0eab0_idx CREATE INDEX work_experi_salesfo_b0eab0_idx ON public.work_experiences USING btree (salesforce_ref)
work_experiences_contact_id_6aeaea28 CREATE INDEX work_experiences_contact_id_6aeaea28 ON public.work_experiences USING btree (contact_id)
work_experiences_job_type_id_bcef01ba CREATE INDEX work_experiences_job_type_id_bcef01ba ON public.work_experiences USING btree (job_type_id)
work_experiences_pkey CREATE UNIQUE INDEX work_experiences_pkey ON public.work_experiences USING btree (id)
work_experiences_sector_id_e6d74e2e CREATE INDEX work_experiences_sector_id_e6d74e2e ON public.work_experiences USING btree (sector_id)

Generated by tbls