cls_classifiers
Записей: ~2
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('cls_classifiers_id... | |
| name | character varying(200) | NOT NULL | ||
| code | character varying(50) | NOT NULL | ||
| description | text | NULL | ||
| is_active | boolean | NOT NULL | ||
| created_at | timestamp with time zone | NULL | now() |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| cls_classifiers_code_key | CREATE UNIQUE INDEX cls_classifiers_code_key ON public.cls_classifiers USING ... |
| cls_classifiers_pkey | CREATE UNIQUE INDEX cls_classifiers_pkey ON public.cls_classifiers USING btre... |
| ix_cls_classifiers_id | CREATE INDEX ix_cls_classifiers_id ON public.cls_classifiers USING btree (id) |
Используется в
- cls_appeal_types — через classifier_id
- suo_organization_settings — через classifier_id