Centurio Система & модульна документація
🏛️ Архітектура платформи 🔑 Login
🏠 Всі модулі / crm_office / Коммунікація & Почтові папки
📘

Коммунікація & Почтові папки

communications crm_office 🛡️ RLS Protected

Комунікація & Почтові ведомості <unk> процесна та API-документація, отримана з коду.

Fachliche Bestimmung: Комунікація & Почтові папки <unk> процесна та API-документація, отримана з коду.

⚡ Процес роботи

Повідомлення користувача: агент відповіді plan:command_reply_agent

Проверене Durable plan (durable_plan), старт: manual_command.

1. reply_agent
reply_agent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "reply_agent", "condition_fact": null}
Aktionen: reply_agent

🗄️ Моделі даних & поля

Communications communications RLS Aktiv
28 Полі / графи

Tabelle communications

Feldname Тип даних Обов'язок Schlüssel Професійна значення
channel VARCHAR(32) Ja * - Feld channel
direction VARCHAR(16) Ja * - Feld direction
sender VARCHAR(320) Nein - Feld sender
recipients ARRAY Ja * - Feld recipients
subject VARCHAR(512) Nein - Feld subject
body_text TEXT Nein - Feld body_text
body_html TEXT Nein - Feld body_html
sent_at DATETIME Nein - Feld sent_at
customer_id UUID Nein FK ➔ customers.id Feld customer_id
project_id UUID Nein FK ➔ projects.id Feld project_id
mailbox_account_id UUID Nein FK ➔ mailbox_accounts.id Feld mailbox_account_id
folder VARCHAR(32) Ja * - Feld folder
is_read BOOLEAN Ja * - Feld is_read
is_flagged BOOLEAN Ja * - Feld is_flagged
in_reply_to VARCHAR(512) Nein - Feld in_reply_to
references TEXT Nein - Feld references
thread_key VARCHAR(512) Nein - Feld thread_key
message_uid INTEGER Nein - Feld message_uid
external_message_id VARCHAR(512) Nein - Feld external_message_id
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
NetworkCapabilities network_capabilities RLS Aktiv
10 Полі / графи

Tabelle network_capabilities

Feldname Тип даних Обов'язок Schlüssel Професійна значення
profile_id UUID Ja * FK ➔ network_profiles.id Feld profile_id
name VARCHAR(128) Ja * - Feld name
level VARCHAR(32) Nein - Feld level
certified BOOLEAN Ja * - Feld certified
notes TEXT Nein - Feld notes
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
NetworkMatches network_matches RLS Aktiv
15 Полі / графи

Tabelle network_matches

Feldname Тип даних Обов'язок Schlüssel Професійна значення
demand_id UUID Ja * - Feld demand_id
candidate_type VARCHAR(32) Ja * - Feld candidate_type
candidate_id UUID Ja * - Feld candidate_id
candidate_name VARCHAR(255) Ja * - Feld candidate_name
score NUMERIC(5, 4) Ja * - Feld score
status VARCHAR(48) Ja * - Feld status
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
NetworkOfferings network_offerings RLS Aktiv
14 Полі / графи

Tabelle network_offerings

Feldname Тип даних Обов'язок Schlüssel Професійна значення
profile_id UUID Ja * FK ➔ network_profiles.id Feld profile_id
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
product_id UUID Nein - Feld product_id
price NUMERIC(14, 2) Nein - Feld price
currency VARCHAR(3) Ja * - Feld currency
availability VARCHAR(32) Nein - Feld availability
lead_time_days INTEGER Nein - Feld lead_time_days
active BOOLEAN Ja * - Feld active
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
NetworkProfiles network_profiles RLS Aktiv
18 Полі / графи

Tabelle network_profiles

Feldname Тип даних Обов'язок Schlüssel Професійна значення
profile_type VARCHAR(48) Ja * - Feld profile_type
linked_entity_type VARCHAR(32) Nein - Feld linked_entity_type
linked_entity_id UUID Nein - Feld linked_entity_id
display_name VARCHAR(255) Ja * - Feld display_name
description TEXT Nein - Feld description
vat_id VARCHAR(32) Nein - Feld vat_id
address_text TEXT Nein - Feld address_text
visibility VARCHAR(16) Ja * - Feld visibility
active BOOLEAN Ja * - Feld active
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
Notifications notifications RLS Aktiv
19 Полі / графи

Tabelle notifications

Feldname Тип даних Обов'язок Schlüssel Професійна значення
user_id UUID Ja * FK ➔ users.id Feld user_id
kind VARCHAR(32) Ja * - Feld kind
title VARCHAR(255) Ja * - Feld title
body TEXT Nein - Feld body
link VARCHAR(512) Nein - Feld link
entity_type VARCHAR(64) Nein - Feld entity_type
entity_id UUID Nein - Feld entity_id
actor_user_id UUID Nein FK ➔ users.id Feld actor_user_id
dedupe_key VARCHAR(160) Nein - Feld dedupe_key
read_at DATETIME Nein - Feld read_at
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
created_by UUID Nein - Feld created_by
updated_by UUID Nein - Feld updated_by
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata

🔌 Початкові точки (UI & API)

Art Метод Останній пункт / шлях Titel & Zweck Право на
⚡ REST API DELETE /api/v1/communications/mailboxes/{account_id}
delete_mailbox
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API DELETE /api/v1/communications/mailboxes/{account_id}/rules/{rule_id}
delete_rule
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API DELETE /api/v1/communications/signatures/{sig_id}
delete_signature
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API DELETE /api/v1/communications/{comm_id}
delete_communication
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API GET /api/v1/communications
list_communications
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/addressbook
get_addressbook
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/folders/counts
folder_counts
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/mailboxes
list_mailboxes
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/mailboxes/presets
get_mailbox_presets
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/mailboxes/{account_id}
get_mailbox
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/mailboxes/{account_id}/rules
list_rules
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/settings
get_comm_settings
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/signatures
list_signatures
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/{comm_id}
get_communication
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/{comm_id}/event-suggestion
mail_event_suggestion
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/communications/{comm_id}/thread
get_thread
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/meetings/{room_key}
meeting_info
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/network/demands
list_demands
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/network/profiles
list_profiles
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/notifications
list_notifications
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /api/v1/notifications/count
unread_count
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API GET /communications
communications_page
Semantic binding: inventory_only; mutation=False
communications
⚡ REST API PATCH /api/v1/network/demands/{demand_id}/status
update_demand_status
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/bulk
bulk_action
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/compose
compose_message
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/drafts
save_draft
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/mailboxes
create_mailbox
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/mailboxes/autodiscover
autodiscover_mailbox
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/mailboxes/sync-all
sync_all_mailboxes
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/mailboxes/test-draft
test_draft_mailbox
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/mailboxes/{account_id}/rules
create_rule
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/mailboxes/{account_id}/sync
sync_mailbox_now
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/mailboxes/{account_id}/test
test_mailbox_connection
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/signatures
create_signature
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/context
update_communication_context
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/event
create_event_from_communication
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/flags
set_flags
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/forward
forward_message
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/forward-to-inbox
forward_communication_to_inbox
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/move
move_message
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/reply
reply_message
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/communications/{comm_id}/task
create_task_from_communication
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/meetings
create_meeting
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/meetings/{room_key}/end
end_meeting
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/meetings/{room_key}/invite
запросити
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/network/capabilities
create_capability
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/network/demands
create_demand
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/network/demands/{demand_id}/convert
convert_lead
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/network/demands/{demand_id}/match
match_demand
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/network/demands/{demand_id}/propose
create_proposal
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/network/profiles
create_profile
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API POST /api/v1/notifications/read
mark_read
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API PUT /api/v1/communications/mailboxes/{account_id}
update_mailbox
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API PUT /api/v1/communications/mailboxes/{account_id}/rules/{rule_id}
update_rule
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API PUT /api/v1/communications/settings
put_comm_settings
Semantic binding: operator_surface; mutation=True
communications
⚡ REST API PUT /api/v1/communications/signatures/{sig_id}
update_signature
Semantic binding: operator_surface; mutation=True
communications

🛡️ Регуляторна діяльність

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Простерогідність
  • Ізоляція клієнта (PostgreSQL RLS)