БД callbox (СУО)

Хост: db-1 (10.10.19.31:5432) Пользователь: asterisk Приложения: Система учёта обращений

Автоматически сгенерировано: 2026-03-03 09:38

Таблицы

| Таблица | Записей | Описание | FK | |---------|---------|----------|----|| | appeal_files | -1 | | 1 FK | | appeal_types | -1 | | — | | appeals | -1 | | 7 FK | | categories | -1 | | 1 FK | | cls_appeal_types | 8 | | 1 FK | | cls_categories | 48 | | 1 FK | | cls_classifiers | 2 | | — | | cls_subcategories | 182 | | 1 FK | | persons | -1 | | — | | response_methods | -1 | | — | | sources | -1 | | — | | subcategories | -1 | | 1 FK | | suo_organization_parents | -1 | | 2 FK | | suo_organization_settings | 2 | | 2 FK | | suo_organizations | 4 | | 1 FK | | suo_tasks | 349 | | 4 FK | | suo_user_roles | 4 | | 1 FK | | suo_users | 10 | | 2 FK |

Схема связей (Mermaid)

erDiagram
    appeals ||--o{ appeal_files : "appeal_id"
    cls_appeal_types ||--o{ appeals : "appeal_type_id"
    persons ||--o{ appeals : "applicant_id"
    cls_categories ||--o{ appeals : "category_id"
    persons ||--o{ appeals : "patient_id"
    response_methods ||--o{ appeals : "response_method_id"
    sources ||--o{ appeals : "source_id"
    cls_subcategories ||--o{ appeals : "subcategory_id"
    appeal_types ||--o{ categories : "appeal_type_id"
    cls_classifiers ||--o{ cls_appeal_types : "classifier_id"
    cls_appeal_types ||--o{ cls_categories : "appeal_type_id"
    cls_categories ||--o{ cls_subcategories : "category_id"
    categories ||--o{ subcategories : "category_id"
    suo_organizations ||--o{ suo_organization_parents : "organization_id"
    suo_organizations ||--o{ suo_organization_parents : "parent_id"
    cls_classifiers ||--o{ suo_organization_settings : "classifier_id"
    suo_organizations ||--o{ suo_organization_settings : "organization_id"
    suo_organizations ||--o{ suo_organizations : "parent_id"
    appeals ||--o{ suo_tasks : "appeal_id"
    suo_users ||--o{ suo_tasks : "assigned_user_id"
    suo_users ||--o{ suo_tasks : "created_by_user_id"
    suo_organizations ||--o{ suo_tasks : "organization_id"
    suo_users ||--o{ suo_user_roles : "user_id"
    suo_organizations ||--o{ suo_users : "suo_organization_id"
    suo_users ||--o{ suo_users : "supervisor_id"