DMS Folder Schema

Folder display name

Parent folder ID (null = root level)

Full materialized path (e.g. /Rechnungen/2026/)

Icon name for display

Color hex for display

Default document type for uploads into this folder

Retention policy inherited by documents in this folder

Sort order among siblings

Folder template that produced this folder (for traceability and re-apply).

Entity type this folder belongs to (party, project, vehicle, …).

Entity ID this folder belongs to.

Storage backend that physically holds this folder (if any).

Backend-specific folder identifier (e.g. Graph driveItem id).

Backend-absolute path at creation time (audit + quick display).

Backend eTag at last sync — used for echo-suppression and 3-way conflict detection.

SharePoint lastModifiedDateTime captured at last sync.

SharePoint webUrl for direct linkback from DMS UI.

Origin of the most recent write. Drives echo-suppression in the opposite direction.

Last successful sync timestamp (in or out).

Last sync error message — cleared on successful sync.

Conflict-locking state-machine for folder sync (mirrors dms_document.syncState).

Folder filing state. missing_in_backend = SharePoint counterpart no longer exists (K2 scenario).

Path at which the folder was first discovered on the backend — source of truth for path-source: origin.

Backend that originally delivered this folder (inbound origin). Stable across later moves.

Path-ownership model (ADR 0391): "origin" = backend original (inbound sync), "user" = explicit folder choice, "policy" = filing policy template. Only a policy with overrideBackendPath=true may override "origin"/"user". Folders currently never carry "user" — the value exists so the enum stays symmetric with dms_documents.

Timestamp of the most recent successful outbound folder operation.

BullMQ jobId of the last outbound-folder attempt (diagnostics + idempotency).

Total outbound attempts (increments on every CAS-lock acquisition).

Bulk path-rewrite progress after a folder move. null/done = idle.

Cursor for chunked path-rewrite continuation (last processed _id).

Source path prefix for the in-progress async rewrite.

Target path prefix for the in-progress async rewrite.

SharePoint counterpart was deleted while DMS-side changes are still pending — needs conflict triage.

When the SP-side delete was first observed.