RouItem

Tabelle: rou_item
Domain: RouItem · com.reybex.domain.wws.production
Modul: PRD

Partner-Hinweise

• Daten liegen mandantengetrennt – bei SELECT fast immer tenant_id = :mandant setzen (Spalte ggf. TenantId in älteren Tabellen).
• Schreibende SQL (INSERT/UPDATE/DELETE) nur in abgestimmten Export-/Report-Jobs (Transaktion BAS23) und nie ohne Freigabe durch reybex.
• Für API-Integrationen bevorzugt die API statt direkter DB-Zugriffe.

→ Beispiel-SQLs (BAS23)

Primärschlüssel

• id

Spalten

Spalte	SQL-Typ	NULL	Default	Beschreibung
id	bigint	Nein	—	Primärschlüssel (Domain: id)
tenant_id	bigint	Nein	—	Mandanten-ID (Multi-Tenant – in Abfragen fast immer filtern) (Domain: tenantId)
base_quantity	double	Nein	—	base quantity
base_unit_id	bigint	Nein	—	Fremdschlüssel → base unit
cost_center_id	bigint	Ja	—	Fremdschlüssel → cost center
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
date_created	datetime	Nein	—	Anlagezeitpunkt
description	varchar(255)	Ja	—	Beschreibung
detail_description	varchar(255)	Ja	—	detail description
external_material_price	double	Nein	—	external material price
external_purchase_material_id	bigint	Ja	—	Fremdschlüssel → external purchase material
item_number	bigint	Ja	—	Domain-Feld itemNumber
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
machine_id	bigint	Ja	—	Fremdschlüssel → machine
production_department_id	bigint	Ja	—	Fremdschlüssel → production department
machine_time	double	Ja	—	Domain-Feld machineTime
machine_unit_id	bigint	Ja	—	Fremdschlüssel → machine unit
personel_time	double	Ja	—	Domain-Feld personelTime
personel_unit_id	bigint	Ja	—	Fremdschlüssel → personel unit
rou_head_id	bigint	Nein	—	Fremdschlüssel → rou head
setup_time	double	Ja	—	Domain-Feld setupTime
setup_unit_id	bigint	Ja	—	Fremdschlüssel → setup unit
idle_time	double	Ja	—	Domain-Feld idleTime
idle_unit_id	bigint	Ja	—	Fremdschlüssel → idle unit
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
is_external	smallint	Ja	—	Boolean: External
work_description	varchar(255)	Ja	—	Domain-Feld workDescription
work_description_detail	text	Ja	—	Domain-Feld workDescriptionDetail
production_operation_id	bigint	Ja	—	Fremdschlüssel → production operation
before_quality_plan_id	bigint	Ja	—	Fremdschlüssel → before quality plan
after_quality_plan_id	bigint	Ja	—	Fremdschlüssel → after quality plan
nests_count	double	Ja	—	Domain-Feld nestsCount

Fremdschlüssel

Spalte(n)	Referenz
tenant_id	company (tenant_id)