Centurio Documents de système et de module
🏛️ Architecture de plateforme 🔑 Login
🏠 Tous les modules / crm_office / Intranet et publications
📰

Intranet et publications

publishing crm_office 🛡️ RLS Protected

Les sites similaires à SharePoint, les pages/nouvelles/politiques, la diffusion de flux, les pièces jointes DMS et la confirmation de lecture.

Fachliche Bestimmung: L'intégration de l'information et de la communication est une des principales caractéristiques de la communication.

⚡ Flux de travail et cycles de vie

Page d'intranet: projet → circulation → publication intranet_page_lifecycle

Voie de contenu du projet à la version majeure publiée, y compris la confirmation de lecture optionnelle.

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
Le projet
Contributeur met en place et conçoit HTML-body (blanch-sanitise).
Aktionen: attach_document, upload_and_attach, save_draft
2. PENDING
Pour la libération
La page de publication est démarrée par source_type_page.
Aktionen: submit_for_approval
3. PUBLISHED
Publié
publish_from_circulation définit la version majeure et la visibilité du flux.
Aktionen: audience_filter, optional_ack_tasks
4. ACK
Confirmation de lecture
Les politiques requises ont généré des références par version.
Aktionen: le reconnaître

🗄️ Modèles de données

PublishingAcks publishing_acks RLS Aktiv
9 Les champs / colonnes

Tabelle publishing_acks

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
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 Les champs / colonnes

Tabelle publishing_attachments

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
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 Les champs / colonnes

Tabelle publishing_page_versions

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
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 Les champs / colonnes

Tabelle publishing_pages

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
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 Les champs / colonnes

Tabelle publishing_site_members

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
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 Les champs / colonnes

Tabelle publishing_sites

Feldname Type de données Le dépôt Schlüssel Importance professionnelle
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

🔌 Les points d'entrée (UI et API)

Art Le mode de fonctionnement Point de fin / parcours Titel & Zweck Leur
⚡ 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
Résultats de l'analyse
Le programme de révision des données
Standard
🖥️ WEB-UI GET /intranet/pages/{id}/edit
Édition de page
Les pièces jointes de la catégorie "MCE"
Standard
⚡ REST API POST /api/v1/publishing/pages/{id}/submit
Pour la libération
Retour en orbite
Standard

🛡️ Réglementation et conformité

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • La mise en œuvre de la politique de sécurité
  • La rédaction de l'audit
  • Les conditions de l'exonération de la demande
Modules liés:
➔ circulations ➔ documents ➔ tasks