Skip to content

public.contact_skills

Columns

Name Type Default Nullable Children Parents Comment
contact_id bigint false public.contacts
id bigint false
proficiency smallint true
salesforce_ref varchar(255) false
skill_id bigint false public.skills
tag varchar(255) false

Constraints

Name Type Definition
contact_skills_contact_id_8391d350_fk_contacts_id FOREIGN KEY FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED
contact_skills_pkey PRIMARY KEY PRIMARY KEY (id)
contact_skills_proficiency_check CHECK CHECK ((proficiency >= 0))
contact_skills_skill_id_3a4f3097_fk_skills_id FOREIGN KEY FOREIGN KEY (skill_id) REFERENCES skills(id) DEFERRABLE INITIALLY DEFERRED
uniq_contact_skill UNIQUE UNIQUE (contact_id, skill_id)

Indexes

Name Definition
contact_ski_contact_cc9c24_idx CREATE INDEX contact_ski_contact_cc9c24_idx ON public.contact_skills USING btree (contact_id, skill_id)
contact_ski_profici_0747fe_idx CREATE INDEX contact_ski_profici_0747fe_idx ON public.contact_skills USING btree (proficiency)
contact_ski_salesfo_308459_idx CREATE INDEX contact_ski_salesfo_308459_idx ON public.contact_skills USING btree (salesforce_ref)
contact_skills_contact_id_8391d350 CREATE INDEX contact_skills_contact_id_8391d350 ON public.contact_skills USING btree (contact_id)
contact_skills_pkey CREATE UNIQUE INDEX contact_skills_pkey ON public.contact_skills USING btree (id)
contact_skills_skill_id_3a4f3097 CREATE INDEX contact_skills_skill_id_3a4f3097 ON public.contact_skills USING btree (skill_id)
uniq_contact_skill CREATE UNIQUE INDEX uniq_contact_skill ON public.contact_skills USING btree (contact_id, skill_id)

Generated by tbls