Centurio Järjestelmätoduulit
🔍
🏛️ Alustan arkkitehtuuri
🇩🇪 Deutsch 🇬🇧 English 🇫🇷 Français 🇪🇸 Español 🇮🇹 Italiano 🇳🇱 Nederlands 🇵🇱 Polski 🇵🇹 Português 🇨🇿 Čeština 🇸🇰 Slovenčina 🇭🇺 Magyar 🇷🇴 Română 🇧🇬 Български 🇬🇷 Ελληνικά 🇩🇰 Dansk 🇫🇮 Suomi 🇸🇪 Svenska 🇱🇹 Lietuvių 🇱🇻 Latviešu 🇪🇪 Eesti 🇭🇷 Hrvatski 🇸🇮 Slovenščina 🇲🇹 Malti 🇮🇪 Gaeilge 🇷🇺 Русский 🇺🇦 Українська 🇹🇷 Türkçe 🇳🇴 Norsk bokmål 🇷🇸 Српски 🇮🇸 Íslenska 🇨🇭 Schwiiz/Suisse
🔑 Login
🏠 Kaikki moduulit / crm_office / Yhteisö & postit
📘

Yhteisö & postit

communications crm_office 🛡️ RLS Protected

Yhteisö & Postfächer <unk> koodista johdettu prosessi- ja API-asiakirja.

Fachliche Bestimmung: Komunikaatio & postfakker <unk> koodista johdettu prosessi- ja API-asiakirja.
⚡ Työvirrat ja elinkaari (1) 🗄️ Tiedonmallit & kentät (6) 🔌 Alkuperäiset kohdat (UI & API) (30) 🛡️ Sääntely & noudattaminen

⚡ Työvirrat ja elinkaari

Käyttäjäohje: vastausagentti plan:command_reply_agent

Tarkistettu kestävä suunnitelma (durable_plan), aloitus: 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

🗄️ Tiedonmallit & kentät

Communications communications RLS Aktiv
20 Taulukot

Tabelle communications

Feldname Tyyppi Tilanne Schlüssel Työalainen merkitys
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
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 Taulukot

Tabelle network_capabilities

Feldname Tyyppi Tilanne Schlüssel Työalainen merkitys
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 Taulukot

Tabelle network_matches

Feldname Tyyppi Tilanne Schlüssel Työalainen merkitys
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 Taulukot

Tabelle network_offerings

Feldname Tyyppi Tilanne Schlüssel Työalainen merkitys
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 Taulukot

Tabelle network_profiles

Feldname Tyyppi Tilanne Schlüssel Työalainen merkitys
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 Taulukot

Tabelle notifications

Feldname Tyyppi Tilanne Schlüssel Työalainen merkitys
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

🔌 Alkuperäiset kohdat (UI & API)

Art Tekijä Loppu- / kulku Titel & Zweck Ehdotus
⚡ REST API DELETE /api/v1/communications/mailboxes/{account_id}
delete_mailbox
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API GET /api/v1/communications
list_communications
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/communications/mailboxes
list_mailboxes
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/communications/mailboxes/presets
get_mailbox_presets
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/communications/mailboxes/{account_id}
get_mailbox
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/communications/{comm_id}
get_communication
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/meetings/{room_key}
meeting_info
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/network/demands
list_demands
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/network/profiles
list_profiles
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/notifications
list_notifications
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /api/v1/notifications/count
unread_count
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API GET /communications
communications_page
Semantic binding: not_evaluated; mutation=False
 communications
⚡ REST API PATCH /api/v1/network/demands/{demand_id}/status
update_demand_status
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/communications/mailboxes
create_mailbox
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/communications/mailboxes/autodiscover
autodiscover_mailbox
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/communications/mailboxes/test-draft
test_draft_mailbox
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/communications/mailboxes/{account_id}/sync
sync_mailbox_now
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/communications/mailboxes/{account_id}/test
test_mailbox_connection
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/communications/{comm_id}/forward-to-inbox
forward_communication_to_inbox
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/meetings
create_meeting
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/meetings/{room_key}/end
end_meeting
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/meetings/{room_key}/invite
kutsu
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/network/capabilities
create_capability
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/network/demands
create_demand
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/network/demands/{demand_id}/convert
convert_lead
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/network/demands/{demand_id}/match
match_demand
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/network/demands/{demand_id}/propose
create_proposal
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/network/profiles
create_profile
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API POST /api/v1/notifications/read
mark_read
Semantic binding: not_evaluated; mutation=True
 communications
⚡ REST API PUT /api/v1/communications/mailboxes/{account_id}
update_mailbox
Semantic binding: not_evaluated; mutation=True
 communications

🛡️ Sääntely & noudattaminen

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Tilanne
  • Kuntointikerro (PostgreSQL RLS)