🔐

Administraţia sistemului

admin core_platform 🛡️ RLS Protected

Autentificare centrală, gestionare a sesiunilor, conturi globale de utilizatori și niveluri de autorizare specifice chiriașilor.

Fachliche Bestimmung: Utilizatorii de sistem și organizațiile sunt gestionați conform unui model de identitate de două dimensiuni. Un utilizator poate exista la nivel global și poate fi alocat mai multor clienți (chirieri) cu niveluri de autorizare diferite (0=Nici de acces, 1=citire, 2=scris, 3=administrare).

⚡ Fluxuri de lucru (4) 🗄️ Modele de date & câmpuri (166) 🔌 Puncte de inițiere (UI & API) (183) 🛡️ Reglementări și respectare

⚡ Fluxuri de lucru

Ciclul de viață al autentificării și autorizării `user_auth_lifecycle`

Începerea încercării de a se înregistra, validarea cu parolele și generarea sesiunii, până la legarea cu contextul clientului.

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

Cererea de notificare

Utilizatorul trimite e-mail și parola prin HTTPS POST / login.

Aktionen: Verificarea limitării ratei, În cazul în care se aplică cerințele de la punctul 1.6.1.

2. CREDENTIAL_CHECK

Verificarea cu contrasei

Compensare cu bcrypt/argon2 hash în tabelul utilizatori.

Aktionen: Audit de intrare

3. CONTEXT_BINDING

Obligația pentru client

Determinarea organizaţiei şi a rolului atribuit de utilizatorii organizaţionali.

Aktionen: Sesiunea de suspendare a JWT

4. AUTHENTICATED

Sediul activ

Setarea cookie-ului HttpOnly cu închis în închiriat cu încheietura de text al chiriașului.

Aktionen: Activarea RLS ExecutionContext

Instrucțiune de utilizare: agent de setare industrial `plan:command_industry_setup_agent`

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. industry_setup_agent

industry_setup_agent

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

Aktionen: industry_setup_agent

Benutzerbefehl: integrations consultant agent `plan:command_integrations_consultant_agent`

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. integrations_consultant_agent

integrations_consultant_agent

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

Aktionen: integrations_consultant_agent

Benutzerbefehl: setup consultant agent `plan:command_setup_consultant_agent`

Plan durabil verificat (durable_plan), inițiativă: manual_command.

1. setup_consultant_agent

setup_consultant_agent

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

Aktionen: setup_consultant_agent

🗄️ Modele de date & câmpuri

AccountCodes account_codes RLS Aktiv

14 Câmpuri / coloane

Tabelle account_codes

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`account_type`	`VARCHAR(48)`	Ja *	-	Feld account_type
`description`	`TEXT`	Nein	-	Feld description
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

AiBudgetTopups ai_budget_topups RLS Aktiv

14 Câmpuri / coloane

Tabelle ai_budget_topups

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`kind`	`VARCHAR(16)`	Ja *	-	Feld kind
`package_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld package_amount
`package_gb`	`INTEGER`	Nein	-	Feld package_gb
`created_by`	`UUID`	Nein	-	Feld created_by
`payment_confirmed_at`	`DATETIME`	Nein	-	Feld payment_confirmed_at
`operator_invoice_id`	`UUID`	Nein	-	Feld operator_invoice_id
`operator_invoice_document_id`	`UUID`	Nein	-	Feld operator_invoice_document_id
`refunded_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld refunded_amount
`operator_credit_note_id`	`UUID`	Nein	-	Feld operator_credit_note_id
`operator_credit_note_document_id`	`UUID`	Nein	-	Feld operator_credit_note_document_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

AiUsage ai_usage RLS Aktiv

20 Câmpuri / coloane

Tabelle ai_usage

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`agent_run_id`	`UUID`	Nein	FK ➔ agent_runs.id	Feld agent_run_id
`provider`	`VARCHAR(32)`	Ja *	-	Feld provider
`model`	`VARCHAR(64)`	Ja *	-	Feld model
`operation`	`VARCHAR(32)`	Ja *	-	Feld operation
`input_tokens`	`INTEGER`	Ja *	-	Feld input_tokens
`output_tokens`	`INTEGER`	Ja *	-	Feld output_tokens
`pages`	`INTEGER`	Ja *	-	Feld pages
`cost`	`NUMERIC(10, 6)`	Ja *	-	Feld cost
`duration_ms`	`INTEGER`	Nein	-	Feld duration_ms
`provider_request_id`	`VARCHAR(160)`	Nein	-	Feld provider_request_id
`cost_source`	`VARCHAR(32)`	Ja *	-	Feld cost_source
`provider_usage`	`JSONB`	Ja *	-	Feld provider_usage
`period`	`VARCHAR(7)`	Ja *	-	Feld period
`billable_amount`	`NUMERIC(14, 6)`	Ja *	-	Feld billable_amount
`markup_rate`	`NUMERIC(7, 4)`	Ja *	-	Feld markup_rate
`is_byok`	`BOOLEAN`	Ja *	-	Feld is_byok
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

ApiConnectors api_connectors RLS Aktiv

21 Câmpuri / coloane

Tabelle api_connectors

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`base_url`	`VARCHAR(2048)`	Ja *	-	Feld base_url
`auth_type`	`VARCHAR(32)`	Ja *	-	Feld auth_type
`auth_config`	`JSONB`	Ja *	-	Feld auth_config
`secret_encrypted`	`TEXT`	Nein	-	Feld secret_encrypted
`source`	`VARCHAR(16)`	Ja *	-	Feld source
`spec_hash`	`VARCHAR(64)`	Nein	-	Feld spec_hash
`version`	`INTEGER`	Ja *	-	Feld version
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`execution_allowed`	`BOOLEAN`	Ja *	-	Feld execution_allowed
`host_ok`	`BOOLEAN`	Ja *	-	Feld host_ok
`description`	`VARCHAR(512)`	Nein	-	Feld description
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

AuditLogs audit_logs RLS Aktiv

14 Câmpuri / coloane

Tabelle audit_logs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`actor_type`	`VARCHAR(16)`	Ja *	-	Feld actor_type
`actor_id`	`UUID`	Nein	-	Feld actor_id
`action`	`VARCHAR(64)`	Ja *	-	Feld action
`entity_type`	`VARCHAR(64)`	Ja *	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`before_data`	`JSONB`	Nein	-	Feld before_data
`after_data`	`JSONB`	Nein	-	Feld after_data
`timestamp`	`DATETIME`	Ja *	-	Feld timestamp
`ip_address`	`INET`	Nein	-	Feld ip_address
`user_agent`	`VARCHAR(512)`	Nein	-	Feld user_agent
`agent_run_id`	`UUID`	Nein	FK ➔ agent_runs.id	Feld agent_run_id
`correlation_id`	`UUID`	Nein	-	Feld correlation_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id

BankAccounts bank_accounts RLS Aktiv

20 Câmpuri / coloane

Tabelle bank_accounts

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`bank_id`	`UUID`	Nein	FK ➔ banks.id	Feld bank_id
`label`	`VARCHAR(255)`	Ja *	-	Feld label
`iban`	`VARCHAR(34)`	Nein	-	Feld iban
`bic`	`VARCHAR(11)`	Nein	-	Feld bic
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`account_holder`	`VARCHAR(255)`	Nein	-	Feld account_holder
`account_kind`	`VARCHAR(16)`	Ja *	-	Feld account_kind
`gl_account_code`	`VARCHAR(32)`	Nein	-	Feld gl_account_code
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Banks banks RLS Aktiv

14 Câmpuri / coloane

Tabelle banks

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`bic`	`VARCHAR(11)`	Nein	-	Feld bic
`country_code`	`VARCHAR(2)`	Ja *	-	Feld country_code
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

BusinessRequirements business_requirements RLS Aktiv

14 Câmpuri / coloane

Tabelle business_requirements

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`case_id`	`UUID`	Ja *	FK ➔ consultant_cases.id	Feld case_id
`key`	`VARCHAR(96)`	Ja *	-	Feld key
`statement`	`TEXT`	Ja *	-	Feld statement
`interpretation`	`TEXT`	Ja *	-	Feld interpretation
`source`	`VARCHAR(64)`	Ja *	-	Feld source
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`valid_until`	`DATETIME`	Nein	-	Feld valid_until
`contradictions`	`JSONB`	Ja *	-	Feld contradictions
`parameters`	`JSONB`	Ja *	-	Feld parameters
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ consultant_cases.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

CategoryAttributeBindings category_attribute_bindings RLS Aktiv

12 Câmpuri / coloane

Tabelle category_attribute_bindings

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`category_id`	`UUID`	Ja *	FK ➔ product_categories.id	Feld category_id
`field_key`	`VARCHAR(128)`	Ja *	-	Feld field_key
`fieldset_group`	`VARCHAR(64)`	Ja *	-	Feld fieldset_group
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`is_required`	`BOOLEAN`	Ja *	-	Feld is_required
`inherit_to_children`	`BOOLEAN`	Ja *	-	Feld inherit_to_children
`variant_role`	`VARCHAR(48)`	Ja *	-	Feld variant_role
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

CategoryFieldsetActivations category_fieldset_activations RLS Aktiv

11 Câmpuri / coloane

Tabelle category_fieldset_activations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`category_id`	`UUID`	Ja *	FK ➔ product_categories.id	Feld category_id
`revision_id`	`UUID`	Ja *	FK ➔ category_fieldset_revisions.id	Feld revision_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ category_fieldset_revisions.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

CategoryFieldsetRevisions category_fieldset_revisions RLS Aktiv

17 Câmpuri / coloane

Tabelle category_fieldset_revisions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`category_id`	`UUID`	Ja *	FK ➔ product_categories.id	Feld category_id
`version`	`INTEGER`	Ja *	-	Feld version
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`snapshot`	`JSONB`	Ja *	-	Feld snapshot
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`simulation_result`	`JSONB`	Nein	-	Feld simulation_result
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConnectorBindings connector_bindings RLS Aktiv

20 Câmpuri / coloane

Tabelle connector_bindings

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`connector_id`	`UUID`	Ja *	FK ➔ api_connectors.id	Feld connector_id
`direction`	`VARCHAR(16)`	Ja *	-	Feld direction
`signal_key`	`VARCHAR(128)`	Ja *	-	Feld signal_key
`operation_id`	`UUID`	Nein	FK ➔ connector_operations.id	Feld operation_id
`target_capability_key`	`VARCHAR(128)`	Nein	-	Feld target_capability_key
`inbound_endpoint_id`	`UUID`	Nein	FK ➔ inbound_webhook_endpoints.id	Feld inbound_endpoint_id
`field_mappings`	`JSONB`	Ja *	-	Feld field_mappings
`response_signal_key`	`VARCHAR(128)`	Nein	-	Feld response_signal_key
`inbound_schema`	`JSONB`	Ja *	-	Feld inbound_schema
`active`	`BOOLEAN`	Ja *	-	Feld active
`description`	`VARCHAR(255)`	Nein	-	Feld description
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConnectorDeliveries connector_deliveries RLS Aktiv

21 Câmpuri / coloane

Tabelle connector_deliveries

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`binding_id`	`UUID`	Nein	FK ➔ connector_bindings.id	Feld binding_id
`operation_id`	`UUID`	Ja *	FK ➔ connector_operations.id	Feld operation_id
`signal_key`	`VARCHAR(128)`	Nein	-	Feld signal_key
`request_payload`	`JSONB`	Ja *	-	Feld request_payload
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`attempt_count`	`INTEGER`	Ja *	-	Feld attempt_count
`next_attempt_at`	`DATETIME`	Nein	-	Feld next_attempt_at
`last_error`	`TEXT`	Nein	-	Feld last_error
`response_status`	`INTEGER`	Nein	-	Feld response_status
`response_body`	`TEXT`	Nein	-	Feld response_body
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`delivered_at`	`DATETIME`	Nein	-	Feld delivered_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConnectorOperations connector_operations RLS Aktiv

22 Câmpuri / coloane

Tabelle connector_operations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`connector_id`	`UUID`	Ja *	FK ➔ api_connectors.id	Feld connector_id
`operation_key`	`VARCHAR(128)`	Ja *	-	Feld operation_key
`method`	`VARCHAR(8)`	Ja *	-	Feld method
`path_template`	`VARCHAR(1024)`	Ja *	-	Feld path_template
`summary`	`VARCHAR(512)`	Nein	-	Feld summary
`parameters_schema`	`JSONB`	Ja *	-	Feld parameters_schema
`request_schema`	`JSONB`	Ja *	-	Feld request_schema
`response_schema`	`JSONB`	Ja *	-	Feld response_schema
`idempotency_header`	`VARCHAR(128)`	Nein	-	Feld idempotency_header
`timeout_seconds`	`INTEGER`	Ja *	-	Feld timeout_seconds
`risk_level`	`VARCHAR(32)`	Ja *	-	Feld risk_level
`selected`	`BOOLEAN`	Ja *	-	Feld selected
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConsultantCases consultant_cases RLS Aktiv

21 Câmpuri / coloane

Tabelle consultant_cases

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`mandate_id`	`UUID`	Ja *	FK ➔ consultant_mandates.id	Feld mandate_id
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`trigger_kind`	`VARCHAR(32)`	Ja *	-	Feld trigger_kind
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`priority`	`INTEGER`	Ja *	-	Feld priority
`domains`	`JSONB`	Ja *	-	Feld domains
`object_keys`	`JSONB`	Ja *	-	Feld object_keys
`process_keys`	`JSONB`	Ja *	-	Feld process_keys
`correlation_key`	`VARCHAR(160)`	Ja *	-	Feld correlation_key
`summary`	`JSONB`	Ja *	-	Feld summary
`baseline_plan_id`	`UUID`	Nein	FK ➔ consultant_plans.id	Feld baseline_plan_id
`closed_at`	`DATETIME`	Nein	-	Feld closed_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ consultant_mandates.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConsultantEvidence consultant_evidence RLS Aktiv

10 Câmpuri / coloane

Tabelle consultant_evidence

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`plan_id`	`UUID`	Ja *	FK ➔ consultant_plans.id	Feld plan_id
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`summary`	`JSONB`	Ja *	-	Feld summary
`actor_id`	`UUID`	Nein	-	Feld actor_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ consultant_plans.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConsultantMandates consultant_mandates RLS Aktiv

20 Câmpuri / coloane

Tabelle consultant_mandates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`label`	`VARCHAR(255)`	Ja *	-	Feld label
`autonomy_level`	`VARCHAR(24)`	Ja *	-	Feld autonomy_level
`domain_scope`	`JSONB`	Ja *	-	Feld domain_scope
`observation_sources`	`JSONB`	Ja *	-	Feld observation_sources
`owner_user_id`	`UUID`	Ja *	-	Feld owner_user_id
`version`	`INTEGER`	Ja *	-	Feld version
`rate_limit_per_day`	`INTEGER`	Ja *	-	Feld rate_limit_per_day
`privacy_bounds`	`JSONB`	Ja *	-	Feld privacy_bounds
`revoked_at`	`DATETIME`	Nein	-	Feld revoked_at
`revoked_by`	`UUID`	Nein	-	Feld revoked_by
`revoke_reason`	`TEXT`	Nein	-	Feld revoke_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConsultantObservations consultant_observations RLS Aktiv

12 Câmpuri / coloane

Tabelle consultant_observations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`case_id`	`UUID`	Ja *	FK ➔ consultant_cases.id	Feld case_id
`source_kind`	`VARCHAR(48)`	Ja *	-	Feld source_kind
`source_ref`	`VARCHAR(160)`	Nein	-	Feld source_ref
`confidence`	`VARCHAR(16)`	Ja *	-	Feld confidence
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`access_label`	`VARCHAR(64)`	Ja *	-	Feld access_label
`payload`	`JSONB`	Ja *	-	Feld payload
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConsultantPlans consultant_plans RLS Aktiv

18 Câmpuri / coloane

Tabelle consultant_plans

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`kind`	`VARCHAR(32)`	Ja *	-	Feld kind
`version`	`INTEGER`	Ja *	-	Feld version
`industry_key`	`VARCHAR(64)`	Ja *	-	Feld industry_key
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`proposal_hash`	`VARCHAR(64)`	Ja *	-	Feld proposal_hash
`snapshot`	`JSONB`	Ja *	-	Feld snapshot
`simulated_at`	`DATETIME`	Nein	-	Feld simulated_at
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`approved_by`	`UUID`	Nein	-	Feld approved_by
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ConsultantSteps consultant_steps RLS Aktiv

13 Câmpuri / coloane

Tabelle consultant_steps

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`plan_id`	`UUID`	Ja *	FK ➔ consultant_plans.id	Feld plan_id
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`key`	`VARCHAR(96)`	Ja *	-	Feld key
`label`	`VARCHAR(255)`	Ja *	-	Feld label
`state`	`VARCHAR(24)`	Ja *	-	Feld state
`source`	`VARCHAR(255)`	Ja *	-	Feld source
`description`	`TEXT`	Nein	-	Feld description
`approval_required`	`BOOLEAN`	Ja *	-	Feld approval_required
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

Contacts contacts RLS Aktiv

24 Câmpuri / coloane

Tabelle contacts

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`parent_contact_id`	`UUID`	Nein	FK ➔ contacts.id	Feld parent_contact_id
`first_name`	`VARCHAR(128)`	Nein	-	Feld first_name
`last_name`	`VARCHAR(128)`	Nein	-	Feld last_name
`email`	`VARCHAR(320)`	Nein	-	Feld email
`phone`	`VARCHAR(64)`	Nein	-	Feld phone
`mobile`	`VARCHAR(64)`	Nein	-	Feld mobile
`fax`	`VARCHAR(64)`	Nein	-	Feld fax
`role`	`VARCHAR(128)`	Nein	-	Feld role
`department`	`VARCHAR(128)`	Nein	-	Feld department
`job_title`	`VARCHAR(128)`	Nein	-	Feld job_title
`is_primary`	`BOOLEAN`	Ja *	-	Feld is_primary
`birthday`	`DATE`	Nein	-	Feld birthday
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

CostCenters cost_centers RLS Aktiv

17 Câmpuri / coloane

Tabelle cost_centers

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(64)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`active`	`BOOLEAN`	Ja *	-	Feld active
`kind`	`VARCHAR(12)`	Ja *	-	Feld kind
`sort_order`	`INTEGER`	Ja *	-	Feld sort_order
`surcharge_base`	`VARCHAR(16)`	Nein	-	Feld surcharge_base
`normal_surcharge_percent`	`NUMERIC(8, 2)`	Nein	-	Feld normal_surcharge_percent
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

CostEntries cost_entries RLS Aktiv

22 Câmpuri / coloane

Tabelle cost_entries

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`cost_type_id`	`UUID`	Nein	FK ➔ cost_types.id	Feld cost_type_id
`cost_center_id`	`UUID`	Nein	FK ➔ cost_centers.id	Feld cost_center_id
`source_type`	`VARCHAR(32)`	Ja *	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`quantity`	`NUMERIC(14, 4)`	Nein	-	Feld quantity
`unit`	`VARCHAR(16)`	Nein	-	Feld unit
`unit_cost`	`NUMERIC(14, 2)`	Nein	-	Feld unit_cost
`amount`	`NUMERIC(14, 2)`	Ja *	-	Feld amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`estimated`	`BOOLEAN`	Ja *	-	Feld estimated
`description`	`TEXT`	Ja *	-	Feld description
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`metadata`	`JSONB`	Ja *	-	Feld metadata

CostTypes cost_types RLS Aktiv

15 Câmpuri / coloane

Tabelle cost_types

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(64)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`active`	`BOOLEAN`	Ja *	-	Feld active
`account_code`	`VARCHAR(32)`	Nein	-	Feld account_code
`default_cost_center_id`	`UUID`	Nein	FK ➔ cost_centers.id	Feld default_cost_center_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

CustomizationChangeSets customization_change_sets RLS Aktiv

22 Câmpuri / coloane

Tabelle customization_change_sets

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`case_id`	`UUID`	Ja *	FK ➔ consultant_cases.id	Feld case_id
`version`	`INTEGER`	Ja *	-	Feld version
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`intent_key`	`VARCHAR(96)`	Ja *	-	Feld intent_key
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`risk_class`	`VARCHAR(16)`	Ja *	-	Feld risk_class
`target_state`	`JSONB`	Ja *	-	Feld target_state
`baseline_hashes`	`JSONB`	Ja *	-	Feld baseline_hashes
`capability_hashes`	`JSONB`	Ja *	-	Feld capability_hashes
`dependencies`	`JSONB`	Ja *	-	Feld dependencies
`gaps`	`JSONB`	Ja *	-	Feld gaps
`activation_plan`	`JSONB`	Ja *	-	Feld activation_plan
`rollback_plan`	`JSONB`	Ja *	-	Feld rollback_plan
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

CustomizationEvidence customization_evidence RLS Aktiv

10 Câmpuri / coloane

Tabelle customization_evidence

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`change_set_id`	`UUID`	Ja *	FK ➔ customization_change_sets.id	Feld change_set_id
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`summary`	`JSONB`	Ja *	-	Feld summary
`actor_id`	`UUID`	Nein	-	Feld actor_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ customization_change_sets.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

CustomizationSteps customization_steps RLS Aktiv

14 Câmpuri / coloane

Tabelle customization_steps

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`change_set_id`	`UUID`	Ja *	FK ➔ customization_change_sets.id	Feld change_set_id
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`key`	`VARCHAR(96)`	Ja *	-	Feld key
`label`	`VARCHAR(255)`	Ja *	-	Feld label
`kind`	`VARCHAR(32)`	Ja *	-	Feld kind
`state`	`VARCHAR(24)`	Ja *	-	Feld state
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`approval_required`	`BOOLEAN`	Ja *	-	Feld approval_required
`payload`	`JSONB`	Ja *	-	Feld payload
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

Demands demands RLS Aktiv

23 Câmpuri / coloane

Tabelle demands

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`demand_type`	`VARCHAR(48)`	Ja *	-	Feld demand_type
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`description`	`TEXT`	Nein	-	Feld description
`project_id`	`UUID`	Nein	-	Feld project_id
`work_order_id`	`UUID`	Nein	-	Feld work_order_id
`product_id`	`UUID`	Nein	-	Feld product_id
`quantity`	`NUMERIC(14, 4)`	Nein	-	Feld quantity
`unit`	`VARCHAR(16)`	Nein	-	Feld unit
`location`	`VARCHAR(255)`	Nein	-	Feld location
`required_from`	`DATE`	Nein	-	Feld required_from
`required_until`	`DATE`	Nein	-	Feld required_until
`budget`	`NUMERIC(14, 2)`	Nein	-	Feld budget
`visibility`	`VARCHAR(16)`	Ja *	-	Feld visibility
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

DomainEvents domain_events RLS Aktiv

18 Câmpuri / coloane

Tabelle domain_events

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`event_type`	`VARCHAR(64)`	Ja *	-	Feld event_type
`entity_type`	`VARCHAR(64)`	Ja *	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`payload`	`JSONB`	Ja *	-	Feld payload
`actor_type`	`VARCHAR(16)`	Ja *	-	Feld actor_type
`actor_id`	`UUID`	Nein	-	Feld actor_id
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`correlation_id`	`UUID`	Nein	-	Feld correlation_id
`causation_id`	`UUID`	Nein	-	Feld causation_id
`workflow_origin_run_id`	`UUID`	Nein	FK ➔ workflow_runs.id	Feld workflow_origin_run_id
`published_at`	`DATETIME`	Nein	-	Feld published_at
`dispatch_attempts`	`INTEGER`	Ja *	-	Feld dispatch_attempts
`next_dispatch_at`	`DATETIME`	Ja *	-	Feld next_dispatch_at
`dead_letter_at`	`DATETIME`	Nein	-	Feld dead_letter_at
`last_dispatch_error_code`	`VARCHAR(120)`	Nein	-	Feld last_dispatch_error_code
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ workflow_runs.tenant_id	Feld tenant_id

EcommerceChannels ecommerce_channels RLS Aktiv

22 Câmpuri / coloane

Tabelle ecommerce_channels

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`slug`	`VARCHAR(64)`	Ja *	-	Feld slug
`platform`	`VARCHAR(32)`	Ja *	-	Feld platform
`api_url`	`VARCHAR(255)`	Nein	-	Feld api_url
`credentials_encrypted`	`TEXT`	Ja *	-	Feld credentials_encrypted
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`sync_inventory`	`BOOLEAN`	Ja *	-	Feld sync_inventory
`auto_create_order`	`BOOLEAN`	Ja *	-	Feld auto_create_order
`settings`	`JSONB`	Ja *	-	Feld settings
`last_sync_at`	`DATETIME`	Nein	-	Feld last_sync_at
`last_sync_status`	`VARCHAR(32)`	Nein	-	Feld last_sync_status
`last_error`	`VARCHAR(500)`	Nein	-	Feld last_error
`api_connector_id`	`UUID`	Nein	FK ➔ api_connectors.id	Feld api_connector_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

EcommerceOrderSyncs ecommerce_order_syncs RLS Aktiv

21 Câmpuri / coloane

Tabelle ecommerce_order_syncs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`channel_id`	`UUID`	Ja *	FK ➔ ecommerce_channels.id	Feld channel_id
`external_order_id`	`VARCHAR(128)`	Ja *	-	Feld external_order_id
`idempotency_hash`	`VARCHAR(64)`	Ja *	-	Feld idempotency_hash
`webhook_delivery_id`	`VARCHAR(128)`	Nein	-	Feld webhook_delivery_id
`sync_status`	`VARCHAR(32)`	Ja *	-	Feld sync_status
`quote_id`	`UUID`	Nein	FK ➔ quotes.id	Feld quote_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`order_amount`	`NUMERIC(14, 2)`	Nein	-	Feld order_amount
`order_currency`	`VARCHAR(3)`	Ja *	-	Feld order_currency
`payload_snapshot`	`JSONB`	Ja *	-	Feld payload_snapshot
`error_message`	`VARCHAR(500)`	Nein	-	Feld error_message
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ExchangeRates exchange_rates RLS Aktiv

13 Câmpuri / coloane

Tabelle exchange_rates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`rate_date`	`DATE`	Ja *	-	Feld rate_date
`rate`	`NUMERIC(18, 8)`	Ja *	-	Feld rate
`note`	`VARCHAR(255)`	Nein	-	Feld note
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ExportBatches export_batches RLS Aktiv

24 Câmpuri / coloane

Tabelle export_batches

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`profile_id`	`UUID`	Nein	FK ➔ export_profiles.id	Feld profile_id
`period_from`	`DATE`	Nein	-	Feld period_from
`period_to`	`DATE`	Nein	-	Feld period_to
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`artifact_storage_key`	`VARCHAR(1024)`	Nein	-	Feld artifact_storage_key
`artifact_filename`	`VARCHAR(512)`	Nein	-	Feld artifact_filename
`artifact_size_bytes`	`INTEGER`	Nein	-	Feld artifact_size_bytes
`artifact_mime_type`	`VARCHAR(128)`	Nein	-	Feld artifact_mime_type
`item_count`	`INTEGER`	Ja *	-	Feld item_count
`net_total`	`NUMERIC`	Ja *	-	Feld net_total
`tax_total`	`NUMERIC`	Ja *	-	Feld tax_total
`gross_total`	`NUMERIC`	Ja *	-	Feld gross_total
`exported_at`	`DATETIME`	Nein	-	Feld exported_at
`error_message`	`TEXT`	Nein	-	Feld error_message
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ExportItems export_items RLS Aktiv

11 Câmpuri / coloane

Tabelle export_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`export_batch_id`	`UUID`	Ja *	FK ➔ export_batches.id	Feld export_batch_id
`accounting_entry_id`	`UUID`	Ja *	FK ➔ accounting_entries.id	Feld accounting_entry_id
`document_id`	`UUID`	Nein	FK ➔ documents.id	Feld document_id
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`row_data`	`JSONB`	Nein	-	Feld row_data
`error_message`	`TEXT`	Nein	-	Feld error_message
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ExportProfiles export_profiles RLS Aktiv

13 Câmpuri / coloane

Tabelle export_profiles

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`target`	`VARCHAR(48)`	Ja *	-	Feld target
`settings`	`JSONB`	Ja *	-	Feld settings
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ExtraWorkCandidates extra_work_candidates RLS Aktiv

21 Câmpuri / coloane

Tabelle extra_work_candidates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`quote_id`	`UUID`	Nein	FK ➔ quotes.id	Feld quote_id
`description`	`TEXT`	Ja *	-	Feld description
`evidence`	`TEXT`	Nein	-	Feld evidence
`estimated_quantity`	`NUMERIC(14, 4)`	Nein	-	Feld estimated_quantity
`unit`	`VARCHAR(16)`	Nein	-	Feld unit
`estimated_price`	`NUMERIC(14, 2)`	Nein	-	Feld estimated_price
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`confidence`	`NUMERIC(4, 3)`	Nein	-	Feld confidence
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

FieldActivities field_activities RLS Aktiv

18 Câmpuri / coloane

Tabelle field_activities

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`asset_id`	`UUID`	Ja *	FK ➔ assets.id	Feld asset_id
`activity_date`	`DATE`	Ja *	-	Feld activity_date
`activity_type`	`VARCHAR(48)`	Ja *	-	Feld activity_type
`crop`	`VARCHAR(128)`	Nein	-	Feld crop
`product_name`	`VARCHAR(255)`	Nein	-	Feld product_name
`product_quantity`	`NUMERIC(14, 4)`	Nein	-	Feld product_quantity
`product_unit`	`VARCHAR(32)`	Nein	-	Feld product_unit
`area_treated_ha`	`NUMERIC(14, 4)`	Nein	-	Feld area_treated_ha
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

GaebDocuments gaeb_documents RLS Aktiv

21 Câmpuri / coloane

Tabelle gaeb_documents

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`quote_id`	`UUID`	Nein	FK ➔ quotes.id	Feld quote_id
`file_name`	`VARCHAR(255)`	Ja *	-	Feld file_name
`gaeb_phase`	`VARCHAR(10)`	Ja *	-	Feld gaeb_phase
`gaeb_version`	`VARCHAR(20)`	Ja *	-	Feld gaeb_version
`project_name`	`VARCHAR(255)`	Ja *	-	Feld project_name
`dp_number`	`VARCHAR(128)`	Nein	-	Feld dp_number
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`total_net_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld total_net_amount
`total_tax_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld total_tax_amount
`total_gross_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld total_gross_amount
`xml_payload_raw`	`TEXT`	Ja *	-	Feld xml_payload_raw
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

GaebItems gaeb_items RLS Aktiv

23 Câmpuri / coloane

Tabelle gaeb_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`document_id`	`UUID`	Ja *	FK ➔ gaeb_documents.id	Feld document_id
`section_id`	`UUID`	Ja *	FK ➔ gaeb_sections.id	Feld section_id
`oz`	`VARCHAR(32)`	Ja *	-	Feld oz
`item_type`	`VARCHAR(32)`	Ja *	-	Feld item_type
`short_text`	`VARCHAR(500)`	Ja *	-	Feld short_text
`long_text`	`TEXT`	Nein	-	Feld long_text
`quantity`	`NUMERIC(12, 3)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_price`	`NUMERIC(14, 2)`	Ja *	-	Feld unit_price
`total_price`	`NUMERIC(14, 2)`	Ja *	-	Feld total_price
`vat_rate`	`NUMERIC(5, 2)`	Nein	-	Feld vat_rate
`is_discountable`	`BOOLEAN`	Ja *	-	Feld is_discountable
`internal_product_id`	`UUID`	Nein	FK ➔ products.id	Feld internal_product_id
`match_confidence`	`NUMERIC(3, 2)`	Nein	-	Feld match_confidence
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

GaebSections gaeb_sections RLS Aktiv

16 Câmpuri / coloane

Tabelle gaeb_sections

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`document_id`	`UUID`	Ja *	FK ➔ gaeb_documents.id	Feld document_id
`parent_section_id`	`UUID`	Nein	FK ➔ gaeb_sections.id	Feld parent_section_id
`order_index`	`INTEGER`	Ja *	-	Feld order_index
`section_code`	`VARCHAR(64)`	Ja *	-	Feld section_code
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`description`	`TEXT`	Nein	-	Feld description
`subtotal_net`	`NUMERIC(14, 2)`	Ja *	-	Feld subtotal_net
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

GlobalCostCenters global_cost_centers

8 Câmpuri / coloane

Tabelle global_cost_centers

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(64)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`active`	`BOOLEAN`	Ja *	-	Feld active
`sort_order`	`INTEGER`	Ja *	-	Feld sort_order
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

GlobalCostTypes global_cost_types

9 Câmpuri / coloane

Tabelle global_cost_types

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(64)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`active`	`BOOLEAN`	Ja *	-	Feld active
`suggested_account_code`	`VARCHAR(32)`	Nein	-	Feld suggested_account_code
`sort_order`	`INTEGER`	Ja *	-	Feld sort_order
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

GoodsReceiptItems goods_receipt_items RLS Aktiv

25 Câmpuri / coloane

Tabelle goods_receipt_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`goods_receipt_id`	`UUID`	Ja *	FK ➔ goods_receipts.id	Feld goods_receipt_id
`purchase_item_id`	`UUID`	Nein	FK ➔ purchase_items.id	Feld purchase_item_id
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`description`	`TEXT`	Ja *	-	Feld description
`quantity_received`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_received
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_cost`	`NUMERIC(14, 2)`	Ja *	-	Feld unit_cost
`tax_rate`	`NUMERIC(6, 4)`	Ja *	-	Feld tax_rate
`net_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld net_amount
`tax_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld tax_amount
`gross_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld gross_amount
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`quantity_accepted`	`NUMERIC(14, 4)`	Nein	-	Feld quantity_accepted
`quantity_rejected`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_rejected
`rejection_reason`	`TEXT`	Nein	-	Feld rejection_reason
`stock_owner`	`VARCHAR(32)`	Ja *	-	Feld stock_owner
`consignment_contract_id`	`UUID`	Nein	FK ➔ contracts.id	Feld consignment_contract_id
`destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld destination_location_id
`tracking_entries`	`JSONB`	Ja *	-	Feld tracking_entries
`confidence`	`NUMERIC(4, 3)`	Nein	-	Feld confidence
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

GoodsReceipts goods_receipts RLS Aktiv

30 Câmpuri / coloane

Tabelle goods_receipts

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`receipt_number`	`VARCHAR(32)`	Ja *	-	Feld receipt_number
`purchase_id`	`UUID`	Nein	FK ➔ purchases.id	Feld purchase_id
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`invoice_id`	`UUID`	Nein	FK ➔ invoices.id	Feld invoice_id
`received_at`	`DATETIME`	Ja *	-	Feld received_at
`destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld destination_location_id
`delivery_note_number`	`VARCHAR(128)`	Nein	-	Feld delivery_note_number
`delivery_note_date`	`DATE`	Nein	-	Feld delivery_note_date
`carrier`	`VARCHAR(128)`	Nein	-	Feld carrier
`tracking_number`	`VARCHAR(128)`	Nein	-	Feld tracking_number
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`contract_id`	`UUID`	Nein	FK ➔ contracts.id	Feld contract_id
`procurement_type`	`VARCHAR(32)`	Ja *	-	Feld procurement_type
`inspection_status`	`VARCHAR(32)`	Ja *	-	Feld inspection_status
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`net_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld net_amount
`tax_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld tax_amount
`gross_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld gross_amount
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`notes`	`TEXT`	Nein	-	Feld notes
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ImportBatchRecords import_batch_records RLS Aktiv

11 Câmpuri / coloane

Tabelle import_batch_records

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`job_id`	`UUID`	Ja *	FK ➔ import_jobs.id	Feld job_id
`batch_id`	`UUID`	Ja *	-	Feld batch_id
`entity_type`	`VARCHAR(64)`	Ja *	-	Feld entity_type
`entity_id`	`UUID`	Ja *	-	Feld entity_id
`action`	`VARCHAR(16)`	Ja *	-	Feld action
`snapshot_before`	`JSONB`	Nein	-	Feld snapshot_before
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ImportJobs import_jobs RLS Aktiv

27 Câmpuri / coloane

Tabelle import_jobs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`target_entity`	`VARCHAR(64)`	Ja *	-	Feld target_entity
`source_type`	`VARCHAR(32)`	Ja *	-	Feld source_type
`filename`	`VARCHAR(255)`	Ja *	-	Feld filename
`file_hash`	`VARCHAR(64)`	Ja *	-	Feld file_hash
`status`	`VARCHAR(32)`	Ja *	-	Feld status
`total_rows`	`INTEGER`	Ja *	-	Feld total_rows
`valid_rows`	`INTEGER`	Ja *	-	Feld valid_rows
`error_rows`	`INTEGER`	Ja *	-	Feld error_rows
`created_count`	`INTEGER`	Ja *	-	Feld created_count
`updated_count`	`INTEGER`	Ja *	-	Feld updated_count
`batch_id`	`UUID`	Ja *	-	Feld batch_id
`field_mapping`	`JSONB`	Ja *	-	Feld field_mapping
`dry_run_summary`	`JSONB`	Ja *	-	Feld dry_run_summary
`error_details`	`JSONB`	Ja *	-	Feld error_details
`raw_data_storage`	`JSONB`	Ja *	-	Feld raw_data_storage
`profile_id`	`UUID`	Nein	FK ➔ import_profiles.id	Feld profile_id
`applied_by_user_id`	`UUID`	Nein	-	Feld applied_by_user_id
`applied_at`	`DATETIME`	Nein	-	Feld applied_at
`rolled_back_at`	`DATETIME`	Nein	-	Feld rolled_back_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ImportProfiles import_profiles RLS Aktiv

14 Câmpuri / coloane

Tabelle import_profiles

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`target_entity`	`VARCHAR(64)`	Ja *	-	Feld target_entity
`source_type`	`VARCHAR(32)`	Ja *	-	Feld source_type
`field_mapping`	`JSONB`	Ja *	-	Feld field_mapping
`transformation_rules`	`JSONB`	Ja *	-	Feld transformation_rules
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

InboundWebhookEndpoints inbound_webhook_endpoints RLS Aktiv

15 Câmpuri / coloane

Tabelle inbound_webhook_endpoints

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`token`	`VARCHAR(64)`	Ja *	-	Feld token
`secret_encrypted`	`TEXT`	Nein	-	Feld secret_encrypted
`emits_signal_key`	`VARCHAR(128)`	Ja *	-	Feld emits_signal_key
`active`	`BOOLEAN`	Ja *	-	Feld active
`description`	`VARCHAR(255)`	Nein	-	Feld description
`created_by`	`UUID`	Nein	-	Feld created_by
`last_received_at`	`DATETIME`	Nein	-	Feld last_received_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

InboundWebhookReceipts inbound_webhook_receipts RLS Aktiv

14 Câmpuri / coloane

Tabelle inbound_webhook_receipts

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`endpoint_id`	`UUID`	Ja *	FK ➔ inbound_webhook_endpoints.id	Feld endpoint_id
`received_at`	`DATETIME`	Ja *	-	Feld received_at
`raw_payload`	`JSONB`	Ja *	-	Feld raw_payload
`signature_valid`	`BOOLEAN`	Nein	-	Feld signature_valid
`emitted_signal`	`BOOLEAN`	Ja *	-	Feld emitted_signal
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

InsurancePolicies insurance_policies RLS Aktiv

22 Câmpuri / coloane

Tabelle insurance_policies

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`policy_number`	`VARCHAR(64)`	Ja *	-	Feld policy_number
`insurer`	`VARCHAR(255)`	Ja *	-	Feld insurer
`coverage_type`	`VARCHAR(64)`	Ja *	-	Feld coverage_type
`coverage_desc`	`TEXT`	Nein	-	Feld coverage_desc
`valid_from`	`DATE`	Nein	-	Feld valid_from
`valid_until`	`DATE`	Nein	-	Feld valid_until
`premium_amount`	`NUMERIC(14, 2)`	Nein	-	Feld premium_amount
`deductible`	`NUMERIC(14, 2)`	Nein	-	Feld deductible
`asset_id`	`UUID`	Nein	FK ➔ assets.id	Feld asset_id
`vehicle_id`	`UUID`	Nein	FK ➔ fleet_vehicles.id	Feld vehicle_id
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`reminder_days`	`INTEGER`	Ja *	-	Feld reminder_days
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Jobs jobs RLS Aktiv

17 Câmpuri / coloane

Tabelle jobs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`job_type`	`VARCHAR(64)`	Ja *	-	Feld job_type
`payload`	`JSONB`	Ja *	-	Feld payload
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`run_after`	`DATETIME`	Ja *	-	Feld run_after
`attempts`	`INTEGER`	Ja *	-	Feld attempts
`max_attempts`	`INTEGER`	Ja *	-	Feld max_attempts
`locked_at`	`DATETIME`	Nein	-	Feld locked_at
`locked_by`	`VARCHAR(64)`	Nein	-	Feld locked_by
`finished_at`	`DATETIME`	Nein	-	Feld finished_at
`last_error`	`TEXT`	Nein	-	Feld last_error
`source_event_id`	`UUID`	Nein	FK ➔ domain_events.id	Feld source_event_id
`correlation_id`	`UUID`	Nein	-	Feld correlation_id
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

JournalEntries journal_entries RLS Aktiv

18 Câmpuri / coloane

Tabelle journal_entries

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`journal_id`	`UUID`	Ja *	FK ➔ journals.id	Feld journal_id
`entry_number`	`VARCHAR(64)`	Ja *	-	Feld entry_number
`entry_date`	`DATE`	Ja *	-	Feld entry_date
`reference`	`VARCHAR(128)`	Nein	-	Feld reference
`description`	`TEXT`	Nein	-	Feld description
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`posted_at`	`DATETIME`	Nein	-	Feld posted_at
`total_debit`	`NUMERIC(14, 2)`	Ja *	-	Feld total_debit
`total_credit`	`NUMERIC(14, 2)`	Ja *	-	Feld total_credit
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`metadata`	`JSONB`	Ja *	-	Feld metadata

JournalEntryLines journal_entry_lines RLS Aktiv

15 Câmpuri / coloane

Tabelle journal_entry_lines

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`journal_entry_id`	`UUID`	Ja *	FK ➔ journal_entries.id	Feld journal_entry_id
`account_code`	`VARCHAR(32)`	Ja *	-	Feld account_code
`debit`	`NUMERIC(14, 2)`	Ja *	-	Feld debit
`credit`	`NUMERIC(14, 2)`	Ja *	-	Feld credit
`description`	`VARCHAR(255)`	Nein	-	Feld description
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`cost_center_id`	`UUID`	Nein	FK ➔ cost_centers.id	Feld cost_center_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`internal_order_id`	`UUID`	Nein	FK ➔ controlling_internal_orders.id	Feld internal_order_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

Journals journals RLS Aktiv

15 Câmpuri / coloane

Tabelle journals

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(16)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`journal_type`	`VARCHAR(48)`	Ja *	-	Feld journal_type
`default_debit_account_code`	`VARCHAR(32)`	Nein	-	Feld default_debit_account_code
`default_credit_account_code`	`VARCHAR(32)`	Nein	-	Feld default_credit_account_code
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Kn8ReferenceCodes kn8_reference_codes

5 Câmpuri / coloane

Tabelle kn8_reference_codes

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`version_id`	`UUID`	Ja *	FK ➔ kn8_reference_versions.id	Feld version_id
`code`	`VARCHAR(8)`	Ja *	-	Feld code
`description`	`TEXT`	Ja *	-	Feld description
`search_text`	`TEXT`	Ja *	-	Feld search_text
`id`	`UUID`	Nein	PK	Feld id

Kn8ReferenceVersions kn8_reference_versions

8 Câmpuri / coloane

Tabelle kn8_reference_versions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`version`	`VARCHAR(30)`	Ja *	-	Feld version
`source_url`	`VARCHAR(500)`	Ja *	-	Feld source_url
`source_sha256`	`VARCHAR(64)`	Ja *	-	Feld source_sha256
`effective_from`	`DATE`	Ja *	-	Feld effective_from
`imported_by`	`UUID`	Ja *	FK ➔ users.id	Feld imported_by
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`id`	`UUID`	Nein	PK	Feld id

LabelTemplates label_templates RLS Aktiv

17 Câmpuri / coloane

Tabelle label_templates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(64)`	Ja *	-	Feld code
`name`	`VARCHAR(256)`	Ja *	-	Feld name
`target_type`	`VARCHAR(32)`	Ja *	-	Feld target_type
`output_format`	`VARCHAR(16)`	Ja *	-	Feld output_format
`width_mm`	`INTEGER`	Ja *	-	Feld width_mm
`height_mm`	`INTEGER`	Ja *	-	Feld height_mm
`template_body`	`TEXT`	Ja *	-	Feld template_body
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

LandedCostAllocations landed_cost_allocations RLS Aktiv

12 Câmpuri / coloane

Tabelle landed_cost_allocations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`landed_cost_id`	`UUID`	Ja *	FK ➔ landed_costs.id	Feld landed_cost_id
`receipt_item_id`	`UUID`	Ja *	FK ➔ goods_receipt_items.id	Feld receipt_item_id
`allocated_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld allocated_amount
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

LandedCosts landed_costs RLS Aktiv

18 Câmpuri / coloane

Tabelle landed_costs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`label`	`VARCHAR(128)`	Ja *	-	Feld label
`goods_receipt_id`	`UUID`	Ja *	FK ➔ goods_receipts.id	Feld goods_receipt_id
`amount`	`NUMERIC(14, 2)`	Ja *	-	Feld amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`allocation_method`	`VARCHAR(16)`	Ja *	-	Feld allocation_method
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`posted_at`	`DATETIME`	Nein	-	Feld posted_at
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

LearnedRules learned_rules RLS Aktiv

19 Câmpuri / coloane

Tabelle learned_rules

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`type`	`VARCHAR(64)`	Ja *	-	Feld type
`condition`	`JSONB`	Ja *	-	Feld condition
`action`	`JSONB`	Ja *	-	Feld action
`confidence`	`NUMERIC(4, 3)`	Ja *	-	Feld confidence
`source`	`VARCHAR(48)`	Ja *	-	Feld source
`confirmed_by_user`	`BOOLEAN`	Ja *	-	Feld confirmed_by_user
`hit_count`	`INTEGER`	Ja *	-	Feld hit_count
`last_applied_at`	`DATETIME`	Nein	-	Feld last_applied_at
`active`	`BOOLEAN`	Ja *	-	Feld active
`condition_fingerprint`	`VARCHAR(64)`	Ja *	-	Feld condition_fingerprint
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

LocationEndCustomerAliases location_end_customer_aliases RLS Aktiv

14 Câmpuri / coloane

Tabelle location_end_customer_aliases

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`location_id`	`UUID`	Ja *	FK ➔ locations.id	Feld location_id
`end_customer_id`	`UUID`	Ja *	FK ➔ customers.id	Feld end_customer_id
`alias_number`	`INTEGER`	Ja *	-	Feld alias_number
`wave_key`	`VARCHAR(64)`	Ja *	-	Feld wave_key
`released_at`	`DATETIME`	Nein	-	Feld released_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Locations locations RLS Aktiv

27 Câmpuri / coloane

Tabelle locations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`code`	`VARCHAR(32)`	Nein	-	Feld code
`barcode`	`VARCHAR(64)`	Nein	-	Feld barcode
`type`	`VARCHAR(48)`	Ja *	-	Feld type
`hierarchy_level`	`VARCHAR(16)`	Nein	-	Feld hierarchy_level
`storage_mode`	`VARCHAR(8)`	Ja *	-	Feld storage_mode
`pick_sequence`	`INTEGER`	Nein	-	Feld pick_sequence
`removal_strategy`	`VARCHAR(8)`	Nein	-	Feld removal_strategy
`storage_category_id`	`UUID`	Nein	-	Feld storage_category_id
`parent_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld parent_location_id
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`user_id`	`UUID`	Nein	FK ➔ users.id	Feld user_id
`street`	`VARCHAR(255)`	Nein	-	Feld street
`postal_code`	`VARCHAR(16)`	Nein	-	Feld postal_code
`city`	`VARCHAR(128)`	Nein	-	Feld city
`country_code`	`VARCHAR(2)`	Nein	-	Feld country_code
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MailboxAccounts mailbox_accounts RLS Aktiv

48 Câmpuri / coloane

Tabelle mailbox_accounts

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`email_address`	`VARCHAR(320)`	Ja *	-	Feld email_address
`provider_type`	`VARCHAR(32)`	Ja *	-	Feld provider_type
`organization_user_id`	`UUID`	Nein	FK ➔ organization_users.id	Feld organization_user_id
`access_org_user_ids`	`JSONB`	Nein	-	Feld access_org_user_ids
`imap_host`	`VARCHAR(255)`	Nein	-	Feld imap_host
`imap_port`	`INTEGER`	Ja *	-	Feld imap_port
`imap_security`	`VARCHAR(16)`	Ja *	-	Feld imap_security
`imap_username`	`VARCHAR(320)`	Nein	-	Feld imap_username
`encrypted_password`	`TEXT`	Nein	-	Feld encrypted_password
`sync_folder`	`VARCHAR(128)`	Ja *	-	Feld sync_folder
`last_sync_at`	`DATETIME`	Nein	-	Feld last_sync_at
`last_uid`	`INTEGER`	Ja *	-	Feld last_uid
`sync_interval_minutes`	`INTEGER`	Ja *	-	Feld sync_interval_minutes
`smtp_host`	`VARCHAR(255)`	Nein	-	Feld smtp_host
`smtp_port`	`INTEGER`	Ja *	-	Feld smtp_port
`smtp_security`	`VARCHAR(16)`	Ja *	-	Feld smtp_security
`smtp_username`	`VARCHAR(320)`	Nein	-	Feld smtp_username
`encrypted_smtp_password`	`TEXT`	Nein	-	Feld encrypted_smtp_password
`from_name`	`VARCHAR(128)`	Nein	-	Feld from_name
`signature_text`	`TEXT`	Nein	-	Feld signature_text
`signature_html`	`TEXT`	Nein	-	Feld signature_html
`signature_image_document_id`	`UUID`	Nein	-	Feld signature_image_document_id
`signature_use_company_logo`	`BOOLEAN`	Ja *	-	Feld signature_use_company_logo
`inbox_processing`	`BOOLEAN`	Ja *	-	Feld inbox_processing
`oof_enabled`	`BOOLEAN`	Ja *	-	Feld oof_enabled
`oof_subject`	`VARCHAR(512)`	Nein	-	Feld oof_subject
`oof_body`	`TEXT`	Nein	-	Feld oof_body
`oof_from`	`DATETIME`	Nein	-	Feld oof_from
`oof_until`	`DATETIME`	Nein	-	Feld oof_until
`oof_once_days`	`INTEGER`	Ja *	-	Feld oof_once_days
`oauth_tenant_id`	`VARCHAR(128)`	Nein	-	Feld oauth_tenant_id
`client_id`	`VARCHAR(128)`	Nein	-	Feld client_id
`encrypted_refresh_token`	`TEXT`	Nein	-	Feld encrypted_refresh_token
`token_expiry`	`DATETIME`	Nein	-	Feld token_expiry
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`connection_status`	`VARCHAR(32)`	Ja *	-	Feld connection_status
`last_error`	`TEXT`	Nein	-	Feld last_error
`last_successful_sync_at`	`DATETIME`	Nein	-	Feld last_successful_sync_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MailboxOofLog mailbox_oof_log RLS Aktiv

12 Câmpuri / coloane

Tabelle mailbox_oof_log

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`mailbox_account_id`	`UUID`	Ja *	FK ➔ mailbox_accounts.id	Feld mailbox_account_id
`sender_email`	`VARCHAR(320)`	Ja *	-	Feld sender_email
`last_sent_at`	`DATETIME`	Ja *	-	Feld last_sent_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MailboxRules mailbox_rules RLS Aktiv

17 Câmpuri / coloane

Tabelle mailbox_rules

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`mailbox_account_id`	`UUID`	Ja *	FK ➔ mailbox_accounts.id	Feld mailbox_account_id
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`active`	`BOOLEAN`	Ja *	-	Feld active
`position`	`INTEGER`	Ja *	-	Feld position
`conditions`	`JSONB`	Ja *	-	Feld conditions
`actions`	`JSONB`	Ja *	-	Feld actions
`stop_processing`	`BOOLEAN`	Ja *	-	Feld stop_processing
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata
`deleted_at`	`DATETIME`	Nein	-	Feld deleted_at

MailboxSignatures mailbox_signatures RLS Aktiv

21 Câmpuri / coloane

Tabelle mailbox_signatures

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`mailbox_account_id`	`UUID`	Nein	FK ➔ mailbox_accounts.id	Feld mailbox_account_id
`organization_user_id`	`UUID`	Nein	FK ➔ organization_users.id	Feld organization_user_id
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`body_text`	`TEXT`	Nein	-	Feld body_text
`body_html`	`TEXT`	Nein	-	Feld body_html
`use_company_logo`	`BOOLEAN`	Ja *	-	Feld use_company_logo
`inline_image_document_id`	`UUID`	Nein	-	Feld inline_image_document_id
`attachment_document_ids`	`JSONB`	Ja *	-	Feld attachment_document_ids
`is_default_new`	`BOOLEAN`	Ja *	-	Feld is_default_new
`is_default_reply`	`BOOLEAN`	Ja *	-	Feld is_default_reply
`position`	`INTEGER`	Ja *	-	Feld position
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata
`deleted_at`	`DATETIME`	Nein	-	Feld deleted_at

NumberSequences number_sequences RLS Aktiv

24 Câmpuri / coloane

Tabelle number_sequences

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`document_type`	`VARCHAR(48)`	Ja *	-	Feld document_type
`code`	`VARCHAR(48)`	Ja *	-	Feld code
`name`	`VARCHAR(64)`	Ja *	-	Feld name
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`priority`	`INTEGER`	Ja *	-	Feld priority
`criteria`	`JSONB`	Ja *	-	Feld criteria
`prefix`	`VARCHAR(16)`	Ja *	-	Feld prefix
`suffix`	`VARCHAR(16)`	Ja *	-	Feld suffix
`pattern`	`VARCHAR(64)`	Ja *	-	Feld pattern
`padding`	`INTEGER`	Ja *	-	Feld padding
`start_value`	`INTEGER`	Ja *	-	Feld start_value
`next_value`	`INTEGER`	Ja *	-	Feld next_value
`reset_policy`	`VARCHAR(48)`	Ja *	-	Feld reset_policy
`period_key`	`VARCHAR(16)`	Ja *	-	Feld period_key
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

OauthIdentities oauth_identities

7 Câmpuri / coloane

Tabelle oauth_identities

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`user_id`	`UUID`	Ja *	FK ➔ users.id	Feld user_id
`provider`	`VARCHAR(32)`	Ja *	-	Feld provider
`provider_user_id`	`VARCHAR(255)`	Ja *	-	Feld provider_user_id
`email`	`VARCHAR(320)`	Ja *	-	Feld email
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

OrgUnitMembers org_unit_members RLS Aktiv

12 Câmpuri / coloane

Tabelle org_unit_members

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`unit_id`	`UUID`	Ja *	FK ➔ org_units.id	Feld unit_id
`user_id`	`UUID`	Ja *	FK ➔ users.id	Feld user_id
`is_lead`	`BOOLEAN`	Ja *	-	Feld is_lead
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

OrgUnits org_units RLS Aktiv

17 Câmpuri / coloane

Tabelle org_units

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`kind`	`VARCHAR(16)`	Ja *	-	Feld kind
`parent_id`	`UUID`	Nein	FK ➔ org_units.id	Feld parent_id
`manager_user_id`	`UUID`	Nein	FK ➔ users.id	Feld manager_user_id
`description`	`TEXT`	Nein	-	Feld description
`sort_order`	`INTEGER`	Ja *	-	Feld sort_order
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

OrganizationUsers organization_users RLS Aktiv

29 Câmpuri / coloane

Tabelle organization_users

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`user_id`	`UUID`	Ja *	FK ➔ users.id	Feld user_id
`role`	`VARCHAR(48)`	Ja *	-	Feld role
`custom_role_id`	`UUID`	Nein	FK ➔ tenant_roles.id	Feld custom_role_id
`permissions`	`JSONB`	Ja *	-	Feld permissions
`is_owner`	`BOOLEAN`	Ja *	-	Feld is_owner
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`employee_number`	`VARCHAR(32)`	Nein	-	Feld employee_number
`trade`	`VARCHAR(128)`	Nein	-	Feld trade
`hourly_rate`	`NUMERIC(10, 2)`	Nein	-	Feld hourly_rate
`hire_date`	`DATE`	Nein	-	Feld hire_date
`phone_mobile`	`VARCHAR(64)`	Nein	-	Feld phone_mobile
`emergency_contact`	`VARCHAR(255)`	Nein	-	Feld emergency_contact
`adr_certified`	`BOOLEAN`	Ja *	-	Feld adr_certified
`birth_date`	`DATE`	Nein	-	Feld birth_date
`sv_number`	`VARCHAR(32)`	Nein	-	Feld sv_number
`tax_id`	`VARCHAR(16)`	Nein	-	Feld tax_id
`religion`	`VARCHAR(64)`	Nein	-	Feld religion
`health_insurance`	`VARCHAR(128)`	Nein	-	Feld health_insurance
`iban`	`VARCHAR(34)`	Nein	-	Feld iban
`address`	`VARCHAR(512)`	Nein	-	Feld address
`employment_type`	`VARCHAR(48)`	Nein	-	Feld employment_type
`weekly_hours`	`NUMERIC(5, 2)`	Nein	-	Feld weekly_hours
`exit_date`	`DATE`	Nein	-	Feld exit_date
`work_permit_until`	`DATE`	Nein	-	Feld work_permit_until
`supervisor_id`	`UUID`	Nein	FK ➔ organization_users.id	Feld supervisor_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

Organizations organizations

60 Câmpuri / coloane

Tabelle organizations

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

PartnerShopRates partner_shop_rates RLS Aktiv

14 Câmpuri / coloane

Tabelle partner_shop_rates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`partner_customer_id`	`UUID`	Ja *	FK ➔ customers.id	Feld partner_customer_id
`shop_supplier_id`	`UUID`	Ja *	FK ➔ suppliers.id	Feld shop_supplier_id
`adjustment_percent`	`NUMERIC(8, 4)`	Ja *	-	Feld adjustment_percent
`active`	`BOOLEAN`	Ja *	-	Feld active
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

PeppolTransmissions peppol_transmissions RLS Aktiv

21 Câmpuri / coloane

Tabelle peppol_transmissions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`invoice_id`	`UUID`	Nein	FK ➔ invoices.id	Feld invoice_id
`transmission_type`	`VARCHAR(48)`	Ja *	-	Feld transmission_type
`document_type`	`VARCHAR(48)`	Ja *	-	Feld document_type
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`sender_participant_id`	`VARCHAR(64)`	Ja *	-	Feld sender_participant_id
`receiver_participant_id`	`VARCHAR(64)`	Ja *	-	Feld receiver_participant_id
`message_id`	`VARCHAR(128)`	Ja *	-	Feld message_id
`payload_xml`	`TEXT`	Ja *	-	Feld payload_xml
`peppol_response`	`JSONB`	Ja *	-	Feld peppol_response
`error_message`	`TEXT`	Nein	-	Feld error_message
`transmitted_at`	`DATETIME`	Nein	-	Feld transmitted_at
`delivered_at`	`DATETIME`	Nein	-	Feld delivered_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

PlatformProducts platform_products

21 Câmpuri / coloane

Tabelle platform_products

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`key`	`VARCHAR(64)`	Ja *	-	Feld key
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`tagline`	`VARCHAR(255)`	Nein	-	Feld tagline
`description`	`TEXT`	Nein	-	Feld description
`audience`	`VARCHAR(48)`	Ja *	-	Feld audience
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`module_keys`	`JSONB`	Ja *	-	Feld module_keys
`workflow_keys`	`JSONB`	Ja *	-	Feld workflow_keys
`agent_keys`	`JSONB`	Ja *	-	Feld agent_keys
`recommended_industry_keys`	`JSONB`	Ja *	-	Feld recommended_industry_keys
`ai_rationale`	`TEXT`	Nein	-	Feld ai_rationale
`ai_confidence`	`NUMERIC(4, 3)`	Nein	-	Feld ai_confidence
`highlights`	`JSONB`	Ja *	-	Feld highlights
`price_amount`	`NUMERIC(14, 2)`	Nein	-	Feld price_amount
`price_currency`	`VARCHAR(3)`	Ja *	-	Feld price_currency
`price_period`	`VARCHAR(16)`	Ja *	-	Feld price_period
`created_by`	`UUID`	Nein	-	Feld created_by
`published_at`	`DATETIME`	Nein	-	Feld published_at
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

PlatformSettings platform_settings

6 Câmpuri / coloane

Tabelle platform_settings

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`key`	`VARCHAR(64)`	Ja *	-	Feld key
`value_encrypted`	`TEXT`	Ja *	-	Feld value_encrypted
`updated_by`	`UUID`	Nein	-	Feld updated_by
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

PlatformSubscriptionInvoices platform_subscription_invoices RLS Aktiv

14 Câmpuri / coloane

Tabelle platform_subscription_invoices

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`stripe_subscription_id`	`VARCHAR(64)`	Ja *	-	Feld stripe_subscription_id
`stripe_invoice_id`	`VARCHAR(64)`	Ja *	-	Feld stripe_invoice_id
`plan`	`VARCHAR(48)`	Ja *	-	Feld plan
`period_start`	`DATETIME`	Ja *	-	Feld period_start
`period_end`	`DATETIME`	Ja *	-	Feld period_end
`amount_gross`	`NUMERIC(14, 2)`	Ja *	-	Feld amount_gross
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`paid_at`	`DATETIME`	Nein	-	Feld paid_at
`operator_invoice_id`	`UUID`	Nein	FK ➔ invoices.id	Feld operator_invoice_id
`operator_invoice_document_id`	`UUID`	Nein	FK ➔ documents.id	Feld operator_invoice_document_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

PricelistItems pricelist_items RLS Aktiv

22 Câmpuri / coloane

Tabelle pricelist_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`pricelist_id`	`UUID`	Ja *	FK ➔ pricelists.id	Feld pricelist_id
`scope`	`VARCHAR(16)`	Ja *	-	Feld scope
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`category_id`	`UUID`	Nein	FK ➔ product_categories.id	Feld category_id
`min_quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld min_quantity
`price_basis`	`VARCHAR(16)`	Ja *	-	Feld price_basis
`price`	`NUMERIC(14, 2)`	Nein	-	Feld price
`label`	`VARCHAR(255)`	Nein	-	Feld label
`discount_percent`	`NUMERIC(5, 2)`	Nein	-	Feld discount_percent
`surcharge`	`NUMERIC(14, 2)`	Nein	-	Feld surcharge
`min_margin_percent`	`NUMERIC(5, 2)`	Nein	-	Feld min_margin_percent
`max_margin_percent`	`NUMERIC(5, 2)`	Nein	-	Feld max_margin_percent
`agent_price`	`NUMERIC(14, 2)`	Nein	-	Feld agent_price
`agent_discount_percent`	`NUMERIC(5, 2)`	Nein	-	Feld agent_discount_percent
`agent_surcharge`	`NUMERIC(14, 2)`	Nein	-	Feld agent_surcharge
`valid_from`	`DATE`	Nein	-	Feld valid_from
`valid_until`	`DATE`	Nein	-	Feld valid_until
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

Pricelists pricelists RLS Aktiv

16 Câmpuri / coloane

Tabelle pricelists

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`parent_id`	`UUID`	Nein	FK ➔ pricelists.id	Feld parent_id
`valid_from`	`DATE`	Nein	-	Feld valid_from
`valid_until`	`DATE`	Nein	-	Feld valid_until
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

PrintBridges print_bridges RLS Aktiv

19 Câmpuri / coloane

Tabelle print_bridges

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`bridge_uid`	`VARCHAR(64)`	Ja *	-	Feld bridge_uid
`name`	`VARCHAR(256)`	Ja *	-	Feld name
`token_hash`	`VARCHAR(64)`	Ja *	-	Feld token_hash
`active`	`BOOLEAN`	Ja *	-	Feld active
`capabilities`	`JSONB`	Ja *	-	Feld capabilities
`discovered_printers`	`JSONB`	Ja *	-	Feld discovered_printers
`software_version`	`VARCHAR(64)`	Nein	-	Feld software_version
`hostname`	`VARCHAR(256)`	Nein	-	Feld hostname
`last_ip`	`VARCHAR(64)`	Nein	-	Feld last_ip
`last_seen_at`	`DATETIME`	Nein	-	Feld last_seen_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

PrintJobs print_jobs RLS Aktiv

33 Câmpuri / coloane

Tabelle print_jobs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`template_id`	`UUID`	Nein	FK ➔ label_templates.id	Feld template_id
`printer_id`	`UUID`	Nein	FK ➔ printers.id	Feld printer_id
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`copies`	`INTEGER`	Ja *	-	Feld copies
`entity_type`	`VARCHAR(32)`	Ja *	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`operation_code`	`VARCHAR(64)`	Nein	-	Feld operation_code
`payload_snapshot`	`JSONB`	Ja *	-	Feld payload_snapshot
`output_format`	`VARCHAR(16)`	Ja *	-	Feld output_format
`rendered_content`	`BLOB`	Nein	-	Feld rendered_content
`content_type`	`VARCHAR(128)`	Ja *	-	Feld content_type
`error_message`	`TEXT`	Nein	-	Feld error_message
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`content_checksum`	`VARCHAR(64)`	Nein	-	Feld content_checksum
`leased_by_bridge_id`	`UUID`	Nein	FK ➔ print_bridges.id	Feld leased_by_bridge_id
`lease_token_hash`	`VARCHAR(64)`	Nein	-	Feld lease_token_hash
`leased_until`	`DATETIME`	Nein	-	Feld leased_until
`attempt_count`	`INTEGER`	Ja *	-	Feld attempt_count
`next_retry_at`	`DATETIME`	Nein	-	Feld next_retry_at
`delivered_at`	`DATETIME`	Nein	-	Feld delivered_at
`acknowledged_at`	`DATETIME`	Nein	-	Feld acknowledged_at
`reprint_of_id`	`UUID`	Nein	FK ➔ print_jobs.id	Feld reprint_of_id
`reprint_reason`	`TEXT`	Nein	-	Feld reprint_reason
`printed_at`	`DATETIME`	Nein	-	Feld printed_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Printers printers RLS Aktiv

20 Câmpuri / coloane

Tabelle printers

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(64)`	Ja *	-	Feld code
`name`	`VARCHAR(256)`	Ja *	-	Feld name
`connection_type`	`VARCHAR(16)`	Ja *	-	Feld connection_type
`output_format`	`VARCHAR(16)`	Ja *	-	Feld output_format
`device_name`	`VARCHAR(256)`	Nein	-	Feld device_name
`bridge_id`	`UUID`	Nein	FK ➔ print_bridges.id	Feld bridge_id
`host`	`VARCHAR(255)`	Nein	-	Feld host
`port`	`INTEGER`	Nein	-	Feld port
`location_id`	`UUID`	Nein	FK ➔ locations.id	Feld location_id
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductAccessories product_accessories RLS Aktiv

12 Câmpuri / coloane

Tabelle product_accessories

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`accessory_product_id`	`UUID`	Ja *	FK ➔ products.id	Feld accessory_product_id
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductAttributeValues product_attribute_values RLS Aktiv

15 Câmpuri / coloane

Tabelle product_attribute_values

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`attribute_id`	`UUID`	Ja *	FK ➔ product_attributes.id	Feld attribute_id
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`color_hex`	`VARCHAR(7)`	Nein	-	Feld color_hex
`default_price_extra`	`NUMERIC(14, 2)`	Ja *	-	Feld default_price_extra
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductAttributes product_attributes RLS Aktiv

13 Câmpuri / coloane

Tabelle product_attributes

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`display_type`	`VARCHAR(48)`	Ja *	-	Feld display_type
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductBomCustomers product_bom_customers RLS Aktiv

7 Câmpuri / coloane

Tabelle product_bom_customers

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`bom_id`	`UUID`	Ja *	FK ➔ product_boms.id	Feld bom_id
`customer_id`	`UUID`	Ja *	FK ➔ customers.id	Feld customer_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductBomLines product_bom_lines RLS Aktiv

15 Câmpuri / coloane

Tabelle product_bom_lines

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`bom_id`	`UUID`	Ja *	FK ➔ product_boms.id	Feld bom_id
`component_product_id`	`UUID`	Ja *	FK ➔ products.id	Feld component_product_id
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_cost`	`NUMERIC(14, 2)`	Nein	-	Feld unit_cost
`position`	`INTEGER`	Ja *	-	Feld position
`notes`	`TEXT`	Nein	-	Feld notes
`recovery_percent`	`NUMERIC(6, 2)`	Nein	-	Feld recovery_percent
`component_bom_id`	`UUID`	Nein	FK ➔ product_boms.id	Feld component_bom_id
`do_not_explode`	`BOOLEAN`	Ja *	-	Feld do_not_explode
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductBomSteps product_bom_steps RLS Aktiv

15 Câmpuri / coloane

Tabelle product_bom_steps

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`bom_id`	`UUID`	Ja *	FK ➔ product_boms.id	Feld bom_id
`position`	`INTEGER`	Ja *	-	Feld position
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`workstation_id`	`UUID`	Nein	FK ➔ workstations.id	Feld workstation_id
`estimated_minutes`	`INTEGER`	Nein	-	Feld estimated_minutes
`setup_minutes`	`INTEGER`	Nein	-	Feld setup_minutes
`image_url`	`TEXT`	Nein	-	Feld image_url
`image_urls`	`JSONB`	Nein	-	Feld image_urls
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductBoms product_boms RLS Aktiv

27 Câmpuri / coloane

Tabelle product_boms

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`code`	`VARCHAR(64)`	Nein	-	Feld code
`bom_type`	`VARCHAR(48)`	Ja *	-	Feld bom_type
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`instructions`	`TEXT`	Nein	-	Feld instructions
`default_workstation_id`	`UUID`	Nein	FK ➔ workstations.id	Feld default_workstation_id
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`picking_policy`	`VARCHAR(32)`	Ja *	-	Feld picking_policy
`estimated_minutes`	`INTEGER`	Nein	-	Feld estimated_minutes
`active`	`BOOLEAN`	Ja *	-	Feld active
`notes`	`TEXT`	Nein	-	Feld notes
`revision`	`VARCHAR(32)`	Ja *	-	Feld revision
`valid_from`	`DATE`	Nein	-	Feld valid_from
`valid_until`	`DATE`	Nein	-	Feld valid_until
`explode_components`	`BOOLEAN`	Ja *	-	Feld explode_components
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductCategoryTaxonomyBindings product_category_taxonomy_bindings RLS Aktiv

14 Câmpuri / coloane

Tabelle product_category_taxonomy_bindings

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`standard_code`	`VARCHAR(32)`	Ja *	FK ➔ standard_categories.code	Feld standard_code
`category_id`	`UUID`	Ja *	FK ➔ product_categories.id	Feld category_id
`version`	`INTEGER`	Ja *	-	Feld version
`active`	`BOOLEAN`	Ja *	-	Feld active
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ product_categories.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductCompatibilities product_compatibilities RLS Aktiv

12 Câmpuri / coloane

Tabelle product_compatibilities

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`part_product_id`	`UUID`	Ja *	FK ➔ products.id	Feld part_product_id
`equipment_product_id`	`UUID`	Ja *	FK ➔ products.id	Feld equipment_product_id
`notes`	`VARCHAR(255)`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductSupplierinfo product_supplierinfo RLS Aktiv

21 Câmpuri / coloane

Tabelle product_supplierinfo

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`supplier_id`	`UUID`	Ja *	FK ➔ suppliers.id	Feld supplier_id
`vendor_product_name`	`VARCHAR(255)`	Nein	-	Feld vendor_product_name
`vendor_product_code`	`VARCHAR(64)`	Nein	-	Feld vendor_product_code
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`min_qty`	`NUMERIC(14, 4)`	Ja *	-	Feld min_qty
`price`	`NUMERIC(14, 2)`	Nein	-	Feld price
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`delay`	`INTEGER`	Ja *	-	Feld delay
`is_preferred`	`BOOLEAN`	Ja *	-	Feld is_preferred
`date_start`	`DATE`	Nein	-	Feld date_start
`date_end`	`DATE`	Nein	-	Feld date_end
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ProductVariantValues product_variant_values RLS Aktiv

8 Câmpuri / coloane

Tabelle product_variant_values

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`value_id`	`UUID`	Ja *	FK ➔ product_attribute_values.id	Feld value_id
`price_extra`	`NUMERIC(14, 2)`	Ja *	-	Feld price_extra
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

PurchaseItems purchase_items RLS Aktiv

25 Câmpuri / coloane

Tabelle purchase_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`purchase_id`	`UUID`	Ja *	FK ➔ purchases.id	Feld purchase_id
`position`	`INTEGER`	Ja *	-	Feld position
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`description`	`TEXT`	Ja *	-	Feld description
`quantity_ordered`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_ordered
`quantity_received`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_received
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_price`	`NUMERIC(14, 2)`	Ja *	-	Feld unit_price
`tax_rate`	`NUMERIC(6, 4)`	Ja *	-	Feld tax_rate
`net_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld net_amount
`tax_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld tax_amount
`gross_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld gross_amount
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`supplier_product_code`	`VARCHAR(64)`	Nein	-	Feld supplier_product_code
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`quantity_billed`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_billed
`discount_percentage`	`NUMERIC(6, 4)`	Ja *	-	Feld discount_percentage
`target_consignment`	`BOOLEAN`	Ja *	-	Feld target_consignment
`destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld destination_location_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

PurchaseRequisitionItems purchase_requisition_items RLS Aktiv

13 Câmpuri / coloane

Tabelle purchase_requisition_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`purchase_requisition_id`	`UUID`	Ja *	FK ➔ purchase_requisitions.id	Feld purchase_requisition_id
`position`	`INTEGER`	Ja *	-	Feld position
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`description`	`TEXT`	Ja *	-	Feld description
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_price_estimate`	`NUMERIC(14, 2)`	Nein	-	Feld unit_price_estimate
`purchase_item_id`	`UUID`	Nein	FK ➔ purchase_items.id	Feld purchase_item_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

PurchaseRequisitions purchase_requisitions RLS Aktiv

20 Câmpuri / coloane

Tabelle purchase_requisitions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`requisition_number`	`VARCHAR(32)`	Ja *	-	Feld requisition_number
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`requester_user_id`	`UUID`	Ja *	FK ➔ users.id	Feld requester_user_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`cost_center_id`	`UUID`	Nein	FK ➔ cost_centers.id	Feld cost_center_id
`notes`	`TEXT`	Nein	-	Feld notes
`approved_by`	`UUID`	Nein	FK ➔ users.id	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`purchase_id`	`UUID`	Nein	FK ➔ purchases.id	Feld purchase_id
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

PurchaseRfqLines purchase_rfq_lines RLS Aktiv

11 Câmpuri / coloane

Tabelle purchase_rfq_lines

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`rfq_id`	`UUID`	Ja *	FK ➔ purchase_rfqs.id	Feld rfq_id
`position`	`INTEGER`	Ja *	-	Feld position
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`description`	`TEXT`	Ja *	-	Feld description
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

PurchaseRfqSuppliers purchase_rfq_suppliers RLS Aktiv

9 Câmpuri / coloane

Tabelle purchase_rfq_suppliers

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`rfq_id`	`UUID`	Ja *	FK ➔ purchase_rfqs.id	Feld rfq_id
`supplier_id`	`UUID`	Ja *	FK ➔ suppliers.id	Feld supplier_id
`email_sent_at`	`DATETIME`	Nein	-	Feld email_sent_at
`quote_id`	`UUID`	Nein	FK ➔ supplier_quotes.id	Feld quote_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

PurchaseRfqs purchase_rfqs RLS Aktiv

16 Câmpuri / coloane

Tabelle purchase_rfqs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`rfq_number`	`VARCHAR(32)`	Ja *	-	Feld rfq_number
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`requisition_id`	`UUID`	Nein	FK ➔ purchase_requisitions.id	Feld requisition_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`notes`	`TEXT`	Nein	-	Feld notes
`due_date`	`DATE`	Nein	-	Feld due_date
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Purchases purchases RLS Aktiv

41 Câmpuri / coloane

Tabelle purchases

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`purchase_number`	`VARCHAR(32)`	Ja *	-	Feld purchase_number
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld destination_location_id
`order_date`	`DATE`	Nein	-	Feld order_date
`expected_delivery_date`	`DATE`	Nein	-	Feld expected_delivery_date
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`net_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld net_amount
`tax_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld tax_amount
`gross_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld gross_amount
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`supplier_reference`	`VARCHAR(128)`	Nein	-	Feld supplier_reference
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`contract_id`	`UUID`	Nein	FK ➔ contracts.id	Feld contract_id
`procurement_type`	`VARCHAR(32)`	Ja *	-	Feld procurement_type
`incoterm`	`VARCHAR(16)`	Nein	-	Feld incoterm
`incoterm_location`	`VARCHAR(128)`	Nein	-	Feld incoterm_location
`payment_terms`	`VARCHAR(128)`	Nein	-	Feld payment_terms
`payment_term_code`	`VARCHAR(32)`	Nein	-	Feld payment_term_code
`delivery_address`	`TEXT`	Nein	-	Feld delivery_address
`cost_center_id`	`UUID`	Nein	FK ➔ cost_centers.id	Feld cost_center_id
`cost_type_id`	`UUID`	Nein	FK ➔ cost_types.id	Feld cost_type_id
`sent_at`	`DATETIME`	Nein	-	Feld sent_at
`sent_to_email`	`VARCHAR(320)`	Nein	-	Feld sent_to_email
`supplier_confirmed_at`	`DATETIME`	Nein	-	Feld supplier_confirmed_at
`supplier_confirmation_number`	`VARCHAR(128)`	Nein	-	Feld supplier_confirmation_number
`pdf_storage_key`	`VARCHAR(255)`	Nein	-	Feld pdf_storage_key
`is_consolidated`	`BOOLEAN`	Ja *	-	Feld is_consolidated
`grouping_mode`	`VARCHAR(32)`	Ja *	-	Feld grouping_mode
`notes`	`TEXT`	Nein	-	Feld notes
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

QuoteTemplateItems quote_template_items RLS Aktiv

14 Câmpuri / coloane

Tabelle quote_template_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`template_id`	`UUID`	Ja *	FK ➔ quote_templates.id	Feld template_id
`position`	`INTEGER`	Ja *	-	Feld position
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`description`	`TEXT`	Ja *	-	Feld description
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_price`	`NUMERIC(14, 2)`	Nein	-	Feld unit_price
`discount_percent`	`NUMERIC(5, 2)`	Ja *	-	Feld discount_percent
`tax_rate`	`NUMERIC(6, 4)`	Ja *	-	Feld tax_rate
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

QuoteTemplates quote_templates RLS Aktiv

20 Câmpuri / coloane

Tabelle quote_templates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`validity_days`	`INTEGER`	Ja *	-	Feld validity_days
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`payment_terms`	`VARCHAR(128)`	Nein	-	Feld payment_terms
`payment_term_code`	`VARCHAR(32)`	Nein	-	Feld payment_term_code
`delivery_address`	`TEXT`	Nein	-	Feld delivery_address
`terms`	`TEXT`	Nein	-	Feld terms
`notes`	`TEXT`	Nein	-	Feld notes
`signature_required`	`BOOLEAN`	Ja *	-	Feld signature_required
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Reminders reminders RLS Aktiv

17 Câmpuri / coloane

Tabelle reminders

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`remind_at`	`DATETIME`	Ja *	-	Feld remind_at
`entity_type`	`VARCHAR(64)`	Nein	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`task_id`	`UUID`	Nein	FK ➔ tasks.id	Feld task_id
`is_sent`	`BOOLEAN`	Ja *	-	Feld is_sent
`sent_at`	`DATETIME`	Nein	-	Feld sent_at
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ReorderingRules reordering_rules RLS Aktiv

20 Câmpuri / coloane

Tabelle reordering_rules

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`location_id`	`UUID`	Nein	FK ➔ locations.id	Feld location_id
`supplier_info_id`	`UUID`	Nein	FK ➔ product_supplierinfo.id	Feld supplier_info_id
`min_quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld min_quantity
`target_quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld target_quantity
`order_multiple`	`NUMERIC(14, 4)`	Ja *	-	Feld order_multiple
`min_order_quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld min_order_quantity
`automatic`	`BOOLEAN`	Ja *	-	Feld automatic
`active`	`BOOLEAN`	Ja *	-	Feld active
`last_evaluated_at`	`DATETIME`	Nein	-	Feld last_evaluated_at
`last_procurement_at`	`DATETIME`	Nein	-	Feld last_procurement_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ReviewTasks review_tasks RLS Aktiv

23 Câmpuri / coloane

Tabelle review_tasks

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`agent_run_id`	`UUID`	Nein	FK ➔ agent_runs.id	Feld agent_run_id
`inbox_item_id`	`UUID`	Nein	FK ➔ inbox_items.id	Feld inbox_item_id
`review_type`	`VARCHAR(48)`	Ja *	-	Feld review_type
`question`	`TEXT`	Ja *	-	Feld question
`proposed_action`	`JSONB`	Ja *	-	Feld proposed_action
`options`	`JSONB`	Ja *	-	Feld options
`entity_type`	`VARCHAR(64)`	Nein	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`confidence`	`NUMERIC(4, 3)`	Nein	-	Feld confidence
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`assigned_user_id`	`UUID`	Nein	FK ➔ users.id	Feld assigned_user_id
`resolution`	`JSONB`	Ja *	-	Feld resolution
`resolved_by`	`UUID`	Nein	FK ➔ users.id	Feld resolved_by
`resolved_at`	`DATETIME`	Nein	-	Feld resolved_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ScanBridges scan_bridges RLS Aktiv

18 Câmpuri / coloane

Tabelle scan_bridges

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`bridge_uid`	`VARCHAR(64)`	Ja *	-	Feld bridge_uid
`name`	`VARCHAR(256)`	Ja *	-	Feld name
`token_hash`	`VARCHAR(64)`	Ja *	-	Feld token_hash
`active`	`BOOLEAN`	Ja *	-	Feld active
`hostname`	`VARCHAR(256)`	Nein	-	Feld hostname
`software_version`	`VARCHAR(64)`	Nein	-	Feld software_version
`watch_folder`	`VARCHAR(512)`	Nein	-	Feld watch_folder
`last_ip`	`VARCHAR(64)`	Nein	-	Feld last_ip
`last_seen_at`	`DATETIME`	Nein	-	Feld last_seen_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ScanImports scan_imports RLS Aktiv

24 Câmpuri / coloane

Tabelle scan_imports

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`bridge_id`	`UUID`	Ja *	FK ➔ scan_bridges.id	Feld bridge_id
`upload_uid`	`VARCHAR(128)`	Ja *	-	Feld upload_uid
`sha256`	`VARCHAR(64)`	Ja *	-	Feld sha256
`original_filename`	`VARCHAR(256)`	Ja *	-	Feld original_filename
`content_type`	`VARCHAR(128)`	Ja *	-	Feld content_type
`size_bytes`	`BIGINT`	Ja *	-	Feld size_bytes
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`document_type`	`VARCHAR(64)`	Nein	-	Feld document_type
`operation_type`	`VARCHAR(64)`	Nein	-	Feld operation_type
`reference_type`	`VARCHAR(32)`	Nein	-	Feld reference_type
`reference_id`	`UUID`	Nein	-	Feld reference_id
`reference_value`	`VARCHAR(256)`	Nein	-	Feld reference_value
`document_id`	`UUID`	Nein	FK ➔ documents.id	Feld document_id
`metadata_payload`	`JSONB`	Nein	-	Feld metadata_payload
`error_message`	`TEXT`	Nein	-	Feld error_message
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticActivations semantic_activations RLS Aktiv

12 Câmpuri / coloane

Tabelle semantic_activations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`scope`	`VARCHAR(16)`	Ja *	-	Feld scope
`scope_key`	`VARCHAR(96)`	Ja *	-	Feld scope_key
`release_id`	`UUID`	Ja *	FK ➔ semantic_releases.id	Feld release_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticAuditEvents semantic_audit_events RLS Aktiv

14 Câmpuri / coloane

Tabelle semantic_audit_events

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`actor_id`	`UUID`	Nein	-	Feld actor_id
`agent_run_id`	`UUID`	Nein	-	Feld agent_run_id
`intent`	`VARCHAR(96)`	Ja *	-	Feld intent
`object_key`	`VARCHAR(96)`	Ja *	-	Feld object_key
`entity_id`	`UUID`	Nein	-	Feld entity_id
`decision`	`VARCHAR(16)`	Ja *	-	Feld decision
`reason`	`TEXT`	Ja *	-	Feld reason
`context_hash`	`VARCHAR(64)`	Nein	-	Feld context_hash
`release_versions`	`JSONB`	Ja *	-	Feld release_versions
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticDefinitions semantic_definitions RLS Aktiv

10 Câmpuri / coloane

Tabelle semantic_definitions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`release_id`	`UUID`	Ja *	FK ➔ semantic_releases.id	Feld release_id
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`key`	`VARCHAR(96)`	Ja *	-	Feld key
`mode`	`VARCHAR(16)`	Ja *	-	Feld mode
`body`	`JSONB`	Ja *	-	Feld body
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticExtensionValues semantic_extension_values RLS Aktiv

11 Câmpuri / coloane

Tabelle semantic_extension_values

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`object_key`	`VARCHAR(96)`	Ja *	-	Feld object_key
`entity_id`	`UUID`	Ja *	-	Feld entity_id
`field_key`	`VARCHAR(96)`	Ja *	-	Feld field_key
`revision`	`INTEGER`	Ja *	-	Feld revision
`value`	`JSONB`	Ja *	-	Feld value
`release_id`	`UUID`	Ja *	FK ➔ semantic_releases.id	Feld release_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticPacks semantic_packs

10 Câmpuri / coloane

Tabelle semantic_packs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`scope`	`VARCHAR(16)`	Ja *	-	Feld scope
`scope_key`	`VARCHAR(96)`	Ja *	-	Feld scope_key
`version`	`INTEGER`	Ja *	-	Feld version
`active`	`BOOLEAN`	Ja *	-	Feld active
`definitions`	`JSONB`	Ja *	-	Feld definitions
`source`	`VARCHAR(255)`	Ja *	-	Feld source
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

SemanticQuoteApprovals semantic_quote_approvals RLS Aktiv

10 Câmpuri / coloane

Tabelle semantic_quote_approvals

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`quote_id`	`UUID`	Ja *	FK ➔ quotes.id	Feld quote_id
`context_hash`	`VARCHAR(64)`	Ja *	-	Feld context_hash
`facts_hash`	`VARCHAR(64)`	Ja *	-	Feld facts_hash
`approved_by`	`UUID`	Ja *	-	Feld approved_by
`reason`	`TEXT`	Ja *	-	Feld reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticReleases semantic_releases RLS Aktiv

18 Câmpuri / coloane

Tabelle semantic_releases

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`scope`	`VARCHAR(16)`	Ja *	-	Feld scope
`scope_key`	`VARCHAR(96)`	Ja *	-	Feld scope_key
`version`	`INTEGER`	Ja *	-	Feld version
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`base_release_id`	`UUID`	Nein	FK ➔ semantic_releases.id	Feld base_release_id
`reason`	`TEXT`	Ja *	-	Feld reason
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticSimulations semantic_simulations RLS Aktiv

11 Câmpuri / coloane

Tabelle semantic_simulations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`release_id`	`UUID`	Ja *	FK ➔ semantic_releases.id	Feld release_id
`entity_type`	`VARCHAR(96)`	Ja *	-	Feld entity_type
`entity_id`	`UUID`	Ja *	-	Feld entity_id
`intent`	`VARCHAR(96)`	Ja *	-	Feld intent
`result`	`JSONB`	Ja *	-	Feld result
`release_hash`	`VARCHAR(64)`	Ja *	-	Feld release_hash
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ semantic_releases.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticTenantProfiles semantic_tenant_profiles RLS Aktiv

10 Câmpuri / coloane

Tabelle semantic_tenant_profiles

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`industry_key`	`VARCHAR(96)`	Nein	-	Feld industry_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticWorkerBindings semantic_worker_bindings RLS Aktiv

16 Câmpuri / coloane

Tabelle semantic_worker_bindings

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`role_key`	`VARCHAR(96)`	Ja *	-	Feld role_key
`trigger_event`	`VARCHAR(64)`	Ja *	-	Feld trigger_event
`supervisor_user_id`	`UUID`	Nein	FK ➔ organization_users.user_id	Feld supervisor_user_id
`version`	`INTEGER`	Ja *	-	Feld version
`is_current`	`BOOLEAN`	Ja *	-	Feld is_current
`enabled`	`BOOLEAN`	Ja *	-	Feld enabled
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`simulation_result`	`JSONB`	Nein	-	Feld simulation_result
`approved_by`	`UUID`	Nein	-	Feld approved_by
`reason`	`TEXT`	Ja *	-	Feld reason
`created_by`	`UUID`	Ja *	-	Feld created_by
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organization_users.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

SemanticWorkerRuns semantic_worker_runs RLS Aktiv

11 Câmpuri / coloane

Tabelle semantic_worker_runs

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`binding_id`	`UUID`	Ja *	FK ➔ semantic_worker_bindings.id	Feld binding_id
`event_id`	`UUID`	Ja *	-	Feld event_id
`entity_id`	`UUID`	Ja *	-	Feld entity_id
`decision`	`VARCHAR(16)`	Ja *	-	Feld decision
`context_hash`	`VARCHAR(64)`	Nein	-	Feld context_hash
`result`	`JSONB`	Ja *	-	Feld result
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ semantic_worker_bindings.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ServiceChecklistTemplates service_checklist_templates RLS Aktiv

14 Câmpuri / coloane

Tabelle service_checklist_templates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`trade`	`VARCHAR(64)`	Nein	-	Feld trade
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`definition`	`JSONB`	Ja *	-	Feld definition
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ServiceMaterialEntries service_material_entries RLS Aktiv

11 Câmpuri / coloane

Tabelle service_material_entries

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`service_report_id`	`UUID`	Ja *	FK ➔ service_reports.id	Feld service_report_id
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`quantity`	`NUMERIC`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`stock_movement_id`	`UUID`	Nein	FK ➔ stock_movements.id	Feld stock_movement_id
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ServicePhotos service_photos RLS Aktiv

12 Câmpuri / coloane

Tabelle service_photos

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`service_report_id`	`UUID`	Ja *	FK ➔ service_reports.id	Feld service_report_id
`document_id`	`UUID`	Ja *	FK ➔ documents.id	Feld document_id
`caption`	`VARCHAR(255)`	Nein	-	Feld caption
`checklist_item_label`	`VARCHAR(255)`	Nein	-	Feld checklist_item_label
`taken_at`	`DATETIME`	Nein	-	Feld taken_at
`lat`	`NUMERIC(9, 6)`	Nein	-	Feld lat
`lng`	`NUMERIC(9, 6)`	Nein	-	Feld lng
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

ServiceReports service_reports RLS Aktiv

49 Câmpuri / coloane

Tabelle service_reports

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`report_number`	`VARCHAR(32)`	Ja *	-	Feld report_number
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`asset_id`	`UUID`	Nein	FK ➔ assets.id	Feld asset_id
`technician_id`	`UUID`	Nein	FK ➔ organization_users.id	Feld technician_id
`checklist_template_id`	`UUID`	Nein	FK ➔ service_checklist_templates.id	Feld checklist_template_id
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`description`	`TEXT`	Nein	-	Feld description
`scheduled_start`	`DATETIME`	Nein	-	Feld scheduled_start
`scheduled_end`	`DATETIME`	Nein	-	Feld scheduled_end
`travel_started_at`	`DATETIME`	Nein	-	Feld travel_started_at
`arrived_at`	`DATETIME`	Nein	-	Feld arrived_at
`work_started_at`	`DATETIME`	Nein	-	Feld work_started_at
`work_ended_at`	`DATETIME`	Nein	-	Feld work_ended_at
`departed_at`	`DATETIME`	Nein	-	Feld departed_at
`location_lat`	`NUMERIC(9, 6)`	Nein	-	Feld location_lat
`location_lng`	`NUMERIC(9, 6)`	Nein	-	Feld location_lng
`location_address`	`VARCHAR(512)`	Nein	-	Feld location_address
`travel_minutes`	`INTEGER`	Ja *	-	Feld travel_minutes
`work_minutes`	`INTEGER`	Ja *	-	Feld work_minutes
`break_minutes`	`INTEGER`	Ja *	-	Feld break_minutes
`checklist_results`	`JSONB`	Ja *	-	Feld checklist_results
`work_performed`	`TEXT`	Nein	-	Feld work_performed
`result_summary`	`TEXT`	Nein	-	Feld result_summary
`defects_found`	`TEXT`	Nein	-	Feld defects_found
`follow_up_needed`	`BOOLEAN`	Ja *	-	Feld follow_up_needed
`follow_up_notes`	`TEXT`	Nein	-	Feld follow_up_notes
`acceptance_items`	`JSONB`	Ja *	-	Feld acceptance_items
`acceptance_status`	`VARCHAR(32)`	Ja *	-	Feld acceptance_status
`acceptance_notes`	`TEXT`	Nein	-	Feld acceptance_notes
`accepted_at`	`DATETIME`	Nein	-	Feld accepted_at
`accepted_by_name`	`VARCHAR(255)`	Nein	-	Feld accepted_by_name
`signature_document_id`	`UUID`	Nein	FK ➔ documents.id	Feld signature_document_id
`signed_by_name`	`VARCHAR(255)`	Nein	-	Feld signed_by_name
`signed_at`	`DATETIME`	Nein	-	Feld signed_at
`pdf_document_id`	`UUID`	Nein	FK ➔ documents.id	Feld pdf_document_id
`completed_at`	`DATETIME`	Nein	-	Feld completed_at
`ticket_id`	`UUID`	Nein	FK ➔ tickets.id	Feld ticket_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

ServiceTimeEntries service_time_entries RLS Aktiv

15 Câmpuri / coloane

Tabelle service_time_entries

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`service_report_id`	`UUID`	Ja *	FK ➔ service_reports.id	Feld service_report_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`user_id`	`UUID`	Nein	FK ➔ users.id	Feld user_id
`entry_type`	`VARCHAR(48)`	Ja *	-	Feld entry_type
`started_at`	`DATETIME`	Nein	-	Feld started_at
`ended_at`	`DATETIME`	Nein	-	Feld ended_at
`duration_minutes`	`INTEGER`	Ja *	-	Feld duration_minutes
`description`	`TEXT`	Nein	-	Feld description
`billable`	`BOOLEAN`	Ja *	-	Feld billable
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

StandardCategories standard_categories

9 Câmpuri / coloane

Tabelle standard_categories

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Nein	PK	Feld code
`parent_code`	`VARCHAR(32)`	Nein	-	Feld parent_code
`level`	`INTEGER`	Ja *	-	Feld level
`name_de`	`VARCHAR(512)`	Nein	-	Feld name_de
`name_en`	`VARCHAR(512)`	Ja *	-	Feld name_en
`name_fr`	`VARCHAR(512)`	Nein	-	Feld name_fr
`name_it`	`VARCHAR(512)`	Nein	-	Feld name_it
`name_es`	`VARCHAR(512)`	Nein	-	Feld name_es
`active`	`BOOLEAN`	Ja *	-	Feld active

StandardCategoryFieldsetTemplates standard_category_fieldset_templates

7 Câmpuri / coloane

Tabelle standard_category_fieldset_templates

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`standard_code`	`VARCHAR(32)`	Nein	PK	Feld standard_code
`version`	`INTEGER`	Ja *	-	Feld version
`fieldset_title`	`VARCHAR(255)`	Ja *	-	Feld fieldset_title
`fieldset_description`	`TEXT`	Nein	-	Feld fieldset_description
`attributes`	`JSONB`	Ja *	-	Feld attributes
`active`	`BOOLEAN`	Ja *	-	Feld active
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

StockCountLines stock_count_lines RLS Aktiv

15 Câmpuri / coloane

Tabelle stock_count_lines

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`session_id`	`UUID`	Ja *	FK ➔ stock_count_sessions.id	Feld session_id
`position`	`INTEGER`	Ja *	-	Feld position
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`location_id`	`UUID`	Ja *	FK ➔ locations.id	Feld location_id
`system_quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld system_quantity
`counted_quantity`	`NUMERIC(14, 4)`	Nein	-	Feld counted_quantity
`line_status`	`VARCHAR(16)`	Ja *	-	Feld line_status
`difference`	`NUMERIC(14, 4)`	Nein	-	Feld difference
`notes`	`VARCHAR(500)`	Nein	-	Feld notes
`movement_id`	`UUID`	Nein	FK ➔ stock_movements.id	Feld movement_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

StockCountSessions stock_count_sessions RLS Aktiv

17 Câmpuri / coloane

Tabelle stock_count_sessions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`count_number`	`VARCHAR(40)`	Ja *	-	Feld count_number
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`scope`	`VARCHAR(16)`	Ja *	-	Feld scope
`location_id`	`UUID`	Nein	FK ➔ locations.id	Feld location_id
`notes`	`VARCHAR(1000)`	Nein	-	Feld notes
`counted_at`	`DATETIME`	Nein	-	Feld counted_at
`released_at`	`DATETIME`	Nein	-	Feld released_at
`cancelled_at`	`DATETIME`	Nein	-	Feld cancelled_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

StockIssueItems stock_issue_items RLS Aktiv

15 Câmpuri / coloane

Tabelle stock_issue_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`issue_id`	`UUID`	Ja *	FK ➔ stock_issues.id	Feld issue_id
`position`	`INTEGER`	Ja *	-	Feld position
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`from_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld from_location_id
`invoice_item_id`	`UUID`	Nein	FK ➔ invoice_items.id	Feld invoice_item_id
`reservation_id`	`UUID`	Nein	FK ➔ stock_reservations.id	Feld reservation_id
`tracking_entries`	`JSONB`	Ja *	-	Feld tracking_entries
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

StockIssues stock_issues RLS Aktiv

24 Câmpuri / coloane

Tabelle stock_issues

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`issue_number`	`VARCHAR(32)`	Ja *	-	Feld issue_number
`reason`	`VARCHAR(48)`	Ja *	-	Feld reason
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`owner_customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld owner_customer_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`invoice_id`	`UUID`	Nein	FK ➔ invoices.id	Feld invoice_id
`from_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld from_location_id
`delivery_note_document_id`	`UUID`	Nein	FK ➔ documents.id	Feld delivery_note_document_id
`shipment_id`	`UUID`	Nein	FK ➔ logistics_shipments.id	Feld shipment_id
`notes`	`TEXT`	Nein	-	Feld notes
`posted_at`	`DATETIME`	Nein	-	Feld posted_at
`reversed_at`	`DATETIME`	Nein	-	Feld reversed_at
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

StockLots stock_lots RLS Aktiv

19 Câmpuri / coloane

Tabelle stock_lots

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`code`	`VARCHAR(128)`	Ja *	-	Feld code
`tracking_type`	`VARCHAR(48)`	Ja *	-	Feld tracking_type
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`goods_receipt_item_id`	`UUID`	Nein	FK ➔ goods_receipt_items.id	Feld goods_receipt_item_id
`manufactured_at`	`DATE`	Nein	-	Feld manufactured_at
`expires_at`	`DATE`	Nein	-	Feld expires_at
`active`	`BOOLEAN`	Ja *	-	Feld active
`parent_lot_id`	`UUID`	Nein	FK ➔ stock_lots.id	Feld parent_lot_id
`source_assembly_order_id`	`UUID`	Nein	FK ➔ assembly_orders.id	Feld source_assembly_order_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

StockMovementLots stock_movement_lots RLS Aktiv

8 Câmpuri / coloane

Tabelle stock_movement_lots

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`movement_id`	`UUID`	Ja *	FK ➔ stock_movements.id	Feld movement_id
`lot_id`	`UUID`	Ja *	FK ➔ stock_lots.id	Feld lot_id
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

StockMovements stock_movements RLS Aktiv

25 Câmpuri / coloane

Tabelle stock_movements

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`from_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld from_location_id
`to_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld to_location_id
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_cost`	`NUMERIC(14, 2)`	Nein	-	Feld unit_cost
`total_cost`	`NUMERIC(14, 2)`	Nein	-	Feld total_cost
`notes`	`TEXT`	Nein	-	Feld notes
`movement_type`	`VARCHAR(48)`	Ja *	-	Feld movement_type
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`expense_item_id`	`UUID`	Nein	FK ➔ expense_items.id	Feld expense_item_id
`goods_receipt_item_id`	`UUID`	Nein	FK ➔ goods_receipt_items.id	Feld goods_receipt_item_id
`stock_issue_item_id`	`UUID`	Nein	FK ➔ stock_issue_items.id	Feld stock_issue_item_id
`owner_customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld owner_customer_id
`reversal_of_id`	`UUID`	Nein	FK ➔ stock_movements.id	Feld reversal_of_id
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`source`	`VARCHAR(32)`	Nein	-	Feld source
`confidence`	`NUMERIC(4, 3)`	Nein	-	Feld confidence
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

StockReservations stock_reservations RLS Aktiv

17 Câmpuri / coloane

Tabelle stock_reservations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`location_id`	`UUID`	Nein	FK ➔ locations.id	Feld location_id
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`fulfilled_quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld fulfilled_quantity
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`source_type`	`VARCHAR(32)`	Ja *	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`expires_at`	`DATETIME`	Nein	-	Feld expires_at
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`owner_customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld owner_customer_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`metadata`	`JSONB`	Ja *	-	Feld metadata

StorageCategories storage_categories RLS Aktiv

16 Câmpuri / coloane

Tabelle storage_categories

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`code`	`VARCHAR(32)`	Nein	-	Feld code
`max_weight_kg`	`NUMERIC`	Nein	-	Feld max_weight_kg
`max_quantity`	`NUMERIC(14, 4)`	Nein	-	Feld max_quantity
`new_product_policy`	`VARCHAR(24)`	Ja *	-	Feld new_product_policy
`active`	`BOOLEAN`	Ja *	-	Feld active
`warehouse_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld warehouse_location_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

StorageOrderLines storage_order_lines RLS Aktiv

10 Câmpuri / coloane

Tabelle storage_order_lines

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`order_id`	`UUID`	Ja *	FK ➔ storage_orders.id	Feld order_id
`article_id`	`UUID`	Ja *	FK ➔ stored_articles.id	Feld article_id
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`lot_code`	`VARCHAR(64)`	Nein	-	Feld lot_code
`location_id`	`UUID`	Nein	FK ➔ locations.id	Feld location_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

StorageOrders storage_orders RLS Aktiv

19 Câmpuri / coloane

Tabelle storage_orders

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`order_number`	`VARCHAR(64)`	Ja *	-	Feld order_number
`contract_id`	`UUID`	Ja *	FK ➔ contracts.id	Feld contract_id
`order_type`	`VARCHAR(8)`	Ja *	-	Feld order_type
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`reference`	`VARCHAR(128)`	Nein	-	Feld reference
`route_id`	`UUID`	Nein	FK ➔ warehouse_routes.id	Feld route_id
`carrier`	`VARCHAR(128)`	Nein	-	Feld carrier
`planned_at`	`DATETIME`	Nein	-	Feld planned_at
`done_at`	`DATETIME`	Nein	-	Feld done_at
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

StoredArticles stored_articles RLS Aktiv

19 Câmpuri / coloane

Tabelle stored_articles

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`owner_type`	`VARCHAR(16)`	Ja *	-	Feld owner_type
`owner_id`	`UUID`	Ja *	-	Feld owner_id
`sku`	`VARCHAR(64)`	Ja *	-	Feld sku
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`storage_unit`	`VARCHAR(16)`	Nein	-	Feld storage_unit
`barcode`	`VARCHAR(64)`	Nein	-	Feld barcode
`description`	`TEXT`	Nein	-	Feld description
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

TaxCodes tax_codes RLS Aktiv

17 Câmpuri / coloane

Tabelle tax_codes

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`rate`	`NUMERIC(6, 4)`	Ja *	-	Feld rate
`direction`	`VARCHAR(48)`	Ja *	-	Feld direction
`account_code`	`VARCHAR(32)`	Nein	-	Feld account_code
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`counter_account_code`	`VARCHAR(32)`	Nein	-	Feld counter_account_code
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

TenantAiCredentials tenant_ai_credentials RLS Aktiv

18 Câmpuri / coloane

Tabelle tenant_ai_credentials

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`provider`	`VARCHAR(32)`	Ja *	-	Feld provider
`label`	`VARCHAR(120)`	Ja *	-	Feld label
`api_key_encrypted`	`TEXT`	Ja *	-	Feld api_key_encrypted
`base_url`	`VARCHAR(255)`	Nein	-	Feld base_url
`model_overrides`	`JSONB`	Ja *	-	Feld model_overrides
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`last_validated_at`	`DATETIME`	Nein	-	Feld last_validated_at
`last_error`	`VARCHAR(500)`	Nein	-	Feld last_error
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

TenantBranding tenant_branding RLS Aktiv

15 Câmpuri / coloane

Tabelle tenant_branding

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`logo_png`	`BLOB`	Nein	-	Feld logo_png
`logo_width_px`	`INTEGER`	Nein	-	Feld logo_width_px
`logo_height_px`	`INTEGER`	Nein	-	Feld logo_height_px
`logo_filename`	`VARCHAR(255)`	Nein	-	Feld logo_filename
`logo_sha256`	`VARCHAR(64)`	Nein	-	Feld logo_sha256
`accent_color`	`VARCHAR(7)`	Ja *	-	Feld accent_color
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

TenantCurrencies tenant_currencies RLS Aktiv

13 Câmpuri / coloane

Tabelle tenant_currencies

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(3)`	Ja *	-	Feld code
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`active`	`BOOLEAN`	Ja *	-	Feld active
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

TenantPaymentTerms tenant_payment_terms RLS Aktiv

16 Câmpuri / coloane

Tabelle tenant_payment_terms

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`net_days`	`INTEGER`	Ja *	-	Feld net_days
`skonto_days`	`INTEGER`	Nein	-	Feld skonto_days
`skonto_percent`	`NUMERIC(6, 2)`	Nein	-	Feld skonto_percent
`active`	`BOOLEAN`	Ja *	-	Feld active
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

TenantRoles tenant_roles RLS Aktiv

11 Câmpuri / coloane

Tabelle tenant_roles

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(128)`	Ja *	-	Feld name
`code`	`VARCHAR(64)`	Ja *	-	Feld code
`description`	`VARCHAR(512)`	Nein	-	Feld description
`sector`	`VARCHAR(64)`	Ja *	-	Feld sector
`base_role`	`VARCHAR(64)`	Nein	-	Feld base_role
`permissions`	`JSONB`	Ja *	-	Feld permissions
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

TenantStorageDestinations tenant_storage_destinations RLS Aktiv

35 Câmpuri / coloane

Tabelle tenant_storage_destinations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`mode`	`VARCHAR(48)`	Ja *	-	Feld mode
`provider_type`	`VARCHAR(48)`	Ja *	-	Feld provider_type
`active`	`BOOLEAN`	Ja *	-	Feld active
`s3_endpoint_url`	`VARCHAR(512)`	Nein	-	Feld s3_endpoint_url
`s3_region`	`VARCHAR(64)`	Nein	-	Feld s3_region
`s3_bucket`	`VARCHAR(128)`	Nein	-	Feld s3_bucket
`s3_access_key`	`VARCHAR(256)`	Nein	-	Feld s3_access_key
`encrypted_s3_secret_key`	`TEXT`	Nein	-	Feld encrypted_s3_secret_key
`s3_force_path_style`	`BOOLEAN`	Ja *	-	Feld s3_force_path_style
`s3_prefix`	`VARCHAR(256)`	Nein	-	Feld s3_prefix
`webdav_url`	`VARCHAR(512)`	Nein	-	Feld webdav_url
`webdav_username`	`VARCHAR(256)`	Nein	-	Feld webdav_username
`encrypted_webdav_password`	`TEXT`	Nein	-	Feld encrypted_webdav_password
`webdav_base_path`	`VARCHAR(512)`	Nein	-	Feld webdav_base_path
`oauth_account_email`	`VARCHAR(320)`	Nein	-	Feld oauth_account_email
`oauth_tenant_id`	`VARCHAR(128)`	Nein	-	Feld oauth_tenant_id
`encrypted_oauth_access_token`	`TEXT`	Nein	-	Feld encrypted_oauth_access_token
`oauth_access_token_expiry`	`DATETIME`	Nein	-	Feld oauth_access_token_expiry
`encrypted_oauth_refresh_token`	`TEXT`	Nein	-	Feld encrypted_oauth_refresh_token
`oauth_state`	`VARCHAR(128)`	Nein	-	Feld oauth_state
`oauth_folder_id`	`VARCHAR(512)`	Nein	-	Feld oauth_folder_id
`oauth_folder_label`	`VARCHAR(256)`	Nein	-	Feld oauth_folder_label
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`last_error`	`TEXT`	Nein	-	Feld last_error
`last_tested_at`	`DATETIME`	Nein	-	Feld last_tested_at
`last_synced_at`	`DATETIME`	Nein	-	Feld last_synced_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

TenantSubscriptions tenant_subscriptions RLS Aktiv

14 Câmpuri / coloane

Tabelle tenant_subscriptions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`kind`	`VARCHAR(32)`	Ja *	-	Feld kind
`package_key`	`VARCHAR(32)`	Ja *	-	Feld package_key
`stripe_subscription_id`	`VARCHAR(64)`	Ja *	-	Feld stripe_subscription_id
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`amount_monthly`	`NUMERIC(14, 2)`	Ja *	-	Feld amount_monthly
`credit_monthly`	`NUMERIC(14, 2)`	Nein	-	Feld credit_monthly
`storage_gb`	`INTEGER`	Nein	-	Feld storage_gb
`max_users`	`INTEGER`	Nein	-	Feld max_users
`cancel_at_period_end`	`BOOLEAN`	Ja *	-	Feld cancel_at_period_end
`current_period_end`	`DATETIME`	Nein	-	Feld current_period_end
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

ThirdPartyStockMovements third_party_stock_movements RLS Aktiv

21 Câmpuri / coloane

Tabelle third_party_stock_movements

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`article_id`	`UUID`	Ja *	FK ➔ stored_articles.id	Feld article_id
`contract_id`	`UUID`	Nein	FK ➔ contracts.id	Feld contract_id
`order_id`	`UUID`	Nein	-	Feld order_id
`movement_type`	`VARCHAR(16)`	Ja *	-	Feld movement_type
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`from_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld from_location_id
`to_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld to_location_id
`lot_code`	`VARCHAR(64)`	Nein	-	Feld lot_code
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`reference`	`VARCHAR(128)`	Nein	-	Feld reference
`notes`	`TEXT`	Nein	-	Feld notes
`idempotency_key`	`VARCHAR(128)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

UnitsOfMeasure units_of_measure RLS Aktiv

19 Câmpuri / coloane

Tabelle units_of_measure

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(16)`	Ja *	-	Feld code
`symbol`	`VARCHAR(16)`	Ja *	-	Feld symbol
`category`	`VARCHAR(32)`	Ja *	-	Feld category
`name_de`	`VARCHAR(64)`	Ja *	-	Feld name_de
`name_en`	`VARCHAR(64)`	Ja *	-	Feld name_en
`name_fr`	`VARCHAR(64)`	Nein	-	Feld name_fr
`name_it`	`VARCHAR(64)`	Nein	-	Feld name_it
`name_es`	`VARCHAR(64)`	Nein	-	Feld name_es
`active`	`BOOLEAN`	Ja *	-	Feld active
`is_default`	`BOOLEAN`	Ja *	-	Feld is_default
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

Users users

16 Câmpuri / coloane

Tabelle users

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`email`	`VARCHAR(320)`	Ja *	-	Feld email
`password_hash`	`VARCHAR(128)`	Nein	-	Feld password_hash
`credential_version`	`INTEGER`	Ja *	-	Feld credential_version
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`phone`	`VARCHAR(64)`	Nein	-	Feld phone
`language`	`VARCHAR(10)`	Ja *	-	Feld language
`timezone`	`VARCHAR(64)`	Ja *	-	Feld timezone
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`totp_secret_encrypted`	`VARCHAR(512)`	Nein	-	Feld totp_secret_encrypted
`last_login_at`	`DATETIME`	Nein	-	Feld last_login_at
`is_portal_admin`	`BOOLEAN`	Ja *	-	Feld is_portal_admin
`anonymized_at`	`DATETIME`	Nein	-	Feld anonymized_at
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehouseDockSlots warehouse_dock_slots RLS Aktiv

13 Câmpuri / coloane

Tabelle warehouse_dock_slots

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`dock_id`	`UUID`	Ja *	FK ➔ warehouse_docks.id	Feld dock_id
`window_start`	`DATETIME`	Ja *	-	Feld window_start
`window_end`	`DATETIME`	Ja *	-	Feld window_end
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`tour_stop_id`	`UUID`	Nein	FK ➔ logistics_tour_stops.id	Feld tour_stop_id
`shipment_id`	`UUID`	Nein	FK ➔ logistics_shipments.id	Feld shipment_id
`checked_in_at`	`DATETIME`	Nein	-	Feld checked_in_at
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehouseDocks warehouse_docks RLS Aktiv

16 Câmpuri / coloane

Tabelle warehouse_docks

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`location_id`	`UUID`	Ja *	FK ➔ locations.id	Feld location_id
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`dock_type`	`VARCHAR(48)`	Ja *	-	Feld dock_type
`capacity_parallel`	`INTEGER`	Ja *	-	Feld capacity_parallel
`is_active`	`BOOLEAN`	Ja *	-	Feld is_active
`notes`	`TEXT`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehouseOperationTypes warehouse_operation_types RLS Aktiv

27 Câmpuri / coloane

Tabelle warehouse_operation_types

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`sequence_prefix`	`VARCHAR(16)`	Ja *	-	Feld sequence_prefix
`barcode_prefix`	`VARCHAR(32)`	Nein	-	Feld barcode_prefix
`default_source_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld default_source_location_id
`default_destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld default_destination_location_id
`reservation_method`	`VARCHAR(24)`	Ja *	-	Feld reservation_method
`create_backorder`	`VARCHAR(8)`	Ja *	-	Feld create_backorder
`returns_operation_type_id`	`UUID`	Nein	FK ➔ warehouse_operation_types.id	Feld returns_operation_type_id
`show_in_overview`	`BOOLEAN`	Ja *	-	Feld show_in_overview
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`active`	`BOOLEAN`	Ja *	-	Feld active
`warehouse_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld warehouse_location_id
`print_labels_enabled`	`BOOLEAN`	Ja *	-	Feld print_labels_enabled
`auto_print_labels`	`BOOLEAN`	Ja *	-	Feld auto_print_labels
`label_template_code`	`VARCHAR(64)`	Nein	-	Feld label_template_code
`label_printer_id`	`UUID`	Nein	FK ➔ printers.id	Feld label_printer_id
`label_copies`	`INTEGER`	Ja *	-	Feld label_copies
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehousePickCarts warehouse_pick_carts RLS Aktiv

15 Câmpuri / coloane

Tabelle warehouse_pick_carts

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`barcode`	`VARCHAR(64)`	Nein	-	Feld barcode
`slot_count`	`INTEGER`	Ja *	-	Feld slot_count
`warehouse_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld warehouse_location_id
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehousePickTotes warehouse_pick_totes RLS Aktiv

16 Câmpuri / coloane

Tabelle warehouse_pick_totes

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`barcode`	`VARCHAR(64)`	Nein	-	Feld barcode
`tote_type`	`VARCHAR(24)`	Ja *	-	Feld tote_type
`cart_id`	`UUID`	Nein	FK ➔ warehouse_pick_carts.id	Feld cart_id
`slot_index`	`INTEGER`	Nein	-	Feld slot_index
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehousePickingItems warehouse_picking_items RLS Aktiv

14 Câmpuri / coloane

Tabelle warehouse_picking_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`picking_id`	`UUID`	Ja *	FK ➔ warehouse_pickings.id	Feld picking_id
`position`	`INTEGER`	Ja *	-	Feld position
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`quantity_demanded`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_demanded
`quantity_reserved`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_reserved
`quantity_done`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_done
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`source_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld source_location_id
`destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld destination_location_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehousePickings warehouse_pickings RLS Aktiv

31 Câmpuri / coloane

Tabelle warehouse_pickings

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`picking_number`	`VARCHAR(40)`	Ja *	-	Feld picking_number
`picking_type`	`VARCHAR(32)`	Ja *	-	Feld picking_type
`operation_type_id`	`UUID`	Nein	FK ➔ warehouse_operation_types.id	Feld operation_type_id
`stock_issue_id`	`UUID`	Nein	FK ➔ stock_issues.id	Feld stock_issue_id
`wave_id`	`UUID`	Nein	FK ➔ warehouse_waves.id	Feld wave_id
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`purchase_id`	`UUID`	Nein	FK ➔ purchases.id	Feld purchase_id
`invoice_id`	`UUID`	Nein	FK ➔ invoices.id	Feld invoice_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`assembly_order_id`	`UUID`	Nein	FK ➔ assembly_orders.id	Feld assembly_order_id
`process_intent`	`VARCHAR(32)`	Nein	-	Feld process_intent
`service_report_id`	`UUID`	Nein	FK ➔ service_reports.id	Feld service_report_id
`cart_id`	`UUID`	Nein	FK ➔ warehouse_pick_carts.id	Feld cart_id
`tote_id`	`UUID`	Nein	FK ➔ warehouse_pick_totes.id	Feld tote_id
`source_quote_id`	`UUID`	Nein	FK ➔ quotes.id	Feld source_quote_id
`source_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld source_location_id
`destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld destination_location_id
`assigned_user_id`	`UUID`	Nein	FK ➔ users.id	Feld assigned_user_id
`scheduled_at`	`DATETIME`	Nein	-	Feld scheduled_at
`started_at`	`DATETIME`	Nein	-	Feld started_at
`completed_at`	`DATETIME`	Nein	-	Feld completed_at
`notes`	`VARCHAR(1000)`	Nein	-	Feld notes
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehousePutawayRules warehouse_putaway_rules RLS Aktiv

21 Câmpuri / coloane

Tabelle warehouse_putaway_rules

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`product_category_id`	`UUID`	Nein	FK ➔ product_categories.id	Feld product_category_id
`arrive_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld arrive_location_id
`store_location_id`	`UUID`	Ja *	FK ➔ locations.id	Feld store_location_id
`storage_category_id`	`UUID`	Nein	FK ➔ storage_categories.id	Feld storage_category_id
`goods_kind`	`VARCHAR(16)`	Ja *	-	Feld goods_kind
`stock_owner`	`VARCHAR(16)`	Ja *	-	Feld stock_owner
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`sublocation_mode`	`VARCHAR(16)`	Ja *	-	Feld sublocation_mode
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`active`	`BOOLEAN`	Ja *	-	Feld active
`warehouse_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld warehouse_location_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehouseRoutes warehouse_routes RLS Aktiv

25 Câmpuri / coloane

Tabelle warehouse_routes

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`operation_type`	`VARCHAR(32)`	Ja *	-	Feld operation_type
`action`	`VARCHAR(16)`	Ja *	-	Feld action
`goods_kind`	`VARCHAR(16)`	Ja *	-	Feld goods_kind
`stock_owner`	`VARCHAR(16)`	Ja *	-	Feld stock_owner
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`source_zone_id`	`UUID`	Nein	FK ➔ warehouse_zones.id	Feld source_zone_id
`destination_zone_id`	`UUID`	Nein	FK ➔ warehouse_zones.id	Feld destination_zone_id
`source_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld source_location_id
`destination_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld destination_location_id
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`product_category_id`	`UUID`	Nein	FK ➔ product_categories.id	Feld product_category_id
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`active`	`BOOLEAN`	Ja *	-	Feld active
`warehouse_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld warehouse_location_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehouseSettings warehouse_settings RLS Aktiv

25 Câmpuri / coloane

Tabelle warehouse_settings

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`track_lots`	`BOOLEAN`	Ja *	-	Feld track_lots
`track_serial_numbers`	`BOOLEAN`	Ja *	-	Feld track_serial_numbers
`track_expiry_dates`	`BOOLEAN`	Ja *	-	Feld track_expiry_dates
`multi_step_routes`	`BOOLEAN`	Ja *	-	Feld multi_step_routes
`storage_categories`	`BOOLEAN`	Ja *	-	Feld storage_categories
`consignment`	`BOOLEAN`	Ja *	-	Feld consignment
`use_packages`	`BOOLEAN`	Ja *	-	Feld use_packages
`bonded_customs`	`BOOLEAN`	Ja *	-	Feld bonded_customs
`receipt_steps`	`INTEGER`	Ja *	-	Feld receipt_steps
`delivery_steps`	`INTEGER`	Ja *	-	Feld delivery_steps
`default_removal_strategy`	`VARCHAR(8)`	Ja *	-	Feld default_removal_strategy
`annual_inventory_day`	`INTEGER`	Nein	-	Feld annual_inventory_day
`annual_inventory_month`	`INTEGER`	Nein	-	Feld annual_inventory_month
`scan_required_for_moves`	`BOOLEAN`	Ja *	-	Feld scan_required_for_moves
`auto_confirm_deliveries`	`BOOLEAN`	Ja *	-	Feld auto_confirm_deliveries
`warehouse_location_id`	`UUID`	Nein	FK ➔ locations.id	Feld warehouse_location_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehouseWaves warehouse_waves RLS Aktiv

15 Câmpuri / coloane

Tabelle warehouse_waves

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`wave_number`	`VARCHAR(40)`	Ja *	-	Feld wave_number
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`assigned_user_id`	`UUID`	Nein	FK ➔ users.id	Feld assigned_user_id
`notes`	`VARCHAR(1000)`	Nein	-	Feld notes
`released_at`	`DATETIME`	Nein	-	Feld released_at
`completed_at`	`DATETIME`	Nein	-	Feld completed_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WarehouseZones warehouse_zones RLS Aktiv

15 Câmpuri / coloane

Tabelle warehouse_zones

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`location_id`	`UUID`	Ja *	FK ➔ locations.id	Feld location_id
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`name`	`VARCHAR(120)`	Ja *	-	Feld name
`zone_type`	`VARCHAR(32)`	Ja *	-	Feld zone_type
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WebhookDeliveries webhook_deliveries RLS Aktiv

19 Câmpuri / coloane

Tabelle webhook_deliveries

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`subscription_id`	`UUID`	Ja *	FK ➔ webhook_subscriptions.id	Feld subscription_id
`signal_key`	`VARCHAR(128)`	Ja *	-	Feld signal_key
`payload`	`JSONB`	Ja *	-	Feld payload
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`attempt_count`	`INTEGER`	Ja *	-	Feld attempt_count
`next_attempt_at`	`DATETIME`	Nein	-	Feld next_attempt_at
`last_error`	`TEXT`	Nein	-	Feld last_error
`response_status`	`INTEGER`	Nein	-	Feld response_status
`response_body`	`TEXT`	Nein	-	Feld response_body
`delivered_at`	`DATETIME`	Nein	-	Feld delivered_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WebhookSubscriptions webhook_subscriptions RLS Aktiv

15 Câmpuri / coloane

Tabelle webhook_subscriptions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`signal_key`	`VARCHAR(128)`	Ja *	-	Feld signal_key
`target_url`	`VARCHAR(2048)`	Ja *	-	Feld target_url
`secret_encrypted`	`TEXT`	Nein	-	Feld secret_encrypted
`connector_operation_id`	`UUID`	Nein	FK ➔ connector_operations.id	Feld connector_operation_id
`active`	`BOOLEAN`	Ja *	-	Feld active
`description`	`VARCHAR(255)`	Nein	-	Feld description
`created_by`	`UUID`	Nein	-	Feld created_by
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WorkOrderItems work_order_items RLS Aktiv

22 Câmpuri / coloane

Tabelle work_order_items

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`work_order_id`	`UUID`	Ja *	FK ➔ work_orders.id	Feld work_order_id
`position`	`INTEGER`	Ja *	-	Feld position
`item_type`	`VARCHAR(32)`	Ja *	-	Feld item_type
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`sku`	`VARCHAR(64)`	Nein	-	Feld sku
`title`	`VARCHAR(255)`	Ja *	-	Feld title
`description`	`TEXT`	Nein	-	Feld description
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`unit_price`	`NUMERIC(14, 2)`	Ja *	-	Feld unit_price
`discount_percent`	`NUMERIC(5, 2)`	Ja *	-	Feld discount_percent
`tax_rate`	`NUMERIC(6, 4)`	Ja *	-	Feld tax_rate
`net_total`	`NUMERIC(14, 2)`	Ja *	-	Feld net_total
`tax_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld tax_amount
`gross_total`	`NUMERIC(14, 2)`	Ja *	-	Feld gross_total
`quantity_delivered`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_delivered
`quantity_invoiced`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_invoiced
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

WorkOrderMaterialRequirements work_order_material_requirements RLS Aktiv

18 Câmpuri / coloane

Tabelle work_order_material_requirements

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`work_order_id`	`UUID`	Ja *	FK ➔ work_orders.id	Feld work_order_id
`product_id`	`UUID`	Ja *	FK ➔ products.id	Feld product_id
`quantity_required`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_required
`quantity_issued`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity_issued
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`notes`	`TEXT`	Nein	-	Feld notes
`purchase_id`	`UUID`	Nein	FK ➔ purchases.id	Feld purchase_id
`purchase_item_id`	`UUID`	Nein	FK ➔ purchase_items.id	Feld purchase_item_id
`procurement_status`	`VARCHAR(24)`	Ja *	-	Feld procurement_status
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

WorkstationCalendarExceptions workstation_calendar_exceptions RLS Aktiv

10 Câmpuri / coloane

Tabelle workstation_calendar_exceptions

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`workstation_id`	`UUID`	Ja *	FK ➔ workstations.id	Feld workstation_id
`exception_date`	`DATE`	Ja *	-	Feld exception_date
`capacity_minutes`	`INTEGER`	Ja *	-	Feld capacity_minutes
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`reason`	`VARCHAR(255)`	Nein	-	Feld reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

Workstations workstations RLS Aktiv

21 Câmpuri / coloane

Tabelle workstations

Feldname	Tip de date	Obligatoriu	Schlüssel	Importanța profesională
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`code`	`VARCHAR(32)`	Nein	-	Feld code
`workstation_type`	`VARCHAR(48)`	Ja *	-	Feld workstation_type
`location_id`	`UUID`	Nein	FK ➔ locations.id	Feld location_id
`assigned_user_id`	`UUID`	Nein	FK ➔ users.id	Feld assigned_user_id
`active`	`BOOLEAN`	Ja *	-	Feld active
`capacity_notes`	`TEXT`	Nein	-	Feld capacity_notes
`notes`	`TEXT`	Nein	-	Feld notes
`capacity_minutes_per_day`	`INTEGER`	Ja *	-	Feld capacity_minutes_per_day
`working_days`	`JSONB`	Ja *	-	Feld working_days
`parallel_units`	`INTEGER`	Ja *	-	Feld parallel_units
`efficiency_percent`	`NUMERIC(6, 2)`	Ja *	-	Feld efficiency_percent
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

🔌 Puncte de inițiere (UI & API)

Art	Metoda	Punctul de încheiere / traseul	Titel & Zweck	Asigurarea
⚡ REST API	DELETE	`/api/v1/admin/roles/{role_id}`	delete_custom_role Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	DELETE	`/api/v1/org-units/{unit_id}`	delete_unit Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	DELETE	`/api/v1/platform-products/{product_id}`	delete_product Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	DELETE	`/api/v1/platform-settings/{key}`	reset_setting Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	GET	`/admin`	admin_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/accounts`	admin_accounts_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/ai`	admin_ai_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/ai/guthaben/{topup_id}/gutschrift`	admin_ai_topup_credit_note Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/ai/guthaben/{topup_id}/rechnung`	admin_ai_topup_invoice Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/billing`	admin_billing_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/branche`	admin_industry_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/branche/preview`	admin_industry_preview Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/categories`	categories_admin_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/categories/new`	categories_admin_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/categories/{category_id}/edit`	categories_admin_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/categories/{category_id}/fields`	categories_admin_fields_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/consultants`	admin_consultant_plans_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/controlling`	admin_controlling_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/currencies`	currencies_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/currencies/new`	currencies_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/currencies/{currency_id}/edit`	currencies_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/documents`	admin_documents_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/geo`	admin_geo_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/journals`	admin_journals_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/number-sequences`	admin_number_sequences_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/number-sequences/new`	number_sequences_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/number-sequences/{sequence_id}/edit`	number_sequences_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/nummernkreise`	admin_number_sequences_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/nummernkreise/new`	number_sequences_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/nummernkreise/{sequence_id}/edit`	number_sequences_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/onboarding/plan`	admin_onboarding_plan Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/org-units`	admin_org_units_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/org-units/new`	admin_org_units_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/org-units/{unit_id}/edit`	admin_org_units_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/payment-terms`	payment_terms_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/payment-terms/new`	payment_terms_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/payment-terms/{term_id}/edit`	payment_terms_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/permissions`	admin_permissions_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/platform-products`	platform_products_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/platform-products/new`	platform_products_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/platform-products/{product_id}/edit`	platform_products_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/portal`	admin_portal_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/profile`	admin_profile_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-advisor`	admin_tax_advisor_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-advisor/check`	admin_tax_advisor_check Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-codes`	tax_codes_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-codes/new`	tax_codes_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/tax-codes/{tax_id}/edit`	tax_codes_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/units`	units_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/units/new`	units_new_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/admin/units/{unit_id}/edit`	units_edit_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/consultant-cases`	list_consultant_cases Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/consultant-cases/{case_id}`	get_consultant_case Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/consultant-change-sets/{change_set_id}`	get_consultant_change_set Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/consultant-mandate`	get_consultant_mandate Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/consultant-plans`	list_consultant_plans Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/consultant-plans/{plan_id}`	get_consultant_plan Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/my-permissions`	my_permissions Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/outbox/dead-letters`	list_outbox_dead_letters Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/permissions`	permission_matrix Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/roles`	list_custom_roles Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/admin/roles/{role_id}`	get_custom_role Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units`	list_units Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units/by-user/{user_id}`	user_units Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units/me`	my_units Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/org-units/{unit_id}/members`	unit_members Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products`	list_published_products Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products/all`	list_all_products Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products/meta/agents`	list_available_agents Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-products/{product_id}`	get_product Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/platform-settings`	list_settings Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions`	list_subscriptions Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/collections`	colectări Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/collections.csv`	collections_csv Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/link-info`	link_info Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/{contract_id}`	Detalii Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/api/v1/subscriptions/{contract_id}/linked`	legate Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/platform`	platform_admin_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/platform/settings`	platform_settings_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/platform/tenants/{org_id}`	platform_tenant_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/subscriptions`	subscriptions_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	GET	`/subscriptions/collections`	subscription_collections_page Semantic binding: inventory_only; mutation=False	`admin`
⚡ REST API	PATCH	`/api/v1/admin/roles/{role_id}`	update_custom_role Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	PATCH	`/api/v1/org-units/{unit_id}`	update_unit Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	PATCH	`/api/v1/platform-products/{product_id}`	update_product Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts`	admin_add_party_account Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/category`	admin_create_category Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/category/{category_id}`	admin_set_category_accounts Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/category/{category_id}/deactivate`	admin_deactivate_category Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/supplier/{supplier_id}`	admin_set_supplier_account Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/tax`	admin_add_tax_code Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/tax/{tax_code_id}/deactivate`	admin_deactivate_tax_code Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/accounts/{account_id}/deactivate`	admin_deactivate_party_account Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/budget`	admin_ai_budget_save Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/budget/topup`	admin_ai_budget_topup Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/checkout`	admin_ai_checkout Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials`	admin_ai_credential_create Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials/{credential_id}/activate`	admin_ai_credential_activate Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials/{credential_id}/delete`	admin_ai_credential_delete Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials/{credential_id}/models`	admin_ai_credential_models_update Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/credentials/{credential_id}/test`	admin_ai_credential_test Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/platform-models`	admin_ai_platform_models_update Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/ai/storage-topup`	admin_storage_topup Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/billing/checkout`	admin_billing_checkout Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/billing/portal`	admin_billing_portal Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/billing/subscribe`	admin_billing_subscribe Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/branche/apply`	admin_industry_apply Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories`	admin_create_product_category Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/seed-default-fieldsets`	admin_categories_seed_default_fieldsets Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/{category_id}/delete`	admin_delete_product_category Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/{category_id}/edit`	admin_edit_product_category Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/categories/{category_id}/toggle-active`	admin_toggle_active_product_category Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/copy-global`	admin_copy_global_cost_library Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-center`	admin_add_cost_center Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-center/{cost_center_id}`	admin_update_cost_center Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-type`	admin_add_cost_type Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-type-accounts/propose`	admin_propose_cost_type_accounts Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/cost-type/{cost_type_id}`	admin_update_cost_type Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-center`	admin_upsert_global_cost_center Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-center/{center_id}`	admin_update_global_cost_center Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-type`	admin_upsert_global_cost_type Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/controlling/global-cost-type/{type_id}`	admin_update_global_cost_type Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/onboarding/apply`	admin_onboarding_apply Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/onboarding/approve-fieldsets`	admin_onboarding_approve_fieldsets Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/accounts`	admin_portal_account_create Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/accounts/{account_id}/password`	admin_portal_account_password Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/accounts/{account_id}/status`	admin_portal_account_status Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/requests/{request_id}/decide`	admin_portal_request_decide Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/portal/settings`	admin_portal_settings_save Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/profile`	admin_profile_save Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/tax-advisor/apply`	admin_tax_advisor_apply Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/admin/tax-advisor/proposal`	admin_tax_advisor_proposal Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/agents/{agent_name}/toggle`	toggle_agent Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-cases`	open_consultant_case Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-cases/{case_id}/compile`	compile_consultant_case Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-cases/{case_id}/observations`	record_consultant_observation Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-cases/{case_id}/requirements`	confirm_business_requirement Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-cases/{case_id}/status`	set_consultant_case_status Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-change-sets/{change_set_id}/activate`	activate_consultant_change_set Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-change-sets/{change_set_id}/approve`	approve_consultant_change_set Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-change-sets/{change_set_id}/go-live`	go_live_consultant_change_set Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-change-sets/{change_set_id}/simulate`	simulate_consultant_change_set Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-discovery/next`	next_consultant_discovery Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-mandate`	create_consultant_mandate Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-mandate/revoke`	revoke_consultant_mandate Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/setup`	create_setup_consultant_plan Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/{plan_id}/apply-bound-live`	apply_consultant_bound_live Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/{plan_id}/approve`	approve_consultant_plan Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/{plan_id}/execute-bound/{step_key}`	execute_consultant_bound_step Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/{plan_id}/simulate`	simulate_consultant_plan Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/{plan_id}/steps/configure_warehouse_settings/execute`	execute_consultant_warehouse_settings Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/{plan_id}/steps/propose_sales_policy/execute`	propose_consultant_sales_policy Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/consultant-plans/{plan_id}/steps/review_warehouse_structure/execute`	execute_consultant_warehouse_step Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/modules/{module}/toggle`	toggle_module Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/outbox/dead-letters/{event_id}/replay`	replay_outbox_dead_letter Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/admin/roles`	create_custom_role Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/org-units`	create_unit Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products`	create_product Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/propose`	propose_product Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/{product_id}/apply/{tenant_id}`	apply_product_to_tenant Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/{product_id}/publish`	publish_product Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/platform-products/{product_id}/unpublish`	unpublish_product Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/from-order/{work_order_id}`	from_order Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/link`	link Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/cancel`	anulare Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/change-line`	change_line Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/invoice-now`	invoice_now Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/pause`	Pauza Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/resume`	întocmire Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/api/v1/subscriptions/{contract_id}/revoke-cancellation`	Revocare Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/platform/tenants/{org_id}/plan`	platform_tenant_plan_set Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/platform/tenants/{org_id}/status`	platform_tenant_status_set Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	POST	`/platform/tenants/{org_id}/topups/{topup_id}/confirm`	platform_tenant_confirm_topup Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/org-units/by-user/{user_id}`	set_user_units Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/org-units/{unit_id}/members`	set_members Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/platform-settings/{key}`	update_setting Semantic binding: operator_surface; mutation=True	`admin`
⚡ REST API	PUT	`/api/v1/subscriptions/{contract_id}/settings`	save_settings Semantic binding: operator_surface; mutation=True	`admin`
🖥️ WEB-UI	GET	`/login`	Pagina de notificare Afişează formularul de conectare cu selecţia de limbă	Standard
🖥️ WEB-UI	POST	`/login`	Comerciantul de notificare Verificarea datelor de înscriere şi iniţierea sesiunii	Standard
🖥️ WEB-UI	POST	`/logout`	Decludere Invalidează sesiunea și șterge cookie-urile	Standard
⚡ REST API	GET	`/api/v1/auth/me`	Utilizatori actuali Întoarce profilul și autorizațiile	`authenticated`
⚡ REST API	GET	`/api/v1/admin/industry-profiles`	Profilul de sector În cazul în care se aplică cerințele de bază, se aplică cerințele de bază.	`admin:read`
⚡ REST API	POST	`/api/v1/admin/apply-industry-profile`	Aplicarea Comentariile și seturile de categorii inițiate	`admin:manage`

🛡️ Reglementări și respectare

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

Articolul 32 din Regulamentul general privind reglementarea și reglementarea în cauză
BSI Protecția fundamentală a informațiilor (directive de parolă, RLS)

Module legate:

➔ tenants ➔ employees ➔ policies

Administraţia sistemului

⚡ Fluxuri de lucru

Ciclul de viață al autentificării și autorizării user_auth_lifecycle

Instrucțiune de utilizare: agent de setare industrial plan:command_industry_setup_agent

Benutzerbefehl: integrations consultant agent plan:command_integrations_consultant_agent

Benutzerbefehl: setup consultant agent plan:command_setup_consultant_agent

🗄️ Modele de date & câmpuri

🔌 Puncte de inițiere (UI & API)

🛡️ Reglementări și respectare

Ciclul de viață al autentificării și autorizării `user_auth_lifecycle`

Instrucțiune de utilizare: agent de setare industrial `plan:command_industry_setup_agent`

Benutzerbefehl: integrations consultant agent `plan:command_integrations_consultant_agent`

Benutzerbefehl: setup consultant agent `plan:command_setup_consultant_agent`