Centurio Documentazione dei sistemi e dei moduli
🔍
🏛️ Architettura della piattaforma
🇩🇪 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
🏠 Tutti i moduli / crm_office / Intranet & pubblicazioni
📰

Intranet & pubblicazioni

publishing crm_office 🛡️ RLS Protected

Siti simili a SharePoint, Pagine/News/Policies, distribuzione di dati, allegati DMS e conferma di lettura.

Fachliche Bestimmung: dipendente intranet: aree (siti) con roli di membro, progetti con organi di TinyMCE, rilascio tramite DocumentCirculation (source_type=publishing_page), versione principale presso Publish, opzionali Ack-tasks presso le politiche.
⚡ Flussi di lavoro e cicli di vita (1) 🗄️ Modelli di dati (6) 🔌 Punto di partenza (UI & API) (20) 🛡️ Regolamentazione e conformità

⚡ Flussi di lavoro e cicli di vita

Pagina di intranet: progetto → circolazione → pubblicazione intranet_page_lifecycle

Tracciato di contenuti dal progetto alla versione principale pubblicata, inclusa la conferma di lettura opzionale.

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
Progetto
Contributor crea e progetta HTML-body (bleach-sanitized).
Aktionen: attach_document, upload_and_attach, save_draft
2. PENDING
Per la liberazione
Inizia la circolazione con source_type=publishing_page.
Aktionen: submit_for_approval
3. PUBLISHED
Pubblicato
publish_from_circulation impone la versione principale e la visibilità dei feed.
Aktionen: audience_filter, optional_ack_tasks
4. ACK
Confirmazione di lettura
Le politiche con richieste hanno generato indicazioni di richieste per versione.
Aktionen: riconoscere

🗄️ Modelli di dati

PublishingAcks publishing_acks RLS Aktiv
9 Feltri / colonne

Tabelle publishing_acks

Feldname Tipo di dati Dati Schlüssel Importanza professionale
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 Feltri / colonne

Tabelle publishing_attachments

Feldname Tipo di dati Dati Schlüssel Importanza professionale
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 Feltri / colonne

Tabelle publishing_page_versions

Feldname Tipo di dati Dati Schlüssel Importanza professionale
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 Feltri / colonne

Tabelle publishing_pages

Feldname Tipo di dati Dati Schlüssel Importanza professionale
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 Feltri / colonne

Tabelle publishing_site_members

Feldname Tipo di dati Dati Schlüssel Importanza professionale
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 Feltri / colonne

Tabelle publishing_sites

Feldname Tipo di dati Dati Schlüssel Importanza professionale
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

🔌 Punto di partenza (UI & API)

Art Metodo Punto finale / percorso Titel & Zweck Il diritto
⚡ REST API DELETE /api/v1/publishing/pages/{page_id}/attachments/{document_id}
detach_document
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API GET /api/v1/publishing/dms-search
dms_search
Semantic binding: inventory_only; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/feed
publishing_feed
Semantic binding: inventory_only; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/pages/{page_id}
get_page
Semantic binding: inventory_only; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/pages/{page_id}/attachments
list_attachments
Semantic binding: inventory_only; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/sites
list_sites
Semantic binding: inventory_only; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/sites/{site_id}/members
list_members
Semantic binding: inventory_only; mutation=False
 publishing
⚡ REST API GET /api/v1/publishing/sites/{site_id}/pages
list_site_pages
Semantic binding: inventory_only; mutation=False
 publishing
⚡ REST API PATCH /api/v1/publishing/pages/{page_id}
update_page
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API PATCH /api/v1/publishing/sites/{site_id}
update_site
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages
create_page
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/ack
acknowledge_page
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/attachments
attach_document
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/submit
submit_page
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/pages/{page_id}/unpublish
unpublish_page
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API POST /api/v1/publishing/sites
create_site
Semantic binding: operator_surface; mutation=True
 publishing
⚡ REST API PUT /api/v1/publishing/sites/{site_id}/members
set_member
Semantic binding: operator_surface; mutation=True
 publishing
🖥️ WEB-UI GET /intranet
Fatto di intranet
In particolare, il numero di persone che hanno partecipato alla riunione è stato di circa un milione di persone.
 Standard
🖥️ WEB-UI GET /intranet/pages/{id}/edit
Redazione del sito
Appendici di cui al punto 1.
 Standard
⚡ REST API POST /api/v1/publishing/pages/{id}/submit
Per la liberazione
Iniziazione della circolazione
 Standard

🛡️ Regolamentazione e conformità

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • Capacità di verifica
  • Pubblicazione di revisione
  • Isolamento dei clienti (RLS)
Moduli collegati:
➔ circulations ➔ documents ➔ tasks