Skip to content

public.job_skills

Columns

Name Type Default Nullable Children Parents Comment
id bigint false
importance integer true
job_id bigint false public.jobs
level integer true
salesforce_ref varchar(255) false
skill_id bigint false public.skills

Constraints

Name Type Definition
job_skills_importance_check CHECK CHECK ((importance >= 0))
job_skills_job_id_680b1a54_fk_jobs_id FOREIGN KEY FOREIGN KEY (job_id) REFERENCES jobs(id) DEFERRABLE INITIALLY DEFERRED
job_skills_level_check CHECK CHECK ((level >= 0))
job_skills_pkey PRIMARY KEY PRIMARY KEY (id)
job_skills_skill_id_2e20aa5e_fk_skills_id FOREIGN KEY FOREIGN KEY (skill_id) REFERENCES skills(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
job_skills_job_id_4d5fcf_idx CREATE INDEX job_skills_job_id_4d5fcf_idx ON public.job_skills USING btree (job_id)
job_skills_job_id_680b1a54 CREATE INDEX job_skills_job_id_680b1a54 ON public.job_skills USING btree (job_id)
job_skills_pkey CREATE UNIQUE INDEX job_skills_pkey ON public.job_skills USING btree (id)
job_skills_salesfo_5f51af_idx CREATE INDEX job_skills_salesfo_5f51af_idx ON public.job_skills USING btree (salesforce_ref)
job_skills_skill_i_0a801d_idx CREATE INDEX job_skills_skill_i_0a801d_idx ON public.job_skills USING btree (skill_id)
job_skills_skill_id_2e20aa5e CREATE INDEX job_skills_skill_id_2e20aa5e ON public.job_skills USING btree (skill_id)

Generated by tbls