0..*
category 1
0..*
properties 0..*
0..*
equipment 1
0..*
group 0..1
0..*
types 0..*
0..1
mainModule 1
0..*
document 1
0..*
equipment 1
0..*
type 1
0..*
equipment 1
0..*
schedule 0..1
0..1
reservation 0..1
0..*
maintenance 1
0..*
equipment 1
0..*
schedule 1
0..*
equipment 1
0..*
property 1
0..*
equipment 1
0..*
request 1
0..*
equipment 1
0..*
role 1
0..*
equipment 1
0..*
equipment 1
0..*
service 0..1
0..*
logging 1
0..*
parameter 1
0..*
logging 1
0..*
parameter 1
0..*
logging 1
0..*
equipment 1
0..*
loggingParameter 1
0..*
service 1
0..*
method 1
0..*
logging 1
0..*
loggingServiceMethod 1
0..*
loggingServiceMethodOptions 0..1
0..*
loggingServiceMethodParameter 1
0..*
serviceProcessingMethod 1
0..*
parameters 0..*
0..*
serviceProcessingMethod 1
0..*
equipment 0..1
0..*
function 0..1
0..*
groups 0..*
0..*
type 0..1
0..*
function 1
0..*
module 1
0..*
module 1
0..*
module 1
0..*
ecn 1
0..*
attachment 1
0..*
module 1
0..*
type 1
0..*
module 1
0..*
equipmentProperties 0..*
0..*
module 1
0..*
issue 1
0..*
attachment 1
0..*
module 1
0..*
moduleParameter 1
0..*
module 1
0..*
property 1
0..*
module 1
0..*
status 1
0..*
status 1
0..*
attachment 1
0..*
equipment 1
0..*
modules 0..*
0..*
status 1
0..*
monitor 1
0..1
step 1
0..1
measurement 1
0..*
loggingParameter 1
0..*
measurement 1
0..*
logging 0..1
0..*
measurement 1
0..*
monitorStepParameter 1
0..*
result 1
0..*
loggingParameter 1
0..*
result 1
0..*
requirementStep 0..1
0..1
measurement 1
0..1
step 1
0..1
requirement 1
0..*
fromStatuses 0..*
0..*
requirement 1
0..*
targets 0..*
0..*
toStatus 1
0..*
loggingParameter 1
0..*
requirement 1
0..*
monitor 1
0..*
schedule 0..1
0..*
monitor 1
0..*
monitor 1
0..*
stepGroup 0..1
0..1
step 1
0..*
step 1
0..*
stepParameter 1
0..1
stepParameterValue 1
0..*
equipment 1
0..*
block 0..1
0..*
doubleReservations 0..*
0..*
equipment 1
0..*
equipmentModule 0..*
0..*
equipmentModuleAsset 0..*
0..*
recurringLink 0..1
0..1
mainEquipment 1
0..*
equipment 1
0..*
setup 1
equipment_category
id: integer
dateCreated: datetime
lastUpdate: datetime
default: boolean
name: string
equipment_category_type
id: integer
name: string
dateCreated: datetime
lastUpdate: datetime
category_id: FK
equipment_document
id: integer
description: text
date_added: datetime
filename: text
user_id: FK
equipment_id: FK
equipment_equipment
id: integer
name: string
MESName: string
model: string
number: string
active: boolean
workstationComponents: json
availableForRental: boolean
grade: smallint
activeInMES: boolean
frontColor: string
backColor: string
reservationOptions: json
projectManagementEnabled: boolean
costCenter: string
doubleBookingPossible: boolean
reservationApprovalRequired: boolean
calendarText: text
trainingOption: smallint
ownership: smallint
dateCreated: datetime
lastUpdate: datetime
serialNumber: string
description: text
trainingDescription: text
subLocation: string
originalPurchaseOrder: string
project_id: FK
creator_id: FK
manufacturer_id: FK
room_id: FK
zoneGroup_id: FK
zone_id: FK
location_id: FK
area_id: FK
group_id: FK
mainModule_id: FK
label_id: FK
equipment_equipment_document_file
id: integer
file: blob
document_id: FK
equipment_equipment_link
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
url: string
equipment_id: FK
type_id: FK
equipment_equipment_link_type
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
equipment_equipment_mailing_recipient
id: integer
type: string
title: string
description: string
equipment_equipment_preventive_maintenance_maintenance
id: integer
dateCreated: datetime
lastUpdate: datetime
dateScheduled: datetime
dateExecuted: datetime
title: string
description: text
preMaintenanceActions: text
actions: text
maintenanceExecutedBy: smallint
comment: text
status: smallint
equipment_id: FK
schedule_id: FK
reservation_id: FK
user_id: FK
equipment_equipment_preventive_maintenance_maintenance_file
id: integer
description: text
dateCreated: datetime
lastUpdate: datetime
maintenance_id: FK
file_id: FK
equipment_equipment_preventive_maintenance_schedule
id: integer
dateCreated: datetime
lastUpdate: datetime
title: string
description: text
equipmentInMaintenance: smallint
maintenanceExecutedBy: smallint
preMaintenanceActions: text
actions: text
frequency: integer
plannedDaysInAdvance: integer
duration: integer
startHour: integer
equipment_id: FK
equipment_equipment_preventive_maintenance_schedule_file
id: integer
description: text
dateCreated: datetime
lastUpdate: datetime
schedule_id: FK
file_id: FK
equipment_equipment_property
id: integer
dateCreated: datetime
value: text
valueArray: array
valueInteger: integer
valueFloat: float
valueDate: date
property_id: FK
equipment_id: FK
equipment_equipment_request
id: integer
dateCreated: datetime
lastUpdate: datetime
reason: text
materials: text
frequency: text
status: smallint
equipment_id: FK
user_id: FK
equipment_equipment_request_flow
id: integer
order: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
status: smallint
request_id: FK
user_id: FK
equipment_equipment_role
id: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
status: smallint
inApprovalFlow: smallint
equipment_id: FK
user_id: FK
role_id: FK
equipment_equipment_user
id: integer
dateCreated: datetime
comment: text
status: smallint
equipment_id: FK
user_id: FK
equipment_group
id: integer
name: string
description: text
dateCreated: datetime
lastUpdate: datetime
equipment_logging
id: integer
title: string
description: text
fileName: string
fileData: text
separator: string
mimeType: text
dateCreated: datetime
lastUpdate: datetime
equipment_id: FK
service_id: FK
equipment_logging_column
id: integer
dateCreated: datetime
lastUpdate: datetime
column: string
startRow: smallint
logging_id: FK
parameter_id: FK
equipment_logging_direct_value
id: integer
dateCreated: datetime
lastUpdate: datetime
column: string
row: smallint
logging_id: FK
parameter_id: FK
equipment_logging_identifier_value
id: integer
dateCreated: datetime
lastUpdate: datetime
column: string
row: smallint
value: string
logging_id: FK
equipment_logging_parameter
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
parameter_id: FK
unit_id: FK
equipment_logging_parameter_equipment
id: integer
dateCreated: datetime
lastUpdate: datetime
loggingParameter_id: FK
equipment_id: FK
equipment_logging_service
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
serverUrl: string
swaggerFile: string
equipment_logging_service_method
id: integer
dateCreated: datetime
lastUpdate: datetime
path: string
method: smallint
responseContentType: string
service_id: FK
equipment_logging_service_method_parameter
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
type: smallint
required: boolean
method_id: FK
equipment_logging_service_processing_method
id: integer
type: integer
dateCreated: datetime
lastUpdate: datetime
logging_id: FK
loggingServiceMethod_id: FK
equipment_logging_service_processing_method_parameter
id: integer
dateCreated: datetime
lastUpdate: datetime
value: string
serviceProcessingMethod_id: FK
loggingServiceMethodOptions_id: FK
loggingServiceMethodParameter_id: FK
equipment_logging_service_processing_method_result
id: integer
dateCreated: datetime
lastUpdate: datetime
resultIndex: string
resultType: smallint
dataType: smallint
serviceProcessingMethod_id: FK
equipment_module
id: integer
name: string
active: boolean
reservationPossible: boolean
MESName: string
number: string
manufacturer: string
serialNumber: string
dateCreated: datetime
lastUpdate: datetime
type_id: FK
label_id: FK
equipment_id: FK
function_id: FK
equipment_module_asset
id: integer
name: string
label: string
type: string
dateCreated: datetime
lastUpdate: datetime
function_id: FK
module_id: FK
equipment_module_asset_function
id: integer
function: string
dateCreated: datetime
lastUpdate: datetime
equipment_module_changelog
id: integer
dateCreated: datetime
message: text
type: smallint
source: smallint
module_id: FK
user_id: FK
runstep_id: FK
runstep_checklist_id: FK
serviceEventChecklist_id: FK
equipment_module_ecn
id: integer
dateCreated: datetime
lastUpdate: datetime
dateClosed: datetime
ecn: string
description: text
module_id: FK
user_id: FK
update_user_id: FK
equipment_module_ecn_attachment
id: integer
dateCreated: datetime
filename: string
mimeType: string
fileSize: integer
ecn_id: FK
equipment_module_ecn_attachment_file
id: integer
file: blob
attachment_id: FK
equipment_module_external_activity
id: integer
dateCreated: datetime
account: string
activity: text
comment: text
module_id: FK
user_id: FK
type_id: FK
equipment_module_external_activity_type
id: integer
type: string
description: text
isActive: boolean
dateCreated: datetime
lastUpdate: datetime
equipment_module_facility
id: integer
label: string
dateCreated: datetime
lastUpdate: datetime
facility_id: FK
module_id: FK
equipment_module_function
id: integer
function: string
dateCreated: datetime
lastUpdate: datetime
equipment_module_group
id: integer
group: string
visibility: smallint
sort: smallint
dateCreated: datetime
lastUpdate: datetime
equipment_module_issue
id: integer
dateCreated: datetime
lastUpdate: datetime
dateClosed: datetime
status: smallint
issueType: smallint
issue: string
description: text
actions: text
forecastUp: date
module_id: FK
user_id: FK
update_user_id: FK
equipment_module_issue_attachment
id: integer
dateCreated: datetime
filename: string
mimeType: string
fileSize: integer
issue_id: FK
equipment_module_issue_attachment_file
id: integer
file: blob
attachment_id: FK
equipment_module_parameter
id: integer
fixRange: smallint
showInName: smallint
required: smallint
header: smallint
locked: smallint
visibility: smallint
minValue: float
maxValue: float
value: string
sequence: integer
module_id: FK
parameter_id: FK
unit_id: FK
equipment_module_parameter_value
id: integer
value: string
moduleParameter_id: FK
equipment_module_property
id: integer
dateCreated: datetime
value: text
valueArray: array
valueInteger: integer
valueDate: date
valueFloat: float
property_id: FK
module_id: FK
equipment_module_status
id: integer
active: boolean
dateCreated: datetime
lastUpdate: datetime
description: text
module_id: FK
status_id: FK
user_id: FK
equipment_module_status_attachment
id: integer
dateCreated: datetime
filename: text
mimeType: string
fileSize: integer
status_id: FK
equipment_module_status_attachment_file
id: integer
file: blob
attachment_id: FK
equipment_module_status_rule
id: integer
label: string
priority: integer
moduleStatusType: smallint
checkAllModule: boolean
equipment_id: FK
status_id: FK
equipment_module_type
id: integer
type: string
dateCreated: datetime
lastUpdate: datetime
equipment_monitor
id: integer
name: string
description: text
dateCreated: datetime
lastUpdate: datetime
frequency: string
status: smallint
type: integer
project_id: FK
user_id: FK
equipment_monitor_changelog
id: integer
dateCreated: datetime
message: string
monitor_id: FK
user_id: FK
equipment_monitor_measurement
id: integer
dateCreated: datetime
lastUpdate: datetime
sequence: integer
title: string
definition: string
method: text
step_id: FK
equipment_monitor_measurement_label
id: integer
label: string
open: smallint
measurement_id: FK
equipment_monitor_measurement_logging_parameter
id: integer
dateCreated: datetime
lastUpdate: datetime
measurement_id: FK
loggingParameter_id: FK
equipment_monitor_measurement_result
id: integer
dateCreated: datetime
lastUpdate: datetime
uuid: string
measurement_id: FK
logging_id: FK
file_id: FK
equipment_monitor_measurement_result_process_parameter_value
id: integer
dateCreated: datetime
lastUpdate: datetime
floatValue: float
unit: string
result_id: FK
monitorStepParameter_id: FK
equipment_monitor_measurement_result_value
id: integer
floatValue: float
stringValue: string
intValue: integer
stdDev: float
unit: string
result_id: FK
loggingParameter_id: FK
equipment_monitor_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
equipment_monitor_requirement_label
id: integer
label: string
open: smallint
requirement_id: FK
equipment_monitor_requirement_module_status_change
id: integer
type: smallint
requirement_id: FK
toStatus_id: FK
equipment_monitor_requirement_target
id: integer
dateCreated: datetime
lastUpdate: datetime
minValue: float
maxValue: float
target: float
inclusive: smallint
unit: string
requirement_id: FK
loggingParameter_id: FK
equipment_monitor_run
id: integer
dateCreated: datetime
lastUpdate: datetime
monitor_id: FK
run_id: FK
schedule_id: FK
equipment_monitor_schedule
id: integer
dateCreated: datetime
lastUpdate: datetime
title: string
description: string
parts: smallint
actions: text
frequency: integer
monitor_id: FK
project_id: FK
team_id: FK
group_id: FK
equipment_monitor_step
id: integer
sequence: integer
number: integer
dateCreated: datetime
lastUpdate: datetime
subSteps: integer
isMonitored: smallint
remark: text
instructions: text
processName: string
monitor_id: FK
user_id: FK
processmodule_id: FK
stepgroup_id: FK
process_module_recipe_version_id: FK
equipment_monitor_step_group
id: integer
dateCreated: datetime
lastUpdate: datetime
label: string
locked: smallint
equipment_monitor_step_label
id: integer
label: string
open: smallint
step_id: FK
equipment_monitor_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
equipment_monitor_step_parameter_value
id: integer
value: string
sequence: integer
step_parameter_id: FK
consumable_id: FK
equipment_monitor_variable
id: integer
title: string
description: text
dateCreated: datetime
lastUpdate: datetime
stepParameterValue_id: FK
equipment_picture
id: integer
mimeType: string
extension: string
fileSize: integer
width: integer
height: integer
dateCreated: datetime
lastUpdate: datetime
image: blob
equipment_id: FK
equipment_property
id: integer
type: string
showInList: boolean
groupable: boolean
isConnecting: boolean
label: text
values: text
defaultValue: text
sort: smallint
friendlyText: text
equipment_reservation
id: integer
startDate: datetime
endDate: datetime
dateApproved: datetime
dateCreated: datetime
lastUpdate: datetime
status: integer
rental_status: integer
recurring: smallint
recurringEndDate: datetime
title: string
description: text
type: integer
isDoubleReservation: boolean
recurring_link_id: FK
serviceEvent_id: FK
user_id: FK
equipment_id: FK
run_id: FK
room_id: FK
project_id: FK
roomProject_id: FK
block_id: FK
equipment_reservation_block
id: integer
dateCreated: datetime
lastUpdate: datetime
user_id: FK
equipment_role
id: integer
title: string
description: text
sequence: integer
equipment_setup
id: integer
dateCreated: datetime
lastUpdate: datetime
setupType: smallint
reservationType: smallint
endDate: datetime
startDate: datetime
mainEquipment_id: FK
equipment_setup_equipment
id: integer
title: string
dateCreated: datetime
lastUpdate: datetime
dateEnd: datetime
setup_id: FK
equipment_id: FK
equipment_status
id: integer
status: string
sequence: integer
frontColor: string
backColor: string
dateCreated: datetime
lastUpdate: datetime
statusType: smallint
equipment_statusmail
id: integer
dateCreated: datetime
lastUpdate: datetime
name: string
filter: json
equipmentFilter: text
sequence: integer
showIssuesWithPriority: boolean
showInNavigation: boolean
showIssues: integer
showReservations: boolean
classification: smallint
order: integer
direction: string
to: text
cc: text
bcc: text
subject: string
user_id: FK