Centurio Sistem ve modül belgesi
🏛️ Platform mimarisi 🔑 Login
🏠 Tüm modüller / crm_office / İletişim ve Posta
📘

İletişim ve Posta

communications crm_office 🛡️ RLS Protected

İletişim & Posta Ürünleri <unk> Koddan alınan süreç ve API belgeleri.

Fachliche Bestimmung: Komünikasyon & Posta Fakları <unk> koddan alınan süreç ve API belgeleri. Tüm kayıtlı süreçleri, yetenekleri, durum makineleri, API'leri ve simülasyon ve incelemeler için tabloları içerir.

⚡ İş akışları ve yaşam döngüleri

Kullanıcı emri: Cevap verme ajanı plan:command_reply_agent

Kontrol edilmiş Durable plan (durable_plan), başlangıç: 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

🗄️ Verim modelleri & alanlar

Communications communications RLS Aktiv
28 Alanlar / Sütunlar

Tabelle communications

Feldname Verim tipi İade Schlüssel Mesleki anlam
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 Alanlar / Sütunlar

Tabelle network_capabilities

Feldname Verim tipi İade Schlüssel Mesleki anlam
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 Alanlar / Sütunlar

Tabelle network_matches

Feldname Verim tipi İade Schlüssel Mesleki anlam
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 Alanlar / Sütunlar

Tabelle network_offerings

Feldname Verim tipi İade Schlüssel Mesleki anlam
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 Alanlar / Sütunlar

Tabelle network_profiles

Feldname Verim tipi İade Schlüssel Mesleki anlam
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 Alanlar / Sütunlar

Tabelle notifications

Feldname Verim tipi İade Schlüssel Mesleki anlam
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

🔌 Giriş noktaları (UI & API)

Art Metod Son nokta / yol Titel & Zweck Yasal
⚡ 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
davet
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

🛡️ Yönetim ve Uyum

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Görevlilik
  • Müşteri izolyasyonu (PostgreSQL RLS)