Centurio Raf- og móðulýsing
🔍
🏛️ Verkfærslur
🇩🇪 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
🏠 Öll svið / crm_office / Hringningar og spjall
📘

Hringningar og spjall

chat crm_office 🛡️ RLS Protected

Teymisspjall og símtöl <unk> úr kóða- og API-skjalagerð.

Fachliche Bestimmung: Team-chat & call <unk> Process- og API-skjalagerð sem er leidd af kóða. Fær alla skráða ferli, getu, staða vélum, API og töflum fyrir lífræna og endurskoðun.
⚡ Starfsflæði og lífsstíl (0) 🗄️ Upplýsingarmyndir og sviði (4) 🔌 Upphafstaðir (UI og API) (21) 🛡️ Reglugerð og eftirfylgni

⚡ Starfsflæði og lífsstíl

Dieses Modul folgt dem standardisierten transaktionalen CRUD- und Event-Lifecycle.

🗄️ Upplýsingarmyndir og sviði

ChatChannels chat_channels RLS Aktiv
18 Fylgi / rammur

Tabelle chat_channels

Feldname Upplýsingar Þörf Schlüssel Sérfræðilegt þýði
kind VARCHAR(8) Ja * - Feld kind
name VARCHAR(120) Nein - Feld name
topic VARCHAR(255) Nein - Feld topic
is_private BOOLEAN Ja * - Feld is_private
entity_type VARCHAR(32) Nein - Feld entity_type
entity_id UUID Nein - Feld entity_id
dm_key VARCHAR(80) Nein - Feld dm_key
archived_at DATETIME Nein - Feld archived_at
last_message_at DATETIME Nein - Feld last_message_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
ChatMembers chat_members RLS Aktiv
15 Fylgi / rammur

Tabelle chat_members

Feldname Upplýsingar Þörf Schlüssel Sérfræðilegt þýði
channel_id UUID Ja * FK ➔ chat_channels.id Feld channel_id
user_id UUID Nein FK ➔ users.id Feld user_id
portal_user_id UUID Nein FK ➔ portal_users.id Feld portal_user_id
role VARCHAR(8) Ja * - Feld role
last_read_seq BIGINT Ja * - Feld last_read_seq
muted BOOLEAN Ja * - Feld muted
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
ChatMessages chat_messages RLS Aktiv
19 Fylgi / rammur

Tabelle chat_messages

Feldname Upplýsingar Þörf Schlüssel Sérfræðilegt þýði
seq BIGINT Ja * - Feld seq
channel_id UUID Ja * FK ➔ chat_channels.id Feld channel_id
author_id UUID Nein FK ➔ users.id Feld author_id
portal_author_id UUID Nein FK ➔ portal_users.id Feld portal_author_id
parent_id UUID Nein FK ➔ chat_messages.id Feld parent_id
kind VARCHAR(8) Ja * - Feld kind
body TEXT Ja * - Feld body
mention_ids JSONB Ja * - Feld mention_ids
edited_at DATETIME Nein - Feld edited_at
deleted_at DATETIME Nein - Feld deleted_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
ChatReactions chat_reactions RLS Aktiv
12 Fylgi / rammur

Tabelle chat_reactions

Feldname Upplýsingar Þörf Schlüssel Sérfræðilegt þýði
message_id UUID Ja * FK ➔ chat_messages.id Feld message_id
user_id UUID Ja * FK ➔ users.id Feld user_id
emoji VARCHAR(16) Ja * - Feld emoji
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

🔌 Upphafstaðir (UI og API)

Art Aðferð Endaskil / leið Titel & Zweck Tilréttaröðun
⚡ REST API DELETE /api/v1/chat/messages/{message_id}
delete_message
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API GET /api/v1/chat/channels
list_channels
Semantic binding: inventory_only; mutation=False
 chat
⚡ REST API GET /api/v1/chat/channels/{channel_id}/members
channel_members
Semantic binding: inventory_only; mutation=False
 chat
⚡ REST API GET /api/v1/chat/channels/{channel_id}/messages
channel_messages
Semantic binding: inventory_only; mutation=False
 chat
⚡ REST API GET /api/v1/chat/messages/{message_id}/thread
message_thread
Semantic binding: inventory_only; mutation=False
 chat
⚡ REST API GET /api/v1/chat/search
að leita
Semantic binding: inventory_only; mutation=False
 chat
⚡ REST API GET /api/v1/chat/unread
ólæst
Semantic binding: inventory_only; mutation=False
 chat
⚡ REST API GET /chat
chat_page
Semantic binding: inventory_only; mutation=False
 chat
⚡ REST API PATCH /api/v1/chat/messages/{message_id}
edit_message
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels
create_channel
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels/{channel_id}/archive
archive_channel
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels/{channel_id}/call
start_call
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels/{channel_id}/join
join_channel
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels/{channel_id}/leave
leave_channel
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels/{channel_id}/members
add_members
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels/{channel_id}/messages
post_message
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/channels/{channel_id}/read
mark_read
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/dm
open_dm
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/entity
open_entity_chat
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API POST /api/v1/chat/messages/{message_id}/react
að bregðast við
Semantic binding: operator_surface; mutation=True
 chat
⚡ REST API PUT /api/v1/chat/channels/{channel_id}/mute
mute_channel
Semantic binding: operator_surface; mutation=True
 chat

🛡️ Reglugerð og eftirfylgni

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Gæðslu og efnismun
  • Þingþjónustuþjónusta (PostgreSQL RLS)