Centurio Documentación de sistemas y módulos
🔍
🏛️ Arquitectura de la plataforma
🇩🇪 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
🏠 Todos los módulos / core_platform / Los clientes y las organizaciones (multi tenencia)
🏢

Los clientes y las organizaciones (multi tenencia)

tenants core_platform 🛡️ RLS Protected

Se trata de un sistema de aislamiento de datos estricto, datos generales de las organizaciones, perfiles de los sectores y precondiciones específicas de cada país.

Fachliche Bestimmung: La base de la arquitectura multi-arrendatario. Cada organización posee un entorno aislado. A través de la seguridad de nivel de fila (RLS) de PostgreSQL se asegura a nivel de base de datos que no se pueden ver ni modificar datos a través de los mandantes.
⚡ Flujos de trabajo y ciclos de vida (4) 🗄️ Modelos de datos y campos (166) 🔌 Puntos de inicio (UI y API) (183) 🛡️ Regulación y cumplimiento

⚡ Flujos de trabajo y ciclos de vida

Inicialización de los clientes y creación de sectores tenant_provisioning

instalación de una nueva organización, incluidos los marcos de contabilidad estándar, las categorías de sectores y los círculos de números.

graph LR A[Organisation anlegen] --> B[RLS-Sicherheit verankern] B --> C[Branchenprofil wählen] C --> D[Kategorie-Sets initialisieren] D --> E[Nummernkreise anlegen]
1. CREATE_ORG
La organización
instalación de la organización con datos de origen y número de impuestos.
Aktionen: Generar identificación de inquilino
2. INIT_RLS
Límites de seguridad de RLS
Colocar app.current_tenant_id en el contexto de ejecución.
Aktionen: El régimen de aislamiento de los inquilinos
3. SEED_INDUSTRY
Configuración de los sectores
Cargar los conjuntos de campos de categoría predefinidos y los marcos de cuenta estándar.
Aktionen: Seed de catálogo, El número de círculos

Otros productos y servicios de la industria plan:command_industry_setup_agent

Plan durable comprobado (durable_plan), inicio: manual_command.

1. industry_setup_agent
industry_setup_agent
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Aktionen: industry_setup_agent

Benutzerbefehl: integrations consultant agent plan:command_integrations_consultant_agent

Plan durable comprobado (durable_plan), inicio: manual_command.

1. integrations_consultant_agent
integrations_consultant_agent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "integrations_consultant_agent", "condition_fact": null}
Aktionen: integrations_consultant_agent

Benutzerbefehl: setup consultant agent plan:command_setup_consultant_agent

Plan durable comprobado (durable_plan), inicio: manual_command.

1. setup_consultant_agent
setup_consultant_agent
{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "setup_consultant_agent", "condition_fact": null}
Aktionen: setup_consultant_agent

🗄️ Modelos de datos y campos

AccountCodes account_codes RLS Aktiv
14 Cálculos y columnas

Tabelle account_codes

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
account_type VARCHAR(48) Ja * - Feld account_type
description TEXT Nein - Feld description
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
AiBudgetTopups ai_budget_topups RLS Aktiv
14 Cálculos y columnas

Tabelle ai_budget_topups

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
kind VARCHAR(16) Ja * - Feld kind
package_amount NUMERIC(14, 2) Ja * - Feld package_amount
package_gb INTEGER Nein - Feld package_gb
created_by UUID Nein - Feld created_by
payment_confirmed_at DATETIME Nein - Feld payment_confirmed_at
operator_invoice_id UUID Nein - Feld operator_invoice_id
operator_invoice_document_id UUID Nein - Feld operator_invoice_document_id
refunded_amount NUMERIC(14, 2) Ja * - Feld refunded_amount
operator_credit_note_id UUID Nein - Feld operator_credit_note_id
operator_credit_note_document_id UUID Nein - Feld operator_credit_note_document_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
AiUsage ai_usage RLS Aktiv
20 Cálculos y columnas

Tabelle ai_usage

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
agent_run_id UUID Nein FK ➔ agent_runs.id Feld agent_run_id
provider VARCHAR(32) Ja * - Feld provider
model VARCHAR(64) Ja * - Feld model
operation VARCHAR(32) Ja * - Feld operation
input_tokens INTEGER Ja * - Feld input_tokens
output_tokens INTEGER Ja * - Feld output_tokens
pages INTEGER Ja * - Feld pages
cost NUMERIC(10, 6) Ja * - Feld cost
duration_ms INTEGER Nein - Feld duration_ms
provider_request_id VARCHAR(160) Nein - Feld provider_request_id
cost_source VARCHAR(32) Ja * - Feld cost_source
provider_usage JSONB Ja * - Feld provider_usage
period VARCHAR(7) Ja * - Feld period
billable_amount NUMERIC(14, 6) Ja * - Feld billable_amount
markup_rate NUMERIC(7, 4) Ja * - Feld markup_rate
is_byok BOOLEAN Ja * - Feld is_byok
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
ApiConnectors api_connectors RLS Aktiv
21 Cálculos y columnas

Tabelle api_connectors

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
base_url VARCHAR(2048) Ja * - Feld base_url
auth_type VARCHAR(32) Ja * - Feld auth_type
auth_config JSONB Ja * - Feld auth_config
secret_encrypted TEXT Nein - Feld secret_encrypted
source VARCHAR(16) Ja * - Feld source
spec_hash VARCHAR(64) Nein - Feld spec_hash
version INTEGER Ja * - Feld version
status VARCHAR(16) Ja * - Feld status
execution_allowed BOOLEAN Ja * - Feld execution_allowed
host_ok BOOLEAN Ja * - Feld host_ok
description VARCHAR(512) Nein - Feld description
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
AuditLogs audit_logs RLS Aktiv
14 Cálculos y columnas

Tabelle audit_logs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
actor_type VARCHAR(16) Ja * - Feld actor_type
actor_id UUID Nein - Feld actor_id
action VARCHAR(64) Ja * - Feld action
entity_type VARCHAR(64) Ja * - Feld entity_type
entity_id UUID Nein - Feld entity_id
before_data JSONB Nein - Feld before_data
after_data JSONB Nein - Feld after_data
timestamp DATETIME Ja * - Feld timestamp
ip_address INET Nein - Feld ip_address
user_agent VARCHAR(512) Nein - Feld user_agent
agent_run_id UUID Nein FK ➔ agent_runs.id Feld agent_run_id
correlation_id UUID Nein - Feld correlation_id
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organizations.id Feld tenant_id
BankAccounts bank_accounts RLS Aktiv
20 Cálculos y columnas

Tabelle bank_accounts

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
bank_id UUID Nein FK ➔ banks.id Feld bank_id
label VARCHAR(255) Ja * - Feld label
iban VARCHAR(34) Nein - Feld iban
bic VARCHAR(11) Nein - Feld bic
currency VARCHAR(3) Ja * - Feld currency
account_holder VARCHAR(255) Nein - Feld account_holder
account_kind VARCHAR(16) Ja * - Feld account_kind
gl_account_code VARCHAR(32) Nein - Feld gl_account_code
is_default BOOLEAN Ja * - Feld is_default
status VARCHAR(16) Ja * - Feld status
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
Banks banks RLS Aktiv
14 Cálculos y columnas

Tabelle banks

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
bic VARCHAR(11) Nein - Feld bic
country_code VARCHAR(2) Ja * - Feld country_code
status VARCHAR(16) Ja * - Feld status
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
BusinessRequirements business_requirements RLS Aktiv
14 Cálculos y columnas

Tabelle business_requirements

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
case_id UUID Ja * FK ➔ consultant_cases.id Feld case_id
key VARCHAR(96) Ja * - Feld key
statement TEXT Ja * - Feld statement
interpretation TEXT Ja * - Feld interpretation
source VARCHAR(64) Ja * - Feld source
status VARCHAR(24) Ja * - Feld status
valid_until DATETIME Nein - Feld valid_until
contradictions JSONB Ja * - Feld contradictions
parameters JSONB Ja * - Feld parameters
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ consultant_cases.tenant_id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
CategoryAttributeBindings category_attribute_bindings RLS Aktiv
12 Cálculos y columnas

Tabelle category_attribute_bindings

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
category_id UUID Ja * FK ➔ product_categories.id Feld category_id
field_key VARCHAR(128) Ja * - Feld field_key
fieldset_group VARCHAR(64) Ja * - Feld fieldset_group
sequence INTEGER Ja * - Feld sequence
is_required BOOLEAN Ja * - Feld is_required
inherit_to_children BOOLEAN Ja * - Feld inherit_to_children
variant_role VARCHAR(48) Ja * - Feld variant_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
CategoryFieldsetActivations category_fieldset_activations RLS Aktiv
11 Cálculos y columnas

Tabelle category_fieldset_activations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
category_id UUID Ja * FK ➔ product_categories.id Feld category_id
revision_id UUID Ja * FK ➔ category_fieldset_revisions.id Feld revision_id
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ category_fieldset_revisions.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
CategoryFieldsetRevisions category_fieldset_revisions RLS Aktiv
17 Cálculos y columnas

Tabelle category_fieldset_revisions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
category_id UUID Ja * FK ➔ product_categories.id Feld category_id
version INTEGER Ja * - Feld version
status VARCHAR(16) Ja * - Feld status
snapshot JSONB Ja * - Feld snapshot
content_hash VARCHAR(64) Ja * - Feld content_hash
simulation_result JSONB Nein - Feld simulation_result
approved_by UUID Nein - Feld approved_by
approved_at DATETIME Nein - Feld approved_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
ConnectorBindings connector_bindings RLS Aktiv
20 Cálculos y columnas

Tabelle connector_bindings

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
connector_id UUID Ja * FK ➔ api_connectors.id Feld connector_id
direction VARCHAR(16) Ja * - Feld direction
signal_key VARCHAR(128) Ja * - Feld signal_key
operation_id UUID Nein FK ➔ connector_operations.id Feld operation_id
target_capability_key VARCHAR(128) Nein - Feld target_capability_key
inbound_endpoint_id UUID Nein FK ➔ inbound_webhook_endpoints.id Feld inbound_endpoint_id
field_mappings JSONB Ja * - Feld field_mappings
response_signal_key VARCHAR(128) Nein - Feld response_signal_key
inbound_schema JSONB Ja * - Feld inbound_schema
active BOOLEAN Ja * - Feld active
description VARCHAR(255) Nein - Feld description
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
ConnectorDeliveries connector_deliveries RLS Aktiv
21 Cálculos y columnas

Tabelle connector_deliveries

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
binding_id UUID Nein FK ➔ connector_bindings.id Feld binding_id
operation_id UUID Ja * FK ➔ connector_operations.id Feld operation_id
signal_key VARCHAR(128) Nein - Feld signal_key
request_payload JSONB Ja * - Feld request_payload
status VARCHAR(16) Ja * - Feld status
attempt_count INTEGER Ja * - Feld attempt_count
next_attempt_at DATETIME Nein - Feld next_attempt_at
last_error TEXT Nein - Feld last_error
response_status INTEGER Nein - Feld response_status
response_body TEXT Nein - Feld response_body
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
delivered_at DATETIME Nein - Feld delivered_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
ConnectorOperations connector_operations RLS Aktiv
22 Cálculos y columnas

Tabelle connector_operations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
connector_id UUID Ja * FK ➔ api_connectors.id Feld connector_id
operation_key VARCHAR(128) Ja * - Feld operation_key
method VARCHAR(8) Ja * - Feld method
path_template VARCHAR(1024) Ja * - Feld path_template
summary VARCHAR(512) Nein - Feld summary
parameters_schema JSONB Ja * - Feld parameters_schema
request_schema JSONB Ja * - Feld request_schema
response_schema JSONB Ja * - Feld response_schema
idempotency_header VARCHAR(128) Nein - Feld idempotency_header
timeout_seconds INTEGER Ja * - Feld timeout_seconds
risk_level VARCHAR(32) Ja * - Feld risk_level
selected BOOLEAN Ja * - Feld selected
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
ConsultantCases consultant_cases RLS Aktiv
21 Cálculos y columnas

Tabelle consultant_cases

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
mandate_id UUID Ja * FK ➔ consultant_mandates.id Feld mandate_id
title VARCHAR(255) Ja * - Feld title
trigger_kind VARCHAR(32) Ja * - Feld trigger_kind
status VARCHAR(24) Ja * - Feld status
priority INTEGER Ja * - Feld priority
domains JSONB Ja * - Feld domains
object_keys JSONB Ja * - Feld object_keys
process_keys JSONB Ja * - Feld process_keys
correlation_key VARCHAR(160) Ja * - Feld correlation_key
summary JSONB Ja * - Feld summary
baseline_plan_id UUID Nein FK ➔ consultant_plans.id Feld baseline_plan_id
closed_at DATETIME Nein - Feld closed_at
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ consultant_mandates.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
ConsultantEvidence consultant_evidence RLS Aktiv
10 Cálculos y columnas

Tabelle consultant_evidence

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
plan_id UUID Ja * FK ➔ consultant_plans.id Feld plan_id
kind VARCHAR(24) Ja * - Feld kind
content_hash VARCHAR(64) Ja * - Feld content_hash
summary JSONB Ja * - Feld summary
actor_id UUID Nein - Feld actor_id
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ consultant_plans.tenant_id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
ConsultantMandates consultant_mandates RLS Aktiv
20 Cálculos y columnas

Tabelle consultant_mandates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
label VARCHAR(255) Ja * - Feld label
autonomy_level VARCHAR(24) Ja * - Feld autonomy_level
domain_scope JSONB Ja * - Feld domain_scope
observation_sources JSONB Ja * - Feld observation_sources
owner_user_id UUID Ja * - Feld owner_user_id
version INTEGER Ja * - Feld version
rate_limit_per_day INTEGER Ja * - Feld rate_limit_per_day
privacy_bounds JSONB Ja * - Feld privacy_bounds
revoked_at DATETIME Nein - Feld revoked_at
revoked_by UUID Nein - Feld revoked_by
revoke_reason TEXT Nein - Feld revoke_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
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
ConsultantObservations consultant_observations RLS Aktiv
12 Cálculos y columnas

Tabelle consultant_observations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
case_id UUID Ja * FK ➔ consultant_cases.id Feld case_id
source_kind VARCHAR(48) Ja * - Feld source_kind
source_ref VARCHAR(160) Nein - Feld source_ref
confidence VARCHAR(16) Ja * - Feld confidence
content_hash VARCHAR(64) Ja * - Feld content_hash
access_label VARCHAR(64) Ja * - Feld access_label
payload JSONB Ja * - Feld payload
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
ConsultantPlans consultant_plans RLS Aktiv
18 Cálculos y columnas

Tabelle consultant_plans

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
kind VARCHAR(32) Ja * - Feld kind
version INTEGER Ja * - Feld version
industry_key VARCHAR(64) Ja * - Feld industry_key
status VARCHAR(16) Ja * - Feld status
proposal_hash VARCHAR(64) Ja * - Feld proposal_hash
snapshot JSONB Ja * - Feld snapshot
simulated_at DATETIME Nein - Feld simulated_at
approved_at DATETIME Nein - Feld approved_at
approved_by UUID Nein - Feld approved_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
ConsultantSteps consultant_steps RLS Aktiv
13 Cálculos y columnas

Tabelle consultant_steps

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
plan_id UUID Ja * FK ➔ consultant_plans.id Feld plan_id
sequence INTEGER Ja * - Feld sequence
key VARCHAR(96) Ja * - Feld key
label VARCHAR(255) Ja * - Feld label
state VARCHAR(24) Ja * - Feld state
source VARCHAR(255) Ja * - Feld source
description TEXT Nein - Feld description
approval_required BOOLEAN Ja * - Feld approval_required
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
Contacts contacts RLS Aktiv
24 Cálculos y columnas

Tabelle contacts

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
customer_id UUID Nein FK ➔ customers.id Feld customer_id
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
parent_contact_id UUID Nein FK ➔ contacts.id Feld parent_contact_id
first_name VARCHAR(128) Nein - Feld first_name
last_name VARCHAR(128) Nein - Feld last_name
email VARCHAR(320) Nein - Feld email
phone VARCHAR(64) Nein - Feld phone
mobile VARCHAR(64) Nein - Feld mobile
fax VARCHAR(64) Nein - Feld fax
role VARCHAR(128) Nein - Feld role
department VARCHAR(128) Nein - Feld department
job_title VARCHAR(128) Nein - Feld job_title
is_primary BOOLEAN Ja * - Feld is_primary
birthday DATE Nein - Feld birthday
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
CostCenters cost_centers RLS Aktiv
17 Cálculos y columnas

Tabelle cost_centers

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(64) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
active BOOLEAN Ja * - Feld active
kind VARCHAR(12) Ja * - Feld kind
sort_order INTEGER Ja * - Feld sort_order
surcharge_base VARCHAR(16) Nein - Feld surcharge_base
normal_surcharge_percent NUMERIC(8, 2) Nein - Feld normal_surcharge_percent
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
CostEntries cost_entries RLS Aktiv
22 Cálculos y columnas

Tabelle cost_entries

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
project_id UUID Nein FK ➔ projects.id Feld project_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
cost_type_id UUID Nein FK ➔ cost_types.id Feld cost_type_id
cost_center_id UUID Nein FK ➔ cost_centers.id Feld cost_center_id
source_type VARCHAR(32) Ja * - Feld source_type
source_id UUID Nein - Feld source_id
quantity NUMERIC(14, 4) Nein - Feld quantity
unit VARCHAR(16) Nein - Feld unit
unit_cost NUMERIC(14, 2) Nein - Feld unit_cost
amount NUMERIC(14, 2) Ja * - Feld amount
currency VARCHAR(3) Ja * - Feld currency
occurred_at DATETIME Ja * - Feld occurred_at
estimated BOOLEAN Ja * - Feld estimated
description TEXT Ja * - Feld description
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
metadata JSONB Ja * - Feld metadata
CostTypes cost_types RLS Aktiv
15 Cálculos y columnas

Tabelle cost_types

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(64) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
active BOOLEAN Ja * - Feld active
account_code VARCHAR(32) Nein - Feld account_code
default_cost_center_id UUID Nein FK ➔ cost_centers.id Feld default_cost_center_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
CustomizationChangeSets customization_change_sets RLS Aktiv
22 Cálculos y columnas

Tabelle customization_change_sets

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
case_id UUID Ja * FK ➔ consultant_cases.id Feld case_id
version INTEGER Ja * - Feld version
status VARCHAR(24) Ja * - Feld status
intent_key VARCHAR(96) Ja * - Feld intent_key
content_hash VARCHAR(64) Ja * - Feld content_hash
risk_class VARCHAR(16) Ja * - Feld risk_class
target_state JSONB Ja * - Feld target_state
baseline_hashes JSONB Ja * - Feld baseline_hashes
capability_hashes JSONB Ja * - Feld capability_hashes
dependencies JSONB Ja * - Feld dependencies
gaps JSONB Ja * - Feld gaps
activation_plan JSONB Ja * - Feld activation_plan
rollback_plan JSONB Ja * - Feld rollback_plan
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
CustomizationEvidence customization_evidence RLS Aktiv
10 Cálculos y columnas

Tabelle customization_evidence

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
change_set_id UUID Ja * FK ➔ customization_change_sets.id Feld change_set_id
kind VARCHAR(24) Ja * - Feld kind
content_hash VARCHAR(64) Ja * - Feld content_hash
summary JSONB Ja * - Feld summary
actor_id UUID Nein - Feld actor_id
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ customization_change_sets.tenant_id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
CustomizationSteps customization_steps RLS Aktiv
14 Cálculos y columnas

Tabelle customization_steps

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
change_set_id UUID Ja * FK ➔ customization_change_sets.id Feld change_set_id
sequence INTEGER Ja * - Feld sequence
key VARCHAR(96) Ja * - Feld key
label VARCHAR(255) Ja * - Feld label
kind VARCHAR(32) Ja * - Feld kind
state VARCHAR(24) Ja * - Feld state
content_hash VARCHAR(64) Ja * - Feld content_hash
approval_required BOOLEAN Ja * - Feld approval_required
payload JSONB Ja * - Feld payload
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
Demands demands RLS Aktiv
23 Cálculos y columnas

Tabelle demands

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
demand_type VARCHAR(48) Ja * - Feld demand_type
status VARCHAR(48) Ja * - Feld status
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
project_id UUID Nein - Feld project_id
work_order_id UUID Nein - Feld work_order_id
product_id UUID Nein - Feld product_id
quantity NUMERIC(14, 4) Nein - Feld quantity
unit VARCHAR(16) Nein - Feld unit
location VARCHAR(255) Nein - Feld location
required_from DATE Nein - Feld required_from
required_until DATE Nein - Feld required_until
budget NUMERIC(14, 2) Nein - Feld budget
visibility VARCHAR(16) Ja * - Feld visibility
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
DomainEvents domain_events RLS Aktiv
18 Cálculos y columnas

Tabelle domain_events

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
event_type VARCHAR(64) Ja * - Feld event_type
entity_type VARCHAR(64) Ja * - Feld entity_type
entity_id UUID Nein - Feld entity_id
payload JSONB Ja * - Feld payload
actor_type VARCHAR(16) Ja * - Feld actor_type
actor_id UUID Nein - Feld actor_id
occurred_at DATETIME Ja * - Feld occurred_at
correlation_id UUID Nein - Feld correlation_id
causation_id UUID Nein - Feld causation_id
workflow_origin_run_id UUID Nein FK ➔ workflow_runs.id Feld workflow_origin_run_id
published_at DATETIME Nein - Feld published_at
dispatch_attempts INTEGER Ja * - Feld dispatch_attempts
next_dispatch_at DATETIME Ja * - Feld next_dispatch_at
dead_letter_at DATETIME Nein - Feld dead_letter_at
last_dispatch_error_code VARCHAR(120) Nein - Feld last_dispatch_error_code
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ workflow_runs.tenant_id Feld tenant_id
EcommerceChannels ecommerce_channels RLS Aktiv
22 Cálculos y columnas

Tabelle ecommerce_channels

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(120) Ja * - Feld name
slug VARCHAR(64) Ja * - Feld slug
platform VARCHAR(32) Ja * - Feld platform
api_url VARCHAR(255) Nein - Feld api_url
credentials_encrypted TEXT Ja * - Feld credentials_encrypted
is_active BOOLEAN Ja * - Feld is_active
sync_inventory BOOLEAN Ja * - Feld sync_inventory
auto_create_order BOOLEAN Ja * - Feld auto_create_order
settings JSONB Ja * - Feld settings
last_sync_at DATETIME Nein - Feld last_sync_at
last_sync_status VARCHAR(32) Nein - Feld last_sync_status
last_error VARCHAR(500) Nein - Feld last_error
api_connector_id UUID Nein FK ➔ api_connectors.id Feld api_connector_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
EcommerceOrderSyncs ecommerce_order_syncs RLS Aktiv
21 Cálculos y columnas

Tabelle ecommerce_order_syncs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
channel_id UUID Ja * FK ➔ ecommerce_channels.id Feld channel_id
external_order_id VARCHAR(128) Ja * - Feld external_order_id
idempotency_hash VARCHAR(64) Ja * - Feld idempotency_hash
webhook_delivery_id VARCHAR(128) Nein - Feld webhook_delivery_id
sync_status VARCHAR(32) Ja * - Feld sync_status
quote_id UUID Nein FK ➔ quotes.id Feld quote_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
order_amount NUMERIC(14, 2) Nein - Feld order_amount
order_currency VARCHAR(3) Ja * - Feld order_currency
payload_snapshot JSONB Ja * - Feld payload_snapshot
error_message VARCHAR(500) Nein - Feld error_message
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
ExchangeRates exchange_rates RLS Aktiv
13 Cálculos y columnas

Tabelle exchange_rates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
currency VARCHAR(3) Ja * - Feld currency
rate_date DATE Ja * - Feld rate_date
rate NUMERIC(18, 8) Ja * - Feld rate
note VARCHAR(255) Nein - Feld note
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
ExportBatches export_batches RLS Aktiv
24 Cálculos y columnas

Tabelle export_batches

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
profile_id UUID Nein FK ➔ export_profiles.id Feld profile_id
period_from DATE Nein - Feld period_from
period_to DATE Nein - Feld period_to
status VARCHAR(48) Ja * - Feld status
artifact_storage_key VARCHAR(1024) Nein - Feld artifact_storage_key
artifact_filename VARCHAR(512) Nein - Feld artifact_filename
artifact_size_bytes INTEGER Nein - Feld artifact_size_bytes
artifact_mime_type VARCHAR(128) Nein - Feld artifact_mime_type
item_count INTEGER Ja * - Feld item_count
net_total NUMERIC Ja * - Feld net_total
tax_total NUMERIC Ja * - Feld tax_total
gross_total NUMERIC Ja * - Feld gross_total
exported_at DATETIME Nein - Feld exported_at
error_message TEXT Nein - Feld error_message
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
ExportItems export_items RLS Aktiv
11 Cálculos y columnas

Tabelle export_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
export_batch_id UUID Ja * FK ➔ export_batches.id Feld export_batch_id
accounting_entry_id UUID Ja * FK ➔ accounting_entries.id Feld accounting_entry_id
document_id UUID Nein FK ➔ documents.id Feld document_id
status VARCHAR(48) Ja * - Feld status
row_data JSONB Nein - Feld row_data
error_message TEXT Nein - Feld error_message
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
ExportProfiles export_profiles RLS Aktiv
13 Cálculos y columnas

Tabelle export_profiles

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(128) Ja * - Feld name
target VARCHAR(48) Ja * - Feld target
settings JSONB Ja * - Feld settings
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
ExtraWorkCandidates extra_work_candidates RLS Aktiv
21 Cálculos y columnas

Tabelle extra_work_candidates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
project_id UUID Nein FK ➔ projects.id Feld project_id
quote_id UUID Nein FK ➔ quotes.id Feld quote_id
description TEXT Ja * - Feld description
evidence TEXT Nein - Feld evidence
estimated_quantity NUMERIC(14, 4) Nein - Feld estimated_quantity
unit VARCHAR(16) Nein - Feld unit
estimated_price NUMERIC(14, 2) Nein - Feld estimated_price
currency VARCHAR(3) Ja * - Feld currency
status VARCHAR(48) Ja * - Feld status
confidence NUMERIC(4, 3) Nein - Feld confidence
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
FieldActivities field_activities RLS Aktiv
18 Cálculos y columnas

Tabelle field_activities

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
asset_id UUID Ja * FK ➔ assets.id Feld asset_id
activity_date DATE Ja * - Feld activity_date
activity_type VARCHAR(48) Ja * - Feld activity_type
crop VARCHAR(128) Nein - Feld crop
product_name VARCHAR(255) Nein - Feld product_name
product_quantity NUMERIC(14, 4) Nein - Feld product_quantity
product_unit VARCHAR(32) Nein - Feld product_unit
area_treated_ha NUMERIC(14, 4) Nein - Feld area_treated_ha
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
GaebDocuments gaeb_documents RLS Aktiv
21 Cálculos y columnas

Tabelle gaeb_documents

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
project_id UUID Nein FK ➔ projects.id Feld project_id
quote_id UUID Nein FK ➔ quotes.id Feld quote_id
file_name VARCHAR(255) Ja * - Feld file_name
gaeb_phase VARCHAR(10) Ja * - Feld gaeb_phase
gaeb_version VARCHAR(20) Ja * - Feld gaeb_version
project_name VARCHAR(255) Ja * - Feld project_name
dp_number VARCHAR(128) Nein - Feld dp_number
currency VARCHAR(3) Ja * - Feld currency
total_net_amount NUMERIC(14, 2) Ja * - Feld total_net_amount
total_tax_amount NUMERIC(14, 2) Ja * - Feld total_tax_amount
total_gross_amount NUMERIC(14, 2) Ja * - Feld total_gross_amount
xml_payload_raw TEXT Ja * - Feld xml_payload_raw
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
GaebItems gaeb_items RLS Aktiv
23 Cálculos y columnas

Tabelle gaeb_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
document_id UUID Ja * FK ➔ gaeb_documents.id Feld document_id
section_id UUID Ja * FK ➔ gaeb_sections.id Feld section_id
oz VARCHAR(32) Ja * - Feld oz
item_type VARCHAR(32) Ja * - Feld item_type
short_text VARCHAR(500) Ja * - Feld short_text
long_text TEXT Nein - Feld long_text
quantity NUMERIC(12, 3) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
unit_price NUMERIC(14, 2) Ja * - Feld unit_price
total_price NUMERIC(14, 2) Ja * - Feld total_price
vat_rate NUMERIC(5, 2) Nein - Feld vat_rate
is_discountable BOOLEAN Ja * - Feld is_discountable
internal_product_id UUID Nein FK ➔ products.id Feld internal_product_id
match_confidence NUMERIC(3, 2) Nein - Feld match_confidence
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
GaebSections gaeb_sections RLS Aktiv
16 Cálculos y columnas

Tabelle gaeb_sections

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
document_id UUID Ja * FK ➔ gaeb_documents.id Feld document_id
parent_section_id UUID Nein FK ➔ gaeb_sections.id Feld parent_section_id
order_index INTEGER Ja * - Feld order_index
section_code VARCHAR(64) Ja * - Feld section_code
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
subtotal_net NUMERIC(14, 2) Ja * - Feld subtotal_net
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
GlobalCostCenters global_cost_centers
8 Cálculos y columnas

Tabelle global_cost_centers

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(64) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
active BOOLEAN Ja * - Feld active
sort_order INTEGER Ja * - Feld sort_order
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
GlobalCostTypes global_cost_types
9 Cálculos y columnas

Tabelle global_cost_types

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(64) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
active BOOLEAN Ja * - Feld active
suggested_account_code VARCHAR(32) Nein - Feld suggested_account_code
sort_order INTEGER Ja * - Feld sort_order
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
GoodsReceiptItems goods_receipt_items RLS Aktiv
25 Cálculos y columnas

Tabelle goods_receipt_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
goods_receipt_id UUID Ja * FK ➔ goods_receipts.id Feld goods_receipt_id
purchase_item_id UUID Nein FK ➔ purchase_items.id Feld purchase_item_id
product_id UUID Nein FK ➔ products.id Feld product_id
description TEXT Ja * - Feld description
quantity_received NUMERIC(14, 4) Ja * - Feld quantity_received
unit VARCHAR(16) Ja * - Feld unit
unit_cost NUMERIC(14, 2) Ja * - Feld unit_cost
tax_rate NUMERIC(6, 4) Ja * - Feld tax_rate
net_amount NUMERIC(14, 2) Ja * - Feld net_amount
tax_amount NUMERIC(14, 2) Ja * - Feld tax_amount
gross_amount NUMERIC(14, 2) Ja * - Feld gross_amount
project_id UUID Nein FK ➔ projects.id Feld project_id
quantity_accepted NUMERIC(14, 4) Nein - Feld quantity_accepted
quantity_rejected NUMERIC(14, 4) Ja * - Feld quantity_rejected
rejection_reason TEXT Nein - Feld rejection_reason
stock_owner VARCHAR(32) Ja * - Feld stock_owner
consignment_contract_id UUID Nein FK ➔ contracts.id Feld consignment_contract_id
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_id
tracking_entries JSONB Ja * - Feld tracking_entries
confidence NUMERIC(4, 3) Nein - Feld confidence
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
GoodsReceipts goods_receipts RLS Aktiv
30 Cálculos y columnas

Tabelle goods_receipts

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
receipt_number VARCHAR(32) Ja * - Feld receipt_number
purchase_id UUID Nein FK ➔ purchases.id Feld purchase_id
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
invoice_id UUID Nein FK ➔ invoices.id Feld invoice_id
received_at DATETIME Ja * - Feld received_at
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_id
delivery_note_number VARCHAR(128) Nein - Feld delivery_note_number
delivery_note_date DATE Nein - Feld delivery_note_date
carrier VARCHAR(128) Nein - Feld carrier
tracking_number VARCHAR(128) Nein - Feld tracking_number
customer_id UUID Nein FK ➔ customers.id Feld customer_id
contract_id UUID Nein FK ➔ contracts.id Feld contract_id
procurement_type VARCHAR(32) Ja * - Feld procurement_type
inspection_status VARCHAR(32) Ja * - Feld inspection_status
currency VARCHAR(3) Ja * - Feld currency
net_amount NUMERIC(14, 2) Ja * - Feld net_amount
tax_amount NUMERIC(14, 2) Ja * - Feld tax_amount
gross_amount NUMERIC(14, 2) Ja * - Feld gross_amount
status VARCHAR(48) Ja * - Feld status
notes TEXT Nein - Feld notes
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
ImportBatchRecords import_batch_records RLS Aktiv
11 Cálculos y columnas

Tabelle import_batch_records

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
job_id UUID Ja * FK ➔ import_jobs.id Feld job_id
batch_id UUID Ja * - Feld batch_id
entity_type VARCHAR(64) Ja * - Feld entity_type
entity_id UUID Ja * - Feld entity_id
action VARCHAR(16) Ja * - Feld action
snapshot_before JSONB Nein - Feld snapshot_before
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
ImportJobs import_jobs RLS Aktiv
27 Cálculos y columnas

Tabelle import_jobs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
target_entity VARCHAR(64) Ja * - Feld target_entity
source_type VARCHAR(32) Ja * - Feld source_type
filename VARCHAR(255) Ja * - Feld filename
file_hash VARCHAR(64) Ja * - Feld file_hash
status VARCHAR(32) Ja * - Feld status
total_rows INTEGER Ja * - Feld total_rows
valid_rows INTEGER Ja * - Feld valid_rows
error_rows INTEGER Ja * - Feld error_rows
created_count INTEGER Ja * - Feld created_count
updated_count INTEGER Ja * - Feld updated_count
batch_id UUID Ja * - Feld batch_id
field_mapping JSONB Ja * - Feld field_mapping
dry_run_summary JSONB Ja * - Feld dry_run_summary
error_details JSONB Ja * - Feld error_details
raw_data_storage JSONB Ja * - Feld raw_data_storage
profile_id UUID Nein FK ➔ import_profiles.id Feld profile_id
applied_by_user_id UUID Nein - Feld applied_by_user_id
applied_at DATETIME Nein - Feld applied_at
rolled_back_at DATETIME Nein - Feld rolled_back_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_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
ImportProfiles import_profiles RLS Aktiv
14 Cálculos y columnas

Tabelle import_profiles

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(120) Ja * - Feld name
target_entity VARCHAR(64) Ja * - Feld target_entity
source_type VARCHAR(32) Ja * - Feld source_type
field_mapping JSONB Ja * - Feld field_mapping
transformation_rules JSONB Ja * - Feld transformation_rules
is_default BOOLEAN Ja * - Feld is_default
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_id UUID Nein - Feld source_id
metadata JSONB Ja * - Feld metadata
InboundWebhookEndpoints inbound_webhook_endpoints RLS Aktiv
15 Cálculos y columnas

Tabelle inbound_webhook_endpoints

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
token VARCHAR(64) Ja * - Feld token
secret_encrypted TEXT Nein - Feld secret_encrypted
emits_signal_key VARCHAR(128) Ja * - Feld emits_signal_key
active BOOLEAN Ja * - Feld active
description VARCHAR(255) Nein - Feld description
created_by UUID Nein - Feld created_by
last_received_at DATETIME Nein - Feld last_received_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
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
InboundWebhookReceipts inbound_webhook_receipts RLS Aktiv
14 Cálculos y columnas

Tabelle inbound_webhook_receipts

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
endpoint_id UUID Ja * FK ➔ inbound_webhook_endpoints.id Feld endpoint_id
received_at DATETIME Ja * - Feld received_at
raw_payload JSONB Ja * - Feld raw_payload
signature_valid BOOLEAN Nein - Feld signature_valid
emitted_signal BOOLEAN Ja * - Feld emitted_signal
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
InsurancePolicies insurance_policies RLS Aktiv
22 Cálculos y columnas

Tabelle insurance_policies

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
policy_number VARCHAR(64) Ja * - Feld policy_number
insurer VARCHAR(255) Ja * - Feld insurer
coverage_type VARCHAR(64) Ja * - Feld coverage_type
coverage_desc TEXT Nein - Feld coverage_desc
valid_from DATE Nein - Feld valid_from
valid_until DATE Nein - Feld valid_until
premium_amount NUMERIC(14, 2) Nein - Feld premium_amount
deductible NUMERIC(14, 2) Nein - Feld deductible
asset_id UUID Nein FK ➔ assets.id Feld asset_id
vehicle_id UUID Nein FK ➔ fleet_vehicles.id Feld vehicle_id
status VARCHAR(16) Ja * - Feld status
reminder_days INTEGER Ja * - Feld reminder_days
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
Jobs jobs RLS Aktiv
17 Cálculos y columnas

Tabelle jobs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
job_type VARCHAR(64) Ja * - Feld job_type
payload JSONB Ja * - Feld payload
status VARCHAR(48) Ja * - Feld status
run_after DATETIME Ja * - Feld run_after
attempts INTEGER Ja * - Feld attempts
max_attempts INTEGER Ja * - Feld max_attempts
locked_at DATETIME Nein - Feld locked_at
locked_by VARCHAR(64) Nein - Feld locked_by
finished_at DATETIME Nein - Feld finished_at
last_error TEXT Nein - Feld last_error
source_event_id UUID Nein FK ➔ domain_events.id Feld source_event_id
correlation_id UUID Nein - Feld correlation_id
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
JournalEntries journal_entries RLS Aktiv
18 Cálculos y columnas

Tabelle journal_entries

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
journal_id UUID Ja * FK ➔ journals.id Feld journal_id
entry_number VARCHAR(64) Ja * - Feld entry_number
entry_date DATE Ja * - Feld entry_date
reference VARCHAR(128) Nein - Feld reference
description TEXT Nein - Feld description
source_type VARCHAR(32) Nein - Feld source_type
source_id UUID Nein - Feld source_id
status VARCHAR(48) Ja * - Feld status
posted_at DATETIME Nein - Feld posted_at
total_debit NUMERIC(14, 2) Ja * - Feld total_debit
total_credit NUMERIC(14, 2) Ja * - Feld total_credit
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
metadata JSONB Ja * - Feld metadata
JournalEntryLines journal_entry_lines RLS Aktiv
15 Cálculos y columnas

Tabelle journal_entry_lines

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
journal_entry_id UUID Ja * FK ➔ journal_entries.id Feld journal_entry_id
account_code VARCHAR(32) Ja * - Feld account_code
debit NUMERIC(14, 2) Ja * - Feld debit
credit NUMERIC(14, 2) Ja * - Feld credit
description VARCHAR(255) Nein - Feld description
customer_id UUID Nein FK ➔ customers.id Feld customer_id
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
cost_center_id UUID Nein FK ➔ cost_centers.id Feld cost_center_id
project_id UUID Nein FK ➔ projects.id Feld project_id
internal_order_id UUID Nein FK ➔ controlling_internal_orders.id Feld internal_order_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
metadata JSONB Ja * - Feld metadata
Journals journals RLS Aktiv
15 Cálculos y columnas

Tabelle journals

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(16) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
journal_type VARCHAR(48) Ja * - Feld journal_type
default_debit_account_code VARCHAR(32) Nein - Feld default_debit_account_code
default_credit_account_code VARCHAR(32) Nein - Feld default_credit_account_code
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
Kn8ReferenceCodes kn8_reference_codes
5 Cálculos y columnas

Tabelle kn8_reference_codes

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
version_id UUID Ja * FK ➔ kn8_reference_versions.id Feld version_id
code VARCHAR(8) Ja * - Feld code
description TEXT Ja * - Feld description
search_text TEXT Ja * - Feld search_text
id UUID Nein PK Feld id
Kn8ReferenceVersions kn8_reference_versions
8 Cálculos y columnas

Tabelle kn8_reference_versions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
version VARCHAR(30) Ja * - Feld version
source_url VARCHAR(500) Ja * - Feld source_url
source_sha256 VARCHAR(64) Ja * - Feld source_sha256
effective_from DATE Ja * - Feld effective_from
imported_by UUID Ja * FK ➔ users.id Feld imported_by
is_active BOOLEAN Ja * - Feld is_active
created_at DATETIME Ja * - Feld created_at
id UUID Nein PK Feld id
LabelTemplates label_templates RLS Aktiv
17 Cálculos y columnas

Tabelle label_templates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(64) Ja * - Feld code
name VARCHAR(256) Ja * - Feld name
target_type VARCHAR(32) Ja * - Feld target_type
output_format VARCHAR(16) Ja * - Feld output_format
width_mm INTEGER Ja * - Feld width_mm
height_mm INTEGER Ja * - Feld height_mm
template_body TEXT Ja * - Feld template_body
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
LandedCostAllocations landed_cost_allocations RLS Aktiv
12 Cálculos y columnas

Tabelle landed_cost_allocations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
landed_cost_id UUID Ja * FK ➔ landed_costs.id Feld landed_cost_id
receipt_item_id UUID Ja * FK ➔ goods_receipt_items.id Feld receipt_item_id
allocated_amount NUMERIC(14, 2) Ja * - Feld allocated_amount
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
LandedCosts landed_costs RLS Aktiv
18 Cálculos y columnas

Tabelle landed_costs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
label VARCHAR(128) Ja * - Feld label
goods_receipt_id UUID Ja * FK ➔ goods_receipts.id Feld goods_receipt_id
amount NUMERIC(14, 2) Ja * - Feld amount
currency VARCHAR(3) Ja * - Feld currency
allocation_method VARCHAR(16) Ja * - Feld allocation_method
status VARCHAR(16) Ja * - Feld status
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
posted_at DATETIME Nein - Feld posted_at
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
LearnedRules learned_rules RLS Aktiv
19 Cálculos y columnas

Tabelle learned_rules

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
type VARCHAR(64) Ja * - Feld type
condition JSONB Ja * - Feld condition
action JSONB Ja * - Feld action
confidence NUMERIC(4, 3) Ja * - Feld confidence
source VARCHAR(48) Ja * - Feld source
confirmed_by_user BOOLEAN Ja * - Feld confirmed_by_user
hit_count INTEGER Ja * - Feld hit_count
last_applied_at DATETIME Nein - Feld last_applied_at
active BOOLEAN Ja * - Feld active
condition_fingerprint VARCHAR(64) Ja * - Feld condition_fingerprint
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
LocationEndCustomerAliases location_end_customer_aliases RLS Aktiv
14 Cálculos y columnas

Tabelle location_end_customer_aliases

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
location_id UUID Ja * FK ➔ locations.id Feld location_id
end_customer_id UUID Ja * FK ➔ customers.id Feld end_customer_id
alias_number INTEGER Ja * - Feld alias_number
wave_key VARCHAR(64) Ja * - Feld wave_key
released_at DATETIME Nein - Feld released_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
Locations locations RLS Aktiv
27 Cálculos y columnas

Tabelle locations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
code VARCHAR(32) Nein - Feld code
barcode VARCHAR(64) Nein - Feld barcode
type VARCHAR(48) Ja * - Feld type
hierarchy_level VARCHAR(16) Nein - Feld hierarchy_level
storage_mode VARCHAR(8) Ja * - Feld storage_mode
pick_sequence INTEGER Nein - Feld pick_sequence
removal_strategy VARCHAR(8) Nein - Feld removal_strategy
storage_category_id UUID Nein - Feld storage_category_id
parent_location_id UUID Nein FK ➔ locations.id Feld parent_location_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
project_id UUID Nein FK ➔ projects.id Feld project_id
user_id UUID Nein FK ➔ users.id Feld user_id
street VARCHAR(255) Nein - Feld street
postal_code VARCHAR(16) Nein - Feld postal_code
city VARCHAR(128) Nein - Feld city
country_code VARCHAR(2) Nein - Feld country_code
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
MailboxAccounts mailbox_accounts RLS Aktiv
48 Cálculos y columnas

Tabelle mailbox_accounts

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(128) Ja * - Feld name
email_address VARCHAR(320) Ja * - Feld email_address
provider_type VARCHAR(32) Ja * - Feld provider_type
organization_user_id UUID Nein FK ➔ organization_users.id Feld organization_user_id
access_org_user_ids JSONB Nein - Feld access_org_user_ids
imap_host VARCHAR(255) Nein - Feld imap_host
imap_port INTEGER Ja * - Feld imap_port
imap_security VARCHAR(16) Ja * - Feld imap_security
imap_username VARCHAR(320) Nein - Feld imap_username
encrypted_password TEXT Nein - Feld encrypted_password
sync_folder VARCHAR(128) Ja * - Feld sync_folder
last_sync_at DATETIME Nein - Feld last_sync_at
last_uid INTEGER Ja * - Feld last_uid
sync_interval_minutes INTEGER Ja * - Feld sync_interval_minutes
smtp_host VARCHAR(255) Nein - Feld smtp_host
smtp_port INTEGER Ja * - Feld smtp_port
smtp_security VARCHAR(16) Ja * - Feld smtp_security
smtp_username VARCHAR(320) Nein - Feld smtp_username
encrypted_smtp_password TEXT Nein - Feld encrypted_smtp_password
from_name VARCHAR(128) Nein - Feld from_name
signature_text TEXT Nein - Feld signature_text
signature_html TEXT Nein - Feld signature_html
signature_image_document_id UUID Nein - Feld signature_image_document_id
signature_use_company_logo BOOLEAN Ja * - Feld signature_use_company_logo
inbox_processing BOOLEAN Ja * - Feld inbox_processing
oof_enabled BOOLEAN Ja * - Feld oof_enabled
oof_subject VARCHAR(512) Nein - Feld oof_subject
oof_body TEXT Nein - Feld oof_body
oof_from DATETIME Nein - Feld oof_from
oof_until DATETIME Nein - Feld oof_until
oof_once_days INTEGER Ja * - Feld oof_once_days
oauth_tenant_id VARCHAR(128) Nein - Feld oauth_tenant_id
client_id VARCHAR(128) Nein - Feld client_id
encrypted_refresh_token TEXT Nein - Feld encrypted_refresh_token
token_expiry DATETIME Nein - Feld token_expiry
is_active BOOLEAN Ja * - Feld is_active
connection_status VARCHAR(32) Ja * - Feld connection_status
last_error TEXT Nein - Feld last_error
last_successful_sync_at DATETIME Nein - Feld last_successful_sync_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
MailboxOofLog mailbox_oof_log RLS Aktiv
12 Cálculos y columnas

Tabelle mailbox_oof_log

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
mailbox_account_id UUID Ja * FK ➔ mailbox_accounts.id Feld mailbox_account_id
sender_email VARCHAR(320) Ja * - Feld sender_email
last_sent_at DATETIME Ja * - Feld last_sent_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
MailboxRules mailbox_rules RLS Aktiv
17 Cálculos y columnas

Tabelle mailbox_rules

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
mailbox_account_id UUID Ja * FK ➔ mailbox_accounts.id Feld mailbox_account_id
name VARCHAR(128) Ja * - Feld name
active BOOLEAN Ja * - Feld active
position INTEGER Ja * - Feld position
conditions JSONB Ja * - Feld conditions
actions JSONB Ja * - Feld actions
stop_processing BOOLEAN Ja * - Feld stop_processing
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
MailboxSignatures mailbox_signatures RLS Aktiv
21 Cálculos y columnas

Tabelle mailbox_signatures

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
mailbox_account_id UUID Nein FK ➔ mailbox_accounts.id Feld mailbox_account_id
organization_user_id UUID Nein FK ➔ organization_users.id Feld organization_user_id
name VARCHAR(128) Ja * - Feld name
body_text TEXT Nein - Feld body_text
body_html TEXT Nein - Feld body_html
use_company_logo BOOLEAN Ja * - Feld use_company_logo
inline_image_document_id UUID Nein - Feld inline_image_document_id
attachment_document_ids JSONB Ja * - Feld attachment_document_ids
is_default_new BOOLEAN Ja * - Feld is_default_new
is_default_reply BOOLEAN Ja * - Feld is_default_reply
position INTEGER Ja * - Feld position
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
NumberSequences number_sequences RLS Aktiv
24 Cálculos y columnas

Tabelle number_sequences

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
document_type VARCHAR(48) Ja * - Feld document_type
code VARCHAR(48) Ja * - Feld code
name VARCHAR(64) Ja * - Feld name
is_default BOOLEAN Ja * - Feld is_default
priority INTEGER Ja * - Feld priority
criteria JSONB Ja * - Feld criteria
prefix VARCHAR(16) Ja * - Feld prefix
suffix VARCHAR(16) Ja * - Feld suffix
pattern VARCHAR(64) Ja * - Feld pattern
padding INTEGER Ja * - Feld padding
start_value INTEGER Ja * - Feld start_value
next_value INTEGER Ja * - Feld next_value
reset_policy VARCHAR(48) Ja * - Feld reset_policy
period_key VARCHAR(16) Ja * - Feld period_key
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
OauthIdentities oauth_identities
7 Cálculos y columnas

Tabelle oauth_identities

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
user_id UUID Ja * FK ➔ users.id Feld user_id
provider VARCHAR(32) Ja * - Feld provider
provider_user_id VARCHAR(255) Ja * - Feld provider_user_id
email VARCHAR(320) Ja * - Feld email
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
OrgUnitMembers org_unit_members RLS Aktiv
12 Cálculos y columnas

Tabelle org_unit_members

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
unit_id UUID Ja * FK ➔ org_units.id Feld unit_id
user_id UUID Ja * FK ➔ users.id Feld user_id
is_lead BOOLEAN Ja * - Feld is_lead
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
OrgUnits org_units RLS Aktiv
17 Cálculos y columnas

Tabelle org_units

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Ja * - Feld code
name VARCHAR(120) Ja * - Feld name
kind VARCHAR(16) Ja * - Feld kind
parent_id UUID Nein FK ➔ org_units.id Feld parent_id
manager_user_id UUID Nein FK ➔ users.id Feld manager_user_id
description TEXT Nein - Feld description
sort_order INTEGER Ja * - Feld sort_order
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
OrganizationUsers organization_users RLS Aktiv
29 Cálculos y columnas

Tabelle organization_users

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
user_id UUID Ja * FK ➔ users.id Feld user_id
role VARCHAR(48) Ja * - Feld role
custom_role_id UUID Nein FK ➔ tenant_roles.id Feld custom_role_id
permissions JSONB Ja * - Feld permissions
is_owner BOOLEAN Ja * - Feld is_owner
is_active BOOLEAN Ja * - Feld is_active
employee_number VARCHAR(32) Nein - Feld employee_number
trade VARCHAR(128) Nein - Feld trade
hourly_rate NUMERIC(10, 2) Nein - Feld hourly_rate
hire_date DATE Nein - Feld hire_date
phone_mobile VARCHAR(64) Nein - Feld phone_mobile
emergency_contact VARCHAR(255) Nein - Feld emergency_contact
adr_certified BOOLEAN Ja * - Feld adr_certified
birth_date DATE Nein - Feld birth_date
sv_number VARCHAR(32) Nein - Feld sv_number
tax_id VARCHAR(16) Nein - Feld tax_id
religion VARCHAR(64) Nein - Feld religion
health_insurance VARCHAR(128) Nein - Feld health_insurance
iban VARCHAR(34) Nein - Feld iban
address VARCHAR(512) Nein - Feld address
employment_type VARCHAR(48) Nein - Feld employment_type
weekly_hours NUMERIC(5, 2) Nein - Feld weekly_hours
exit_date DATE Nein - Feld exit_date
work_permit_until DATE Nein - Feld work_permit_until
supervisor_id UUID Nein FK ➔ organization_users.id Feld supervisor_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
Organizations organizations
60 Cálculos y columnas

Tabelle organizations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
legal_name VARCHAR(255) Nein - Feld legal_name
slug VARCHAR(64) Ja * - Feld slug
country_code VARCHAR(2) Ja * - Feld country_code
currency VARCHAR(3) Ja * - Feld currency
timezone VARCHAR(64) Ja * - Feld timezone
locale VARCHAR(10) Ja * - Feld locale
vat_id VARCHAR(32) Nein - Feld vat_id
tax_id VARCHAR(32) Nein - Feld tax_id
street VARCHAR(255) Nein - Feld street
house_number VARCHAR(16) Nein - Feld house_number
postal_code VARCHAR(16) Nein - Feld postal_code
city VARCHAR(128) Nein - Feld city
state VARCHAR(64) Nein - Feld state
phone VARCHAR(64) Nein - Feld phone
fax VARCHAR(64) Nein - Feld fax
contact_email VARCHAR(320) Nein - Feld contact_email
website VARCHAR(255) Nein - Feld website
commercial_register VARCHAR(128) Nein - Feld commercial_register
commercial_register_number VARCHAR(64) Nein - Feld commercial_register_number
managing_director VARCHAR(255) Nein - Feld managing_director
business_type VARCHAR(128) Nein - Feld business_type
industry_key VARCHAR(64) Nein - Feld industry_key
enabled_modules JSONB Nein - Feld enabled_modules
locked_modules JSONB Nein - Feld locked_modules
allowed_workflows JSONB Nein - Feld allowed_workflows
platform_product_id UUID Nein FK ➔ platform_products.id Feld platform_product_id
iban VARCHAR(64) Nein - Feld iban
bic VARCHAR(16) Nein - Feld bic
bank_name VARCHAR(128) Nein - Feld bank_name
default_tax_rate NUMERIC(6, 4) Nein - Feld default_tax_rate
chart_of_accounts VARCHAR(48) Ja * - Feld chart_of_accounts
peppol_participant_id VARCHAR(64) Nein - Feld peppol_participant_id
peppol_endpoint_scheme VARCHAR(16) Nein - Feld peppol_endpoint_scheme
business_backend VARCHAR(48) Ja * - Feld business_backend
settings JSONB Ja * - Feld settings
agent_settings JSONB Ja * - Feld agent_settings
monthly_ai_budget NUMERIC(10, 2) Ja * - Feld monthly_ai_budget
monthly_agent_runs INTEGER Ja * - Feld monthly_agent_runs
monthly_document_pages INTEGER Ja * - Feld monthly_document_pages
ai_credit_balance NUMERIC(14, 2) Ja * - Feld ai_credit_balance
ai_region VARCHAR(16) Ja * - Feld ai_region
ai_provider_override VARCHAR(32) Nein - Feld ai_provider_override
plan VARCHAR(48) Ja * - Feld plan
billing_status VARCHAR(48) Ja * - Feld billing_status
plan_started_at DATETIME Nein - Feld plan_started_at
max_users INTEGER Nein - Feld max_users
storage_quota_bytes BIGINT Nein - Feld storage_quota_bytes
ai_documents_per_month INTEGER Nein - Feld ai_documents_per_month
purchased_storage_bytes BIGINT Ja * - Feld purchased_storage_bytes
subscription_storage_bytes BIGINT Ja * - Feld subscription_storage_bytes
stripe_customer_id VARCHAR(64) Nein - Feld stripe_customer_id
stripe_subscription_id VARCHAR(64) Nein - Feld stripe_subscription_id
payment_failed_at DATETIME Nein - Feld payment_failed_at
cancel_at_period_end BOOLEAN Ja * - Feld cancel_at_period_end
deleted_at DATETIME Nein - Feld deleted_at
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
PartnerShopRates partner_shop_rates RLS Aktiv
14 Cálculos y columnas

Tabelle partner_shop_rates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
partner_customer_id UUID Ja * FK ➔ customers.id Feld partner_customer_id
shop_supplier_id UUID Ja * FK ➔ suppliers.id Feld shop_supplier_id
adjustment_percent NUMERIC(8, 4) Ja * - Feld adjustment_percent
active BOOLEAN Ja * - Feld active
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
PeppolTransmissions peppol_transmissions RLS Aktiv
21 Cálculos y columnas

Tabelle peppol_transmissions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
invoice_id UUID Nein FK ➔ invoices.id Feld invoice_id
transmission_type VARCHAR(48) Ja * - Feld transmission_type
document_type VARCHAR(48) Ja * - Feld document_type
status VARCHAR(48) Ja * - Feld status
sender_participant_id VARCHAR(64) Ja * - Feld sender_participant_id
receiver_participant_id VARCHAR(64) Ja * - Feld receiver_participant_id
message_id VARCHAR(128) Ja * - Feld message_id
payload_xml TEXT Ja * - Feld payload_xml
peppol_response JSONB Ja * - Feld peppol_response
error_message TEXT Nein - Feld error_message
transmitted_at DATETIME Nein - Feld transmitted_at
delivered_at DATETIME Nein - Feld delivered_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
PlatformProducts platform_products
21 Cálculos y columnas

Tabelle platform_products

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
key VARCHAR(64) Ja * - Feld key
name VARCHAR(255) Ja * - Feld name
tagline VARCHAR(255) Nein - Feld tagline
description TEXT Nein - Feld description
audience VARCHAR(48) Ja * - Feld audience
status VARCHAR(48) Ja * - Feld status
module_keys JSONB Ja * - Feld module_keys
workflow_keys JSONB Ja * - Feld workflow_keys
agent_keys JSONB Ja * - Feld agent_keys
recommended_industry_keys JSONB Ja * - Feld recommended_industry_keys
ai_rationale TEXT Nein - Feld ai_rationale
ai_confidence NUMERIC(4, 3) Nein - Feld ai_confidence
highlights JSONB Ja * - Feld highlights
price_amount NUMERIC(14, 2) Nein - Feld price_amount
price_currency VARCHAR(3) Ja * - Feld price_currency
price_period VARCHAR(16) Ja * - Feld price_period
created_by UUID Nein - Feld created_by
published_at DATETIME Nein - Feld published_at
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
PlatformSettings platform_settings
6 Cálculos y columnas

Tabelle platform_settings

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
key VARCHAR(64) Ja * - Feld key
value_encrypted TEXT Ja * - Feld value_encrypted
updated_by UUID Nein - Feld updated_by
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
PlatformSubscriptionInvoices platform_subscription_invoices RLS Aktiv
14 Cálculos y columnas

Tabelle platform_subscription_invoices

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
stripe_subscription_id VARCHAR(64) Ja * - Feld stripe_subscription_id
stripe_invoice_id VARCHAR(64) Ja * - Feld stripe_invoice_id
plan VARCHAR(48) Ja * - Feld plan
period_start DATETIME Ja * - Feld period_start
period_end DATETIME Ja * - Feld period_end
amount_gross NUMERIC(14, 2) Ja * - Feld amount_gross
status VARCHAR(16) Ja * - Feld status
paid_at DATETIME Nein - Feld paid_at
operator_invoice_id UUID Nein FK ➔ invoices.id Feld operator_invoice_id
operator_invoice_document_id UUID Nein FK ➔ documents.id Feld operator_invoice_document_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
PricelistItems pricelist_items RLS Aktiv
22 Cálculos y columnas

Tabelle pricelist_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
pricelist_id UUID Ja * FK ➔ pricelists.id Feld pricelist_id
scope VARCHAR(16) Ja * - Feld scope
product_id UUID Nein FK ➔ products.id Feld product_id
category_id UUID Nein FK ➔ product_categories.id Feld category_id
min_quantity NUMERIC(14, 4) Ja * - Feld min_quantity
price_basis VARCHAR(16) Ja * - Feld price_basis
price NUMERIC(14, 2) Nein - Feld price
label VARCHAR(255) Nein - Feld label
discount_percent NUMERIC(5, 2) Nein - Feld discount_percent
surcharge NUMERIC(14, 2) Nein - Feld surcharge
min_margin_percent NUMERIC(5, 2) Nein - Feld min_margin_percent
max_margin_percent NUMERIC(5, 2) Nein - Feld max_margin_percent
agent_price NUMERIC(14, 2) Nein - Feld agent_price
agent_discount_percent NUMERIC(5, 2) Nein - Feld agent_discount_percent
agent_surcharge NUMERIC(14, 2) Nein - Feld agent_surcharge
valid_from DATE Nein - Feld valid_from
valid_until DATE Nein - Feld valid_until
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
Pricelists pricelists RLS Aktiv
16 Cálculos y columnas

Tabelle pricelists

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
currency VARCHAR(3) Ja * - Feld currency
parent_id UUID Nein FK ➔ pricelists.id Feld parent_id
valid_from DATE Nein - Feld valid_from
valid_until DATE Nein - Feld valid_until
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
PrintBridges print_bridges RLS Aktiv
19 Cálculos y columnas

Tabelle print_bridges

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
bridge_uid VARCHAR(64) Ja * - Feld bridge_uid
name VARCHAR(256) Ja * - Feld name
token_hash VARCHAR(64) Ja * - Feld token_hash
active BOOLEAN Ja * - Feld active
capabilities JSONB Ja * - Feld capabilities
discovered_printers JSONB Ja * - Feld discovered_printers
software_version VARCHAR(64) Nein - Feld software_version
hostname VARCHAR(256) Nein - Feld hostname
last_ip VARCHAR(64) Nein - Feld last_ip
last_seen_at DATETIME Nein - Feld last_seen_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
PrintJobs print_jobs RLS Aktiv
33 Cálculos y columnas

Tabelle print_jobs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
template_id UUID Nein FK ➔ label_templates.id Feld template_id
printer_id UUID Nein FK ➔ printers.id Feld printer_id
status VARCHAR(24) Ja * - Feld status
copies INTEGER Ja * - Feld copies
entity_type VARCHAR(32) Ja * - Feld entity_type
entity_id UUID Nein - Feld entity_id
operation_code VARCHAR(64) Nein - Feld operation_code
payload_snapshot JSONB Ja * - Feld payload_snapshot
output_format VARCHAR(16) Ja * - Feld output_format
rendered_content BLOB Nein - Feld rendered_content
content_type VARCHAR(128) Ja * - Feld content_type
error_message TEXT Nein - Feld error_message
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
content_checksum VARCHAR(64) Nein - Feld content_checksum
leased_by_bridge_id UUID Nein FK ➔ print_bridges.id Feld leased_by_bridge_id
lease_token_hash VARCHAR(64) Nein - Feld lease_token_hash
leased_until DATETIME Nein - Feld leased_until
attempt_count INTEGER Ja * - Feld attempt_count
next_retry_at DATETIME Nein - Feld next_retry_at
delivered_at DATETIME Nein - Feld delivered_at
acknowledged_at DATETIME Nein - Feld acknowledged_at
reprint_of_id UUID Nein FK ➔ print_jobs.id Feld reprint_of_id
reprint_reason TEXT Nein - Feld reprint_reason
printed_at DATETIME Nein - Feld printed_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
Printers printers RLS Aktiv
20 Cálculos y columnas

Tabelle printers

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(64) Ja * - Feld code
name VARCHAR(256) Ja * - Feld name
connection_type VARCHAR(16) Ja * - Feld connection_type
output_format VARCHAR(16) Ja * - Feld output_format
device_name VARCHAR(256) Nein - Feld device_name
bridge_id UUID Nein FK ➔ print_bridges.id Feld bridge_id
host VARCHAR(255) Nein - Feld host
port INTEGER Nein - Feld port
location_id UUID Nein FK ➔ locations.id Feld location_id
is_default BOOLEAN Ja * - Feld is_default
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
ProductAccessories product_accessories RLS Aktiv
12 Cálculos y columnas

Tabelle product_accessories

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
accessory_product_id UUID Ja * FK ➔ products.id Feld accessory_product_id
sequence INTEGER Ja * - Feld sequence
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
ProductAttributeValues product_attribute_values RLS Aktiv
15 Cálculos y columnas

Tabelle product_attribute_values

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
attribute_id UUID Ja * FK ➔ product_attributes.id Feld attribute_id
name VARCHAR(128) Ja * - Feld name
color_hex VARCHAR(7) Nein - Feld color_hex
default_price_extra NUMERIC(14, 2) Ja * - Feld default_price_extra
sequence INTEGER Ja * - Feld sequence
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
ProductAttributes product_attributes RLS Aktiv
13 Cálculos y columnas

Tabelle product_attributes

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(128) Ja * - Feld name
display_type VARCHAR(48) Ja * - Feld display_type
sequence INTEGER Ja * - Feld sequence
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
ProductBomCustomers product_bom_customers RLS Aktiv
7 Cálculos y columnas

Tabelle product_bom_customers

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
bom_id UUID Ja * FK ➔ product_boms.id Feld bom_id
customer_id UUID Ja * FK ➔ customers.id Feld customer_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
metadata JSONB Ja * - Feld metadata
ProductBomLines product_bom_lines RLS Aktiv
15 Cálculos y columnas

Tabelle product_bom_lines

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
bom_id UUID Ja * FK ➔ product_boms.id Feld bom_id
component_product_id UUID Ja * FK ➔ products.id Feld component_product_id
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
unit_cost NUMERIC(14, 2) Nein - Feld unit_cost
position INTEGER Ja * - Feld position
notes TEXT Nein - Feld notes
recovery_percent NUMERIC(6, 2) Nein - Feld recovery_percent
component_bom_id UUID Nein FK ➔ product_boms.id Feld component_bom_id
do_not_explode BOOLEAN Ja * - Feld do_not_explode
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
ProductBomSteps product_bom_steps RLS Aktiv
15 Cálculos y columnas

Tabelle product_bom_steps

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
bom_id UUID Ja * FK ➔ product_boms.id Feld bom_id
position INTEGER Ja * - Feld position
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
workstation_id UUID Nein FK ➔ workstations.id Feld workstation_id
estimated_minutes INTEGER Nein - Feld estimated_minutes
setup_minutes INTEGER Nein - Feld setup_minutes
image_url TEXT Nein - Feld image_url
image_urls JSONB Nein - Feld image_urls
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
metadata JSONB Ja * - Feld metadata
ProductBoms product_boms RLS Aktiv
27 Cálculos y columnas

Tabelle product_boms

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
name VARCHAR(255) Ja * - Feld name
code VARCHAR(64) Nein - Feld code
bom_type VARCHAR(48) Ja * - Feld bom_type
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
customer_id UUID Nein FK ➔ customers.id Feld customer_id
instructions TEXT Nein - Feld instructions
default_workstation_id UUID Nein FK ➔ workstations.id Feld default_workstation_id
is_default BOOLEAN Ja * - Feld is_default
picking_policy VARCHAR(32) Ja * - Feld picking_policy
estimated_minutes INTEGER Nein - Feld estimated_minutes
active BOOLEAN Ja * - Feld active
notes TEXT Nein - Feld notes
revision VARCHAR(32) Ja * - Feld revision
valid_from DATE Nein - Feld valid_from
valid_until DATE Nein - Feld valid_until
explode_components BOOLEAN Ja * - Feld explode_components
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
ProductCategoryTaxonomyBindings product_category_taxonomy_bindings RLS Aktiv
14 Cálculos y columnas

Tabelle product_category_taxonomy_bindings

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
standard_code VARCHAR(32) Ja * FK ➔ standard_categories.code Feld standard_code
category_id UUID Ja * FK ➔ product_categories.id Feld category_id
version INTEGER Ja * - Feld version
active BOOLEAN Ja * - Feld active
content_hash VARCHAR(64) Ja * - Feld content_hash
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ product_categories.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
ProductCompatibilities product_compatibilities RLS Aktiv
12 Cálculos y columnas

Tabelle product_compatibilities

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
part_product_id UUID Ja * FK ➔ products.id Feld part_product_id
equipment_product_id UUID Ja * FK ➔ products.id Feld equipment_product_id
notes VARCHAR(255) 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
ProductSupplierinfo product_supplierinfo RLS Aktiv
21 Cálculos y columnas

Tabelle product_supplierinfo

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
supplier_id UUID Ja * FK ➔ suppliers.id Feld supplier_id
vendor_product_name VARCHAR(255) Nein - Feld vendor_product_name
vendor_product_code VARCHAR(64) Nein - Feld vendor_product_code
sequence INTEGER Ja * - Feld sequence
min_qty NUMERIC(14, 4) Ja * - Feld min_qty
price NUMERIC(14, 2) Nein - Feld price
currency VARCHAR(3) Ja * - Feld currency
delay INTEGER Ja * - Feld delay
is_preferred BOOLEAN Ja * - Feld is_preferred
date_start DATE Nein - Feld date_start
date_end DATE Nein - Feld date_end
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
ProductVariantValues product_variant_values RLS Aktiv
8 Cálculos y columnas

Tabelle product_variant_values

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
value_id UUID Ja * FK ➔ product_attribute_values.id Feld value_id
price_extra NUMERIC(14, 2) Ja * - Feld price_extra
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
PurchaseItems purchase_items RLS Aktiv
25 Cálculos y columnas

Tabelle purchase_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
purchase_id UUID Ja * FK ➔ purchases.id Feld purchase_id
position INTEGER Ja * - Feld position
product_id UUID Nein FK ➔ products.id Feld product_id
description TEXT Ja * - Feld description
quantity_ordered NUMERIC(14, 4) Ja * - Feld quantity_ordered
quantity_received NUMERIC(14, 4) Ja * - Feld quantity_received
unit VARCHAR(16) Ja * - Feld unit
unit_price NUMERIC(14, 2) Ja * - Feld unit_price
tax_rate NUMERIC(6, 4) Ja * - Feld tax_rate
net_amount NUMERIC(14, 2) Ja * - Feld net_amount
tax_amount NUMERIC(14, 2) Ja * - Feld tax_amount
gross_amount NUMERIC(14, 2) Ja * - Feld gross_amount
project_id UUID Nein FK ➔ projects.id Feld project_id
supplier_product_code VARCHAR(64) Nein - Feld supplier_product_code
customer_id UUID Nein FK ➔ customers.id Feld customer_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
quantity_billed NUMERIC(14, 4) Ja * - Feld quantity_billed
discount_percentage NUMERIC(6, 4) Ja * - Feld discount_percentage
target_consignment BOOLEAN Ja * - Feld target_consignment
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_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
metadata JSONB Ja * - Feld metadata
PurchaseRequisitionItems purchase_requisition_items RLS Aktiv
13 Cálculos y columnas

Tabelle purchase_requisition_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
purchase_requisition_id UUID Ja * FK ➔ purchase_requisitions.id Feld purchase_requisition_id
position INTEGER Ja * - Feld position
product_id UUID Nein FK ➔ products.id Feld product_id
description TEXT Ja * - Feld description
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
unit_price_estimate NUMERIC(14, 2) Nein - Feld unit_price_estimate
purchase_item_id UUID Nein FK ➔ purchase_items.id Feld purchase_item_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
metadata JSONB Ja * - Feld metadata
PurchaseRequisitions purchase_requisitions RLS Aktiv
20 Cálculos y columnas

Tabelle purchase_requisitions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
requisition_number VARCHAR(32) Ja * - Feld requisition_number
status VARCHAR(48) Ja * - Feld status
requester_user_id UUID Ja * FK ➔ users.id Feld requester_user_id
project_id UUID Nein FK ➔ projects.id Feld project_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
cost_center_id UUID Nein FK ➔ cost_centers.id Feld cost_center_id
notes TEXT Nein - Feld notes
approved_by UUID Nein FK ➔ users.id Feld approved_by
approved_at DATETIME Nein - Feld approved_at
purchase_id UUID Nein FK ➔ purchases.id Feld purchase_id
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
PurchaseRfqLines purchase_rfq_lines RLS Aktiv
11 Cálculos y columnas

Tabelle purchase_rfq_lines

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
rfq_id UUID Ja * FK ➔ purchase_rfqs.id Feld rfq_id
position INTEGER Ja * - Feld position
product_id UUID Nein FK ➔ products.id Feld product_id
description TEXT Ja * - Feld description
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
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
PurchaseRfqSuppliers purchase_rfq_suppliers RLS Aktiv
9 Cálculos y columnas

Tabelle purchase_rfq_suppliers

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
rfq_id UUID Ja * FK ➔ purchase_rfqs.id Feld rfq_id
supplier_id UUID Ja * FK ➔ suppliers.id Feld supplier_id
email_sent_at DATETIME Nein - Feld email_sent_at
quote_id UUID Nein FK ➔ supplier_quotes.id Feld quote_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
metadata JSONB Ja * - Feld metadata
PurchaseRfqs purchase_rfqs RLS Aktiv
16 Cálculos y columnas

Tabelle purchase_rfqs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
rfq_number VARCHAR(32) Ja * - Feld rfq_number
status VARCHAR(48) Ja * - Feld status
requisition_id UUID Nein FK ➔ purchase_requisitions.id Feld requisition_id
project_id UUID Nein FK ➔ projects.id Feld project_id
notes TEXT Nein - Feld notes
due_date DATE Nein - Feld due_date
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
Purchases purchases RLS Aktiv
41 Cálculos y columnas

Tabelle purchases

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
purchase_number VARCHAR(32) Ja * - Feld purchase_number
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
project_id UUID Nein FK ➔ projects.id Feld project_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_id
order_date DATE Nein - Feld order_date
expected_delivery_date DATE Nein - Feld expected_delivery_date
currency VARCHAR(3) Ja * - Feld currency
net_amount NUMERIC(14, 2) Ja * - Feld net_amount
tax_amount NUMERIC(14, 2) Ja * - Feld tax_amount
gross_amount NUMERIC(14, 2) Ja * - Feld gross_amount
status VARCHAR(48) Ja * - Feld status
supplier_reference VARCHAR(128) Nein - Feld supplier_reference
customer_id UUID Nein FK ➔ customers.id Feld customer_id
contract_id UUID Nein FK ➔ contracts.id Feld contract_id
procurement_type VARCHAR(32) Ja * - Feld procurement_type
incoterm VARCHAR(16) Nein - Feld incoterm
incoterm_location VARCHAR(128) Nein - Feld incoterm_location
payment_terms VARCHAR(128) Nein - Feld payment_terms
payment_term_code VARCHAR(32) Nein - Feld payment_term_code
delivery_address TEXT Nein - Feld delivery_address
cost_center_id UUID Nein FK ➔ cost_centers.id Feld cost_center_id
cost_type_id UUID Nein FK ➔ cost_types.id Feld cost_type_id
sent_at DATETIME Nein - Feld sent_at
sent_to_email VARCHAR(320) Nein - Feld sent_to_email
supplier_confirmed_at DATETIME Nein - Feld supplier_confirmed_at
supplier_confirmation_number VARCHAR(128) Nein - Feld supplier_confirmation_number
pdf_storage_key VARCHAR(255) Nein - Feld pdf_storage_key
is_consolidated BOOLEAN Ja * - Feld is_consolidated
grouping_mode VARCHAR(32) Ja * - Feld grouping_mode
notes TEXT Nein - Feld notes
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
QuoteTemplateItems quote_template_items RLS Aktiv
14 Cálculos y columnas

Tabelle quote_template_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
template_id UUID Ja * FK ➔ quote_templates.id Feld template_id
position INTEGER Ja * - Feld position
product_id UUID Nein FK ➔ products.id Feld product_id
description TEXT Ja * - Feld description
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
unit_price NUMERIC(14, 2) Nein - Feld unit_price
discount_percent NUMERIC(5, 2) Ja * - Feld discount_percent
tax_rate NUMERIC(6, 4) Ja * - Feld tax_rate
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
QuoteTemplates quote_templates RLS Aktiv
20 Cálculos y columnas

Tabelle quote_templates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
is_active BOOLEAN Ja * - Feld is_active
validity_days INTEGER Ja * - Feld validity_days
currency VARCHAR(3) Ja * - Feld currency
payment_terms VARCHAR(128) Nein - Feld payment_terms
payment_term_code VARCHAR(32) Nein - Feld payment_term_code
delivery_address TEXT Nein - Feld delivery_address
terms TEXT Nein - Feld terms
notes TEXT Nein - Feld notes
signature_required BOOLEAN Ja * - Feld signature_required
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
Reminders reminders RLS Aktiv
17 Cálculos y columnas

Tabelle reminders

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
title VARCHAR(255) Ja * - Feld title
remind_at DATETIME Ja * - Feld remind_at
entity_type VARCHAR(64) Nein - Feld entity_type
entity_id UUID Nein - Feld entity_id
task_id UUID Nein FK ➔ tasks.id Feld task_id
is_sent BOOLEAN Ja * - Feld is_sent
sent_at DATETIME Nein - Feld sent_at
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
ReorderingRules reordering_rules RLS Aktiv
20 Cálculos y columnas

Tabelle reordering_rules

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
location_id UUID Nein FK ➔ locations.id Feld location_id
supplier_info_id UUID Nein FK ➔ product_supplierinfo.id Feld supplier_info_id
min_quantity NUMERIC(14, 4) Ja * - Feld min_quantity
target_quantity NUMERIC(14, 4) Ja * - Feld target_quantity
order_multiple NUMERIC(14, 4) Ja * - Feld order_multiple
min_order_quantity NUMERIC(14, 4) Ja * - Feld min_order_quantity
automatic BOOLEAN Ja * - Feld automatic
active BOOLEAN Ja * - Feld active
last_evaluated_at DATETIME Nein - Feld last_evaluated_at
last_procurement_at DATETIME Nein - Feld last_procurement_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
ReviewTasks review_tasks RLS Aktiv
23 Cálculos y columnas

Tabelle review_tasks

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
agent_run_id UUID Nein FK ➔ agent_runs.id Feld agent_run_id
inbox_item_id UUID Nein FK ➔ inbox_items.id Feld inbox_item_id
review_type VARCHAR(48) Ja * - Feld review_type
question TEXT Ja * - Feld question
proposed_action JSONB Ja * - Feld proposed_action
options JSONB Ja * - Feld options
entity_type VARCHAR(64) Nein - Feld entity_type
entity_id UUID Nein - Feld entity_id
confidence NUMERIC(4, 3) Nein - Feld confidence
status VARCHAR(48) Ja * - Feld status
assigned_user_id UUID Nein FK ➔ users.id Feld assigned_user_id
resolution JSONB Ja * - Feld resolution
resolved_by UUID Nein FK ➔ users.id Feld resolved_by
resolved_at DATETIME Nein - Feld resolved_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
ScanBridges scan_bridges RLS Aktiv
18 Cálculos y columnas

Tabelle scan_bridges

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
bridge_uid VARCHAR(64) Ja * - Feld bridge_uid
name VARCHAR(256) Ja * - Feld name
token_hash VARCHAR(64) Ja * - Feld token_hash
active BOOLEAN Ja * - Feld active
hostname VARCHAR(256) Nein - Feld hostname
software_version VARCHAR(64) Nein - Feld software_version
watch_folder VARCHAR(512) Nein - Feld watch_folder
last_ip VARCHAR(64) Nein - Feld last_ip
last_seen_at DATETIME Nein - Feld last_seen_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
ScanImports scan_imports RLS Aktiv
24 Cálculos y columnas

Tabelle scan_imports

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
bridge_id UUID Ja * FK ➔ scan_bridges.id Feld bridge_id
upload_uid VARCHAR(128) Ja * - Feld upload_uid
sha256 VARCHAR(64) Ja * - Feld sha256
original_filename VARCHAR(256) Ja * - Feld original_filename
content_type VARCHAR(128) Ja * - Feld content_type
size_bytes BIGINT Ja * - Feld size_bytes
status VARCHAR(24) Ja * - Feld status
document_type VARCHAR(64) Nein - Feld document_type
operation_type VARCHAR(64) Nein - Feld operation_type
reference_type VARCHAR(32) Nein - Feld reference_type
reference_id UUID Nein - Feld reference_id
reference_value VARCHAR(256) Nein - Feld reference_value
document_id UUID Nein FK ➔ documents.id Feld document_id
metadata_payload JSONB Nein - Feld metadata_payload
error_message TEXT Nein - Feld error_message
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
SemanticActivations semantic_activations RLS Aktiv
12 Cálculos y columnas

Tabelle semantic_activations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
scope VARCHAR(16) Ja * - Feld scope
scope_key VARCHAR(96) Ja * - Feld scope_key
release_id UUID Ja * FK ➔ semantic_releases.id Feld release_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
SemanticAuditEvents semantic_audit_events RLS Aktiv
14 Cálculos y columnas

Tabelle semantic_audit_events

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
actor_id UUID Nein - Feld actor_id
agent_run_id UUID Nein - Feld agent_run_id
intent VARCHAR(96) Ja * - Feld intent
object_key VARCHAR(96) Ja * - Feld object_key
entity_id UUID Nein - Feld entity_id
decision VARCHAR(16) Ja * - Feld decision
reason TEXT Ja * - Feld reason
context_hash VARCHAR(64) Nein - Feld context_hash
release_versions JSONB Ja * - Feld release_versions
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
SemanticDefinitions semantic_definitions RLS Aktiv
10 Cálculos y columnas

Tabelle semantic_definitions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
release_id UUID Ja * FK ➔ semantic_releases.id Feld release_id
kind VARCHAR(24) Ja * - Feld kind
key VARCHAR(96) Ja * - Feld key
mode VARCHAR(16) Ja * - Feld mode
body JSONB Ja * - Feld body
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
SemanticExtensionValues semantic_extension_values RLS Aktiv
11 Cálculos y columnas

Tabelle semantic_extension_values

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
object_key VARCHAR(96) Ja * - Feld object_key
entity_id UUID Ja * - Feld entity_id
field_key VARCHAR(96) Ja * - Feld field_key
revision INTEGER Ja * - Feld revision
value JSONB Ja * - Feld value
release_id UUID Ja * FK ➔ semantic_releases.id Feld release_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
metadata JSONB Ja * - Feld metadata
SemanticPacks semantic_packs
10 Cálculos y columnas

Tabelle semantic_packs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
scope VARCHAR(16) Ja * - Feld scope
scope_key VARCHAR(96) Ja * - Feld scope_key
version INTEGER Ja * - Feld version
active BOOLEAN Ja * - Feld active
definitions JSONB Ja * - Feld definitions
source VARCHAR(255) Ja * - Feld source
content_hash VARCHAR(64) Ja * - Feld content_hash
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
SemanticQuoteApprovals semantic_quote_approvals RLS Aktiv
10 Cálculos y columnas

Tabelle semantic_quote_approvals

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
quote_id UUID Ja * FK ➔ quotes.id Feld quote_id
context_hash VARCHAR(64) Ja * - Feld context_hash
facts_hash VARCHAR(64) Ja * - Feld facts_hash
approved_by UUID Ja * - Feld approved_by
reason TEXT Ja * - 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
SemanticReleases semantic_releases RLS Aktiv
18 Cálculos y columnas

Tabelle semantic_releases

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
scope VARCHAR(16) Ja * - Feld scope
scope_key VARCHAR(96) Ja * - Feld scope_key
version INTEGER Ja * - Feld version
status VARCHAR(16) Ja * - Feld status
base_release_id UUID Nein FK ➔ semantic_releases.id Feld base_release_id
reason TEXT Ja * - Feld reason
content_hash VARCHAR(64) Ja * - Feld content_hash
approved_by UUID Nein - Feld approved_by
approved_at DATETIME Nein - Feld approved_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
SemanticSimulations semantic_simulations RLS Aktiv
11 Cálculos y columnas

Tabelle semantic_simulations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
release_id UUID Ja * FK ➔ semantic_releases.id Feld release_id
entity_type VARCHAR(96) Ja * - Feld entity_type
entity_id UUID Ja * - Feld entity_id
intent VARCHAR(96) Ja * - Feld intent
result JSONB Ja * - Feld result
release_hash VARCHAR(64) Ja * - Feld release_hash
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ semantic_releases.tenant_id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
SemanticTenantProfiles semantic_tenant_profiles RLS Aktiv
10 Cálculos y columnas

Tabelle semantic_tenant_profiles

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
industry_key VARCHAR(96) Nein - Feld industry_key
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
SemanticWorkerBindings semantic_worker_bindings RLS Aktiv
16 Cálculos y columnas

Tabelle semantic_worker_bindings

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
role_key VARCHAR(96) Ja * - Feld role_key
trigger_event VARCHAR(64) Ja * - Feld trigger_event
supervisor_user_id UUID Nein FK ➔ organization_users.user_id Feld supervisor_user_id
version INTEGER Ja * - Feld version
is_current BOOLEAN Ja * - Feld is_current
enabled BOOLEAN Ja * - Feld enabled
status VARCHAR(16) Ja * - Feld status
simulation_result JSONB Nein - Feld simulation_result
approved_by UUID Nein - Feld approved_by
reason TEXT Ja * - Feld reason
created_by UUID Ja * - Feld created_by
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ organization_users.tenant_id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
SemanticWorkerRuns semantic_worker_runs RLS Aktiv
11 Cálculos y columnas

Tabelle semantic_worker_runs

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
binding_id UUID Ja * FK ➔ semantic_worker_bindings.id Feld binding_id
event_id UUID Ja * - Feld event_id
entity_id UUID Ja * - Feld entity_id
decision VARCHAR(16) Ja * - Feld decision
context_hash VARCHAR(64) Nein - Feld context_hash
result JSONB Ja * - Feld result
id UUID Nein PK Feld id
tenant_id UUID Ja * FK ➔ semantic_worker_bindings.tenant_id Feld tenant_id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
ServiceChecklistTemplates service_checklist_templates RLS Aktiv
14 Cálculos y columnas

Tabelle service_checklist_templates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
description TEXT Nein - Feld description
trade VARCHAR(64) Nein - Feld trade
is_active BOOLEAN Ja * - Feld is_active
definition JSONB Ja * - Feld definition
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
ServiceMaterialEntries service_material_entries RLS Aktiv
11 Cálculos y columnas

Tabelle service_material_entries

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
service_report_id UUID Ja * FK ➔ service_reports.id Feld service_report_id
product_id UUID Ja * FK ➔ products.id Feld product_id
quantity NUMERIC Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
stock_movement_id UUID Nein FK ➔ stock_movements.id Feld stock_movement_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
metadata JSONB Ja * - Feld metadata
ServicePhotos service_photos RLS Aktiv
12 Cálculos y columnas

Tabelle service_photos

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
service_report_id UUID Ja * FK ➔ service_reports.id Feld service_report_id
document_id UUID Ja * FK ➔ documents.id Feld document_id
caption VARCHAR(255) Nein - Feld caption
checklist_item_label VARCHAR(255) Nein - Feld checklist_item_label
taken_at DATETIME Nein - Feld taken_at
lat NUMERIC(9, 6) Nein - Feld lat
lng NUMERIC(9, 6) Nein - Feld lng
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
ServiceReports service_reports RLS Aktiv
49 Cálculos y columnas

Tabelle service_reports

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
report_number VARCHAR(32) Ja * - Feld report_number
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
project_id UUID Nein FK ➔ projects.id Feld project_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
asset_id UUID Nein FK ➔ assets.id Feld asset_id
technician_id UUID Nein FK ➔ organization_users.id Feld technician_id
checklist_template_id UUID Nein FK ➔ service_checklist_templates.id Feld checklist_template_id
status VARCHAR(48) Ja * - Feld status
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
scheduled_start DATETIME Nein - Feld scheduled_start
scheduled_end DATETIME Nein - Feld scheduled_end
travel_started_at DATETIME Nein - Feld travel_started_at
arrived_at DATETIME Nein - Feld arrived_at
work_started_at DATETIME Nein - Feld work_started_at
work_ended_at DATETIME Nein - Feld work_ended_at
departed_at DATETIME Nein - Feld departed_at
location_lat NUMERIC(9, 6) Nein - Feld location_lat
location_lng NUMERIC(9, 6) Nein - Feld location_lng
location_address VARCHAR(512) Nein - Feld location_address
travel_minutes INTEGER Ja * - Feld travel_minutes
work_minutes INTEGER Ja * - Feld work_minutes
break_minutes INTEGER Ja * - Feld break_minutes
checklist_results JSONB Ja * - Feld checklist_results
work_performed TEXT Nein - Feld work_performed
result_summary TEXT Nein - Feld result_summary
defects_found TEXT Nein - Feld defects_found
follow_up_needed BOOLEAN Ja * - Feld follow_up_needed
follow_up_notes TEXT Nein - Feld follow_up_notes
acceptance_items JSONB Ja * - Feld acceptance_items
acceptance_status VARCHAR(32) Ja * - Feld acceptance_status
acceptance_notes TEXT Nein - Feld acceptance_notes
accepted_at DATETIME Nein - Feld accepted_at
accepted_by_name VARCHAR(255) Nein - Feld accepted_by_name
signature_document_id UUID Nein FK ➔ documents.id Feld signature_document_id
signed_by_name VARCHAR(255) Nein - Feld signed_by_name
signed_at DATETIME Nein - Feld signed_at
pdf_document_id UUID Nein FK ➔ documents.id Feld pdf_document_id
completed_at DATETIME Nein - Feld completed_at
ticket_id UUID Nein FK ➔ tickets.id Feld ticket_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
ServiceTimeEntries service_time_entries RLS Aktiv
15 Cálculos y columnas

Tabelle service_time_entries

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
service_report_id UUID Ja * FK ➔ service_reports.id Feld service_report_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
project_id UUID Nein FK ➔ projects.id Feld project_id
user_id UUID Nein FK ➔ users.id Feld user_id
entry_type VARCHAR(48) Ja * - Feld entry_type
started_at DATETIME Nein - Feld started_at
ended_at DATETIME Nein - Feld ended_at
duration_minutes INTEGER Ja * - Feld duration_minutes
description TEXT Nein - Feld description
billable BOOLEAN Ja * - Feld billable
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
StandardCategories standard_categories
9 Cálculos y columnas

Tabelle standard_categories

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Nein PK Feld code
parent_code VARCHAR(32) Nein - Feld parent_code
level INTEGER Ja * - Feld level
name_de VARCHAR(512) Nein - Feld name_de
name_en VARCHAR(512) Ja * - Feld name_en
name_fr VARCHAR(512) Nein - Feld name_fr
name_it VARCHAR(512) Nein - Feld name_it
name_es VARCHAR(512) Nein - Feld name_es
active BOOLEAN Ja * - Feld active
StandardCategoryFieldsetTemplates standard_category_fieldset_templates
7 Cálculos y columnas

Tabelle standard_category_fieldset_templates

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
standard_code VARCHAR(32) Nein PK Feld standard_code
version INTEGER Ja * - Feld version
fieldset_title VARCHAR(255) Ja * - Feld fieldset_title
fieldset_description TEXT Nein - Feld fieldset_description
attributes JSONB Ja * - Feld attributes
active BOOLEAN Ja * - Feld active
updated_at DATETIME Ja * - Feld updated_at
StockCountLines stock_count_lines RLS Aktiv
15 Cálculos y columnas

Tabelle stock_count_lines

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
session_id UUID Ja * FK ➔ stock_count_sessions.id Feld session_id
position INTEGER Ja * - Feld position
product_id UUID Ja * FK ➔ products.id Feld product_id
location_id UUID Ja * FK ➔ locations.id Feld location_id
system_quantity NUMERIC(14, 4) Ja * - Feld system_quantity
counted_quantity NUMERIC(14, 4) Nein - Feld counted_quantity
line_status VARCHAR(16) Ja * - Feld line_status
difference NUMERIC(14, 4) Nein - Feld difference
notes VARCHAR(500) Nein - Feld notes
movement_id UUID Nein FK ➔ stock_movements.id Feld movement_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
metadata JSONB Ja * - Feld metadata
StockCountSessions stock_count_sessions RLS Aktiv
17 Cálculos y columnas

Tabelle stock_count_sessions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
count_number VARCHAR(40) Ja * - Feld count_number
status VARCHAR(24) Ja * - Feld status
scope VARCHAR(16) Ja * - Feld scope
location_id UUID Nein FK ➔ locations.id Feld location_id
notes VARCHAR(1000) Nein - Feld notes
counted_at DATETIME Nein - Feld counted_at
released_at DATETIME Nein - Feld released_at
cancelled_at DATETIME Nein - Feld cancelled_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
StockIssueItems stock_issue_items RLS Aktiv
15 Cálculos y columnas

Tabelle stock_issue_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
issue_id UUID Ja * FK ➔ stock_issues.id Feld issue_id
position INTEGER Ja * - Feld position
product_id UUID Ja * FK ➔ products.id Feld product_id
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
from_location_id UUID Nein FK ➔ locations.id Feld from_location_id
invoice_item_id UUID Nein FK ➔ invoice_items.id Feld invoice_item_id
reservation_id UUID Nein FK ➔ stock_reservations.id Feld reservation_id
tracking_entries JSONB Ja * - Feld tracking_entries
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
metadata JSONB Ja * - Feld metadata
StockIssues stock_issues RLS Aktiv
24 Cálculos y columnas

Tabelle stock_issues

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
issue_number VARCHAR(32) Ja * - Feld issue_number
reason VARCHAR(48) Ja * - Feld reason
status VARCHAR(48) Ja * - Feld status
customer_id UUID Nein FK ➔ customers.id Feld customer_id
owner_customer_id UUID Nein FK ➔ customers.id Feld owner_customer_id
project_id UUID Nein FK ➔ projects.id Feld project_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
invoice_id UUID Nein FK ➔ invoices.id Feld invoice_id
from_location_id UUID Nein FK ➔ locations.id Feld from_location_id
delivery_note_document_id UUID Nein FK ➔ documents.id Feld delivery_note_document_id
shipment_id UUID Nein FK ➔ logistics_shipments.id Feld shipment_id
notes TEXT Nein - Feld notes
posted_at DATETIME Nein - Feld posted_at
reversed_at DATETIME Nein - Feld reversed_at
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
StockLots stock_lots RLS Aktiv
19 Cálculos y columnas

Tabelle stock_lots

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
code VARCHAR(128) Ja * - Feld code
tracking_type VARCHAR(48) Ja * - Feld tracking_type
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
goods_receipt_item_id UUID Nein FK ➔ goods_receipt_items.id Feld goods_receipt_item_id
manufactured_at DATE Nein - Feld manufactured_at
expires_at DATE Nein - Feld expires_at
active BOOLEAN Ja * - Feld active
parent_lot_id UUID Nein FK ➔ stock_lots.id Feld parent_lot_id
source_assembly_order_id UUID Nein FK ➔ assembly_orders.id Feld source_assembly_order_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
StockMovementLots stock_movement_lots RLS Aktiv
8 Cálculos y columnas

Tabelle stock_movement_lots

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
movement_id UUID Ja * FK ➔ stock_movements.id Feld movement_id
lot_id UUID Ja * FK ➔ stock_lots.id Feld lot_id
quantity NUMERIC(14, 4) Ja * - Feld quantity
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
StockMovements stock_movements RLS Aktiv
25 Cálculos y columnas

Tabelle stock_movements

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
from_location_id UUID Nein FK ➔ locations.id Feld from_location_id
to_location_id UUID Nein FK ➔ locations.id Feld to_location_id
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
unit_cost NUMERIC(14, 2) Nein - Feld unit_cost
total_cost NUMERIC(14, 2) Nein - Feld total_cost
notes TEXT Nein - Feld notes
movement_type VARCHAR(48) Ja * - Feld movement_type
project_id UUID Nein FK ➔ projects.id Feld project_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
expense_item_id UUID Nein FK ➔ expense_items.id Feld expense_item_id
goods_receipt_item_id UUID Nein FK ➔ goods_receipt_items.id Feld goods_receipt_item_id
stock_issue_item_id UUID Nein FK ➔ stock_issue_items.id Feld stock_issue_item_id
owner_customer_id UUID Nein FK ➔ customers.id Feld owner_customer_id
reversal_of_id UUID Nein FK ➔ stock_movements.id Feld reversal_of_id
occurred_at DATETIME Ja * - Feld occurred_at
source VARCHAR(32) Nein - Feld source
confidence NUMERIC(4, 3) Nein - Feld confidence
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
StockReservations stock_reservations RLS Aktiv
17 Cálculos y columnas

Tabelle stock_reservations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Ja * FK ➔ products.id Feld product_id
location_id UUID Nein FK ➔ locations.id Feld location_id
quantity NUMERIC(14, 4) Ja * - Feld quantity
fulfilled_quantity NUMERIC(14, 4) Ja * - Feld fulfilled_quantity
status VARCHAR(48) Ja * - Feld status
source_type VARCHAR(32) Ja * - Feld source_type
source_id UUID Nein - Feld source_id
expires_at DATETIME Nein - Feld expires_at
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
owner_customer_id UUID Nein FK ➔ customers.id Feld owner_customer_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
metadata JSONB Ja * - Feld metadata
StorageCategories storage_categories RLS Aktiv
16 Cálculos y columnas

Tabelle storage_categories

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(120) Ja * - Feld name
code VARCHAR(32) Nein - Feld code
max_weight_kg NUMERIC Nein - Feld max_weight_kg
max_quantity NUMERIC(14, 4) Nein - Feld max_quantity
new_product_policy VARCHAR(24) Ja * - Feld new_product_policy
active BOOLEAN Ja * - Feld active
warehouse_location_id UUID Nein FK ➔ locations.id Feld warehouse_location_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
StorageOrderLines storage_order_lines RLS Aktiv
10 Cálculos y columnas

Tabelle storage_order_lines

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
order_id UUID Ja * FK ➔ storage_orders.id Feld order_id
article_id UUID Ja * FK ➔ stored_articles.id Feld article_id
quantity NUMERIC(14, 4) Ja * - Feld quantity
lot_code VARCHAR(64) Nein - Feld lot_code
location_id UUID Nein FK ➔ locations.id Feld location_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
metadata JSONB Ja * - Feld metadata
StorageOrders storage_orders RLS Aktiv
19 Cálculos y columnas

Tabelle storage_orders

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
order_number VARCHAR(64) Ja * - Feld order_number
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
order_type VARCHAR(8) Ja * - Feld order_type
status VARCHAR(16) Ja * - Feld status
reference VARCHAR(128) Nein - Feld reference
route_id UUID Nein FK ➔ warehouse_routes.id Feld route_id
carrier VARCHAR(128) Nein - Feld carrier
planned_at DATETIME Nein - Feld planned_at
done_at DATETIME Nein - Feld done_at
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
StoredArticles stored_articles RLS Aktiv
19 Cálculos y columnas

Tabelle stored_articles

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
owner_type VARCHAR(16) Ja * - Feld owner_type
owner_id UUID Ja * - Feld owner_id
sku VARCHAR(64) Ja * - Feld sku
name VARCHAR(255) Ja * - Feld name
unit VARCHAR(16) Ja * - Feld unit
storage_unit VARCHAR(16) Nein - Feld storage_unit
barcode VARCHAR(64) Nein - Feld barcode
description TEXT Nein - Feld description
product_id UUID Nein FK ➔ products.id Feld product_id
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
TaxCodes tax_codes RLS Aktiv
17 Cálculos y columnas

Tabelle tax_codes

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
rate NUMERIC(6, 4) Ja * - Feld rate
direction VARCHAR(48) Ja * - Feld direction
account_code VARCHAR(32) Nein - Feld account_code
kind VARCHAR(24) Ja * - Feld kind
counter_account_code VARCHAR(32) Nein - Feld counter_account_code
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
TenantAiCredentials tenant_ai_credentials RLS Aktiv
18 Cálculos y columnas

Tabelle tenant_ai_credentials

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
provider VARCHAR(32) Ja * - Feld provider
label VARCHAR(120) Ja * - Feld label
api_key_encrypted TEXT Ja * - Feld api_key_encrypted
base_url VARCHAR(255) Nein - Feld base_url
model_overrides JSONB Ja * - Feld model_overrides
is_active BOOLEAN Ja * - Feld is_active
status VARCHAR(16) Ja * - Feld status
last_validated_at DATETIME Nein - Feld last_validated_at
last_error VARCHAR(500) Nein - Feld last_error
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
TenantBranding tenant_branding RLS Aktiv
15 Cálculos y columnas

Tabelle tenant_branding

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
logo_png BLOB Nein - Feld logo_png
logo_width_px INTEGER Nein - Feld logo_width_px
logo_height_px INTEGER Nein - Feld logo_height_px
logo_filename VARCHAR(255) Nein - Feld logo_filename
logo_sha256 VARCHAR(64) Nein - Feld logo_sha256
accent_color VARCHAR(7) Ja * - Feld accent_color
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
TenantCurrencies tenant_currencies RLS Aktiv
13 Cálculos y columnas

Tabelle tenant_currencies

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(3) Ja * - Feld code
name VARCHAR(128) Ja * - Feld name
active BOOLEAN Ja * - Feld active
is_default BOOLEAN Ja * - Feld is_default
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
TenantPaymentTerms tenant_payment_terms RLS Aktiv
16 Cálculos y columnas

Tabelle tenant_payment_terms

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Ja * - Feld code
name VARCHAR(128) Ja * - Feld name
net_days INTEGER Ja * - Feld net_days
skonto_days INTEGER Nein - Feld skonto_days
skonto_percent NUMERIC(6, 2) Nein - Feld skonto_percent
active BOOLEAN Ja * - Feld active
is_default BOOLEAN Ja * - Feld is_default
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
TenantRoles tenant_roles RLS Aktiv
11 Cálculos y columnas

Tabelle tenant_roles

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(128) Ja * - Feld name
code VARCHAR(64) Ja * - Feld code
description VARCHAR(512) Nein - Feld description
sector VARCHAR(64) Ja * - Feld sector
base_role VARCHAR(64) Nein - Feld base_role
permissions JSONB Ja * - Feld permissions
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
TenantStorageDestinations tenant_storage_destinations RLS Aktiv
35 Cálculos y columnas

Tabelle tenant_storage_destinations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
mode VARCHAR(48) Ja * - Feld mode
provider_type VARCHAR(48) Ja * - Feld provider_type
active BOOLEAN Ja * - Feld active
s3_endpoint_url VARCHAR(512) Nein - Feld s3_endpoint_url
s3_region VARCHAR(64) Nein - Feld s3_region
s3_bucket VARCHAR(128) Nein - Feld s3_bucket
s3_access_key VARCHAR(256) Nein - Feld s3_access_key
encrypted_s3_secret_key TEXT Nein - Feld encrypted_s3_secret_key
s3_force_path_style BOOLEAN Ja * - Feld s3_force_path_style
s3_prefix VARCHAR(256) Nein - Feld s3_prefix
webdav_url VARCHAR(512) Nein - Feld webdav_url
webdav_username VARCHAR(256) Nein - Feld webdav_username
encrypted_webdav_password TEXT Nein - Feld encrypted_webdav_password
webdav_base_path VARCHAR(512) Nein - Feld webdav_base_path
oauth_account_email VARCHAR(320) Nein - Feld oauth_account_email
oauth_tenant_id VARCHAR(128) Nein - Feld oauth_tenant_id
encrypted_oauth_access_token TEXT Nein - Feld encrypted_oauth_access_token
oauth_access_token_expiry DATETIME Nein - Feld oauth_access_token_expiry
encrypted_oauth_refresh_token TEXT Nein - Feld encrypted_oauth_refresh_token
oauth_state VARCHAR(128) Nein - Feld oauth_state
oauth_folder_id VARCHAR(512) Nein - Feld oauth_folder_id
oauth_folder_label VARCHAR(256) Nein - Feld oauth_folder_label
status VARCHAR(48) Ja * - Feld status
last_error TEXT Nein - Feld last_error
last_tested_at DATETIME Nein - Feld last_tested_at
last_synced_at DATETIME Nein - Feld last_synced_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
TenantSubscriptions tenant_subscriptions RLS Aktiv
14 Cálculos y columnas

Tabelle tenant_subscriptions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
kind VARCHAR(32) Ja * - Feld kind
package_key VARCHAR(32) Ja * - Feld package_key
stripe_subscription_id VARCHAR(64) Ja * - Feld stripe_subscription_id
status VARCHAR(16) Ja * - Feld status
amount_monthly NUMERIC(14, 2) Ja * - Feld amount_monthly
credit_monthly NUMERIC(14, 2) Nein - Feld credit_monthly
storage_gb INTEGER Nein - Feld storage_gb
max_users INTEGER Nein - Feld max_users
cancel_at_period_end BOOLEAN Ja * - Feld cancel_at_period_end
current_period_end DATETIME Nein - Feld current_period_end
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
ThirdPartyStockMovements third_party_stock_movements RLS Aktiv
21 Cálculos y columnas

Tabelle third_party_stock_movements

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
article_id UUID Ja * FK ➔ stored_articles.id Feld article_id
contract_id UUID Nein FK ➔ contracts.id Feld contract_id
order_id UUID Nein - Feld order_id
movement_type VARCHAR(16) Ja * - Feld movement_type
quantity NUMERIC(14, 4) Ja * - Feld quantity
from_location_id UUID Nein FK ➔ locations.id Feld from_location_id
to_location_id UUID Nein FK ➔ locations.id Feld to_location_id
lot_code VARCHAR(64) Nein - Feld lot_code
occurred_at DATETIME Ja * - Feld occurred_at
reference VARCHAR(128) Nein - Feld reference
notes TEXT Nein - Feld notes
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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
UnitsOfMeasure units_of_measure RLS Aktiv
19 Cálculos y columnas

Tabelle units_of_measure

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(16) Ja * - Feld code
symbol VARCHAR(16) Ja * - Feld symbol
category VARCHAR(32) Ja * - Feld category
name_de VARCHAR(64) Ja * - Feld name_de
name_en VARCHAR(64) Ja * - Feld name_en
name_fr VARCHAR(64) Nein - Feld name_fr
name_it VARCHAR(64) Nein - Feld name_it
name_es VARCHAR(64) Nein - Feld name_es
active BOOLEAN Ja * - Feld active
is_default BOOLEAN Ja * - Feld is_default
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
Users users
16 Cálculos y columnas

Tabelle users

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
email VARCHAR(320) Ja * - Feld email
password_hash VARCHAR(128) Nein - Feld password_hash
credential_version INTEGER Ja * - Feld credential_version
name VARCHAR(255) Ja * - Feld name
phone VARCHAR(64) Nein - Feld phone
language VARCHAR(10) Ja * - Feld language
timezone VARCHAR(64) Ja * - Feld timezone
status VARCHAR(48) Ja * - Feld status
totp_secret_encrypted VARCHAR(512) Nein - Feld totp_secret_encrypted
last_login_at DATETIME Nein - Feld last_login_at
is_portal_admin BOOLEAN Ja * - Feld is_portal_admin
anonymized_at DATETIME Nein - Feld anonymized_at
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
WarehouseDockSlots warehouse_dock_slots RLS Aktiv
13 Cálculos y columnas

Tabelle warehouse_dock_slots

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
dock_id UUID Ja * FK ➔ warehouse_docks.id Feld dock_id
window_start DATETIME Ja * - Feld window_start
window_end DATETIME Ja * - Feld window_end
status VARCHAR(48) Ja * - Feld status
tour_stop_id UUID Nein FK ➔ logistics_tour_stops.id Feld tour_stop_id
shipment_id UUID Nein FK ➔ logistics_shipments.id Feld shipment_id
checked_in_at DATETIME Nein - Feld checked_in_at
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
metadata JSONB Ja * - Feld metadata
WarehouseDocks warehouse_docks RLS Aktiv
16 Cálculos y columnas

Tabelle warehouse_docks

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
location_id UUID Ja * FK ➔ locations.id Feld location_id
code VARCHAR(32) Ja * - Feld code
name VARCHAR(255) Ja * - Feld name
dock_type VARCHAR(48) Ja * - Feld dock_type
capacity_parallel INTEGER Ja * - Feld capacity_parallel
is_active BOOLEAN Ja * - Feld is_active
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
WarehouseOperationTypes warehouse_operation_types RLS Aktiv
27 Cálculos y columnas

Tabelle warehouse_operation_types

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(120) Ja * - Feld name
kind VARCHAR(24) Ja * - Feld kind
sequence_prefix VARCHAR(16) Ja * - Feld sequence_prefix
barcode_prefix VARCHAR(32) Nein - Feld barcode_prefix
default_source_location_id UUID Nein FK ➔ locations.id Feld default_source_location_id
default_destination_location_id UUID Nein FK ➔ locations.id Feld default_destination_location_id
reservation_method VARCHAR(24) Ja * - Feld reservation_method
create_backorder VARCHAR(8) Ja * - Feld create_backorder
returns_operation_type_id UUID Nein FK ➔ warehouse_operation_types.id Feld returns_operation_type_id
show_in_overview BOOLEAN Ja * - Feld show_in_overview
sequence INTEGER Ja * - Feld sequence
active BOOLEAN Ja * - Feld active
warehouse_location_id UUID Nein FK ➔ locations.id Feld warehouse_location_id
print_labels_enabled BOOLEAN Ja * - Feld print_labels_enabled
auto_print_labels BOOLEAN Ja * - Feld auto_print_labels
label_template_code VARCHAR(64) Nein - Feld label_template_code
label_printer_id UUID Nein FK ➔ printers.id Feld label_printer_id
label_copies INTEGER Ja * - Feld label_copies
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
WarehousePickCarts warehouse_pick_carts RLS Aktiv
15 Cálculos y columnas

Tabelle warehouse_pick_carts

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Ja * - Feld code
name VARCHAR(120) Ja * - Feld name
barcode VARCHAR(64) Nein - Feld barcode
slot_count INTEGER Ja * - Feld slot_count
warehouse_location_id UUID Nein FK ➔ locations.id Feld warehouse_location_id
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
WarehousePickTotes warehouse_pick_totes RLS Aktiv
16 Cálculos y columnas

Tabelle warehouse_pick_totes

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Ja * - Feld code
barcode VARCHAR(64) Nein - Feld barcode
tote_type VARCHAR(24) Ja * - Feld tote_type
cart_id UUID Nein FK ➔ warehouse_pick_carts.id Feld cart_id
slot_index INTEGER Nein - Feld slot_index
status VARCHAR(24) Ja * - Feld status
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
WarehousePickingItems warehouse_picking_items RLS Aktiv
14 Cálculos y columnas

Tabelle warehouse_picking_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
picking_id UUID Ja * FK ➔ warehouse_pickings.id Feld picking_id
position INTEGER Ja * - Feld position
product_id UUID Ja * FK ➔ products.id Feld product_id
quantity_demanded NUMERIC(14, 4) Ja * - Feld quantity_demanded
quantity_reserved NUMERIC(14, 4) Ja * - Feld quantity_reserved
quantity_done NUMERIC(14, 4) Ja * - Feld quantity_done
unit VARCHAR(16) Ja * - Feld unit
source_location_id UUID Nein FK ➔ locations.id Feld source_location_id
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_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
metadata JSONB Ja * - Feld metadata
WarehousePickings warehouse_pickings RLS Aktiv
31 Cálculos y columnas

Tabelle warehouse_pickings

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
picking_number VARCHAR(40) Ja * - Feld picking_number
picking_type VARCHAR(32) Ja * - Feld picking_type
operation_type_id UUID Nein FK ➔ warehouse_operation_types.id Feld operation_type_id
stock_issue_id UUID Nein FK ➔ stock_issues.id Feld stock_issue_id
wave_id UUID Nein FK ➔ warehouse_waves.id Feld wave_id
status VARCHAR(24) Ja * - Feld status
purchase_id UUID Nein FK ➔ purchases.id Feld purchase_id
invoice_id UUID Nein FK ➔ invoices.id Feld invoice_id
work_order_id UUID Nein FK ➔ work_orders.id Feld work_order_id
assembly_order_id UUID Nein FK ➔ assembly_orders.id Feld assembly_order_id
process_intent VARCHAR(32) Nein - Feld process_intent
service_report_id UUID Nein FK ➔ service_reports.id Feld service_report_id
cart_id UUID Nein FK ➔ warehouse_pick_carts.id Feld cart_id
tote_id UUID Nein FK ➔ warehouse_pick_totes.id Feld tote_id
source_quote_id UUID Nein FK ➔ quotes.id Feld source_quote_id
source_location_id UUID Nein FK ➔ locations.id Feld source_location_id
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_id
assigned_user_id UUID Nein FK ➔ users.id Feld assigned_user_id
scheduled_at DATETIME Nein - Feld scheduled_at
started_at DATETIME Nein - Feld started_at
completed_at DATETIME Nein - Feld completed_at
notes VARCHAR(1000) 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
WarehousePutawayRules warehouse_putaway_rules RLS Aktiv
21 Cálculos y columnas

Tabelle warehouse_putaway_rules

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
product_id UUID Nein FK ➔ products.id Feld product_id
product_category_id UUID Nein FK ➔ product_categories.id Feld product_category_id
arrive_location_id UUID Nein FK ➔ locations.id Feld arrive_location_id
store_location_id UUID Ja * FK ➔ locations.id Feld store_location_id
storage_category_id UUID Nein FK ➔ storage_categories.id Feld storage_category_id
goods_kind VARCHAR(16) Ja * - Feld goods_kind
stock_owner VARCHAR(16) Ja * - Feld stock_owner
customer_id UUID Nein FK ➔ customers.id Feld customer_id
sublocation_mode VARCHAR(16) Ja * - Feld sublocation_mode
sequence INTEGER Ja * - Feld sequence
active BOOLEAN Ja * - Feld active
warehouse_location_id UUID Nein FK ➔ locations.id Feld warehouse_location_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
WarehouseRoutes warehouse_routes RLS Aktiv
25 Cálculos y columnas

Tabelle warehouse_routes

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
code VARCHAR(32) Ja * - Feld code
name VARCHAR(120) Ja * - Feld name
operation_type VARCHAR(32) Ja * - Feld operation_type
action VARCHAR(16) Ja * - Feld action
goods_kind VARCHAR(16) Ja * - Feld goods_kind
stock_owner VARCHAR(16) Ja * - Feld stock_owner
customer_id UUID Nein FK ➔ customers.id Feld customer_id
source_zone_id UUID Nein FK ➔ warehouse_zones.id Feld source_zone_id
destination_zone_id UUID Nein FK ➔ warehouse_zones.id Feld destination_zone_id
source_location_id UUID Nein FK ➔ locations.id Feld source_location_id
destination_location_id UUID Nein FK ➔ locations.id Feld destination_location_id
product_id UUID Nein FK ➔ products.id Feld product_id
product_category_id UUID Nein FK ➔ product_categories.id Feld product_category_id
sequence INTEGER Ja * - Feld sequence
active BOOLEAN Ja * - Feld active
warehouse_location_id UUID Nein FK ➔ locations.id Feld warehouse_location_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
WarehouseSettings warehouse_settings RLS Aktiv
25 Cálculos y columnas

Tabelle warehouse_settings

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
track_lots BOOLEAN Ja * - Feld track_lots
track_serial_numbers BOOLEAN Ja * - Feld track_serial_numbers
track_expiry_dates BOOLEAN Ja * - Feld track_expiry_dates
multi_step_routes BOOLEAN Ja * - Feld multi_step_routes
storage_categories BOOLEAN Ja * - Feld storage_categories
consignment BOOLEAN Ja * - Feld consignment
use_packages BOOLEAN Ja * - Feld use_packages
bonded_customs BOOLEAN Ja * - Feld bonded_customs
receipt_steps INTEGER Ja * - Feld receipt_steps
delivery_steps INTEGER Ja * - Feld delivery_steps
default_removal_strategy VARCHAR(8) Ja * - Feld default_removal_strategy
annual_inventory_day INTEGER Nein - Feld annual_inventory_day
annual_inventory_month INTEGER Nein - Feld annual_inventory_month
scan_required_for_moves BOOLEAN Ja * - Feld scan_required_for_moves
auto_confirm_deliveries BOOLEAN Ja * - Feld auto_confirm_deliveries
warehouse_location_id UUID Nein FK ➔ locations.id Feld warehouse_location_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
WarehouseWaves warehouse_waves RLS Aktiv
15 Cálculos y columnas

Tabelle warehouse_waves

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
wave_number VARCHAR(40) Ja * - Feld wave_number
status VARCHAR(24) Ja * - Feld status
assigned_user_id UUID Nein FK ➔ users.id Feld assigned_user_id
notes VARCHAR(1000) Nein - Feld notes
released_at DATETIME Nein - Feld released_at
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
WarehouseZones warehouse_zones RLS Aktiv
15 Cálculos y columnas

Tabelle warehouse_zones

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
location_id UUID Ja * FK ➔ locations.id Feld location_id
code VARCHAR(32) Ja * - Feld code
name VARCHAR(120) Ja * - Feld name
zone_type VARCHAR(32) Ja * - Feld zone_type
sequence INTEGER Ja * - Feld sequence
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
WebhookDeliveries webhook_deliveries RLS Aktiv
19 Cálculos y columnas

Tabelle webhook_deliveries

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
subscription_id UUID Ja * FK ➔ webhook_subscriptions.id Feld subscription_id
signal_key VARCHAR(128) Ja * - Feld signal_key
payload JSONB Ja * - Feld payload
status VARCHAR(16) Ja * - Feld status
attempt_count INTEGER Ja * - Feld attempt_count
next_attempt_at DATETIME Nein - Feld next_attempt_at
last_error TEXT Nein - Feld last_error
response_status INTEGER Nein - Feld response_status
response_body TEXT Nein - Feld response_body
delivered_at DATETIME Nein - Feld delivered_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
WebhookSubscriptions webhook_subscriptions RLS Aktiv
15 Cálculos y columnas

Tabelle webhook_subscriptions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
signal_key VARCHAR(128) Ja * - Feld signal_key
target_url VARCHAR(2048) Ja * - Feld target_url
secret_encrypted TEXT Nein - Feld secret_encrypted
connector_operation_id UUID Nein FK ➔ connector_operations.id Feld connector_operation_id
active BOOLEAN Ja * - Feld active
description VARCHAR(255) Nein - Feld description
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
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
WorkOrderItems work_order_items RLS Aktiv
22 Cálculos y columnas

Tabelle work_order_items

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
work_order_id UUID Ja * FK ➔ work_orders.id Feld work_order_id
position INTEGER Ja * - Feld position
item_type VARCHAR(32) Ja * - Feld item_type
product_id UUID Nein FK ➔ products.id Feld product_id
sku VARCHAR(64) Nein - Feld sku
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
quantity NUMERIC(14, 4) Ja * - Feld quantity
unit VARCHAR(16) Ja * - Feld unit
unit_price NUMERIC(14, 2) Ja * - Feld unit_price
discount_percent NUMERIC(5, 2) Ja * - Feld discount_percent
tax_rate NUMERIC(6, 4) Ja * - Feld tax_rate
net_total NUMERIC(14, 2) Ja * - Feld net_total
tax_amount NUMERIC(14, 2) Ja * - Feld tax_amount
gross_total NUMERIC(14, 2) Ja * - Feld gross_total
quantity_delivered NUMERIC(14, 4) Ja * - Feld quantity_delivered
quantity_invoiced NUMERIC(14, 4) Ja * - Feld quantity_invoiced
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
WorkOrderMaterialRequirements work_order_material_requirements RLS Aktiv
18 Cálculos y columnas

Tabelle work_order_material_requirements

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
work_order_id UUID Ja * FK ➔ work_orders.id Feld work_order_id
product_id UUID Ja * FK ➔ products.id Feld product_id
quantity_required NUMERIC(14, 4) Ja * - Feld quantity_required
quantity_issued NUMERIC(14, 4) Ja * - Feld quantity_issued
unit VARCHAR(16) Ja * - Feld unit
notes TEXT Nein - Feld notes
purchase_id UUID Nein FK ➔ purchases.id Feld purchase_id
purchase_item_id UUID Nein FK ➔ purchase_items.id Feld purchase_item_id
procurement_status VARCHAR(24) Ja * - Feld procurement_status
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
WorkstationCalendarExceptions workstation_calendar_exceptions RLS Aktiv
10 Cálculos y columnas

Tabelle workstation_calendar_exceptions

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
workstation_id UUID Ja * FK ➔ workstations.id Feld workstation_id
exception_date DATE Ja * - Feld exception_date
capacity_minutes INTEGER Ja * - Feld capacity_minutes
kind VARCHAR(24) Ja * - Feld kind
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
Workstations workstations RLS Aktiv
21 Cálculos y columnas

Tabelle workstations

Feldname Tipo de datos Obligado Schlüssel Importancia profesional
name VARCHAR(255) Ja * - Feld name
code VARCHAR(32) Nein - Feld code
workstation_type VARCHAR(48) Ja * - Feld workstation_type
location_id UUID Nein FK ➔ locations.id Feld location_id
assigned_user_id UUID Nein FK ➔ users.id Feld assigned_user_id
active BOOLEAN Ja * - Feld active
capacity_notes TEXT Nein - Feld capacity_notes
notes TEXT Nein - Feld notes
capacity_minutes_per_day INTEGER Ja * - Feld capacity_minutes_per_day
working_days JSONB Ja * - Feld working_days
parallel_units INTEGER Ja * - Feld parallel_units
efficiency_percent NUMERIC(6, 2) Ja * - Feld efficiency_percent
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

🔌 Puntos de inicio (UI y API)

Art El método Punto final / camino Titel & Zweck Reacción
⚡ REST API DELETE /api/v1/admin/roles/{role_id}
delete_custom_role
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API DELETE /api/v1/org-units/{unit_id}
delete_unit
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API DELETE /api/v1/platform-products/{product_id}
delete_product
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API DELETE /api/v1/platform-settings/{key}
reset_setting
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API GET /admin
admin_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/accounts
admin_accounts_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/ai
admin_ai_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/ai/guthaben/{topup_id}/gutschrift
admin_ai_topup_credit_note
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/ai/guthaben/{topup_id}/rechnung
admin_ai_topup_invoice
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/billing
admin_billing_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/branche
admin_industry_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/branche/preview
admin_industry_preview
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/categories
categories_admin_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/categories/new
categories_admin_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/categories/{category_id}/edit
categories_admin_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/categories/{category_id}/fields
categories_admin_fields_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/consultants
admin_consultant_plans_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/controlling
admin_controlling_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/currencies
currencies_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/currencies/new
currencies_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/currencies/{currency_id}/edit
currencies_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/documents
admin_documents_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/geo
admin_geo_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/journals
admin_journals_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/number-sequences
admin_number_sequences_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/number-sequences/new
number_sequences_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/number-sequences/{sequence_id}/edit
number_sequences_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/nummernkreise
admin_number_sequences_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/nummernkreise/new
number_sequences_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/nummernkreise/{sequence_id}/edit
number_sequences_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/onboarding/plan
admin_onboarding_plan
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/org-units
admin_org_units_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/org-units/new
admin_org_units_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/org-units/{unit_id}/edit
admin_org_units_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/payment-terms
payment_terms_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/payment-terms/new
payment_terms_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/payment-terms/{term_id}/edit
payment_terms_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/permissions
admin_permissions_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/platform-products
platform_products_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/platform-products/new
platform_products_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/platform-products/{product_id}/edit
platform_products_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/portal
admin_portal_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/profile
admin_profile_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/tax-advisor
admin_tax_advisor_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/tax-advisor/check
admin_tax_advisor_check
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/tax-codes
tax_codes_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/tax-codes/new
tax_codes_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/tax-codes/{tax_id}/edit
tax_codes_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/units
units_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/units/new
units_new_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /admin/units/{unit_id}/edit
units_edit_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/consultant-cases
list_consultant_cases
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/consultant-cases/{case_id}
get_consultant_case
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/consultant-change-sets/{change_set_id}
get_consultant_change_set
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/consultant-mandate
get_consultant_mandate
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/consultant-plans
list_consultant_plans
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/consultant-plans/{plan_id}
get_consultant_plan
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/my-permissions
my_permissions
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/outbox/dead-letters
list_outbox_dead_letters
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/permissions
permission_matrix
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/roles
list_custom_roles
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/admin/roles/{role_id}
get_custom_role
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/org-units
list_units
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/org-units/by-user/{user_id}
user_units
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/org-units/me
my_units
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/org-units/{unit_id}/members
unit_members
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/platform-products
list_published_products
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/platform-products/all
list_all_products
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/platform-products/meta/agents
list_available_agents
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/platform-products/{product_id}
get_product
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/platform-settings
list_settings
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/subscriptions
list_subscriptions
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/subscriptions/collections
Recuerdos
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/subscriptions/collections.csv
collections_csv
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/subscriptions/link-info
link_info
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/subscriptions/{contract_id}
Detalles
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /api/v1/subscriptions/{contract_id}/linked
de las
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /platform
platform_admin_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /platform/settings
platform_settings_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /platform/tenants/{org_id}
platform_tenant_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /subscriptions
subscriptions_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API GET /subscriptions/collections
subscription_collections_page
Semantic binding: inventory_only; mutation=False
 admin
⚡ REST API PATCH /api/v1/admin/roles/{role_id}
update_custom_role
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API PATCH /api/v1/org-units/{unit_id}
update_unit
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API PATCH /api/v1/platform-products/{product_id}
update_product
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts
admin_add_party_account
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts/category
admin_create_category
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts/category/{category_id}
admin_set_category_accounts
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts/category/{category_id}/deactivate
admin_deactivate_category
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts/supplier/{supplier_id}
admin_set_supplier_account
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts/tax
admin_add_tax_code
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts/tax/{tax_code_id}/deactivate
admin_deactivate_tax_code
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/accounts/{account_id}/deactivate
admin_deactivate_party_account
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/budget
admin_ai_budget_save
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/budget/topup
admin_ai_budget_topup
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/checkout
admin_ai_checkout
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/credentials
admin_ai_credential_create
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/credentials/{credential_id}/activate
admin_ai_credential_activate
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/credentials/{credential_id}/delete
admin_ai_credential_delete
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/credentials/{credential_id}/models
admin_ai_credential_models_update
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/credentials/{credential_id}/test
admin_ai_credential_test
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/platform-models
admin_ai_platform_models_update
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/ai/storage-topup
admin_storage_topup
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/billing/checkout
admin_billing_checkout
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/billing/portal
admin_billing_portal
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/billing/subscribe
admin_billing_subscribe
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/branche/apply
admin_industry_apply
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/categories
admin_create_product_category
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/categories/seed-default-fieldsets
admin_categories_seed_default_fieldsets
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/categories/{category_id}/delete
admin_delete_product_category
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/categories/{category_id}/edit
admin_edit_product_category
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/categories/{category_id}/toggle-active
admin_toggle_active_product_category
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/copy-global
admin_copy_global_cost_library
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/cost-center
admin_add_cost_center
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/cost-center/{cost_center_id}
admin_update_cost_center
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/cost-type
admin_add_cost_type
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/cost-type-accounts/propose
admin_propose_cost_type_accounts
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/cost-type/{cost_type_id}
admin_update_cost_type
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/global-cost-center
admin_upsert_global_cost_center
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/global-cost-center/{center_id}
admin_update_global_cost_center
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/global-cost-type
admin_upsert_global_cost_type
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/controlling/global-cost-type/{type_id}
admin_update_global_cost_type
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/onboarding/apply
admin_onboarding_apply
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/onboarding/approve-fieldsets
admin_onboarding_approve_fieldsets
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/portal/accounts
admin_portal_account_create
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/portal/accounts/{account_id}/password
admin_portal_account_password
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/portal/accounts/{account_id}/status
admin_portal_account_status
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/portal/requests/{request_id}/decide
admin_portal_request_decide
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/portal/settings
admin_portal_settings_save
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/profile
admin_profile_save
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/tax-advisor/apply
admin_tax_advisor_apply
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /admin/tax-advisor/proposal
admin_tax_advisor_proposal
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/agents/{agent_name}/toggle
toggle_agent
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-cases
open_consultant_case
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-cases/{case_id}/compile
compile_consultant_case
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-cases/{case_id}/observations
record_consultant_observation
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-cases/{case_id}/requirements
confirm_business_requirement
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-cases/{case_id}/status
set_consultant_case_status
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-change-sets/{change_set_id}/activate
activate_consultant_change_set
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-change-sets/{change_set_id}/approve
approve_consultant_change_set
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-change-sets/{change_set_id}/go-live
go_live_consultant_change_set
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-change-sets/{change_set_id}/simulate
simulate_consultant_change_set
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-discovery/next
next_consultant_discovery
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-mandate
create_consultant_mandate
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-mandate/revoke
revoke_consultant_mandate
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/setup
create_setup_consultant_plan
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/{plan_id}/apply-bound-live
apply_consultant_bound_live
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/{plan_id}/approve
approve_consultant_plan
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/{plan_id}/execute-bound/{step_key}
execute_consultant_bound_step
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/{plan_id}/simulate
simulate_consultant_plan
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/{plan_id}/steps/configure_warehouse_settings/execute
execute_consultant_warehouse_settings
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/{plan_id}/steps/propose_sales_policy/execute
propose_consultant_sales_policy
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/consultant-plans/{plan_id}/steps/review_warehouse_structure/execute
execute_consultant_warehouse_step
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/modules/{module}/toggle
toggle_module
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/outbox/dead-letters/{event_id}/replay
replay_outbox_dead_letter
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/admin/roles
create_custom_role
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/org-units
create_unit
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/platform-products
create_product
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/platform-products/propose
propose_product
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/platform-products/{product_id}/apply/{tenant_id}
apply_product_to_tenant
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/platform-products/{product_id}/publish
publish_product
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/platform-products/{product_id}/unpublish
unpublish_product
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/from-order/{work_order_id}
from_order
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/link
enlace
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/{contract_id}/cancel
cancelación
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/{contract_id}/change-line
change_line
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/{contract_id}/invoice-now
invoice_now
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/{contract_id}/pause
Pausa
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/{contract_id}/resume
resumen
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /api/v1/subscriptions/{contract_id}/revoke-cancellation
Revocar
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /platform/tenants/{org_id}/plan
platform_tenant_plan_set
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /platform/tenants/{org_id}/status
platform_tenant_status_set
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API POST /platform/tenants/{org_id}/topups/{topup_id}/confirm
platform_tenant_confirm_topup
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API PUT /api/v1/org-units/by-user/{user_id}
set_user_units
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API PUT /api/v1/org-units/{unit_id}/members
set_members
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API PUT /api/v1/platform-settings/{key}
update_setting
Semantic binding: operator_surface; mutation=True
 admin
⚡ REST API PUT /api/v1/subscriptions/{contract_id}/settings
save_settings
Semantic binding: operator_surface; mutation=True
 admin
🖥️ WEB-UI GET /login
Página de notificación
Muestra el formulario de inicio de sesión con la opción de idioma
 Standard
🖥️ WEB-UI POST /login
Negociadores de notificación
Verifica los datos de registro y inicia la sesión
 Standard
🖥️ WEB-UI POST /logout
Negociadores de baja
Invalida sesión y elimina las cookies
 Standard
⚡ REST API GET /api/v1/auth/me
Usuarios actuales
Regreso de perfil y de las autorizaciones
 authenticated
⚡ REST API GET /api/v1/admin/industry-profiles
Profiles de la industria
Proveedor de perfiles de sectores estándar disponibles
 admin:read
⚡ REST API POST /api/v1/admin/apply-industry-profile
Aplicación de la industria
Componentes e conjuntos de categorías inicializados
 admin:manage

🛡️ Regulación y cumplimiento

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • El Estado miembro podrá adoptar una decisión en el marco de la cual el Estado miembro de la Unión podrá adoptar medidas de ejecución.
  • RGPD: el régimen de aislamiento de los clientes
  • Seguridad de nivel de fila (RLS) de postgreSQL
Modulos vinculados:
➔ identity ➔ catalog ➔ accounting ➔ numbering