public.skills¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| group_id | bigint | false | public.skill_groups | |||
| id | bigint | false | public.contact_skills public.job_skills | |||
| is_active | boolean | false | ||||
| name | varchar(255) | false | ||||
| option_set_id | bigint | true | public.skill_option_sets | |||
| salesforce_ref | varchar(255) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| skills_group_id_aa458dbd_fk_skill_groups_id | FOREIGN KEY | FOREIGN KEY (group_id) REFERENCES skill_groups(id) DEFERRABLE INITIALLY DEFERRED |
| skills_name_key | UNIQUE | UNIQUE (name) |
| skills_option_set_id_32d13eed_fk_skill_option_sets_id | FOREIGN KEY | FOREIGN KEY (option_set_id) REFERENCES skill_option_sets(id) DEFERRABLE INITIALLY DEFERRED |
| skills_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| skills_group_id_aa458dbd | CREATE INDEX skills_group_id_aa458dbd ON public.skills USING btree (group_id) |
| skills_name_2b8674_idx | CREATE INDEX skills_name_2b8674_idx ON public.skills USING btree (name) |
| skills_name_3120df3a_like | CREATE INDEX skills_name_3120df3a_like ON public.skills USING btree (name varchar_pattern_ops) |
| skills_name_key | CREATE UNIQUE INDEX skills_name_key ON public.skills USING btree (name) |
| skills_option_set_id_32d13eed | CREATE INDEX skills_option_set_id_32d13eed ON public.skills USING btree (option_set_id) |
| skills_pkey | CREATE UNIQUE INDEX skills_pkey ON public.skills USING btree (id) |
| skills_salesfo_d507a4_idx | CREATE INDEX skills_salesfo_d507a4_idx ON public.skills USING btree (salesforce_ref) |
Generated by tbls