organization_notifications
Настройки автооповещений для организаций (КМИС интеграция)
Записей: ~176
Колонки
| Колонка | Тип | Nullable | Default | Описание |
|---|---|---|---|---|
| id 🔑 | integer(32) | NOT NULL | nextval('organization_notif... | |
| organization_id | integer(32) | NOT NULL | → organizations(id) | |
| is_active | boolean | NULL | false | |
| kmis_uuid | character varying(36) | NULL | UUID организации в системе КМИС | |
| call_local | boolean | NULL | false | |
| call_longdistance | boolean | NULL | false | |
| call_mobile | boolean | NULL | false | |
| cli_route_id | integer(32) | NULL | Маршрут для исходящего CLI при звонках → incoming_routes(id) | |
| sms_enabled | boolean | NULL | false | |
| created_at | timestamp without time zone | NULL | now() | |
| updated_at | timestamp without time zone | NULL | now() |
🔑 = Primary Key, → = Foreign Key
Индексы
| Имя | Определение |
|---|---|
| idx_org_notifications_org_id | CREATE INDEX idx_org_notifications_org_id ON public.organization_notification... |
| idx_org_notifications_org_unique | CREATE UNIQUE INDEX idx_org_notifications_org_unique ON public.organization_n... |
| idx_org_notifications_uuid | CREATE INDEX idx_org_notifications_uuid ON public.organization_notifications ... |
| organization_notifications_kmis_uuid_key | CREATE UNIQUE INDEX organization_notifications_kmis_uuid_key ON public.organi... |
| organization_notifications_pkey | CREATE UNIQUE INDEX organization_notifications_pkey ON public.organization_no... |
Foreign Keys
| Колонка | Ссылка на |
|---|---|
| cli_route_id | incoming_routes(id) |
| organization_id | organizations(id) |