0..*
type 0..*
0..*
hiddenParameter 0..*
0..*
process 1
0..*
parameter 1
0..*
processModule 1
0..*
unit 0..1
0..*
moduleParameter 1
0..*
processModule 1
0..*
type 0..1
0..*
recipe 1
0..*
recipe 1
0..*
parameter 1
0..*
recipe 1
0..*
unit 0..1
0..*
recipeParameter 1
0..*
recipe 1
0..*
recipe 1
0..*
recipeVersion 1
0..*
parameter 1
0..*
recipeVersion 1
0..*
unit 0..1
0..*
recipeVersionParameter 1
0..*
type 0..1
0..*
unit 0..*
0..*
category 1
0..*
run 1
0..*
runStepChecklist 0..1
0..*
steps 0..*
0..*
run 1
0..*
consumableMatrix 1
0..*
runConsumable 1
0..1
step 1
0..1
measurement 1
0..*
measurement 1
0..*
measurement 1
0..1
stepPart 1
0..*
measurement 1
0..*
runPartMapping 0..1
0..*
result 1
0..*
stepPart 0..1
0..*
run 1
0..*
summary 1
0..*
part 1
0..*
summary 1
0..*
child 1
0..*
parent 1
0..*
part 0..*
0..*
layout 0..1
0..*
parent 0..1
0..*
root 0..1
0..*
run 1
0..*
tray 0..1
0..1
part 1
0..*
part 1
0..*
requirementStep 0..1
0..1
measurement 1
0..1
step 1
0..1
runRequirement 1
0..*
requirement 1
0..1
stepPart 1
0..*
requirement 1
0..*
relatedRuns 0..*
0..*
sampleType 0..1
0..*
trayType 0..1
0..1
run 1
0..*
holdCode 1
0..*
run 1
0..*
priority 1
0..*
run 1
0..*
role 1
0..*
run 1
0..*
run 1
0..*
trayType 1
0..1
stepParameterValue 1
0..*
run 1
0..*
serviceWork 1
0..*
serviceWork 1
0..1
runStep 1
0..*
processModule 1
0..*
processModuleRecipeVersion 0..1
0..*
rework 0..1
0..*
run 1
0..*
stepGroup 0..1
0..*
runStep 1
0..1
runStep 1
0..*
parameter 1
0..*
step 1
0..*
unit 0..1
0..*
assemblyRunStep 0..1
0..*
stepParameter 1
0..1
stepParameterValue 1
0..*
part 1
0..*
step 1
0..*
stepPart 1
0..*
type 1
0..*
toType 0..1
0..*
availableActions 0..*
0..*
tray 1
0..1
stepPart 1
0..*
run 1
0..*
parentPart 0..*
0..1
part 1
0..*
runSubstrate 1
0..*
substrateMatrix 1
process_category
id: integer
name: string
number: integer
dateCreated: datetime
lastUpdate: datetime
process_module
id: integer
dateCreated: datetime
lastUpdate: datetime
inUse: boolean
isAssemblyProcess: boolean
hasLocalParameters: boolean
process_id: FK
module_id: FK
process_module_parameter
id: integer
value: string
sequence: integer
fixRange: smallint
minValue: float
maxValue: float
showInName: smallint
required: smallint
header: smallint
locked: smallint
visibility: smallint
process_module_id: FK
parameter_id: FK
unit_id: FK
process_module_parameter_value
id: integer
value: string
moduleParameter_id: FK
process_module_recipe
id: integer
name: string
description: text
dateCreated: datetime
lastUpdate: datetime
status: smallint
subSteps: integer
process_module_id: FK
type_id: FK
user_id: FK
process_module_recipe_changelog
id: integer
dateCreated: datetime
message: text
recipe_id: FK
user_id: FK
process_module_recipe_checklist
id: integer
dateCreated: datetime
lastUpdate: datetime
task: string
description: text
runChangelogType: integer
equipmentModuleChangelogType: integer
sequence: integer
recipe_id: FK
process_module_recipe_parameter
id: integer
label: string
sequence: integer
createVariable: boolean
fixRange: smallint
minValue: float
maxValue: float
showInName: smallint
required: smallint
header: smallint
locked: smallint
visibility: smallint
recipe_id: FK
parameter_id: FK
unit_id: FK
process_module_recipe_parameter_value
id: integer
value: string
sequence: integer
recipe_parameter_id: FK
consumable_id: FK
process_module_recipe_rework
id: integer
dateCreated: datetime
lastUpdate: datetime
notes: string
recipe_id: FK
template_id: FK
process_module_recipe_type
id: integer
name: string
frontColor: string
backColor: string
dateCreated: datetime
lastUpdate: datetime
process_module_recipe_version
id: integer
dateCreated: datetime
version: integer
subSteps: integer
notes: string
recipe_id: FK
user_id: FK
process_module_recipe_version_checklist
id: integer
dateCreated: datetime
lastUpdate: datetime
task: string
description: text
runChangelogType: integer
equipmentModuleChangelogType: integer
sequence: integer
recipeVersion_id: FK
process_module_recipe_version_parameter
id: integer
label: string
createVariable: boolean
sequence: integer
fixRange: smallint
minValue: float
maxValue: float
showInName: smallint
required: smallint
header: smallint
locked: smallint
visibility: smallint
version_id: FK
parameter_id: FK
unit_id: FK
process_module_recipe_version_parameter_value
id: integer
value: string
sequence: integer
recipe_parameter_id: FK
consumable_id: FK
process_parameter
id: integer
name: string
abbr: string
dateCreated: datetime
lastUpdate: datetime
parameter_type_id: FK
process_parameter_type
id: integer
name: string
abbr: string
dateCreated: datetime
lastUpdate: datetime
process_process
id: integer
version: integer
name: string
number: integer
active: boolean
hasMeasuredValue: boolean
dateCreated: datetime
lastUpdate: datetime
private: boolean
category_id: FK
user_id: FK
process_type
id: integer
name: string
canBeRequirement: smallint
hasColor: smallint
color: string
dateCreated: datetime
lastUpdate: datetime
user_id: FK
process_unit
id: integer
name: string
abbr: string
dateCreated: datetime
lastUpdate: datetime
run_changelog
id: integer
dateCreated: datetime
message: text
type: smallint
source: smallint
run_id: FK
user_id: FK
runstep_checklist_id: FK
run_consumable
id: integer
amount: float
run_id: FK
consumable_id: FK
run_consumable_matrix_consumable
id: integer
consumableNumber: array
label: string
consumable_matrix_id: FK
run_consumable_id: FK
run_hold_code
id: integer
code: string
description: text
frontColor: string
backColor: string
dateCreated: datetime
lastUpdate: datetime
isHold: boolean
run_measurement
id: integer
dateCreated: datetime
lastUpdate: datetime
sequence: integer
title: string
definition: string
method: text
step_id: FK
run_measurement_label
id: integer
label: string
open: smallint
measurement_id: FK
run_measurement_logging_parameter
id: integer
dateCreated: datetime
lastUpdate: datetime
measurement_id: FK
loggingParameter_id: FK
run_measurement_part
id: integer
measuredValue: float
measurement_id: FK
step_part_id: FK
run_measurement_result
id: integer
dateCreated: datetime
lastUpdate: datetime
uuid: string
measurement_id: FK
runPartMapping_id: FK
logging_id: FK
file_id: FK
run_measurement_result_value
id: integer
floatValue: float
stringValue: string
intValue: integer
stdDev: float
unit: string
result_id: FK
loggingParameter_id: FK
step_part_id: FK
run_measurement_summary
id: integer
title: text
description: text
dateCreated: datetime
lastUpdate: datetime
user_id: FK
run_measurement_summary_run
id: integer
dateCreated: datetime
summary_id: FK
run_id: FK
run_measurement_summary_run_part
id: integer
dateCreated: datetime
sequence: integer
comment: text
summary_id: FK
part_id: FK
run_parent
id: integer
description: string
open: smallint
parent_run_id: FK
run_id: FK
run_part
id: integer
partId: smallint
shortLabel: string
label: string
tray_row: smallint
tray_column: smallint
left: integer
level: integer
right: integer
run_id: FK
tray_id: FK
layout_id: FK
baseline_id: FK
root_id: FK
parent_id: FK
run_part_consumable_creation
id: integer
amount: integer
part_id: FK
consumable_id: FK
run_part_layout
id: integer
dateCreated: datetime
lastUpdate: datetime
title: string
description: text
format: smallint
width: smallint
height: smallint
amountOfDevices: smallint
deviceWidth: smallint
deviceHeight: smallint
run_part_mapping
id: integer
dateCreated: datetime
lastUpdate: datetime
mapId: smallint
label: string
xCoordinate: integer
yCoordinate: integer
width: integer
height: integer
part_id: FK
run_priority
id: integer
code: string
description: text
order: integer
frontColor: string
backColor: string
dateCreated: datetime
lastUpdate: datetime
run_requirement
id: integer
dateCreated: datetime
lastUpdate: datetime
sequence: integer
title: string
definition: string
method: text
step_id: FK
requirement_step_id: FK
measurement_id: FK
run_requirement_label
id: integer
label: string
open: smallint
requirement_id: FK
run_requirement_part
id: integer
maxValue: float
requirement_id: FK
step_part_id: FK
run_requirement_target
id: integer
dateCreated: datetime
lastUpdate: datetime
minValue: float
maxValue: float
target: float
inclusive: smallint
unit: string
requirement_id: FK
loggingParameter_id: FK
run_role
id: integer
title: text
description: text
order: integer
status: smallint
run_run
id: integer
number: integer
name: string
location: string
motivation: text
conclusion: text
dateCreated: datetime
startDate: datetime
lastUpdate: datetime
finishDate: datetime
parts: smallint
status: smallint
runType: smallint
labelType: smallint
runLabel: string
hasApproval: boolean
buildStartDate: datetime
environment_id: FK
user_id: FK
project_id: FK
team_id: FK
group_id: FK
trayType_id: FK
sampleType_id: FK
run_run_batch_card
id: integer
dateCreated: datetime
lastUpdate: datetime
content: text
run_id: FK
user_id: FK
run_run_hold_code
id: integer
active: boolean
dateCreated: datetime
lastUpdate: datetime
description: text
run_id: FK
holdCode_id: FK
user_id: FK
run_run_mailing_recipient
id: integer
type: string
title: string
description: string
run_run_priority
id: integer
active: boolean
dateCreated: datetime
lastUpdate: datetime
description: text
run_id: FK
priority_id: FK
user_id: FK
run_run_role
id: integer
dateCreated: datetime
comment: text
status: smallint
run_id: FK
user_id: FK
role_id: FK
run_run_tray
id: integer
name: string
label: string
sequence: smallint
run_id: FK
tray_type_id: FK
run_run_variable
id: integer
title: string
description: text
dateCreated: datetime
lastUpdate: datetime
stepParameterValue_id: FK
run_sample_type
id: integer
type: string
description: text
prefixes: string
treePreset: text
run_service_work
id: integer
name: string
dateCreated: datetime
lastUpdate: datetime
finishDate: datetime
instructions: text
dispatched: smallint
status: smallint
user_id: FK
run_id: FK
run_service_work_comment
id: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
service_work_id: FK
user_id: FK
run_service_work_step
id: integer
dateCreated: datetime
startDate: datetime
lastUpdate: datetime
finishDate: datetime
remark: text
instructions: text
status: smallint
user_id: FK
service_work_id: FK
step_id: FK
run_step
id: integer
sequence: integer
partLevel: integer
split: integer
number: integer
dateCreated: datetime
startDate: datetime
lastUpdate: datetime
finishDate: datetime
dateSkipped: datetime
time: datetime
private: boolean
version: integer
subSteps: integer
standard: smallint
hasParts: boolean
remark: text
instructions: text
status: smallint
upToDate: smallint
processName: string
stepVersion: integer
run_id: FK
rework_id: FK
user_id: FK
start_user_id: FK
finish_user_id: FK
processmodule_id: FK
template_step_id: FK
monitor_step_id: FK
stepgroup_id: FK
process_module_recipe_version_id: FK
run_step_checklist
id: integer
dateCreated: datetime
lastUpdate: datetime
dateExecuted: datetime
task: string
description: text
sequence: integer
runChangelogType: integer
equipmentModuleChangelogType: integer
runStep_id: FK
user_id: FK
run_step_group
id: integer
dateCreated: datetime
lastUpdate: datetime
label: string
locked: smallint
run_step_label
id: integer
label: string
open: smallint
step_id: FK
run_step_parameter
id: integer
label: string
version: integer
sequence: integer
fixRange: smallint
minValue: float
maxValue: float
showInName: smallint
required: smallint
header: smallint
locked: smallint
visibility: smallint
step_id: FK
parameter_id: FK
unit_id: FK
run_step_parameter_value
id: integer
value: string
sequence: integer
step_parameter_id: FK
consumable_id: FK
assemblyRunStep_id: FK
run_step_parameter_value_realised
id: integer
value: string
step_parameter_value_id: FK
run_step_part
id: integer
dateCreated: datetime
lastUpdate: datetime
dateStarted: datetime
dateProcessed: datetime
dateFailed: datetime
comment: text
step_id: FK
part_id: FK
run_step_part_state
id: integer
dateCreated: datetime
comment: text
stepPart_id: FK
type_id: FK
user_id: FK
run_step_part_state_action
id: integer
name: string
toType_id: FK
run_step_part_state_type
id: integer
name: string
isDefaultState: boolean
isFinishedState: boolean
isFailedState: boolean
isRepairingState: boolean
isTestingState: boolean
color: string
run_step_part_tray
id: integer
trayRow: smallint
trayColumn: smallint
stepPart_id: FK
tray_id: FK
run_step_rework
id: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
user_id: FK
run_substrate
id: integer
amount: integer
run_id: FK
substrate_id: FK
run_substrate_matrix
id: integer
part_id: FK
run_substrate_matrix_substrate
id: integer
substrateNumber: array
label: string
substrate_matrix_id: FK
run_substrate_id: FK
run_tray_type
id: integer
type: string
description: text
dateCreated: datetime
lastUpdate: datetime
columns: smallint
rows: smallint
orientation: smallint
forbidden_slots: json