🔐

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

identity core_platform 🛡️ RLS Protected

The Commission shall adopt delegated acts in accordance with Article 21 of Regulation (EU) No 182/2011 and in accordance with Article 21 of Regulation (EU) No 182/2011 of the European Parliament and of the Council [3].

Fachliche Bestimmung: The system is managed by two-tier identity model: a user can exist globally and be assigned to multiple clients (tenants) with different authorization levels (0=No access, 1=reading, 2=writing, 3=administered).

⚡ Workflows and life cycles (2) 🗄️ Data models and fields (152) 🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. (153) 🛡️ Regulatory and compliance

⚡ Workflows and life cycles

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. `user_auth_lifecycle`

The time period from the login attempt to password validation and session generation to the client context binding.

sequenceDiagram User->>AuthAPI: POST /login (email, password) AuthAPI->>DB: SELECT * FROM users WHERE email = ? AuthAPI->>AuthAPI: verify_password(hash, password) AuthAPI->>DB: SELECT role FROM organization_users WHERE user_id=? AND tenant_id=? AuthAPI-->>User: Set-Cookie: session_token (HttpOnly)

1. LOGIN_REQUEST

Request for notification

Users send e-mail and password via HTTPS POST / login.

Aktionen: Limitation of the rate, Other, including parts thereof

2. CREDENTIAL_CHECK

Password checking

Comparison with bcrypt/argon2 hash in table users.

Aktionen: Audit log-in attempt

3. CONTEXT_BINDING

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

Identification of the assigned organisation and role level of the organisation's users.

Aktionen: The Commission shall adopt implementing acts.

4. AUTHENTICATED

The meeting is active

Set the encrypted HttpOnly cookie with tenant context header.

Aktionen: Activate RLS execution

The following information is provided for in the Annex to this Regulation: `plan:command_industry_setup_agent`

The following is the list of the main functions of the system:

1. industry_setup_agent

industry_setup_agent

The following is the list of the products:

Aktionen: industry_setup_agent

🗄️ Data models and fields

AccountCodes account_codes RLS Aktiv

14 Fields and columns

Tabelle account_codes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle ai_budget_topups

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

16 Fields and columns

Tabelle ai_usage

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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
`period`	`VARCHAR(7)`	Ja *	-	Feld period
`billable_amount`	`NUMERIC(14, 6)`	Ja *	-	Feld billable_amount
`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

AuditLogs audit_logs RLS Aktiv

14 Fields and columns

Tabelle audit_logs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

CategoryAttributeBindings category_attribute_bindings RLS Aktiv

12 Fields and columns

Tabelle category_attribute_bindings

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle category_fieldset_activations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ 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

CategoryFieldsetRevisions category_fieldset_revisions RLS Aktiv

17 Fields and columns

Tabelle category_fieldset_revisions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

Contacts contacts RLS Aktiv

24 Fields and columns

Tabelle contacts

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle cost_centers

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle cost_entries

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle cost_types

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

Demands demands RLS Aktiv

23 Fields and columns

Tabelle demands

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

DocumentChunks document_chunks RLS Aktiv

11 Fields and columns

Tabelle document_chunks

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`document_id`	`UUID`	Ja *	FK ➔ documents.id	Feld document_id
`chunk_index`	`INTEGER`	Ja *	-	Feld chunk_index
`content`	`TEXT`	Ja *	-	Feld content
`page_number`	`INTEGER`	Nein	-	Feld page_number
`embedding`	`VECTOR(3072)`	Nein	-	Feld embedding
`embedding_model`	`VARCHAR(64)`	Nein	-	Feld embedding_model
`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

DocumentCirculations document_circulations RLS Aktiv

21 Fields and columns

Tabelle document_circulations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`description`	`TEXT`	Nein	-	Feld description
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`current_position`	`INTEGER`	Ja *	-	Feld current_position
`document_ids`	`JSONB`	Ja *	-	Feld document_ids
`final_storage_key`	`VARCHAR(1024)`	Nein	-	Feld final_storage_key
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`completed_at`	`DATETIME`	Nein	-	Feld completed_at
`completed_by`	`UUID`	Nein	FK ➔ users.id	Feld completed_by
`due_at`	`DATETIME`	Nein	-	Feld due_at
`priority`	`VARCHAR(16)`	Ja *	-	Feld priority
`rejection_reason`	`TEXT`	Nein	-	Feld rejection_reason
`last_activity_at`	`DATETIME`	Nein	-	Feld last_activity_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
`metadata`	`JSONB`	Ja *	-	Feld metadata

DocumentExtractions document_extractions RLS Aktiv

15 Fields and columns

Tabelle document_extractions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`document_id`	`UUID`	Ja *	FK ➔ documents.id	Feld document_id
`provider`	`VARCHAR(64)`	Ja *	-	Feld provider
`provider_version`	`VARCHAR(64)`	Nein	-	Feld provider_version
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`raw_text`	`TEXT`	Nein	-	Feld raw_text
`structured_data`	`JSONB`	Ja *	-	Feld structured_data
`confidence`	`NUMERIC(4, 3)`	Nein	-	Feld confidence
`processing_started_at`	`DATETIME`	Nein	-	Feld processing_started_at
`processing_finished_at`	`DATETIME`	Nein	-	Feld processing_finished_at
`error`	`TEXT`	Nein	-	Feld 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
`metadata`	`JSONB`	Ja *	-	Feld metadata

DocumentLinks document_links RLS Aktiv

10 Fields and columns

Tabelle document_links

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`document_id`	`UUID`	Ja *	FK ➔ documents.id	Feld document_id
`entity_type`	`VARCHAR(64)`	Ja *	-	Feld entity_type
`entity_id`	`UUID`	Ja *	-	Feld entity_id
`relation_type`	`VARCHAR(48)`	Ja *	-	Feld relation_type
`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

DocumentStorageSyncs document_storage_syncs RLS Aktiv

12 Fields and columns

Tabelle document_storage_syncs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`document_id`	`UUID`	Ja *	FK ➔ documents.id	Feld document_id
`destination_id`	`UUID`	Ja *	FK ➔ tenant_storage_destinations.id	Feld destination_id
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`remote_path`	`VARCHAR(1024)`	Nein	-	Feld remote_path
`error`	`TEXT`	Nein	-	Feld error
`attempts`	`INTEGER`	Ja *	-	Feld attempts
`synced_at`	`DATETIME`	Nein	-	Feld 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
`metadata`	`JSONB`	Ja *	-	Feld metadata

DocumentTemplates document_templates RLS Aktiv

13 Fields and columns

Tabelle document_templates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`doc_type`	`VARCHAR(24)`	Ja *	-	Feld doc_type
`layout_key`	`VARCHAR(48)`	Ja *	-	Feld layout_key
`settings`	`JSONB`	Ja *	-	Feld settings
`version`	`INTEGER`	Ja *	-	Feld version
`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 Fields and columns

Tabelle domain_events

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ organizations.id	Feld tenant_id

EcommerceChannels ecommerce_channels RLS Aktiv

21 Fields and columns

Tabelle ecommerce_channels

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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
`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 Fields and columns

Tabelle ecommerce_order_syncs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle exchange_rates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle export_batches

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle export_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle export_profiles

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle extra_work_candidates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle field_activities

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle gaeb_documents

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle gaeb_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle gaeb_sections

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle global_cost_centers

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle global_cost_types

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle goods_receipt_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle goods_receipts

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle import_batch_records

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle import_jobs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle import_profiles

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle inbound_webhook_endpoints

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle inbound_webhook_receipts

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

Jobs jobs RLS Aktiv

17 Fields and columns

Tabelle jobs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle journal_entries

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle journal_entry_lines

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle journals

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle kn8_reference_codes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle kn8_reference_versions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle label_templates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle landed_cost_allocations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle landed_costs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle learned_rules

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle location_end_customer_aliases

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle locations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

35 Fields and columns

Tabelle mailbox_accounts

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`email_address`	`VARCHAR(320)`	Ja *	-	Feld email_address
`provider_type`	`VARCHAR(32)`	Ja *	-	Feld provider_type
`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
`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

NumberSequences number_sequences RLS Aktiv

24 Fields and columns

Tabelle number_sequences

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle oauth_identities

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle org_unit_members

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle org_units

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

28 Fields and columns

Tabelle organization_users

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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
`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 Fields and columns

Tabelle organizations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle partner_shop_rates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle peppol_transmissions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle platform_products

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle platform_settings

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle platform_subscription_invoices

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle pricelist_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle pricelists

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle print_bridges

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle print_jobs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle printers

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle product_accessories

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle product_attribute_values

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle product_attributes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle product_bom_customers

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

13 Fields and columns

Tabelle product_bom_lines

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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
`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 Fields and columns

Tabelle product_bom_steps

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

23 Fields and columns

Tabelle product_boms

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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
`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 Fields and columns

Tabelle product_category_taxonomy_bindings

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ 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

ProductCompatibilities product_compatibilities RLS Aktiv

12 Fields and columns

Tabelle product_compatibilities

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle product_supplierinfo

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle product_variant_values

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

24 Fields and columns

Tabelle purchase_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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
`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 Fields and columns

Tabelle purchase_requisition_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle purchase_requisitions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle purchase_rfq_lines

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle purchase_rfq_suppliers

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle purchase_rfqs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle purchases

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle quote_template_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle quote_templates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle reminders

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle reordering_rules

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle review_tasks

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle scan_bridges

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle scan_imports

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle semantic_activations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ semantic_releases.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

SemanticAuditEvents semantic_audit_events RLS Aktiv

14 Fields and columns

Tabelle semantic_audit_events

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle semantic_definitions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ 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

SemanticExtensionValues semantic_extension_values RLS Aktiv

11 Fields and columns

Tabelle semantic_extension_values

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ 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

SemanticPacks semantic_packs

10 Fields and columns

Tabelle semantic_packs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle semantic_quote_approvals

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle semantic_releases

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ semantic_releases.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

SemanticSimulations semantic_simulations RLS Aktiv

11 Fields and columns

Tabelle semantic_simulations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle semantic_tenant_profiles

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle semantic_worker_bindings

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ organizations.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 Fields and columns

Tabelle semantic_worker_runs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ organizations.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 Fields and columns

Tabelle service_checklist_templates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle service_material_entries

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle service_photos

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle service_reports

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle service_time_entries

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle standard_categories

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle standard_category_fieldset_templates

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_count_lines

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_count_sessions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_issue_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_issues

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_lots

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_movement_lots

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_movements

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stock_reservations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle storage_categories

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle storage_order_lines

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle storage_orders

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle stored_articles

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tax_codes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tenant_ai_credentials

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tenant_branding

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tenant_currencies

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tenant_payment_terms

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tenant_roles

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tenant_storage_destinations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle tenant_subscriptions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle third_party_stock_movements

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle units_of_measure

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle users

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_dock_slots

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_docks

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_operation_types

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_pick_carts

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_pick_totes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_picking_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_pickings

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 ➔ quotes.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

WarehousePutawayRules warehouse_putaway_rules RLS Aktiv

21 Fields and columns

Tabelle warehouse_putaway_rules

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_routes

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

24 Fields and columns

Tabelle warehouse_settings

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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
`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 Fields and columns

Tabelle warehouse_waves

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle warehouse_zones

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle webhook_deliveries

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

14 Fields and columns

Tabelle webhook_subscriptions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`signal_key`	`VARCHAR(128)`	Ja *	-	Feld signal_key
`target_url`	`VARCHAR(2048)`	Ja *	-	Feld target_url
`secret_encrypted`	`TEXT`	Nein	-	Feld secret_encrypted
`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 Fields and columns

Tabelle work_order_items

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle work_order_material_requirements

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle workstation_calendar_exceptions

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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 Fields and columns

Tabelle workstations

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`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

🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

Art	The method	Endpoint / path	Titel & Zweck	The Commission shall adopt the following:
⚡ REST API	DELETE	`/api/v1/admin/roles/{role_id}`	delete_custom_role Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	DELETE	`/api/v1/org-units/{unit_id}`	delete_unit Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	DELETE	`/api/v1/platform-products/{product_id}`	delete_product Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	DELETE	`/api/v1/platform-settings/{key}`	reset_setting Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	GET	`/admin`	admin_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/accounts`	admin_accounts_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/ai`	admin_ai_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/ai/guthaben/{topup_id}/gutschrift`	admin_ai_topup_credit_note Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/ai/guthaben/{topup_id}/rechnung`	admin_ai_topup_invoice Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/billing`	admin_billing_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/branche`	admin_industry_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/branche/preview`	admin_industry_preview Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/categories`	categories_admin_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/categories/new`	categories_admin_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/categories/{category_id}/edit`	categories_admin_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/controlling`	admin_controlling_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/currencies`	currencies_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/currencies/new`	currencies_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/currencies/{currency_id}/edit`	currencies_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/documents`	admin_documents_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/geo`	admin_geo_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/journals`	admin_journals_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/number-sequences`	admin_number_sequences_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/number-sequences/new`	number_sequences_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/number-sequences/{sequence_id}/edit`	number_sequences_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/nummernkreise`	admin_number_sequences_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/nummernkreise/new`	number_sequences_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/nummernkreise/{sequence_id}/edit`	number_sequences_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/onboarding/plan`	admin_onboarding_plan Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/org-units`	admin_org_units_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/org-units/new`	admin_org_units_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/org-units/{unit_id}/edit`	admin_org_units_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/payment-terms`	payment_terms_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/payment-terms/new`	payment_terms_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/payment-terms/{term_id}/edit`	payment_terms_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/permissions`	admin_permissions_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/platform-products`	platform_products_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/platform-products/new`	platform_products_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/platform-products/{product_id}/edit`	platform_products_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/portal`	admin_portal_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/profile`	admin_profile_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-advisor`	admin_tax_advisor_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-advisor/check`	admin_tax_advisor_check Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-codes`	tax_codes_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-codes/new`	tax_codes_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-codes/{tax_id}/edit`	tax_codes_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/units`	units_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/units/new`	units_new_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/admin/units/{unit_id}/edit`	units_edit_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/my-permissions`	my_permissions Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/outbox/dead-letters`	list_outbox_dead_letters Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/permissions`	permission_matrix Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/roles`	list_custom_roles Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/roles/{role_id}`	get_custom_role Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units`	list_units Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units/by-user/{user_id}`	user_units Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units/me`	my_units Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units/{unit_id}/members`	unit_members Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products`	list_published_products Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products/all`	list_all_products Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products/meta/agents`	list_available_agents Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products/{product_id}`	get_product Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-settings`	list_settings Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions`	list_subscriptions Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/collections`	The Commission Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/collections.csv`	collections_csv Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/link-info`	link_info Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/{contract_id}`	Other Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/{contract_id}/linked`	related Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/platform`	platform_admin_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/platform/settings`	platform_settings_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/platform/tenants/{org_id}`	platform_tenant_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/subscriptions`	subscriptions_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	GET	`/subscriptions/collections`	subscription_collections_page Semantic binding: not_evaluated; mutation=False	`admin`
⚡ REST API	PATCH	`/api/v1/admin/roles/{role_id}`	update_custom_role Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	PATCH	`/api/v1/org-units/{unit_id}`	update_unit Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	PATCH	`/api/v1/platform-products/{product_id}`	update_product Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts`	admin_add_party_account Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/category`	admin_create_category Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/category/{category_id}`	admin_set_category_accounts Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/category/{category_id}/deactivate`	admin_deactivate_category Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/supplier/{supplier_id}`	admin_set_supplier_account Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/tax`	admin_add_tax_code Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/tax/{tax_code_id}/deactivate`	admin_deactivate_tax_code Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/{account_id}/deactivate`	admin_deactivate_party_account Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/budget`	admin_ai_budget_save Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/budget/topup`	admin_ai_budget_topup Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/checkout`	admin_ai_checkout Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials`	admin_ai_credential_create Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials/{credential_id}/activate`	admin_ai_credential_activate Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials/{credential_id}/delete`	admin_ai_credential_delete Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials/{credential_id}/test`	admin_ai_credential_test Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/storage-topup`	admin_storage_topup Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/billing/checkout`	admin_billing_checkout Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/billing/portal`	admin_billing_portal Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/billing/subscribe`	admin_billing_subscribe Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/branche/apply`	admin_industry_apply Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories`	admin_create_product_category Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/seed-default-fieldsets`	admin_categories_seed_default_fieldsets Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/{category_id}/delete`	admin_delete_product_category Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/{category_id}/edit`	admin_edit_product_category Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/{category_id}/toggle-active`	admin_toggle_active_product_category Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/copy-global`	admin_copy_global_cost_library Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-center`	admin_add_cost_center Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-center/{cost_center_id}`	admin_update_cost_center Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-type`	admin_add_cost_type Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-type-accounts/propose`	admin_propose_cost_type_accounts Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-type/{cost_type_id}`	admin_update_cost_type Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-center`	admin_upsert_global_cost_center Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-center/{center_id}`	admin_update_global_cost_center Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-type`	admin_upsert_global_cost_type Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-type/{type_id}`	admin_update_global_cost_type Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/onboarding/apply`	admin_onboarding_apply Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/onboarding/approve-fieldsets`	admin_onboarding_approve_fieldsets Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/accounts`	admin_portal_account_create Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/accounts/{account_id}/password`	admin_portal_account_password Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/accounts/{account_id}/status`	admin_portal_account_status Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/requests/{request_id}/decide`	admin_portal_request_decide Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/settings`	admin_portal_settings_save Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/profile`	admin_profile_save Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/tax-advisor/apply`	admin_tax_advisor_apply Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/admin/tax-advisor/proposal`	admin_tax_advisor_proposal Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/agents/{agent_name}/toggle`	toggle_agent Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/modules/{module}/toggle`	toggle_module Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/outbox/dead-letters/{event_id}/replay`	replay_outbox_dead_letter Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/roles`	create_custom_role Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/org-units`	create_unit Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products`	create_product Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/propose`	propose_product Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/{product_id}/apply/{tenant_id}`	apply_product_to_tenant Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/{product_id}/publish`	publish_product Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/{product_id}/unpublish`	unpublish_product Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/from-order/{work_order_id}`	from_order Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/link`	The link Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/cancel`	Cancel Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/change-line`	change_line Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/invoice-now`	invoice_now Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/pause`	Pause Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/resume`	The following is the list of the Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/revoke-cancellation`	Revocated Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/platform/tenants/{org_id}/plan`	platform_tenant_plan_set Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/platform/tenants/{org_id}/status`	platform_tenant_status_set Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	POST	`/platform/tenants/{org_id}/topups/{topup_id}/confirm`	platform_tenant_confirm_topup Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/org-units/by-user/{user_id}`	set_user_units Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/org-units/{unit_id}/members`	set_members Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/platform-settings/{key}`	update_setting Semantic binding: not_evaluated; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/subscriptions/{contract_id}/settings`	save_settings Semantic binding: not_evaluated; mutation=True	`admin`
🖥️ WEB-UI	GET	`/login`	The notification page Shows the login form with language selection	Standard
🖥️ WEB-UI	POST	`/login`	Other information Verifies the registration data and starts the meeting	Standard
🖥️ WEB-UI	POST	`/logout`	Other non-commercial Session invalidated and cookies deleted	Standard
⚡ REST API	GET	`/api/v1/auth/me`	Current users Return of profile and entitlements	`authenticated`
⚡ REST API	GET	`/api/v1/admin/industry-profiles`	The following is the list of the relevant sectors: Supplier of available standard sector profiles	`admin:read`
⚡ REST API	POST	`/api/v1/admin/apply-industry-profile`	Applications for the sector Initialised accounts and category sets	`admin:manage`

🛡️ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

Article 32 (security of processing)
BSI IT-basic protection (password guidelines, RLS)

Connected modules:

➔ tenants ➔ employees ➔ policies

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

⚡ Workflows and life cycles

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. user_auth_lifecycle

The following information is provided for in the Annex to this Regulation: plan:command_industry_setup_agent

🗄️ Data models and fields

🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

🛡️ Regulatory and compliance

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. `user_auth_lifecycle`

The following information is provided for in the Annex to this Regulation: `plan:command_industry_setup_agent`