Centurio Systemen en modules
🔍
🏛️ Plattformarchitectuur
🇩🇪 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
🏠 Alle modules / core_platform / Documenten & archief
📘

Documenten & archief

documents core_platform 🛡️ RLS Protected

Documenten & archief <unk> proces- en API-documentatie afgeleid van code.

Fachliche Bestimmung: Documenten & archief <unk> proces- en API-documentatie afgeleid van code.
⚡ Werkstromen en levenscyclus (5) 🗄️ Datamodellen & velden (19) 🔌 Inleidende punten (UI&API's) (157) 🛡️ Reglementarische en compliance

⚡ Werkstromen en levenscyclus

Gebruikersbevel: classificatieagent plan:command_classification_agent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

1. classification_agent
classification_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: classification_agent

Gebruikersbevel: documentagent plan:command_document_agent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

1. document_agent
document_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: document_agent

Gebruikersbevel: indiener plan:command_filing_agent

Gecontroleerd duurzaam plan (durable_plan), start: manual_command.

1. filing_agent
filing_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: filing_agent

Opgedateerde aangepaste velden op document plan:custom_fields_orchestration

Gecontroleerd duurzaam plan (durable_plan), start: domain_event.

1. custom_fields_agent
custom_fields_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: custom_fields_agent

Artikel 2 status:document

De overgangsregelingen zijn niet verplicht (zie service validatie).

1. uploaded
geüpload
Status <unk>uploaded<unk> van het statusmachine document.
2. processing
Verwerking
Status <unk>verwerking <unk> van het statusmasjiendocument.
3. classified
Classificatie
Status <unk>classified<unk> van het staatmachine document.
4. needs_review
needs_review
Status <unk>needs_review<unk> van het statusmasjiendocument.
5. processed
verwerkte
Status <unk> verwerkt<unk> van het statusmasjien document.
6. archived
gearchiefd
Status <unk>archief <unk> van het statusmasjiendocument.

🗄️ Datamodellen & velden

DocumentFilingRules document_filing_rules RLS Aktiv
16 Veld / kolom

Tabelle document_filing_rules

Feldname Datatipe Verplichting Schlüssel Gezondheid
name VARCHAR(120) Ja * - Feld name
match_document_type VARCHAR(64) Nein - Feld match_document_type
match_mime_prefix VARCHAR(64) Nein - Feld match_mime_prefix
target_folder_id UUID Ja * FK ➔ document_folders.id Feld target_folder_id
priority INTEGER Ja * - Feld priority
active BOOLEAN Ja * - Feld active
is_system BOOLEAN Ja * - Feld is_system
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
DocumentFolders document_folders RLS Aktiv
17 Veld / kolom

Tabelle document_folders

Feldname Datatipe Verplichting Schlüssel Gezondheid
name VARCHAR(120) Ja * - Feld name
code VARCHAR(64) Nein - Feld code
description VARCHAR(500) Nein - Feld description
parent_id UUID Nein FK ➔ document_folders.id Feld parent_id
document_type VARCHAR(64) Nein - Feld document_type
sort_order INTEGER Ja * - Feld sort_order
is_system BOOLEAN Ja * - Feld is_system
active BOOLEAN Ja * - Feld active
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
DocumentVersions document_versions RLS Aktiv
13 Veld / kolom

Tabelle document_versions

Feldname Datatipe Verplichting Schlüssel Gezondheid
document_id UUID Ja * FK ➔ documents.id Feld document_id
version_number INTEGER Ja * - Feld version_number
storage_key VARCHAR(1024) Ja * - Feld storage_key
storage_version_id VARCHAR(128) Nein - Feld storage_version_id
sha256 VARCHAR(64) Ja * - Feld sha256
size_bytes BIGINT Ja * - Feld size_bytes
created_by UUID Nein - Feld created_by
reason VARCHAR(255) Nein - Feld reason
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
Documents documents RLS Aktiv
40 Veld / kolom

Tabelle documents

Feldname Datatipe Verplichting Schlüssel Gezondheid
filename VARCHAR(512) Ja * - Feld filename
original_filename VARCHAR(512) Nein - Feld original_filename
mime_type VARCHAR(128) Ja * - Feld mime_type
size_bytes BIGINT Ja * - Feld size_bytes
page_count INTEGER Nein - Feld page_count
storage_provider VARCHAR(32) Ja * - Feld storage_provider
storage_bucket VARCHAR(128) Ja * - Feld storage_bucket
storage_key VARCHAR(1024) Ja * - Feld storage_key
storage_version_id VARCHAR(128) Nein - Feld storage_version_id
sha256 VARCHAR(64) Ja * - Feld sha256
document_type VARCHAR(48) Ja * - Feld document_type
status VARCHAR(48) Ja * - Feld status
source VARCHAR(48) Ja * - Feld source
document_date DATE Nein - Feld document_date
document_number VARCHAR(64) Nein - Feld document_number
customer_id UUID Nein FK ➔ customers.id Feld customer_id
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
project_id UUID Nein FK ➔ projects.id Feld project_id
asset_id UUID Nein FK ➔ assets.id Feld asset_id
quote_id UUID Nein FK ➔ quotes.id Feld quote_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
expense_id UUID Nein FK ➔ expenses.id Feld expense_id
invoice_id UUID Nein FK ➔ invoices.id Feld invoice_id
extracted_text TEXT Nein - Feld extracted_text
language VARCHAR(10) Nein - Feld language
wopi_lock_id VARCHAR(256) Nein - Feld wopi_lock_id
wopi_lock_expires_at DATETIME Nein - Feld wopi_lock_expires_at
classification_confidence NUMERIC(4, 3) Nein - Feld classification_confidence
folder_id UUID Nein FK ➔ document_folders.id Feld folder_id
search_vector TSVECTOR Nein - Feld search_vector
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
deleted_at DATETIME Nein - Feld deleted_at
PersonalAppointments personal_appointments RLS Aktiv
20 Veld / kolom

Tabelle personal_appointments

Feldname Datatipe Verplichting Schlüssel Gezondheid
title VARCHAR(255) Ja * - Feld title
appointment_date DATE Ja * - Feld appointment_date
appointment_time TIME Nein - Feld appointment_time
provider VARCHAR(200) Nein - Feld provider
location VARCHAR(255) Nein - Feld location
status VARCHAR(24) Ja * - Feld status
member_id UUID Nein FK ➔ personal_household_members.id Feld member_id
source_document_id UUID Nein FK ➔ documents.id Feld source_document_id
review_id UUID Nein FK ➔ review_tasks.id Feld review_id
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
notes TEXT Nein - Feld notes
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
PersonalContracts personal_contracts RLS Aktiv
23 Veld / kolom

Tabelle personal_contracts

Feldname Datatipe Verplichting Schlüssel Gezondheid
title VARCHAR(255) Ja * - Feld title
provider VARCHAR(200) Nein - Feld provider
contract_type VARCHAR(32) Ja * - Feld contract_type
status VARCHAR(24) Ja * - Feld status
start_date DATE Nein - Feld start_date
end_date DATE Nein - Feld end_date
cancellation_deadline DATE Nein - Feld cancellation_deadline
cancellation_notice_days INTEGER Nein - Feld cancellation_notice_days
billing_amount NUMERIC(14, 2) Nein - Feld billing_amount
billing_currency VARCHAR(3) Nein - Feld billing_currency
billing_interval VARCHAR(16) Nein - Feld billing_interval
member_id UUID Nein FK ➔ personal_household_members.id Feld member_id
source_document_id UUID Nein FK ➔ documents.id Feld source_document_id
notes TEXT Nein - Feld notes
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
PersonalEmailVerifications personal_email_verifications RLS Aktiv
9 Veld / kolom

Tabelle personal_email_verifications

Feldname Datatipe Verplichting Schlüssel Gezondheid
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
user_id UUID Ja * FK ➔ users.id Feld user_id
token_hash VARCHAR(64) Ja * - Feld token_hash
expires_at DATETIME Ja * - Feld expires_at
consumed_at DATETIME Nein - Feld consumed_at
last_sent_at DATETIME Ja * - Feld last_sent_at
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
PersonalHouseholdDocumentAssignments personal_household_document_assignments RLS Aktiv
12 Veld / kolom

Tabelle personal_household_document_assignments

Feldname Datatipe Verplichting Schlüssel Gezondheid
document_id UUID Ja * FK ➔ documents.id Feld document_id
member_id UUID Ja * FK ➔ personal_household_members.id Feld member_id
assigned_by UUID Ja * FK ➔ users.id Feld assigned_by
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ personal_household_members.tenant_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
PersonalHouseholdDocumentSubjects personal_household_document_subjects RLS Aktiv
11 Veld / kolom

Tabelle personal_household_document_subjects

Feldname Datatipe Verplichting Schlüssel Gezondheid
document_id UUID Ja * FK ➔ documents.id Feld document_id
member_id UUID Ja * FK ➔ personal_household_members.id Feld member_id
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
PersonalHouseholdInvitations personal_household_invitations RLS Aktiv
16 Veld / kolom

Tabelle personal_household_invitations

Feldname Datatipe Verplichting Schlüssel Gezondheid
member_id UUID Ja * FK ➔ personal_household_members.id Feld member_id
email VARCHAR(320) Ja * - Feld email
token_hash VARCHAR(64) Ja * - Feld token_hash
status VARCHAR(16) Ja * - Feld status
expires_at DATETIME Ja * - Feld expires_at
accepted_at DATETIME Nein - Feld accepted_at
accepted_by UUID Nein FK ➔ users.id Feld accepted_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
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
PersonalHouseholdLedgerEntries personal_household_ledger_entries RLS Aktiv
20 Veld / kolom

Tabelle personal_household_ledger_entries

Feldname Datatipe Verplichting Schlüssel Gezondheid
entry_type VARCHAR(16) Ja * - Feld entry_type
description VARCHAR(255) Ja * - Feld description
category VARCHAR(64) Ja * - Feld category
amount NUMERIC(14, 2) Ja * - Feld amount
currency VARCHAR(3) Ja * - Feld currency
occurred_on DATE Ja * - Feld occurred_on
is_confirmed BOOLEAN Ja * - Feld is_confirmed
member_id UUID Nein FK ➔ personal_household_members.id Feld member_id
source_document_id UUID Nein FK ➔ documents.id Feld source_document_id
replaces_entry_id UUID Nein FK ➔ personal_household_ledger_entries.id Feld replaces_entry_id
notes TEXT Nein - Feld notes
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
PersonalHouseholdLedgerEntryAccess personal_household_ledger_entry_access RLS Aktiv
12 Veld / kolom

Tabelle personal_household_ledger_entry_access

Feldname Datatipe Verplichting Schlüssel Gezondheid
entry_id UUID Ja * FK ➔ personal_household_ledger_entries.id Feld entry_id
member_id UUID Ja * FK ➔ personal_household_members.id Feld member_id
assigned_by UUID Ja * FK ➔ users.id Feld assigned_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
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
PersonalHouseholdLedgerEntrySubjects personal_household_ledger_entry_subjects RLS Aktiv
12 Veld / kolom

Tabelle personal_household_ledger_entry_subjects

Feldname Datatipe Verplichting Schlüssel Gezondheid
entry_id UUID Ja * FK ➔ personal_household_ledger_entries.id Feld entry_id
member_id UUID Ja * FK ➔ personal_household_members.id Feld member_id
share_amount NUMERIC(14, 2) Nein - Feld share_amount
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ personal_household_members.tenant_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
PersonalHouseholdMembers personal_household_members RLS Aktiv
14 Veld / kolom

Tabelle personal_household_members

Feldname Datatipe Verplichting Schlüssel Gezondheid
user_id UUID Nein FK ➔ users.id Feld user_id
display_name VARCHAR(160) Ja * - Feld display_name
relationship VARCHAR(32) Ja * - Feld relationship
role VARCHAR(24) Ja * - Feld role
is_active BOOLEAN Ja * - Feld is_active
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
PersonalMailboxConnections personal_mailbox_connections RLS Aktiv
25 Veld / kolom

Tabelle personal_mailbox_connections

Feldname Datatipe Verplichting Schlüssel Gezondheid
member_id UUID Ja * FK ➔ personal_household_members.id Feld member_id
email_address VARCHAR(320) Ja * - Feld email_address
imap_host VARCHAR(255) Ja * - Feld imap_host
imap_port INTEGER Ja * - Feld imap_port
imap_security VARCHAR(16) Ja * - Feld imap_security
imap_username VARCHAR(320) Ja * - Feld imap_username
encrypted_password TEXT Nein - Feld encrypted_password
sync_folder VARCHAR(128) Ja * - Feld sync_folder
last_uid INTEGER Ja * - Feld last_uid
uid_validity BIGINT Nein - Feld uid_validity
import_generation UUID Ja * - Feld import_generation
active BOOLEAN Ja * - Feld active
consent_version VARCHAR(64) Ja * - Feld consent_version
consented_at DATETIME Ja * - Feld consented_at
consented_by UUID Ja * FK ➔ users.id Feld consented_by
revoked_at DATETIME Nein - Feld revoked_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
PersonalPasswordResets personal_password_resets RLS Aktiv
9 Veld / kolom

Tabelle personal_password_resets

Feldname Datatipe Verplichting Schlüssel Gezondheid
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
user_id UUID Ja * FK ➔ users.id Feld user_id
token_hash VARCHAR(64) Ja * - Feld token_hash
expires_at DATETIME Ja * - Feld expires_at
consumed_at DATETIME Nein - Feld consumed_at
last_sent_at DATETIME Ja * - Feld last_sent_at
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
PersonalPrivacyRequests personal_privacy_requests RLS Aktiv
24 Veld / kolom

Tabelle personal_privacy_requests

Feldname Datatipe Verplichting Schlüssel Gezondheid
requester_user_id UUID Ja * FK ➔ users.id Feld requester_user_id
request_type VARCHAR(24) Ja * - Feld request_type
scope_description VARCHAR(1200) Nein - Feld scope_description
status VARCHAR(24) Ja * - Feld status
due_at DATETIME Ja * - Feld due_at
extended_until DATETIME Nein - Feld extended_until
extension_reason VARCHAR(500) Nein - Feld extension_reason
extension_communicated_at DATETIME Nein - Feld extension_communicated_at
assigned_to VARCHAR(128) Nein - Feld assigned_to
staff_note TEXT Nein - Feld staff_note
decision_notes TEXT Nein - Feld decision_notes
decided_at DATETIME Nein - Feld decided_at
decided_by VARCHAR(128) Nein - Feld decided_by
execution_notes TEXT Nein - Feld execution_notes
completed_at DATETIME Nein - Feld completed_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
PersonalProducts personal_products RLS Aktiv
24 Veld / kolom

Tabelle personal_products

Feldname Datatipe Verplichting Schlüssel Gezondheid
review_id UUID Nein FK ➔ review_tasks.id Feld review_id
title VARCHAR(255) Ja * - Feld title
brand VARCHAR(120) Nein - Feld brand
model VARCHAR(160) Nein - Feld model
serial_number VARCHAR(160) Nein - Feld serial_number
category VARCHAR(64) Ja * - Feld category
status VARCHAR(24) Ja * - Feld status
purchased_on DATE Nein - Feld purchased_on
purchase_amount NUMERIC(14, 2) Nein - Feld purchase_amount
purchase_currency VARCHAR(3) Nein - Feld purchase_currency
return_deadline DATE Nein - Feld return_deadline
warranty_until DATE Nein - Feld warranty_until
member_id UUID Nein FK ➔ personal_household_members.id Feld member_id
source_document_id UUID Nein FK ➔ documents.id Feld source_document_id
notes TEXT Nein - Feld notes
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
PersonalTaskCollaborators personal_task_collaborators RLS Aktiv
11 Veld / kolom

Tabelle personal_task_collaborators

Feldname Datatipe Verplichting Schlüssel Gezondheid
task_id UUID Ja * FK ➔ tasks.id Feld task_id
member_id UUID Ja * FK ➔ personal_household_members.id Feld member_id
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

🔌 Inleidende punten (UI&API's)

Art Metode Eindpunt / pad Titel & Zweck Aanpassing
⚡ REST API DELETE /api/v1/dochelper/documents/{document_id}
delete_personal_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/dochelper/documents/{document_id}/assignments/{member_id}
unassign_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/dochelper/documents/{document_id}/custom-fields/{key}
delete_personal_document_custom_field
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/dochelper/mailbox
disconnect_personal_mailbox
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/dochelper/members/{member_id}
deactivate_member
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/dochelper/members/{member_id}/invitation
revoke_invitation
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/dochelper/storage/{destination_id}
disconnect_personal_storage
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/document-design/branding/logo
delete_logo
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/document-design/templates/{doc_type}
reset_template
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/documents/filing-rules/{rule_id}
delete_filing_rule
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/documents/folders/{folder_id}
delete_folder
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/documents/{document_id}
delete_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/documents/{document_id}/custom-fields/{key}
delete_document_custom_field
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API DELETE /api/v1/tenant-storage/destination/{destination_id}
deactivate_destination
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API GET /api/v1/dochelper/activity
list_household_activity
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/appointments
list_personal_appointments
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/assistant/consent
personal_assistant_consent_status
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/assistant/drafts
list_personal_secretary_drafts
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/assistant/usage
personal_assistant_usage
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/capabilities
dochelper_capabilities
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/contracts
list_personal_contracts
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/data-export
export_household_data
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/data-export/archive
export_household_archive
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/documents
list_documents
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/documents/{document_id}
get_personal_document
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/documents/{document_id}/collaboration
get_document_collaboration
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/documents/{document_id}/custom-fields
get_personal_document_custom_fields
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/documents/{document_id}/download
personal_document_download
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/documents/{document_id}/extracted-fields
get_personal_document_extracted_fields
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/documents/{document_id}/form-fields
personal_document_form_fields
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/filing-rules
list_personal_filing_rules
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/folders
list_document_folders
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/inbox
recent_documents
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/ledger
list_ledger
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/ledger/summary
ledger_monthly_summary
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/ledger/{entry_id}/collaboration
get_ledger_entry_collaboration
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/ledger/{entry_id}/history
ledger_entry_history
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/mailbox
get_personal_mailbox
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/members
list_members
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/printers
personal_print_printers
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/privacy/requests
list_personal_privacy_requests
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/processing-readiness
document_processing_readiness
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/products
list_personal_products
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/proposals
list_proposals
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/proposals/summary
proposals_summary
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/search
search_personal_household
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/session
session_info
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/statistics
personal_statistics
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/storage
get_personal_storage
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/dochelper/tasks
list_personal_tasks
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/document-design/branding
brand
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/document-design/branding/logo
get_logo
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/document-design/catalog
catalogus
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/document-design/gaps
- de
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/document-design/layouts/{key}/thumb.svg
duim
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/document-design/templates/{doc_type}
get_template
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents
list_documents
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/filing-rules
list_filing_rules
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/folders
list_folders
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/folders/counts
folder_counts
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/office/status
office_editor_status
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/{document_id}
get_document
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/{document_id}/custom-fields
get_document_custom_fields
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/{document_id}/download
download_document
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/{document_id}/extracted-fields
get_document_extracted_fields
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/{document_id}/links
get_document_links
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/{document_id}/versions
list_versions
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/documents/{document_id}/versions/{version_id}/download
download_version
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/tenant-storage/destination
get_destination
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/tenant-storage/documents/{document_id}/sync-status
document_sync_status
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/wopi/files/{document_id}
check_file_info
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /api/v1/wopi/files/{document_id}/contents
get_file
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /documents
documents_page
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /documents/{document_id}
document_detail_page
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /portal/{slug}/dokumente/{document_id}
portal_document_download
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API GET /tenant-storage/oauth/callback
tenant_storage_oauth_callback
Semantic binding: not_evaluated; mutation=False
 documents
⚡ REST API PATCH /api/v1/dochelper/contracts/{contract_id}
update_personal_contract
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/dochelper/documents/{document_id}/extracted-fields
correct_personal_document_extracted_fields
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/dochelper/documents/{document_id}/metadata
update_personal_document_metadata
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/dochelper/documents/{document_id}/text
correct_personal_document_text
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/dochelper/filing-rules/{rule_id}
update_personal_filing_rule
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/dochelper/folders/{folder_id}
update_personal_document_folder
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/dochelper/products/{product_id}
update_personal_product
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/documents/filing-rules/{rule_id}
update_filing_rule
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/documents/folders/{folder_id}
update_folder
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/documents/{document_id}
update_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/documents/{document_id}/extracted-fields
correct_document_extracted_fields
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/documents/{document_id}/extracted-text
correct_document_extracted_text
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PATCH /api/v1/tenant-storage/destination/{destination_id}
update_destination
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/appointments
create_personal_appointment
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/appointments/{appointment_id}/complete
complete_personal_appointment
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/assistant/consent/revoke
personal_assistant_consent_revoke
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/assistant/draft
personal_secretary_draft
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/assistant/drafts
save_personal_secretary_draft
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/assistant/message
personal_assistant_message
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/assistant/transcribe
personal_assistant_transcribe
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/auth/login
dochelper_login
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/auth/password-reset/complete
complete_dochelper_password_reset
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/auth/password-reset/request
request_dochelper_password_reset
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/auth/register
register
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/auth/verification/resend
resend_dochelper_verification
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/auth/verify-email
verify_dochelper_email
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/contracts
create_personal_contract
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/documents
capture_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/documents/assign
assign_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/documents/{document_id}/custom-fields
add_personal_document_custom_field
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/documents/{document_id}/fill-form
fill_personal_document_form
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/documents/{document_id}/office/session
open_personal_office_session
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/documents/{document_id}/print
queue_personal_document_print
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/filing-rules
create_personal_filing_rule
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/folders
create_personal_document_folder
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/inbox/{item_id}/retry
retry_failed_document_processing
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/invitations/accept
accept_invitation
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/ledger
add_ledger_entry
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/ledger/{entry_id}/confirm
confirm_ledger_entry
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/ledger/{entry_id}/correct
correct_ledger_entry
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/mailbox/connect
connect_personal_mailbox
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/mailbox/sync
sync_personal_mailbox
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/members
add_member
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/members/{member_id}/invitations
invite_member
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/privacy/requests
create_personal_privacy_request
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/privacy/requests/{request_id}/withdraw
withdraw_personal_privacy_request
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/products
create_personal_product
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/proposals/{proposal_id}/accept
accept_proposal
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/proposals/{proposal_id}/reject
reject_proposal
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/storage/test
test_personal_storage
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/storage/{destination_id}/retry-failed
retry_personal_storage_syncs
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/tasks
create_personal_task
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/dochelper/tasks/{task_id}/complete
complete_personal_task
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/document-design/branding/logo
upload_logo
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/document-design/templates/{doc_type}/preview
Voorbeeld
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents
upload_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/filing-rules
create_filing_rule
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/folders
create_folder
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/office/new
new_office_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/{document_id}/custom-fields
add_document_custom_field
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/{document_id}/link
link_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/{document_id}/move
move_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/{document_id}/office/export-pdf
export_document_pdf
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/{document_id}/office/session
open_office_session
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/{document_id}/versions
upload_version
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/documents/{document_id}/versions/{version_id}/restore
restore_version
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/tenant-storage/destination
create_destination
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/tenant-storage/destination/{destination_id}/oauth/authorize
oauth_authorize
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/tenant-storage/destination/{destination_id}/resync/{document_id}
resync_document
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/tenant-storage/destination/{destination_id}/retry-failed
retry_failed_syncs
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/tenant-storage/destination/{destination_id}/test
test_destination
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/wopi/files/{document_id}
lock_operations
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /api/v1/wopi/files/{document_id}/contents
put_file
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API POST /portal/{slug}/upload
portal_upload
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PUT /api/v1/dochelper/documents/{document_id}/collaboration
update_document_collaboration
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PUT /api/v1/dochelper/documents/{document_id}/custom-fields
replace_personal_document_custom_fields
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PUT /api/v1/dochelper/ledger/{entry_id}/collaboration
update_ledger_entry_collaboration
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PUT /api/v1/dochelper/storage
configure_personal_storage
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PUT /api/v1/document-design/branding/accent
set_accent
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PUT /api/v1/document-design/templates/{doc_type}
put_template
Semantic binding: not_evaluated; mutation=True
 documents
⚡ REST API PUT /api/v1/documents/{document_id}/custom-fields
update_document_custom_fields
Semantic binding: not_evaluated; mutation=True
 documents

🛡️ Reglementarische en compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • De Commissie heeft de Commissie verzocht om een aanvullende verordening te treffen.
  • De volgende functies worden toegepast: