public.skill_options¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | false | ||||
| label | varchar(255) | false | ||||
| option_set_id | bigint | false | public.skill_option_sets | |||
| value | smallint | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| skill_options_option_set_id_465d8916_fk_skill_option_sets_id | FOREIGN KEY | FOREIGN KEY (option_set_id) REFERENCES skill_option_sets(id) DEFERRABLE INITIALLY DEFERRED |
| skill_options_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| skill_options_value_check | CHECK | CHECK ((value >= 0)) |
| uniq_skill_option_label | UNIQUE | UNIQUE (option_set_id, label) |
| uniq_skill_option_value | UNIQUE | UNIQUE (option_set_id, value) |
Indexes¶
| Name | Definition |
|---|---|
| skill_optio_option__fdf1bb_idx | CREATE INDEX skill_optio_option__fdf1bb_idx ON public.skill_options USING btree (option_set_id, value) |
| skill_options_option_set_id_465d8916 | CREATE INDEX skill_options_option_set_id_465d8916 ON public.skill_options USING btree (option_set_id) |
| skill_options_pkey | CREATE UNIQUE INDEX skill_options_pkey ON public.skill_options USING btree (id) |
| uniq_skill_option_label | CREATE UNIQUE INDEX uniq_skill_option_label ON public.skill_options USING btree (option_set_id, label) |
| uniq_skill_option_value | CREATE UNIQUE INDEX uniq_skill_option_value ON public.skill_options USING btree (option_set_id, value) |
Generated by tbls