Centurio System- & Moduldokumentation (CH)
🔍
🏛️ Plattform-Architektur
🇩🇪 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
🏠 Alli Modul / crm_office / Intranet & Veröffentlichungen
📰

Intranet & Veröffentlichungen

publishing crm_office 🛡️ RLS Protected

SharePoint-ähnliche Sites, Seiten/News/Policies, Umlauf-Freigabe, DMS-Anhänge und Lesebestätigung.

Fachliche Bestimmung: Mitarbeiter-Intranet: Bereiche (Sites) mit Mitgliedsrollen, Entwürfe mit TinyMCE-Body, Freigabe über DocumentCirculation (source_type=publishing_page), Major-Version bei Publish, optionale Ack-Tasks bei Policies. Anhänge sind DMS-Dokumente; Download über /api/v1/documents/{id}/download. TinyMCE Link/Bild wählt aus dem DMS.
⚡ Workflows & Läbenszykle (1) 🗄️ Datemodell & Fälder (6) 🔌 Iistigspünkt (UI & APIs) (20) 🛡️ Regulatorie & Compliance

⚡ Workflows & Läbenszykle

Intranet-Seite: Entwurf → Umlauf → Veröffentlichung intranet_page_lifecycle

Inhaltspfad vom Entwurf bis zur veröffentlichten Major-Version inkl. optionaler Lesebestätigung.

sequenceDiagram Author->>PublishingAPI: POST /pages (draft) Author->>PublishingAPI: POST /pages/{id}/attachments Author->>PublishingAPI: POST /pages/{id}/submit PublishingAPI->>Circulations: create source_type=publishing_page Approver->>Circulations: complete_step approved Circulations->>PublishingAPI: publish_from_circulation Reader->>Web: GET /intranet/pages/{id}
1. DRAFT
Entwurf
Contributor legt Seite an und gestaltet HTML-Body (Bleach-sanitized).
Aktionen: attach_document, upload_and_attach, save_draft
2. PENDING
Zur Freigabe
startet DocumentCirculation mit source_type=publishing_page.
Aktionen: submit_for_approval
3. PUBLISHED
Veröffentlicht
publish_from_circulation setzt Major-Version und Feed-Sichtbarkeit.
Aktionen: audience_filter, optional_ack_tasks
4. ACK
Lesebestätigung
Policies mit requires_ack erzeugen Ack-Nachweis pro Version.
Aktionen: acknowledge

🗄️ Datemodell & Fälder

PublishingAcks publishing_acks RLS Aktiv
9 Fälder / Spalte

Tabelle publishing_acks

Feldname Datetyp Pflicht Schlüssel Fachlichi Bedütig
page_id UUID Ja * FK ➔ publishing_pages.id Feld page_id
user_id UUID Ja * FK ➔ users.id Feld user_id
version INTEGER Ja * - Feld version
acknowledged_at DATETIME Ja * - Feld acknowledged_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
metadata JSONB Ja * - Feld metadata
PublishingAttachments publishing_attachments RLS Aktiv
8 Fälder / Spalte

Tabelle publishing_attachments

Feldname Datetyp Pflicht Schlüssel Fachlichi Bedütig
page_id UUID Ja * FK ➔ publishing_pages.id Feld page_id
document_id UUID Ja * FK ➔ documents.id Feld document_id
sort_order INTEGER Ja * - Feld sort_order
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
PublishingPageVersions publishing_page_versions RLS Aktiv
12 Fälder / Spalte

Tabelle publishing_page_versions

Feldname Datetyp Pflicht Schlüssel Fachlichi Bedütig
page_id UUID Ja * FK ➔ publishing_pages.id Feld page_id
version INTEGER Ja * - Feld version
is_major BOOLEAN Ja * - Feld is_major
title VARCHAR(255) Ja * - Feld title
summary TEXT Nein - Feld summary
body TEXT Ja * - Feld body
created_by UUID Nein - Feld created_by
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
PublishingPages publishing_pages RLS Aktiv
28 Fälder / Spalte

Tabelle publishing_pages

Feldname Datetyp Pflicht Schlüssel Fachlichi Bedütig
site_id UUID Ja * FK ➔ publishing_sites.id Feld site_id
page_type VARCHAR(48) Ja * - Feld page_type
status VARCHAR(48) Ja * - Feld status
title VARCHAR(255) Ja * - Feld title
slug VARCHAR(255) Ja * - Feld slug
summary TEXT Nein - Feld summary
body TEXT Ja * - Feld body
pinned BOOLEAN Ja * - Feld pinned
requires_ack BOOLEAN Ja * - Feld requires_ack
published_version INTEGER Nein - Feld published_version
draft_version INTEGER Ja * - Feld draft_version
published_at DATETIME Nein - Feld published_at
published_by UUID Nein - Feld published_by
circulation_id UUID Nein FK ➔ document_circulations.id Feld circulation_id
ism_policy_id UUID Nein - Feld ism_policy_id
audience_kind VARCHAR(48) Ja * - Feld audience_kind
audience_roles JSONB Ja * - Feld audience_roles
audience_unit_ids JSONB Ja * - Feld audience_unit_ids
audience_user_ids JSONB Ja * - Feld audience_user_ids
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
PublishingSiteMembers publishing_site_members RLS Aktiv
8 Fälder / Spalte

Tabelle publishing_site_members

Feldname Datetyp Pflicht Schlüssel Fachlichi Bedütig
site_id UUID Ja * FK ➔ publishing_sites.id Feld site_id
user_id UUID Ja * FK ➔ users.id Feld user_id
role VARCHAR(48) Ja * - Feld role
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
PublishingSites publishing_sites RLS Aktiv
18 Fälder / Spalte

Tabelle publishing_sites

Feldname Datetyp Pflicht Schlüssel Fachlichi Bedütig
name VARCHAR(255) Ja * - Feld name
slug VARCHAR(128) Ja * - Feld slug
description TEXT Nein - Feld description
is_active BOOLEAN Ja * - Feld is_active
default_approver_ids JSONB Ja * - Feld default_approver_ids
default_audience_kind VARCHAR(48) Ja * - Feld default_audience_kind
default_audience_roles JSONB Ja * - Feld default_audience_roles
default_audience_unit_ids JSONB Ja * - Feld default_audience_unit_ids
navigation JSONB Ja * - Feld navigation
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

🔌 Iistigspünkt (UI & APIs)

Art Method Endpunkt / Pfad Titel & Zweck Berächtigig
⚡ REST API DELETE /api/v1/publishing/pages/{page_id}/attachments/{document_id}
detach_document
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API GET /api/v1/publishing/dms-search
dms_search
Semantic binding: not_evaluated; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/feed
publishing_feed
Semantic binding: not_evaluated; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/pages/{page_id}
get_page
Semantic binding: not_evaluated; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/pages/{page_id}/attachments
list_attachments
Semantic binding: not_evaluated; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/sites
list_sites
Semantic binding: not_evaluated; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/sites/{site_id}/members
list_members
Semantic binding: not_evaluated; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/sites/{site_id}/pages
list_site_pages
Semantic binding: not_evaluated; mutation=False
 publishing
⚡ REST API PATCH /api/v1/publishing/pages/{page_id}
update_page
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API PATCH /api/v1/publishing/sites/{site_id}
update_site
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages
create_page
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/ack
acknowledge_page
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/attachments
attach_document
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/submit
submit_page
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/unpublish
unpublish_page
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/sites
create_site
Semantic binding: not_evaluated; mutation=True
 publishing
⚡ REST API PUT /api/v1/publishing/sites/{site_id}/members
set_member
Semantic binding: not_evaluated; mutation=True
 publishing
🖥️ WEB-UI GET /intranet
Intranet-Feed
Audience-gefilterte Übersicht
 Standard
🖥️ WEB-UI GET /intranet/pages/{id}/edit
Seite bearbeiten
TinyMCE + DMS-Anhänge
 Standard
⚡ REST API POST /api/v1/publishing/pages/{id}/submit
Zur Freigabe
Startet Umlauf
 Standard

🛡️ Regulatorie & Compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • GoBD Nachvollziehbarkeit
  • Audit publishing.attachment_*
  • Mandanten-Isolation (RLS)
Verknüpfti Modul:
➔ circulations ➔ documents ➔ tasks