ProdOrderOperation

Tabelle: prod_order_operation
Domain: ProdOrderOperation · 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)
prod_order_id	bigint	Nein	—	Fremdschlüssel → prod order
prod_order_component_id	bigint	Ja	—	Fremdschlüssel → prod order component
item_number	bigint	Ja	—	Domain-Feld itemNumber
production_department_id	bigint	Ja	—	Fremdschlüssel → production department
machine_id	bigint	Ja	—	Fremdschlüssel → machine
setup_time	double	Ja	—	Domain-Feld setupTime
setup_time_in_hours	double	Ja	—	Domain-Feld setupTimeInHours
setup_unit_id	bigint	Ja	—	Fremdschlüssel → setup unit
machine_time	double	Ja	—	Domain-Feld machineTime
machine_time_in_hours	double	Ja	—	Domain-Feld machineTimeInHours
machine_unit_id	bigint	Ja	—	Fremdschlüssel → machine unit
personel_time	double	Ja	—	Domain-Feld personelTime
personel_time_in_hours	double	Ja	—	Domain-Feld personelTimeInHours
personel_unit_id	bigint	Ja	—	Fremdschlüssel → personel unit
idle_time	double	Ja	—	Domain-Feld idleTime
idle_time_in_hours	double	Ja	—	Domain-Feld idleTimeInHours
idle_unit_id	bigint	Ja	—	Fremdschlüssel → idle unit
base_quantity	double	Nein	—	base quantity
base_unit_id	bigint	Nein	—	Fremdschlüssel → base unit
calc_start_operation	datetime	Ja	—	Domain-Feld calcStartOperation
calc_end_operation	datetime	Ja	—	Domain-Feld calcEndOperation
confirmation_number	varchar(255)	Nein	—	Domain-Feld confirmationNumber
confirmation_status	smallint	Ja	—	Domain-Feld confirmationStatus
cost_center_id	bigint	Ja	—	Fremdschlüssel → cost center
description	varchar(255)	Ja	—	Beschreibung (Domain: description)
detail_description	varchar(255)	Ja	—	Domain-Feld detailDescription
external_purchase_material_id	bigint	Ja	—	Fremdschlüssel → external purchase material
is_external_operation	smallint	Nein	—	Domain-Feld isExternalOperation
last_updated	datetime	Ja	CURRENT_TIMESTAMP	Letzte Änderung
updated_by_id	bigint	Ja	—	Geändert von (Benutzer-ID)
created_by_id	bigint	Ja	—	Angelegt von (Benutzer-ID)
date_created	datetime	Nein	—	Anlagezeitpunkt
confirmation_status_id	bigint	Ja	—	Fremdschlüssel → confirmation status
previous_prod_order_operation_id	bigint	Ja	—	Fremdschlüssel → previous prod order operation
is_setup_finished	smallint	Ja	0	Boolean: Setup Finished
before_quality_plan_id	bigint	Ja	—	Fremdschlüssel → before quality plan
after_quality_plan_id	bigint	Ja	—	Fremdschlüssel → after quality plan
is_delete	smallint	Ja	0	Soft-Delete (0 = aktiv, 1 = gelöscht)
original_machine_id	bigint	Ja	—	Fremdschlüssel → original machine

Fremdschlüssel

Spalte(n)	Referenz
previous_prod_order_operation_id	prod_order_operation (id)
base_unit_id	ltt_unit (id)
machine_unit_id	ltt_unit (id)
original_machine_id	machine (id)
personel_unit_id	ltt_unit (id)
setup_unit_id	ltt_unit (id)
prod_order_id	prod_order (id)
tenant_id	company (tenant_id)