Database entity relationship diagram

This reference is generated from the Doctrine ORM metadata.

Entities

`admin_action`

Doctrine entity: Admin\Entity\Action

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`unique_key`	`string`
`actionContent`	`text`
`actionSubject`	`string`
`isActive`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`transactional_id`	`FK`	FK

`admin_announcement`

Doctrine entity: Admin\Entity\Announcement

Column	Doctrine type	Key
`announcement_id`	`integer`
`name`	`string`
`announcement_text`	`text`
`date_created`	`datetime`
`last_update`	`datetime`
`date_announcement_start`	`datetime`
`date_announcement_end`	`datetime`
`type`	`smallint`
`locations`	`smallint`
`is_dismissible`	`boolean`

`admin_api_log`

Doctrine entity: Admin\Entity\Api\Log

Column	Doctrine type	Key
`id`	`integer`
`class`	`string`
`type`	`smallint`
`dateCreated`	`datetime`
`payload`	`string`
`statusCode`	`integer`
`status`	`string`
`response`	`text`

`admin_authentication`

Doctrine entity: Admin\Entity\Authentication

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`buttonText`	`string`
`whitelistedDomains`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`type`	`smallint`
`oAuth2Service_id`	`FK`	FK

`admin_environment`

Doctrine entity: Admin\Entity\Environment

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`route`	`string`
`components`	`json`
`isActive`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`admin_goldstein_client`

Doctrine entity: Admin\Entity\GoldsteinClient

Column	Doctrine type	Key
`id`	`integer`
`token`	`string`
`currentAssociationItem`	`string`
`currentAssociationID`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`admin_goldstein_equipment_association`

Doctrine entity: Admin\Entity\Goldstein\EquipmentAssociation

Column	Doctrine type	Key
`id`	`integer`
`goldstein_client_id`	`FK`	FK
`equipment_id`	`FK`	FK

`admin_goldstein_log`

Doctrine entity: Admin\Entity\Goldstein\GoldsteinLog

Column	Doctrine type	Key
`id`	`integer`
`date`	`datetime`
`action`	`string`
`association`	`string`
`message`	`string`

`admin_log`

Doctrine entity: Admin\Entity\Log

Column	Doctrine type	Key
`id`	`integer`
`date`	`datetime`
`priority`	`string`
`errorMessage`	`text`
`url`	`string`
`file`	`string`
`line`	`integer`
`errorType`	`string`
`trace`	`text`
`request_data`	`json`

`admin_maintenance`

Doctrine entity: Admin\Entity\Maintenance

Column	Doctrine type	Key
`maintenance_id`	`integer`
`name`	`string`
`maintenance_page_text`	`text`
`is_active`	`boolean`
`date_created`	`datetime`
`last_update`	`datetime`
`allow_ip`	`string`

`admin_messages`

Doctrine entity: Admin\Entity\Queue

Column	Doctrine type	Key
`id`	`bigint`
`body`	`text`
`headers`	`text`
`queue_name`	`string`
`created_at`	`datetime`
`available_at`	`datetime`
`delivered_at`	`datetime`

`admin_module`

Doctrine entity: Admin\Entity\Module

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`string`
`isOptional`	`boolean`

`admin_module_option`

Doctrine entity: Admin\Entity\ModuleOption

Column	Doctrine type	Key
`id`	`integer`
`host`	`string`
`moduleName`	`string`
`optionKey`	`string`
`value`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`admin_oauth2_service`

Doctrine entity: Admin\Entity\OAuth2\Service

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`clientId`	`string`
`tenantId`	`string`
`clientSecret`	`string`
`redirectUrl`	`string`
`authorizationUrl`	`string`
`accessTokenUrl`	`string`
`profileUrl`	`string`
`type`	`smallint`
`scope_id`	`FK`	FK

`admin_permit_entity`

Doctrine entity: Admin\Entity\Permit\Entity

Column	Doctrine type	Key
`id`	`integer`
`entity`	`string`
`underscoreFullEntityName`	`string`
`databaseTableName`	`string`

`admin_permit_role`

Doctrine entity: Admin\Entity\Permit\Role

Column	Doctrine type	Key
`id`	`integer`
`role`	`string`
`entity_id`	`FK`	FK

`admin_permit_setter`

Doctrine entity: Admin\Entity\Permit\Setter

Column	Doctrine type	Key
`id`	`integer`
`setter`	`string`
`entityKey`	`string`
`fromClause`	`text`
`whereClause`	`text`
`userKey`	`string`
`entity_id`	`FK`	FK

`admin_permit_user`

Doctrine entity: Admin\Entity\Permit\User

Column	Doctrine type	Key
`key_id`	`integer`
`user_id`	`FK`	FK
`role_id`	`FK`	FK
`setter_id`	`FK`	FK
`access_role_id`	`FK`	FK

`admin_role`

Doctrine entity: Admin\Entity\Role

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`string`
`parent`	`FK`	FK

`admin_selection`

Doctrine entity: Admin\Entity\Selection

Column	Doctrine type	Key
`id`	`integer`
`selection`	`string`
`tag`	`string`
`dateCreated`	`datetime`
`endDate`	`datetime`
`note`	`string`
`core`	`smallint`
`user_id`	`FK`	FK

`admin_selection_sql`

Doctrine entity: Admin\Entity\Selection\Sql

Column	Doctrine type	Key
`id`	`integer`
`query`	`text`
`selection_id`	`FK`	FK

`admin_selection_user`

Doctrine entity: Admin\Entity\Selection\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`user_id`	`FK`	FK
`selection_id`	`FK`	FK

`admin_session`

Doctrine entity: Admin\Entity\Session

Column	Doctrine type	Key
`id`	`integer`
`key`	`string`
`modified`	`integer`
`lifetime`	`integer`
`hits`	`integer`
`data`	`text`
`name`	`string`
`ip`	`string`
`startDate`	`datetime`
`endDate`	`datetime`
`user_id`	`FK`	FK

`admin_support`

Doctrine entity: Admin\Entity\Support

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`admin_user`

Doctrine entity: Admin\Entity\User

Column	Doctrine type	Key
`id`	`integer`
`microsoftId`	`string`
`username`	`string`
`password`	`string`
`firstName`	`string`
`lastName`	`string`
`email`	`string`
`status`	`integer`
`userPrincipalName`	`string`
`autoUpdate`	`smallint`
`triggerUpdate`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateLeave`	`datetime`
`authentication_id`	`FK`	FK

`admin_user_action`

Doctrine entity: Admin\Entity\User\Action

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`entity`	`string`
`entityId`	`integer`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateClosed`	`datetime`
`dateRead`	`datetime`
`user_id`	`FK`	FK
`action_id`	`FK`	FK
`deeplink_id`	`FK`	FK

`admin_user_badge_card`

Doctrine entity: Admin\Entity\User\BadgeCard

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateClosed`	`datetime`
`dateRead`	`datetime`
`isActive`	`boolean`
`badgeUUID`	`string`
`onboardingWord`	`string`
`user_id`	`FK`	FK

`admin_user_preferences`

Doctrine entity: Admin\Entity\User\Preferences

Column	Doctrine type	Key
`id`	`integer`
`stepsPerPage`	`smallint`
`itemsPerPage`	`smallint`
`runsOnPortal`	`smallint`
`actionElement`	`smallint`
`defaultEmphasizedParameters`	`smallint`
`reservationColor`	`string`
`reservationEmailNotifications`	`boolean`
`trainingEmailNotifications`	`boolean`
`layout`	`smallint`
`user_id`	`FK`	FK
`environment_id`	`FK`	FK

`admin_user_preferences_filter`

Doctrine entity: Admin\Entity\User\Preferences\Filter

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`route`	`string`
`favourite`	`boolean`
`filter`	`string`
`preference_id`	`FK`	FK

`admin_user_profile`

Doctrine entity: Admin\Entity\User\Profile

Column	Doctrine type	Key
`id`	`integer`
`companyName`	`string`
`personnelNumber`	`string`
`mobilePhone`	`string`
`phone`	`string`
`jobTitle`	`string`
`officeLocation`	`string`
`location`	`string`
`country`	`string`
`payroll`	`string`
`statute`	`string`
`equivalency`	`string`
`department`	`string`
`user_id`	`FK`	FK

`chemical_chemical`

Doctrine entity: Chemical\Entity\Chemical

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`casNumber`	`string`
`chemical_formula`	`string`
`description`	`text`
`adrClasses`	`string`
`standardProduct`	`smallint`
`physicalState`	`smallint`
`isZZS`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`ehs_link`	`text`
`main_chemical_id`	`FK`	FK

`chemical_chemical_mailing_recipient`

Doctrine entity: Chemical\Entity\Chemical\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`chemical_chemical_role`

Doctrine entity: Chemical\Entity\Chemical\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`status`	`smallint`
`inApprovalFlow`	`smallint`
`chemical_id`	`FK`	FK
`role_id`	`FK`	FK
`user_id`	`FK`	FK

`chemical_cmr`

Doctrine entity: Chemical\Entity\Cmr

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`

`chemical_container`

Doctrine entity: Chemical\Entity\Container\Container

Column	Doctrine type	Key
`id`	`integer`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`deletedAt`	`datetime`
`dateExpire`	`datetime`
`date_opened`	`datetime`
`date_arrived`	`datetime`
`dateMarkedForRemoval`	`datetime`
`sub_location`	`string`
`order_number`	`string`
`supplier`	`string`
`concentration`	`string`
`amount`	`string`
`amountUnit`	`string`
`type_id`	`FK`	FK
`methodOfUse_id`	`FK`	FK
`purpose_id`	`FK`	FK
`user_id`	`FK`	FK
`chemical_id`	`FK`	FK
`location_id`	`FK`	FK
`project_id`	`FK`	FK

`chemical_container_changelog`

Doctrine entity: Chemical\Entity\Container\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`type`	`integer`
`message`	`text`
`container_id`	`FK`	FK
`user_id`	`FK`	FK

`chemical_container_external_label`

Doctrine entity: Chemical\Entity\Container\ExternalLabel

Column	Doctrine type	Key
`id`	`integer`
`qrCodeContent`	`string`
`label`	`string`
`description`	`string`
`orderNumber`	`string`
`sequence`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`container_id`	`FK`	FK

`chemical_container_method_of_use`

Doctrine entity: Chemical\Entity\Container\MethodOfUse

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`chemical_container_purpose`

Doctrine entity: Chemical\Entity\Container\Purpose

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`chemical_container_scanned`

Doctrine entity: Chemical\Entity\Container\Scanned

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`container_id`	`FK`	FK
`user_id`	`FK`	FK

`chemical_container_type`

Doctrine entity: Chemical\Entity\Container\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`label_id`	`FK`	FK

`chemical_container_user`

Doctrine entity: Chemical\Entity\Container\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`deletedAt`	`datetime`
`comment`	`text`
`container_id`	`FK`	FK
`user_id`	`FK`	FK

`chemical_label`

Doctrine entity: Room\Entity\Label

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`labelType`	`smallint`
`mm_top`	`integer`
`mm_left`	`integer`
`mm_width`	`integer`
`mm_height`	`integer`
`layout`	`json`

`chemical_label_attachment`

Doctrine entity: Room\Entity\Label\Attachment

Column	Doctrine type	Key
`id`	`integer`
`attachment`	`string`
`size`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`priority`	`smallint`
`sequence`	`smallint`
`label_id`	`FK`	FK

`chemical_label_attachment_object`

Doctrine entity: Room\Entity\Label\AttachmentObject

Column	Doctrine type	Key
`id`	`integer`
`object`	`blob`
`attachment_id`	`FK`	FK

`chemical_main_chemical`

Doctrine entity: Chemical\Entity\MainChemical

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`code`	`string`
`dateCreated`	`datetime`
`requireMSDS`	`smallint`
`lastUpdate`	`datetime`

`chemical_role`

Doctrine entity: Chemical\Entity\Role

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`description`	`text`
`sequence`	`integer`

`chemical_safety_icon`

Doctrine entity: Chemical\Entity\Safety\Icon

Column	Doctrine type	Key
`id`	`integer`
`class`	`string`
`description`	`text`
`mimeType`	`string`
`extension`	`string`
`fileSize`	`integer`
`width`	`integer`
`height`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`image`	`blob`
`hash`	`string`

`chemical_safety_statement`

Doctrine entity: Chemical\Entity\Safety\Statement

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`number`	`string`
`statement`	`text`

`consumable_consumable`

Doctrine entity: Consumable\Entity\Consumable

Column	Doctrine type	Key
`id`	`integer`
`number`	`string`
`label`	`string`
`information`	`text`
`isActive`	`boolean`
`approvalRequired`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`user_id`	`FK`	FK
`location_id`	`FK`	FK
`type_id`	`FK`	FK

`consumable_consumable_io`

Doctrine entity: Consumable\Entity\Consumable\Io

Column	Doctrine type	Key
`id`	`integer`
`amount`	`integer`
`dateCreated`	`datetime`
`reason`	`text`
`label`	`string`
`consumable_id`	`FK`	FK
`user_id`	`FK`	FK

`consumable_consumable_io_property`

Doctrine entity: Consumable\Entity\Consumable\Io\Property

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`valueArray`	`array`
`valueInteger`	`integer`
`valueFloat`	`float`
`valueDate`	`date`
`property_id`	`FK`	FK
`io_id`	`FK`	FK

`consumable_consumable_property`

Doctrine entity: Consumable\Entity\Consumable\Property

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`valueArray`	`array`
`valueInteger`	`integer`
`valueFloat`	`float`
`valueDate`	`date`
`property_id`	`FK`	FK
`consumable_id`	`FK`	FK

`consumable_property`

Doctrine entity: Consumable\Entity\Property

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`applications`	`json`
`label`	`text`
`showInList`	`boolean`
`values`	`text`
`defaultValue`	`text`
`unit`	`string`
`sort`	`smallint`
`friendlyText`	`text`

`consumable_type`

Doctrine entity: Consumable\Entity\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`consumptionType`	`smallint`
`color`	`string`
`canBeSubstrate`	`boolean`
`consumableNumberPrefix`	`string`

`deeplink`

Doctrine entity: Deeplink\Entity\Deeplink

Column	Doctrine type	Key
`id`	`integer`
`hash`	`string`
`dateCreated`	`datetime`
`endDate`	`datetime`
`dateAccess`	`datetime`
`keyId`	`string`
`target_id`	`FK`	FK
`user_id`	`FK`	FK

`deeplink_target`

Doctrine entity: Deeplink\Entity\Target

Column	Doctrine type	Key
`id`	`integer`
`target`	`string`
`route`	`string`

`equipment_category`

Doctrine entity: Equipment\Entity\Category

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`default`	`boolean`
`name`	`string`

`equipment_category_type`

Doctrine entity: Equipment\Entity\Category\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`category_id`	`FK`	FK

`equipment_document`

Doctrine entity: Equipment\Entity\Equipment\Document

Column	Doctrine type	Key
`id`	`integer`
`description`	`text`
`date_added`	`datetime`
`filename`	`text`
`user_id`	`FK`	FK
`equipment_id`	`FK`	FK

`equipment_equipment`

Doctrine entity: Equipment\Entity\Equipment

Column	Doctrine type	Key
`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`	FK
`creator_id`	`FK`	FK
`manufacturer_id`	`FK`	FK
`room_id`	`FK`	FK
`zoneGroup_id`	`FK`	FK
`zone_id`	`FK`	FK
`location_id`	`FK`	FK
`storage_location_id`	`FK`	FK
`area_id`	`FK`	FK
`group_id`	`FK`	FK
`mainModule_id`	`FK`	FK
`label_id`	`FK`	FK

`equipment_equipment_document_file`

Doctrine entity: Equipment\Entity\Equipment\Document\File

Column	Doctrine type	Key
`id`	`integer`
`file`	`blob`
`document_id`	`FK`	FK

`equipment_equipment_link`

Doctrine entity: Equipment\Entity\Equipment\Link

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`url`	`string`
`equipment_id`	`FK`	FK
`type_id`	`FK`	FK

`equipment_equipment_link_type`

Doctrine entity: Equipment\Entity\Equipment\Link\Type

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`

`equipment_equipment_mailing_recipient`

Doctrine entity: Equipment\Entity\Equipment\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`equipment_equipment_preventive_maintenance_maintenance`

Doctrine entity: Equipment\Entity\Equipment\PreventiveMaintenance\Maintenance

Column	Doctrine type	Key
`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`	FK
`schedule_id`	`FK`	FK
`reservation_id`	`FK`	FK
`user_id`	`FK`	FK

`equipment_equipment_preventive_maintenance_maintenance_file`

Doctrine entity: Equipment\Entity\Equipment\PreventiveMaintenance\Maintenance\File

Column	Doctrine type	Key
`id`	`integer`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`maintenance_id`	`FK`	FK
`file_id`	`FK`	FK

`equipment_equipment_preventive_maintenance_schedule`

Doctrine entity: Equipment\Entity\Equipment\PreventiveMaintenance\Schedule

Column	Doctrine type	Key
`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`	FK

`equipment_equipment_preventive_maintenance_schedule_file`

Doctrine entity: Equipment\Entity\Equipment\PreventiveMaintenance\Schedule\File

Column	Doctrine type	Key
`id`	`integer`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`schedule_id`	`FK`	FK
`file_id`	`FK`	FK

`equipment_equipment_property`

Doctrine entity: Equipment\Entity\Equipment\Property

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`value`	`text`
`valueArray`	`array`
`valueInteger`	`integer`
`valueFloat`	`float`
`valueDate`	`date`
`property_id`	`FK`	FK
`equipment_id`	`FK`	FK

`equipment_equipment_request`

Doctrine entity: Equipment\Entity\Equipment\Request

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`reason`	`text`
`materials`	`text`
`frequency`	`text`
`status`	`smallint`
`equipment_id`	`FK`	FK
`user_id`	`FK`	FK

`equipment_equipment_request_flow`

Doctrine entity: Equipment\Entity\Equipment\Request\Flow

Column	Doctrine type	Key
`id`	`integer`
`order`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`status`	`smallint`
`request_id`	`FK`	FK
`user_id`	`FK`	FK

`equipment_equipment_role`

Doctrine entity: Equipment\Entity\Equipment\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`status`	`smallint`
`inApprovalFlow`	`smallint`
`equipment_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`equipment_equipment_user`

Doctrine entity: Equipment\Entity\Equipment\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`comment`	`text`
`status`	`smallint`
`equipment_id`	`FK`	FK
`user_id`	`FK`	FK

`equipment_group`

Doctrine entity: Equipment\Entity\Group

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`equipment_logging`

Doctrine entity: Equipment\Entity\Equipment\Logging

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`description`	`text`
`fileName`	`string`
`fileData`	`text`
`separator`	`string`
`mimeType`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`equipment_id`	`FK`	FK
`service_id`	`FK`	FK

`equipment_logging_column`

Doctrine entity: Equipment\Entity\Equipment\Logging\Column

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`column`	`string`
`startRow`	`smallint`
`logging_id`	`FK`	FK
`parameter_id`	`FK`	FK

`equipment_logging_direct_value`

Doctrine entity: Equipment\Entity\Equipment\Logging\DirectValue

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`column`	`string`
`row`	`smallint`
`logging_id`	`FK`	FK
`parameter_id`	`FK`	FK

`equipment_logging_identifier_value`

Doctrine entity: Equipment\Entity\Equipment\Logging\IdentifierValue

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`column`	`string`
`row`	`smallint`
`value`	`string`
`logging_id`	`FK`	FK

`equipment_logging_parameter`

Doctrine entity: Equipment\Entity\Equipment\Logging\Parameter

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`equipment_logging_parameter_equipment`

Doctrine entity: Equipment\Entity\Equipment\Logging\Parameter\Equipment

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`loggingParameter_id`	`FK`	FK
`equipment_id`	`FK`	FK

`equipment_logging_service`

Doctrine entity: Equipment\Entity\Equipment\Logging\Service

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`serverUrl`	`string`
`swaggerFile`	`string`

`equipment_logging_service_method`

Doctrine entity: Equipment\Entity\Equipment\Logging\Service\Method

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`path`	`string`
`method`	`smallint`
`responseContentType`	`string`
`service_id`	`FK`	FK

`equipment_logging_service_method_parameter`

Doctrine entity: Equipment\Entity\Equipment\Logging\Service\Method\Parameter

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`type`	`smallint`
`required`	`boolean`
`method_id`	`FK`	FK

`equipment_logging_service_processing_method`

Doctrine entity: Equipment\Entity\Equipment\Logging\ServiceProcessingMethod

Column	Doctrine type	Key
`id`	`integer`
`type`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`logging_id`	`FK`	FK
`loggingServiceMethod_id`	`FK`	FK

`equipment_logging_service_processing_method_parameter`

Doctrine entity: Equipment\Entity\Equipment\Logging\ServiceProcessingMethod\Parameter

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`value`	`string`
`serviceProcessingMethod_id`	`FK`	FK
`loggingServiceMethodOptions_id`	`FK`	FK
`loggingServiceMethodParameter_id`	`FK`	FK

`equipment_logging_service_processing_method_result`

Doctrine entity: Equipment\Entity\Equipment\Logging\ServiceProcessingMethod\Result

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`resultIndex`	`string`
`resultType`	`smallint`
`dataType`	`smallint`
`serviceProcessingMethod_id`	`FK`	FK

`equipment_module`

Doctrine entity: Equipment\Entity\Module

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`active`	`boolean`
`reservationPossible`	`boolean`
`MESName`	`string`
`number`	`string`
`manufacturer`	`string`
`serialNumber`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`type_id`	`FK`	FK
`label_id`	`FK`	FK
`equipment_id`	`FK`	FK
`function_id`	`FK`	FK

`equipment_module_asset`

Doctrine entity: Equipment\Entity\Module\Asset

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`label`	`string`
`type`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`function_id`	`FK`	FK
`module_id`	`FK`	FK

`equipment_module_asset_function`

Doctrine entity: Equipment\Entity\Module\Asset\FunctionEntity

Column	Doctrine type	Key
`id`	`integer`
`function`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`equipment_module_changelog`

Doctrine entity: Equipment\Entity\Module\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`message`	`text`
`type`	`smallint`
`source`	`smallint`
`module_id`	`FK`	FK
`user_id`	`FK`	FK
`runstep_id`	`FK`	FK
`runstep_checklist_id`	`FK`	FK
`serviceEventChecklist_id`	`FK`	FK

`equipment_module_ecn`

Doctrine entity: Equipment\Entity\Module\Ecn

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateClosed`	`datetime`
`ecn`	`string`
`description`	`text`
`module_id`	`FK`	FK
`user_id`	`FK`	FK
`update_user_id`	`FK`	FK

`equipment_module_ecn_attachment`

Doctrine entity: Equipment\Entity\Module\Ecn\Attachment

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`filename`	`string`
`mimeType`	`string`
`fileSize`	`integer`
`ecn_id`	`FK`	FK

`equipment_module_ecn_attachment_file`

Doctrine entity: Equipment\Entity\Module\Ecn\Attachment\File

Column	Doctrine type	Key
`id`	`integer`
`file`	`blob`
`attachment_id`	`FK`	FK

`equipment_module_external_activity`

Doctrine entity: Equipment\Entity\Module\ExternalActivity

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`account`	`string`
`activity`	`text`
`comment`	`text`
`module_id`	`FK`	FK
`user_id`	`FK`	FK
`type_id`	`FK`	FK

`equipment_module_external_activity_type`

Doctrine entity: Equipment\Entity\Module\ExternalActivity\Type

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`description`	`text`
`isActive`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`equipment_module_facility`

Doctrine entity: Equipment\Entity\Module\Facility

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`facility_id`	`FK`	FK
`module_id`	`FK`	FK

`equipment_module_function`

Doctrine entity: Equipment\Entity\Module\FunctionEntity

Column	Doctrine type	Key
`id`	`integer`
`function`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`equipment_module_group`

Doctrine entity: Equipment\Entity\Module\Group

Column	Doctrine type	Key
`id`	`integer`
`group`	`string`
`visibility`	`smallint`
`sort`	`smallint`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`equipment_module_issue`

Doctrine entity: Equipment\Entity\Module\Issue

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateClosed`	`datetime`
`status`	`smallint`
`issueType`	`smallint`
`issue`	`string`
`description`	`text`
`actions`	`text`
`forecastUp`	`date`
`module_id`	`FK`	FK
`user_id`	`FK`	FK
`update_user_id`	`FK`	FK

`equipment_module_issue_attachment`

Doctrine entity: Equipment\Entity\Module\Issue\Attachment

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`filename`	`string`
`mimeType`	`string`
`fileSize`	`integer`
`issue_id`	`FK`	FK

`equipment_module_issue_attachment_file`

Doctrine entity: Equipment\Entity\Module\Issue\Attachment\File

Column	Doctrine type	Key
`id`	`integer`
`file`	`blob`
`attachment_id`	`FK`	FK

`equipment_module_parameter`

Doctrine entity: Equipment\Entity\Module\Parameter

Column	Doctrine type	Key
`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`	FK
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`equipment_module_parameter_value`

Doctrine entity: Equipment\Entity\Module\Parameter\Value

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`moduleParameter_id`	`FK`	FK

`equipment_module_property`

Doctrine entity: Equipment\Entity\Module\Property

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`value`	`text`
`valueArray`	`array`
`valueInteger`	`integer`
`valueDate`	`date`
`valueFloat`	`float`
`property_id`	`FK`	FK
`module_id`	`FK`	FK

`equipment_module_status`

Doctrine entity: Equipment\Entity\Module\Status

Column	Doctrine type	Key
`id`	`integer`
`active`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`description`	`text`
`module_id`	`FK`	FK
`status_id`	`FK`	FK
`user_id`	`FK`	FK

`equipment_module_status_attachment`

Doctrine entity: Equipment\Entity\Module\Status\Attachment

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`filename`	`text`
`mimeType`	`string`
`fileSize`	`integer`
`status_id`	`FK`	FK

`equipment_module_status_attachment_file`

Doctrine entity: Equipment\Entity\Module\Status\Attachment\File

Column	Doctrine type	Key
`id`	`integer`
`file`	`blob`
`attachment_id`	`FK`	FK

`equipment_module_status_rule`

Doctrine entity: Equipment\Entity\Module\Status\Rule

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`priority`	`integer`
`moduleStatusType`	`smallint`
`checkAllModule`	`boolean`
`equipment_id`	`FK`	FK
`status_id`	`FK`	FK

`equipment_module_type`

Doctrine entity: Equipment\Entity\Module\Type

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`equipment_monitor`

Doctrine entity: Equipment\Entity\Monitor

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`frequency`	`string`
`status`	`smallint`
`type`	`integer`
`project_id`	`FK`	FK
`user_id`	`FK`	FK

`equipment_monitor_changelog`

Doctrine entity: Equipment\Entity\Monitor\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`message`	`string`
`monitor_id`	`FK`	FK
`user_id`	`FK`	FK

`equipment_monitor_measurement`

Doctrine entity: Equipment\Entity\Monitor\Measurement

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sequence`	`integer`
`title`	`string`
`definition`	`string`
`method`	`text`
`step_id`	`FK`	FK

`equipment_monitor_measurement_label`

Doctrine entity: Equipment\Entity\Monitor\Measurement\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`measurement_id`	`FK`	FK

`equipment_monitor_measurement_logging_parameter`

Doctrine entity: Equipment\Entity\Monitor\Measurement\LoggingParameter

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`measurement_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK

`equipment_monitor_measurement_result`

Doctrine entity: Equipment\Entity\Monitor\Measurement\Result

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`uuid`	`string`
`measurement_id`	`FK`	FK
`logging_id`	`FK`	FK
`file_id`	`FK`	FK

`equipment_monitor_measurement_result_process_parameter_value`

Doctrine entity: Equipment\Entity\Monitor\Measurement\Result\MonitorStepParameterValue

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`floatValue`	`float`
`unit`	`string`
`result_id`	`FK`	FK
`monitorStepParameter_id`	`FK`	FK

`equipment_monitor_measurement_result_value`

Doctrine entity: Equipment\Entity\Monitor\Measurement\Result\Value

Column	Doctrine type	Key
`id`	`integer`
`floatValue`	`float`
`stringValue`	`string`
`intValue`	`integer`
`stdDev`	`float`
`unit`	`string`
`result_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK

`equipment_monitor_requirement`

Doctrine entity: Equipment\Entity\Monitor\Requirement

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sequence`	`integer`
`title`	`string`
`definition`	`string`
`method`	`text`
`step_id`	`FK`	FK
`requirement_step_id`	`FK`	FK
`measurement_id`	`FK`	FK

`equipment_monitor_requirement_label`

Doctrine entity: Equipment\Entity\Monitor\Requirement\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`requirement_id`	`FK`	FK

`equipment_monitor_requirement_module_status_change`

Doctrine entity: Equipment\Entity\Monitor\Requirement\ModuleStatusChange

Column	Doctrine type	Key
`id`	`integer`
`type`	`smallint`
`requirement_id`	`FK`	FK
`toStatus_id`	`FK`	FK

`equipment_monitor_requirement_target`

Doctrine entity: Equipment\Entity\Monitor\Requirement\Target

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`minValue`	`float`
`maxValue`	`float`
`target`	`float`
`inclusive`	`smallint`
`unit`	`string`
`requirement_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK

`equipment_monitor_run`

Doctrine entity: Equipment\Entity\Monitor\Run

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`monitor_id`	`FK`	FK
`run_id`	`FK`	FK
`schedule_id`	`FK`	FK

`equipment_monitor_schedule`

Doctrine entity: Equipment\Entity\Monitor\Schedule

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`title`	`string`
`description`	`string`
`parts`	`smallint`
`actions`	`text`
`frequency`	`integer`
`monitor_id`	`FK`	FK
`project_id`	`FK`	FK
`team_id`	`FK`	FK
`group_id`	`FK`	FK

`equipment_monitor_step`

Doctrine entity: Equipment\Entity\Monitor\Step

Column	Doctrine type	Key
`id`	`integer`
`sequence`	`integer`
`number`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`subSteps`	`integer`
`isMonitored`	`smallint`
`remark`	`text`
`instructions`	`text`
`processName`	`string`
`monitor_id`	`FK`	FK
`user_id`	`FK`	FK
`processmodule_id`	`FK`	FK
`stepgroup_id`	`FK`	FK
`process_module_recipe_version_id`	`FK`	FK

`equipment_monitor_step_group`

Doctrine entity: Equipment\Entity\Monitor\Step\Group

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`label`	`string`
`locked`	`smallint`

`equipment_monitor_step_label`

Doctrine entity: Equipment\Entity\Monitor\Step\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`step_id`	`FK`	FK

`equipment_monitor_step_parameter`

Doctrine entity: Equipment\Entity\Monitor\Step\Parameter

Column	Doctrine type	Key
`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`	FK
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`equipment_monitor_step_parameter_value`

Doctrine entity: Equipment\Entity\Monitor\Step\Parameter\Value

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`sequence`	`integer`
`step_parameter_id`	`FK`	FK
`consumable_id`	`FK`	FK

`equipment_monitor_variable`

Doctrine entity: Equipment\Entity\Monitor\Variable

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`stepParameterValue_id`	`FK`	FK

`equipment_picture`

Doctrine entity: Equipment\Entity\Equipment\Picture

Column	Doctrine type	Key
`id`	`integer`
`mimeType`	`string`
`extension`	`string`
`fileSize`	`integer`
`width`	`integer`
`height`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`image`	`blob`
`equipment_id`	`FK`	FK

`equipment_property`

Doctrine entity: Equipment\Entity\Property

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`showInList`	`boolean`
`groupable`	`boolean`
`isConnecting`	`boolean`
`label`	`text`
`values`	`text`
`defaultValue`	`text`
`sort`	`smallint`
`friendlyText`	`text`

`equipment_reservation`

Doctrine entity: Equipment\Entity\Equipment\Reservation

Column	Doctrine type	Key
`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`	FK
`serviceEvent_id`	`FK`	FK
`user_id`	`FK`	FK
`equipment_id`	`FK`	FK
`run_id`	`FK`	FK
`room_id`	`FK`	FK
`project_id`	`FK`	FK
`roomProject_id`	`FK`	FK
`block_id`	`FK`	FK

`equipment_reservation_block`

Doctrine entity: Equipment\Entity\Equipment\Reservation\Block

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`user_id`	`FK`	FK

`equipment_role`

Doctrine entity: Equipment\Entity\Role

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`description`	`text`
`sequence`	`integer`

`equipment_setup`

Doctrine entity: Equipment\Entity\Equipment\Setup

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`setupType`	`smallint`
`reservationType`	`smallint`
`endDate`	`datetime`
`startDate`	`datetime`
`mainEquipment_id`	`FK`	FK

`equipment_setup_equipment`

Doctrine entity: Equipment\Entity\Equipment\Setup\Equipment

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateEnd`	`datetime`
`setup_id`	`FK`	FK
`equipment_id`	`FK`	FK

`equipment_status`

Doctrine entity: Equipment\Entity\Status

Column	Doctrine type	Key
`id`	`integer`
`status`	`string`
`sequence`	`integer`
`frontColor`	`string`
`backColor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`statusType`	`smallint`

`equipment_statusmail`

Doctrine entity: Equipment\Entity\StatusMail

Column	Doctrine type	Key
`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`	FK

`facility_facility`

Doctrine entity: Facility\Entity\Facility

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`number`	`string`
`information`	`text`
`active`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`type_id`	`FK`	FK

`facility_facility_preventive_maintenance_maintenance`

Doctrine entity: Facility\Entity\Facility\PreventiveMaintenance\Maintenance

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateScheduled`	`datetime`
`dateExecuted`	`datetime`
`title`	`string`
`description`	`string`
`actions`	`text`
`comment`	`text`
`status`	`smallint`
`facility_id`	`FK`	FK
`schedule_id`	`FK`	FK
`user_id`	`FK`	FK

`facility_facility_preventive_maintenance_schedule`

Doctrine entity: Facility\Entity\Facility\PreventiveMaintenance\Schedule

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`title`	`string`
`description`	`text`
`actions`	`text`
`frequency`	`integer`
`facility_id`	`FK`	FK

`facility_facility_property`

Doctrine entity: Facility\Entity\Facility\Property

Column	Doctrine type	Key
`id`	`integer`
`value`	`text`
`valueArray`	`array`
`valueInteger`	`integer`
`valueFloat`	`float`
`valueDate`	`date`
`property_id`	`FK`	FK
`facility_id`	`FK`	FK

`facility_facility_status`

Doctrine entity: Facility\Entity\Facility\Status

Column	Doctrine type	Key
`id`	`integer`
`isActive`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`description`	`text`
`facility_id`	`FK`	FK
`status_id`	`FK`	FK
`user_id`	`FK`	FK

`facility_property`

Doctrine entity: Facility\Entity\Property

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`label`	`text`
`showInList`	`boolean`
`values`	`text`
`defaultValue`	`text`
`unit`	`string`
`sort`	`smallint`
`friendlyText`	`text`

`facility_status`

Doctrine entity: Facility\Entity\Status

Column	Doctrine type	Key
`id`	`integer`
`status`	`string`
`frontColor`	`string`
`backColor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`facility_type`

Doctrine entity: Facility\Entity\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`color`	`string`

`file_download`

Doctrine entity: File\Entity\Download

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`user_id`	`FK`	FK
`file_id`	`FK`	FK

`file_file`

Doctrine entity: File\Entity\File

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`docRef`	`string`
`original`	`string`
`extension`	`string`
`mimeType`	`string`
`fileSize`	`integer`
`dateCreated`	`datetime`
`hash`	`string`
`sequence`	`integer`
`caption`	`text`
`user_id`	`FK`	FK

`file_file_object`

Doctrine entity: File\Entity\FileObject

Column	Doctrine type	Key
`id`	`integer`
`object`	`blob`
`file_id`	`FK`	FK

`location_area`

Doctrine entity: Location\Entity\Area

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`label`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`facility_id`	`FK`	FK

`location_facility`

Doctrine entity: Location\Entity\Facility

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`label`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`location_facility_logo`

Doctrine entity: Location\Entity\FacilityLogo

Column	Doctrine type	Key
`id`	`integer`
`original`	`string`
`extension`	`string`
`mimeType`	`string`
`fileSize`	`integer`
`logo`	`blob`
`dateCreated`	`datetime`
`dateUpdated`	`datetime`
`facility_id`	`FK`	FK

`location_message`

Doctrine entity: Location\Entity\Message

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`title`	`string`
`description`	`text`
`type_id`	`FK`	FK
`user_id`	`FK`	FK
`update_user_id`	`FK`	FK

`location_message_type`

Doctrine entity: Location\Entity\Message\Type

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`mailing_attachment`

Doctrine entity: Mailing\Entity\Attachment

Column	Doctrine type	Key
`id`	`integer`
`attachment`	`blob`
`filename`	`string`
`inline`	`boolean`
`contentType`	`string`
`mailing_id`	`FK`	FK

`mailing_deeplink`

Doctrine entity: Mailing\Entity\Deeplink

Column	Doctrine type	Key
`id`	`integer`
`dateExpiration`	`date`
`keyId`	`string`
`target_id`	`FK`	FK
`mailing_id`	`FK`	FK

`mailing_distribution_list`

Doctrine entity: Mailing\Entity\DistributionList

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`lastDateSent`	`datetime`
`isActive`	`boolean`
`isAutomatic`	`boolean`
`hour`	`smallint`
`dayOfWeek`	`simple_array`
`trigger`	`simple_array`
`transactional_id`	`FK`	FK

`mailing_distribution_list_sent`

Doctrine entity: Mailing\Entity\DistributionList\Sent

Column	Doctrine type	Key
`id`	`integer`
`dateSent`	`datetime`
`distributionList_id`	`FK`	FK

`mailing_distribution_list_user`

Doctrine entity: Mailing\Entity\DistributionList\User

Column	Doctrine type	Key
`id`	`integer`
`blocked`	`boolean`
`dateSent`	`datetime`
`dateEnd`	`datetime`
`hash`	`string`
`user_id`	`FK`	FK
`distributionList_id`	`FK`	FK

`mailing_email_message`

Doctrine entity: Mailing\Entity\EmailMessage

Column	Doctrine type	Key
`id`	`integer`
`identifier`	`string`
`dateCreated`	`datetime`
`emailAddress`	`string`
`recipientName`	`string`
`subject`	`string`
`toUser`	`text`
`message`	`text`
`amountOfAttachments`	`smallint`
`user_id`	`FK`	FK
`mailingUser_id`	`FK`	FK
`distributionListUser_id`	`FK`	FK
`template_id`	`FK`	FK
`mailer_id`	`FK`	FK
`sender_id`	`FK`	FK
`queueEmail_id`	`FK`	FK

`mailing_email_message_event`

Doctrine entity: Mailing\Entity\EmailMessageEvent

Column	Doctrine type	Key
`id`	`integer`
`event`	`string`
`time`	`datetime`
`messageId`	`bigint`
`email`	`string`
`campaign`	`string`
`smtpReply`	`text`
`url`	`string`
`ip`	`string`
`agent`	`string`
`error`	`string`
`errorRelatedTo`	`string`
`source`	`string`
`emailMessage_id`	`FK`	FK

`mailing_mailer`

Doctrine entity: Mailing\Entity\Mailer

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`service`	`smallint`
`hostname`	`string`
`username`	`string`
`password`	`string`
`port`	`smallint`
`ssl`	`string`
`sendGridApiKey`	`string`
`isDevelopment`	`boolean`
`isActive`	`boolean`
`oAuth2Service_id`	`FK`	FK

`mailing_mailing`

Doctrine entity: Mailing\Entity\Mailing

Column	Doctrine type	Key
`id`	`integer`
`mailing`	`string`
`mailHtml`	`text`
`mailSubject`	`string`
`templateVariables`	`json`
`actionLinks`	`json`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateDeleted`	`datetime`
`dateLastEmailSent`	`datetime`
`dateQueueStart`	`datetime`
`tag`	`string`
`user_id`	`FK`	FK
`template_id`	`FK`	FK
`sender_id`	`FK`	FK
`mailer_id`	`FK`	FK

`mailing_queue`

Doctrine entity: Mailing\Entity\Queue

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`dateSend`	`datetime`
`mailingUser_id`	`FK`	FK
`mailing_id`	`FK`	FK

`mailing_sender`

Doctrine entity: Mailing\Entity\Sender

Column	Doctrine type	Key
`id`	`integer`
`sender`	`string`
`email`	`string`

`mailing_template`

Doctrine entity: Mailing\Entity\Template

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`subject`	`string`
`body`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`mailing_transactional`

Doctrine entity: Mailing\Entity\Transactional

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`scope`	`smallint`
`action`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`mailHtml`	`text`
`mailSubject`	`string`
`template_id`	`FK`	FK
`sender_id`	`FK`	FK
`mailer_id`	`FK`	FK
`target_id`	`FK`	FK

`mailing_transactional_mailing_recipient`

Doctrine entity: Mailing\Entity\Transactional\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`mailing_transactional_recipient`

Doctrine entity: Mailing\Entity\Transactional\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`dateUpdated`	`datetime`
`transactional_id`	`FK`	FK
`generalMailingRecipient_id`	`FK`	FK
`chemicalMailingRecipient_id`	`FK`	FK
`equipmentMailingRecipient_id`	`FK`	FK
`serviceMailingRecipient_id`	`FK`	FK
`roomMailingRecipient_id`	`FK`	FK
`runMailingRecipient_id`	`FK`	FK
`schedulerMailingRecipient_id`	`FK`	FK

`mailing_user`

Doctrine entity: Mailing\Entity\User

Column	Doctrine type	Key
`id`	`integer`
`blocked`	`boolean`
`dateSent`	`datetime`
`hash`	`string`
`user_id`	`FK`	FK
`mailing_id`	`FK`	FK

`oauth_access_tokens`

Doctrine entity: Api\Entity\OAuth\AccessToken

Column	Doctrine type	Key
`id`	`integer`
`access_token`	`text`
`expires`	`datetime_immutable`
`scope`	`string`
`client_id`	`FK`	FK
`user_id`	`FK`	FK

`oauth_authorization_codes`

Doctrine entity: Api\Entity\OAuth\AuthorizationCode

Column	Doctrine type	Key
`id`	`integer`
`authorization_code`	`string`
`expires`	`datetime_immutable`
`redirect_uri`	`string`
`scope`	`string`
`id_token`	`string`
`code_challenge`	`string`
`code_challenge_method`	`string`
`client_id`	`FK`	FK
`user_id`	`FK`	FK

`oauth_clients`

Doctrine entity: Api\Entity\OAuth\Client

Column	Doctrine type	Key
`client_id`	`string`
`client_secret`	`string`
`name`	`string`
`description`	`text`
`client_secret_teaser`	`string`
`redirect_uri`	`string`
`grant_types`	`string`
`scope_id`	`FK`	FK

`oauth_jwt`

Doctrine entity: Api\Entity\OAuth\Jwt

Column	Doctrine type	Key
`id`	`integer`
`public_key`	`string`
`subject`	`string`
`client_id`	`FK`	FK

`oauth_public_keys`

Doctrine entity: Api\Entity\OAuth\PublicKey

Column	Doctrine type	Key
`id`	`integer`
`public_key`	`text`
`private_key`	`text`
`encryption_algorithm`	`string`
`client_id`	`FK`	FK

`oauth_refresh_tokens`

Doctrine entity: Api\Entity\OAuth\RefreshToken

Column	Doctrine type	Key
`id`	`integer`
`refresh_token`	`string`
`expires`	`datetime_immutable`
`scope`	`string`
`client_id`	`FK`	FK
`user_id`	`FK`	FK

`oauth_scopes`

Doctrine entity: Api\Entity\OAuth\Scope

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`scope`	`string`
`is_default`	`boolean`

`organisation_baseline`

Doctrine entity: Organisation\Entity\Baseline

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`string`
`allowPartLabel`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`organisation_department`

Doctrine entity: Organisation\Entity\Department

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`organisation_external_company`

Doctrine entity: Organisation\Entity\ExternalCompany

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`applicationFields`	`json`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`organisation_group`

Doctrine entity: Organisation\Entity\Group

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbr`	`string`
`status`	`boolean`
`runNumberPrefix`	`smallint`
`customRunNumberPrefix`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`approvalRequired`	`boolean`

`organisation_group_role`

Doctrine entity: Organisation\Entity\Group\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`startDate`	`date`
`endDate`	`date`
`comment`	`text`
`status`	`boolean`
`group_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`organisation_group_user`

Doctrine entity: Organisation\Entity\Group\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`startDate`	`date`
`endDate`	`date`
`comment`	`text`
`status`	`boolean`
`group_id`	`FK`	FK
`user_id`	`FK`	FK

`organisation_manufacturer`

Doctrine entity: Organisation\Entity\Manufacturer

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`organisation_program`

Doctrine entity: Organisation\Entity\Program

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbr`	`string`
`status`	`boolean`
`backgroundColor`	`string`
`frontColor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`private`	`boolean`
`dateStart`	`datetime`
`dateEnd`	`datetime`

`organisation_program_role`

Doctrine entity: Organisation\Entity\Program\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`dateStart`	`date`
`dateEnd`	`date`
`comment`	`text`
`status`	`boolean`
`program_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`organisation_program_user`

Doctrine entity: Organisation\Entity\Program\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`dateStart`	`date`
`dateEnd`	`date`
`comment`	`text`
`status`	`boolean`
`program_id`	`FK`	FK
`user_id`	`FK`	FK

`organisation_project`

Doctrine entity: Organisation\Entity\Project

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbr`	`string`
`externalReference`	`string`
`description`	`text`
`status`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`private`	`boolean`
`substratesPerPart`	`smallint`
`substrateRequirement`	`smallint`
`purposes`	`json`
`approvalRequired`	`boolean`
`startDate`	`datetime`
`endDate`	`datetime`

`organisation_project_property`

Doctrine entity: Organisation\Entity\Property

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`label`	`text`
`values`	`text`
`isHidden`	`boolean`
`sort`	`smallint`
`friendlyText`	`text`

`organisation_project_property_value`

Doctrine entity: Organisation\Entity\Project\Property

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`value`	`text`
`valueArray`	`json`
`valueInteger`	`integer`
`valueFloat`	`float`
`valueDate`	`date`
`property_id`	`FK`	FK
`project_id`	`FK`	FK

`organisation_project_role`

Doctrine entity: Organisation\Entity\Project\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`startDate`	`date`
`endDate`	`date`
`comment`	`text`
`status`	`boolean`
`project_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`organisation_project_tag`

Doctrine entity: Organisation\Entity\Project\Tag

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`description`	`string`
`frontColor`	`string`
`backColor`	`string`
`project_id`	`FK`	FK

`organisation_project_user`

Doctrine entity: Organisation\Entity\Project\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`startDate`	`date`
`endDate`	`date`
`comment`	`text`
`status`	`boolean`
`project_id`	`FK`	FK
`user_id`	`FK`	FK

`organisation_role`

Doctrine entity: Organisation\Entity\Role

Column	Doctrine type	Key
`id`	`integer`
`title`	`text`
`description`	`text`
`order`	`integer`
`status`	`boolean`

`organisation_team`

Doctrine entity: Organisation\Entity\Team

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbr`	`string`
`status`	`boolean`
`purposes`	`json`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`approvalRequired`	`boolean`
`group_id`	`FK`	FK

`organisation_team_role`

Doctrine entity: Organisation\Entity\Team\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`startDate`	`date`
`endDate`	`date`
`comment`	`text`
`status`	`boolean`
`team_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`organisation_team_user`

Doctrine entity: Organisation\Entity\Team\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`startDate`	`date`
`endDate`	`date`
`comment`	`text`
`status`	`boolean`
`team_id`	`FK`	FK
`user_id`	`FK`	FK

`organisation_wbs`

Doctrine entity: Organisation\Entity\Wbs

Column	Doctrine type	Key
`id`	`integer`
`code`	`string`
`externalReference`	`string`
`description`	`text`
`status`	`boolean`
`purposes`	`json`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`organisation_wbs_property_value`

Doctrine entity: Organisation\Entity\Wbs\Property

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`value`	`text`
`valueArray`	`json`
`valueInteger`	`integer`
`valueFloat`	`float`
`valueDate`	`date`
`property_id`	`FK`	FK
`wbs_id`	`FK`	FK

`page_news`

Doctrine entity: Page\Entity\News

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`docRef`	`string`
`content`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sticky`	`smallint`
`breakingNews`	`smallint`
`numViews`	`integer`
`user_id`	`FK`	FK

`page_news_read`

Doctrine entity: Page\Entity\News\Read

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`user_id`	`FK`	FK
`news_id`	`FK`	FK

`page_page`

Doctrine entity: Page\Entity\Page

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`docRef`	`string`
`content`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`showInNavigation`	`smallint`
`numViews`	`integer`

`page_page_tree`

Doctrine entity: Page\Entity\Page\Tree

Column	Doctrine type	Key
`id`	`integer`
`sequence`	`integer`
`child_page_id`	`FK`	FK
`parent_page_id`	`FK`	FK

`page_youtrack_project`

Doctrine entity: Page\Entity\YouTrack\Project

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`url`	`string`
`projectId`	`string`
`accessToken`	`string`
`isActive`	`boolean`

`process_category`

Doctrine entity: Process\Entity\Category

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`number`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`process_module`

Doctrine entity: Process\Entity\Process\Module

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`inUse`	`boolean`
`isAssemblyProcess`	`boolean`
`hasLocalParameters`	`boolean`
`process_id`	`FK`	FK
`module_id`	`FK`	FK

`process_module_parameter`

Doctrine entity: Process\Entity\Process\Module\Parameter

Column	Doctrine type	Key
`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`	FK
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`process_module_parameter_value`

Doctrine entity: Process\Entity\Process\Module\Parameter\Value

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`moduleParameter_id`	`FK`	FK

`process_module_recipe`

Doctrine entity: Process\Entity\Process\Module\Recipe

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`status`	`smallint`
`subSteps`	`integer`
`process_module_id`	`FK`	FK
`type_id`	`FK`	FK
`user_id`	`FK`	FK

`process_module_recipe_changelog`

Doctrine entity: Process\Entity\Process\Module\Recipe\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`message`	`text`
`recipe_id`	`FK`	FK
`user_id`	`FK`	FK

`process_module_recipe_checklist`

Doctrine entity: Process\Entity\Process\Module\Recipe\Checklist

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`task`	`string`
`description`	`text`
`runChangelogType`	`integer`
`equipmentModuleChangelogType`	`integer`
`sequence`	`integer`
`recipe_id`	`FK`	FK

`process_module_recipe_parameter`

Doctrine entity: Process\Entity\Process\Module\Recipe\Parameter

Column	Doctrine type	Key
`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`	FK
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`process_module_recipe_parameter_value`

Doctrine entity: Process\Entity\Process\Module\Recipe\Parameter\Value

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`sequence`	`integer`
`recipe_parameter_id`	`FK`	FK
`consumable_id`	`FK`	FK

`process_module_recipe_rework`

Doctrine entity: Process\Entity\Process\Module\Recipe\Rework

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`notes`	`string`
`recipe_id`	`FK`	FK
`template_id`	`FK`	FK

`process_module_recipe_type`

Doctrine entity: Process\Entity\Process\Module\Recipe\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`frontColor`	`string`
`backColor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`process_module_recipe_version`

Doctrine entity: Process\Entity\Process\Module\Recipe\Version

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`version`	`integer`
`subSteps`	`integer`
`notes`	`string`
`recipe_id`	`FK`	FK
`user_id`	`FK`	FK

`process_module_recipe_version_checklist`

Doctrine entity: Process\Entity\Process\Module\Recipe\Version\Checklist

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`task`	`string`
`description`	`text`
`runChangelogType`	`integer`
`equipmentModuleChangelogType`	`integer`
`sequence`	`integer`
`recipeVersion_id`	`FK`	FK

`process_module_recipe_version_parameter`

Doctrine entity: Process\Entity\Process\Module\Recipe\Version\Parameter

Column	Doctrine type	Key
`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`	FK
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`process_module_recipe_version_parameter_value`

Doctrine entity: Process\Entity\Process\Module\Recipe\Version\Parameter\Value

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`sequence`	`integer`
`recipe_parameter_id`	`FK`	FK
`consumable_id`	`FK`	FK

`process_parameter`

Doctrine entity: Process\Entity\Parameter

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbr`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`parameter_type_id`	`FK`	FK

`process_parameter_type`

Doctrine entity: Process\Entity\Parameter\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbr`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`process_process`

Doctrine entity: Process\Entity\Process

Column	Doctrine type	Key
`id`	`integer`
`version`	`integer`
`name`	`string`
`number`	`integer`
`active`	`boolean`
`hasMeasuredValue`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`private`	`boolean`
`category_id`	`FK`	FK
`user_id`	`FK`	FK

`process_type`

Doctrine entity: Process\Entity\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`canBeRequirement`	`smallint`
`hasColor`	`smallint`
`color`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`user_id`	`FK`	FK

`process_unit`

Doctrine entity: Process\Entity\Unit

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbr`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`reporting_storage_location`

Doctrine entity: Reporting\Entity\StorageLocation

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`connectionString`	`string`
`exportFileType`	`string`
`purpose`	`string`
`container`	`string`
`folder`	`string`
`oAuth2Service_id`	`FK`	FK

`reporting_sync_log`

Doctrine entity: Reporting\Entity\SyncLog

Column	Doctrine type	Key
`id`	`integer`
`entity`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`processed`	`integer`
`created`	`integer`
`updated`	`integer`
`skipped`	`integer`
`rawLog`	`text`
`metadata`	`json`
`storageLocation_id`	`FK`	FK

`room_building`

Doctrine entity: Room\Entity\Building

Column	Doctrine type	Key
`id`	`integer`
`code`	`string`
`name`	`string`
`status`	`smallint`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`site_id`	`FK`	FK

`room_document`

Doctrine entity: Room\Entity\Room\Document

Column	Doctrine type	Key
`id`	`integer`
`description`	`text`
`date_added`	`datetime`
`lastUpdate`	`datetime`
`filename`	`text`
`user_id`	`FK`	FK
`room_id`	`FK`	FK

`room_document_file`

Doctrine entity: Room\Entity\Room\Document\File

Column	Doctrine type	Key
`id`	`integer`
`file`	`blob`
`document_id`	`FK`	FK

`room_floorplan`

Doctrine entity: Room\Entity\Room\FloorPlan

Column	Doctrine type	Key
`id`	`integer`
`mimeType`	`string`
`extension`	`string`
`fileSize`	`integer`
`width`	`integer`
`height`	`integer`
`type`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`image`	`blob`
`room_id`	`FK`	FK

`room_location`

Doctrine entity: Room\Entity\Location

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`code`	`string`
`status`	`boolean`
`subdivision_label`	`string`
`gridRow`	`smallint`
`gridColumn`	`smallint`
`gridPosition`	`smallint`
`childGridRows`	`smallint`
`childGridColumns`	`smallint`
`childGridOrientation`	`smallint`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`left`	`integer`
`level`	`integer`
`right`	`integer`
`childSubdivisionTemplate_id`	`FK`	FK
`root_id`	`FK`	FK
`parent_id`	`FK`	FK
`zone_group_id`	`FK`	FK
`label_id`	`FK`	FK

`room_location_subdivision_template`

Doctrine entity: Room\Entity\Location\SubdivisionTemplate

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`rows`	`smallint`
`columns`	`smallint`
`orientation`	`smallint`
`rowLabelType`	`string`
`columnLabelType`	`string`
`labelFormat`	`string`
`custom_labels`	`json`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`room_role`

Doctrine entity: Room\Entity\Role

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`description`	`text`
`sequence`	`integer`

`room_room`

Doctrine entity: Room\Entity\Room

Column	Doctrine type	Key
`id`	`integer`
`name`	`text`
`code`	`string`
`department`	`string`
`purpose`	`string`
`tags`	`string`
`opening_time`	`time`
`closing_time`	`time`
`openingHoursOnReservationsEnforcement`	`integer`
`lastUpdate`	`datetime`
`description`	`text`
`phone`	`text`
`location_details`	`text`
`status`	`smallint`
`training_description`	`text`
`building_id`	`FK`	FK
`label_id`	`FK`	FK

`room_room_link`

Doctrine entity: Room\Entity\Room\Link

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`url`	`string`
`room_id`	`FK`	FK
`type_id`	`FK`	FK

`room_room_link_type`

Doctrine entity: Room\Entity\Room\Link\Type

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`

`room_room_mailing_recipient`

Doctrine entity: Room\Entity\Room\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`room_room_program`

Doctrine entity: Room\Entity\Room\Program

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`isActive`	`boolean`
`program_id`	`FK`	FK
`room_id`	`FK`	FK

`room_room_project`

Doctrine entity: Room\Entity\Room\Project

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`isActive`	`boolean`
`project_id`	`FK`	FK
`wbs_id`	`FK`	FK
`room_id`	`FK`	FK

`room_room_request`

Doctrine entity: Room\Entity\Room\Request

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`hasMentorApproval`	`boolean`
`reason`	`text`
`equipment`	`text`
`materials`	`text`
`frequency`	`text`
`status`	`smallint`
`room_id`	`FK`	FK
`user_id`	`FK`	FK
`user_mentor_id`	`FK`	FK

`room_room_request_flow`

Doctrine entity: Room\Entity\Room\Request\Flow

Column	Doctrine type	Key
`id`	`integer`
`order`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`status`	`smallint`
`request_id`	`FK`	FK
`user_id`	`FK`	FK

`room_room_role`

Doctrine entity: Room\Entity\Room\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`status`	`smallint`
`inApprovalFlow`	`smallint`
`room_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`room_room_user`

Doctrine entity: Room\Entity\Room\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`status`	`smallint`
`room_id`	`FK`	FK
`user_id`	`FK`	FK
`user_mentor_id`	`FK`	FK

`room_site`

Doctrine entity: Room\Entity\Site

Column	Doctrine type	Key
`id`	`integer`
`code`	`string`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`hasExternalChemicalLabelling`	`boolean`

`room_site_floor_plan`

Doctrine entity: Room\Entity\Site\FloorPlan

Column	Doctrine type	Key
`id`	`integer`
`mimeType`	`string`
`extension`	`string`
`fileSize`	`integer`
`width`	`integer`
`height`	`integer`
`type`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`image`	`blob`
`site_id`	`FK`	FK

`room_zone`

Doctrine entity: Room\Entity\Zone

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`description`	`text`
`status`	`smallint`
`group_id`	`FK`	FK
`label_id`	`FK`	FK

`room_zone_group`

Doctrine entity: Room\Entity\Zone\Group

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`description`	`text`
`capacity`	`smallint`
`room_id`	`FK`	FK

`room_zone_group_user`

Doctrine entity: Room\Entity\Zone\Group\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`group_id`	`FK`	FK
`user_id`	`FK`	FK

`room_zone_reservation`

Doctrine entity: Room\Entity\Zone\Reservation

Column	Doctrine type	Key
`id`	`integer`
`time_start`	`datetime`
`time_end`	`datetime`
`recurring`	`integer`
`recurringEndDate`	`datetime`
`type`	`integer`
`title`	`string`
`recurring_link_id`	`FK`	FK
`user_id`	`FK`	FK
`zone_id`	`FK`	FK

`room_zone_user`

Doctrine entity: Room\Entity\Zone\User

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isActive`	`boolean`
`zone_id`	`FK`	FK
`user_id`	`FK`	FK

`run_changelog`

Doctrine entity: Run\Entity\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`message`	`text`
`type`	`smallint`
`source`	`smallint`
`run_id`	`FK`	FK
`user_id`	`FK`	FK
`runstep_checklist_id`	`FK`	FK

`run_consumable`

Doctrine entity: Run\Entity\Consumable

Column	Doctrine type	Key
`id`	`integer`
`amount`	`float`
`run_id`	`FK`	FK
`consumable_id`	`FK`	FK

`run_consumable_matrix_consumable`

Doctrine entity: Run\Entity\Consumable\Matrix\Consumable

Column	Doctrine type	Key
`id`	`integer`
`consumableNumber`	`array`
`label`	`string`
`consumable_matrix_id`	`FK`	FK
`run_consumable_id`	`FK`	FK

`run_hold_code`

Doctrine entity: Run\Entity\HoldCode

Column	Doctrine type	Key
`id`	`integer`
`code`	`string`
`description`	`text`
`frontColor`	`string`
`backColor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isHold`	`boolean`

`run_measurement`

Doctrine entity: Run\Entity\Measurement

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sequence`	`integer`
`title`	`string`
`definition`	`string`
`method`	`text`
`step_id`	`FK`	FK

`run_measurement_label`

Doctrine entity: Run\Entity\Measurement\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`measurement_id`	`FK`	FK

`run_measurement_logging_parameter`

Doctrine entity: Run\Entity\Measurement\LoggingParameter

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`measurement_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK

`run_measurement_part`

Doctrine entity: Run\Entity\Measurement\Part

Column	Doctrine type	Key
`id`	`integer`
`measuredValue`	`float`
`measurement_id`	`FK`	FK
`step_part_id`	`FK`	FK

`run_measurement_result`

Doctrine entity: Run\Entity\Measurement\Result

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`uuid`	`string`
`measurement_id`	`FK`	FK
`runPartMapping_id`	`FK`	FK
`logging_id`	`FK`	FK
`file_id`	`FK`	FK

`run_measurement_result_value`

Doctrine entity: Run\Entity\Measurement\Result\Value

Column	Doctrine type	Key
`id`	`integer`
`floatValue`	`float`
`stringValue`	`string`
`intValue`	`integer`
`stdDev`	`float`
`unit`	`string`
`result_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK
`step_part_id`	`FK`	FK

`run_measurement_summary`

Doctrine entity: Run\Entity\Measurement\Summary

Column	Doctrine type	Key
`id`	`integer`
`title`	`text`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`user_id`	`FK`	FK

`run_measurement_summary_run`

Doctrine entity: Run\Entity\Measurement\Summary\Run

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`summary_id`	`FK`	FK
`run_id`	`FK`	FK

`run_measurement_summary_run_part`

Doctrine entity: Run\Entity\Measurement\Summary\Run\Part

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`sequence`	`integer`
`comment`	`text`
`summary_id`	`FK`	FK
`part_id`	`FK`	FK

`run_parent`

Doctrine entity: Run\Entity\RunParent

Column	Doctrine type	Key
`id`	`integer`
`description`	`string`
`open`	`smallint`
`parent_run_id`	`FK`	FK
`run_id`	`FK`	FK

`run_part`

Doctrine entity: Run\Entity\Part

Column	Doctrine type	Key
`id`	`integer`
`partId`	`smallint`
`shortLabel`	`string`
`label`	`string`
`tray_row`	`smallint`
`tray_column`	`smallint`
`left`	`integer`
`level`	`integer`
`right`	`integer`
`run_id`	`FK`	FK
`tray_id`	`FK`	FK
`layout_id`	`FK`	FK
`baseline_id`	`FK`	FK
`root_id`	`FK`	FK
`parent_id`	`FK`	FK

`run_part_consumable_creation`

Doctrine entity: Run\Entity\Part\Consumable\Creation

Column	Doctrine type	Key
`id`	`integer`
`amount`	`integer`
`part_id`	`FK`	FK
`consumable_id`	`FK`	FK

`run_part_layout`

Doctrine entity: Run\Entity\Part\Layout

Column	Doctrine type	Key
`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`

Doctrine entity: Run\Entity\Part\Mapping

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`mapId`	`smallint`
`label`	`string`
`xCoordinate`	`integer`
`yCoordinate`	`integer`
`width`	`integer`
`height`	`integer`
`part_id`	`FK`	FK

`run_priority`

Doctrine entity: Run\Entity\Priority

Column	Doctrine type	Key
`id`	`integer`
`code`	`string`
`description`	`text`
`order`	`integer`
`frontColor`	`string`
`backColor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`run_requirement`

Doctrine entity: Run\Entity\Requirement

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sequence`	`integer`
`title`	`string`
`definition`	`string`
`method`	`text`
`step_id`	`FK`	FK
`requirement_step_id`	`FK`	FK
`measurement_id`	`FK`	FK

`run_requirement_label`

Doctrine entity: Run\Entity\Requirement\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`requirement_id`	`FK`	FK

`run_requirement_part`

Doctrine entity: Run\Entity\Requirement\Part

Column	Doctrine type	Key
`id`	`integer`
`maxValue`	`float`
`requirement_id`	`FK`	FK
`step_part_id`	`FK`	FK

`run_requirement_target`

Doctrine entity: Run\Entity\Requirement\Target

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`minValue`	`float`
`maxValue`	`float`
`target`	`float`
`inclusive`	`smallint`
`unit`	`string`
`requirement_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK

`run_role`

Doctrine entity: Run\Entity\Role

Column	Doctrine type	Key
`id`	`integer`
`title`	`text`
`description`	`text`
`order`	`integer`
`status`	`smallint`

`run_run`

Doctrine entity: Run\Entity\Run

Column	Doctrine type	Key
`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`	FK
`user_id`	`FK`	FK
`project_id`	`FK`	FK
`team_id`	`FK`	FK
`group_id`	`FK`	FK
`trayType_id`	`FK`	FK
`sampleType_id`	`FK`	FK

`run_run_batch_card`

Doctrine entity: Run\Entity\Run\BatchCard

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`content`	`text`
`run_id`	`FK`	FK
`user_id`	`FK`	FK

`run_run_hold_code`

Doctrine entity: Run\Entity\Run\HoldCode

Column	Doctrine type	Key
`id`	`integer`
`active`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`description`	`text`
`run_id`	`FK`	FK
`holdCode_id`	`FK`	FK
`user_id`	`FK`	FK

`run_run_mailing_recipient`

Doctrine entity: Run\Entity\Run\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`run_run_priority`

Doctrine entity: Run\Entity\Run\Priority

Column	Doctrine type	Key
`id`	`integer`
`active`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`description`	`text`
`run_id`	`FK`	FK
`priority_id`	`FK`	FK
`user_id`	`FK`	FK

`run_run_role`

Doctrine entity: Run\Entity\Run\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`comment`	`text`
`status`	`smallint`
`run_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`run_run_tray`

Doctrine entity: Run\Entity\Run\Tray

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`label`	`string`
`sequence`	`smallint`
`run_id`	`FK`	FK
`tray_type_id`	`FK`	FK

`run_run_variable`

Doctrine entity: Run\Entity\Run\Variable

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`stepParameterValue_id`	`FK`	FK

`run_sample_type`

Doctrine entity: Run\Entity\SampleType

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`description`	`text`
`prefixes`	`string`
`treePreset`	`text`

`run_service_work`

Doctrine entity: Run\Entity\ServiceWork

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`finishDate`	`datetime`
`instructions`	`text`
`dispatched`	`smallint`
`status`	`smallint`
`user_id`	`FK`	FK
`run_id`	`FK`	FK

`run_service_work_comment`

Doctrine entity: Run\Entity\ServiceWork\Comment

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`service_work_id`	`FK`	FK
`user_id`	`FK`	FK

`run_service_work_step`

Doctrine entity: Run\Entity\ServiceWork\Step

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`startDate`	`datetime`
`lastUpdate`	`datetime`
`finishDate`	`datetime`
`remark`	`text`
`instructions`	`text`
`status`	`smallint`
`user_id`	`FK`	FK
`service_work_id`	`FK`	FK
`step_id`	`FK`	FK

`run_step`

Doctrine entity: Run\Entity\Step

Column	Doctrine type	Key
`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`	FK
`rework_id`	`FK`	FK
`user_id`	`FK`	FK
`start_user_id`	`FK`	FK
`finish_user_id`	`FK`	FK
`processmodule_id`	`FK`	FK
`template_step_id`	`FK`	FK
`monitor_step_id`	`FK`	FK
`stepgroup_id`	`FK`	FK
`process_module_recipe_version_id`	`FK`	FK

`run_step_checklist`

Doctrine entity: Run\Entity\Step\Checklist

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateExecuted`	`datetime`
`task`	`string`
`description`	`text`
`sequence`	`integer`
`runChangelogType`	`integer`
`equipmentModuleChangelogType`	`integer`
`runStep_id`	`FK`	FK
`user_id`	`FK`	FK

`run_step_group`

Doctrine entity: Run\Entity\Step\Group

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`label`	`string`
`locked`	`smallint`

`run_step_label`

Doctrine entity: Run\Entity\Step\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`step_id`	`FK`	FK

`run_step_parameter`

Doctrine entity: Run\Entity\Step\Parameter

Column	Doctrine type	Key
`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`	FK
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`run_step_parameter_value`

Doctrine entity: Run\Entity\Step\Parameter\Value

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`sequence`	`integer`
`step_parameter_id`	`FK`	FK
`consumable_id`	`FK`	FK
`assemblyRunStep_id`	`FK`	FK

`run_step_parameter_value_realised`

Doctrine entity: Run\Entity\Step\Parameter\Value\Realised

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`step_parameter_value_id`	`FK`	FK

`run_step_part`

Doctrine entity: Run\Entity\Step\Part

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateStarted`	`datetime`
`dateProcessed`	`datetime`
`dateFailed`	`datetime`
`comment`	`text`
`step_id`	`FK`	FK
`part_id`	`FK`	FK

`run_step_part_state`

Doctrine entity: Run\Entity\Step\Part\State

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`comment`	`text`
`stepPart_id`	`FK`	FK
`type_id`	`FK`	FK
`user_id`	`FK`	FK

`run_step_part_state_action`

Doctrine entity: Run\Entity\Step\Part\State\Action

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`toType_id`	`FK`	FK

`run_step_part_state_type`

Doctrine entity: Run\Entity\Step\Part\State\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`isDefaultState`	`boolean`
`isFinishedState`	`boolean`
`isFailedState`	`boolean`
`isRepairingState`	`boolean`
`isTestingState`	`boolean`
`color`	`string`

`run_step_part_tray`

Doctrine entity: Run\Entity\Step\Part\Tray

Column	Doctrine type	Key
`id`	`integer`
`trayRow`	`smallint`
`trayColumn`	`smallint`
`stepPart_id`	`FK`	FK
`tray_id`	`FK`	FK

`run_step_rework`

Doctrine entity: Run\Entity\Step\Rework

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comment`	`text`
`user_id`	`FK`	FK

`run_substrate`

Doctrine entity: Run\Entity\Substrate

Column	Doctrine type	Key
`id`	`integer`
`amount`	`integer`
`run_id`	`FK`	FK
`substrate_id`	`FK`	FK

`run_substrate_matrix`

Doctrine entity: Run\Entity\Substrate\Matrix

Column	Doctrine type	Key
`id`	`integer`
`part_id`	`FK`	FK

`run_substrate_matrix_substrate`

Doctrine entity: Run\Entity\Substrate\Matrix\Substrate

Column	Doctrine type	Key
`id`	`integer`
`substrateNumber`	`array`
`label`	`string`
`substrate_matrix_id`	`FK`	FK
`run_substrate_id`	`FK`	FK

`run_tray_type`

Doctrine entity: Run\Entity\TrayType

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`columns`	`smallint`
`rows`	`smallint`
`orientation`	`smallint`
`forbidden_slots`	`json`

`scheduler_job`

Doctrine entity: Scheduler\Entity\Job

Column	Doctrine type	Key
`id`	`integer`
`lotId`	`string`
`lots`	`text`
`description`	`text`
`equipmentFilter`	`text`
`expectedDuration`	`integer`
`weight`	`smallint`
`noProject`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateSubmitted`	`datetime_immutable`
`dateSubmissionDateValid`	`datetime_immutable`
`dateStarted`	`datetime_immutable`
`dateFinished`	`datetime_immutable`
`temperature`	`integer`
`numberOfChildren`	`integer`
`keepJobOnEquipment`	`boolean`
`emailOnProposedTimeslotChange`	`boolean`
`ignoreStartWorkingHourForNextChild`	`boolean`
`isContiguous`	`boolean`
`maxParallelJobs`	`integer`
`setupTime`	`integer`
`holdUntil`	`datetime`
`dueBy`	`datetime`
`startHour`	`integer`
`endHour`	`integer`
`user_id`	`FK`	FK
`program_id`	`FK`	FK
`project_id`	`FK`	FK
`wbs_id`	`FK`	FK

`scheduler_job_changelog`

Doctrine entity: Scheduler\Entity\Job\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime_immutable`
`changelog`	`text`
`job_id`	`FK`	FK
`user_id`	`FK`	FK

`scheduler_job_equipment`

Doctrine entity: Scheduler\Entity\Job\Equipment

Column	Doctrine type	Key
`id`	`integer`
`motivation`	`string`
`include`	`boolean`
`dateCreated`	`datetime`
`type`	`smallint`
`lastUpdate`	`datetime`
`job_id`	`FK`	FK
`equipment_id`	`FK`	FK
`replacedJobEquipment_id`	`FK`	FK
`equipmentReservation_id`	`FK`	FK

`scheduler_job_status`

Doctrine entity: Scheduler\Entity\Job\Status

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime_immutable`
`status`	`smallint`
`job_id`	`FK`	FK
`user_id`	`FK`	FK

`scheduler_mailing`

Doctrine entity: Scheduler\Entity\Mailing

Column	Doctrine type	Key
`id`	`integer`
`action`	`string`
`event`	`string`
`isActive`	`boolean`
`isAutomatic`	`boolean`
`interval`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`transactional_id`	`FK`	FK

`scheduler_queue`

Doctrine entity: Scheduler\Entity\Queue

Column	Doctrine type	Key
`id`	`integer`
`identifier`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateStart`	`datetime_immutable`
`dateEnd`	`datetime_immutable`
`dateGrace`	`datetime_immutable`
`dateDefer`	`datetime_immutable`
`dateStarted`	`datetime_immutable`
`dateFinished`	`datetime_immutable`
`dateLocked`	`datetime_immutable`
`frozen`	`boolean`
`weightedDuration`	`float`
`job_id`	`FK`	FK
`equipment_id`	`FK`	FK
`equipmentReservation_id`	`FK`	FK
`quotaRule_id`	`FK`	FK

`scheduler_queue_email`

Doctrine entity: Scheduler\Entity\Queue\Email

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`dateSend`	`datetime`
`dateInvalid`	`datetime`
`schedulerMailing_id`	`FK`	FK
`queue_id`	`FK`	FK

`scheduler_queue_grace_request`

Doctrine entity: Scheduler\Entity\Queue\GraceRequest

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`reason`	`text`
`graceTime`	`integer`
`user_id`	`FK`	FK
`queue_id`	`FK`	FK

`scheduler_quota_header`

Doctrine entity: Scheduler\Entity\QuotaHeader

Column	Doctrine type	Key
`id`	`integer`
`isActive`	`boolean`
`entityType`	`smallint`
`quotaPeriodValue`	`integer`
`quotaPeriodUnit`	`smallint`
`peakHoursWeight`	`float`
`peakHoursStart`	`time`
`peakHoursEnd`	`time`
`offPeakWeight`	`float`
`weekendWeight`	`float`
`lastMinuteWeight`	`float`
`slaValue`	`integer`
`slaUnit`	`smallint`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`equipment_id`	`FK`	FK
`equipmentGroup_id`	`FK`	FK

`scheduler_quota_rule`

Doctrine entity: Scheduler\Entity\QuotaRule

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`isActive`	`boolean`
`userGroupType`	`smallint`
`percentQuota`	`integer`
`personalQuota`	`integer`
`bookingLeadTimeValue`	`integer`
`bookingLeadTimeUnit`	`smallint`
`maxBookingsNumber`	`integer`
`maxBookingTimeValue`	`integer`
`maxBookingTimeUnit`	`smallint`
`bookingWindowValue`	`integer`
`bookingWindowUnit`	`smallint`
`priorityGroup`	`smallint`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateStart`	`datetime`
`quotaHeader_id`	`FK`	FK
`team_id`	`FK`	FK
`project_id`	`FK`	FK

`scheduler_scheduler_mailing_recipient`

Doctrine entity: Scheduler\Entity\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`sensor_calibration_type`

Doctrine entity: Sensor\Entity\Calibration\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`link`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`color`	`string`

`sensor_file_type`

Doctrine entity: Sensor\Entity\File\Type

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`usage`	`array`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`sensor_manufacturer`

Doctrine entity: Sensor\Entity\Manufacturer

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`abbreviation`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`sensor_property`

Doctrine entity: Sensor\Entity\Property

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`label`	`text`
`showInList`	`boolean`
`values`	`text`
`defaultValue`	`text`
`unit`	`string`
`sort`	`smallint`
`friendlyText`	`text`

`sensor_request`

Doctrine entity: Sensor\Entity\Sensor\Request

Column	Doctrine type	Key
`id`	`integer`
`number`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`comments`	`text`
`project_id`	`FK`	FK
`responsible_id`	`FK`	FK
`requester_id`	`FK`	FK

`sensor_request_bonding`

Doctrine entity: Sensor\Entity\Sensor\Request\Bonding

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateSensorReturn`	`datetime`
`comments`	`text`
`sensorRequest_id`	`FK`	FK

`sensor_request_calibration`

Doctrine entity: Sensor\Entity\Sensor\Request\Calibration

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`requireCalibration`	`boolean`
`dateCalibrated`	`datetime`
`comments`	`text`
`sensorRequest_id`	`FK`	FK

`sensor_request_calibration_file`

Doctrine entity: Sensor\Entity\Sensor\Request\Calibration\File

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`docRef`	`string`
`mimeType`	`string`
`fileSize`	`integer`
`dateCreated`	`datetime`
`hash`	`string`
`type_id`	`FK`	FK
`calibration_id`	`FK`	FK

`sensor_request_calibration_file_object`

Doctrine entity: Sensor\Entity\Sensor\Request\Calibration\FileObject

Column	Doctrine type	Key
`id`	`integer`
`object`	`blob`
`file_id`	`FK`	FK

`sensor_request_changelog`

Doctrine entity: Sensor\Entity\Sensor\Request\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`changelog`	`text`
`oldValues`	`json`
`newValues`	`json`
`request_id`	`FK`	FK
`user_id`	`FK`	FK

`sensor_request_fabrication_finish`

Doctrine entity: Sensor\Entity\Sensor\Request\FabricationFinish

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateFabricationFinish`	`datetime`
`comments`	`text`
`sensorRequest_id`	`FK`	FK

`sensor_request_file_type`

Doctrine entity: Sensor\Entity\Sensor\Request\FileType

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`isRequired`	`boolean`
`phase`	`smallint`
`fileType_id`	`FK`	FK

`sensor_request_information`

Doctrine entity: Sensor\Entity\Sensor\Request\Information

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`amountOfSensors`	`integer`
`amountOfBonds`	`integer`
`applicationSensor`	`string`
`pcb`	`string`
`connectors`	`string`
`epoxy`	`string`
`fabricationRequirements`	`text`
`wirebondSchema`	`string`
`comments`	`text`
`sensorRequest_id`	`FK`	FK
`site_id`	`FK`	FK

`sensor_request_information_file`

Doctrine entity: Sensor\Entity\Sensor\Request\Information\File

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`docRef`	`string`
`mimeType`	`string`
`fileSize`	`integer`
`dateCreated`	`datetime`
`hash`	`string`
`type_id`	`FK`	FK
`information_id`	`FK`	FK

`sensor_request_information_file_object`

Doctrine entity: Sensor\Entity\Sensor\Request\Information\FileObject

Column	Doctrine type	Key
`id`	`integer`
`object`	`blob`
`file_id`	`FK`	FK

`sensor_request_sending_preparation`

Doctrine entity: Sensor\Entity\Sensor\Request\SendingPreparation

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateSensorPickup`	`datetime`
`comments`	`text`
`sensorRequest_id`	`FK`	FK

`sensor_sensor`

Doctrine entity: Sensor\Entity\Sensor

Column	Doctrine type	Key
`id`	`integer`
`localIdentifier`	`string`
`label`	`string`
`number`	`smallint`
`applicationSensor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`owner_id`	`FK`	FK
`requester_id`	`FK`	FK
`request_id`	`FK`	FK
`project_id`	`FK`	FK
`site_id`	`FK`	FK
`manufacturer_id`	`FK`	FK

`sensor_sensor_calibration`

Doctrine entity: Sensor\Entity\Sensor\Calibration

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateCalibrated`	`datetime`
`dateValid`	`datetime`
`user_id`	`FK`	FK
`sensor_id`	`FK`	FK
`type_id`	`FK`	FK

`sensor_sensor_calibration_property`

Doctrine entity: Sensor\Entity\Sensor\Calibration\Property

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`valueArray`	`array`
`valueInteger`	`integer`
`valueFloat`	`float`
`valueDate`	`date`
`property_id`	`FK`	FK
`calibration_id`	`FK`	FK

`sensor_sensor_changelog`

Doctrine entity: Sensor\Entity\Sensor\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`message`	`text`
`type`	`smallint`
`sensor_id`	`FK`	FK
`user_id`	`FK`	FK

`sensor_sensor_file`

Doctrine entity: Sensor\Entity\Sensor\File

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`docRef`	`string`
`mimeType`	`string`
`fileSize`	`integer`
`dateCreated`	`datetime`
`hash`	`string`
`type_id`	`FK`	FK
`sensor_id`	`FK`	FK

`sensor_sensor_file_object`

Doctrine entity: Sensor\Entity\Sensor\FileObject

Column	Doctrine type	Key
`id`	`integer`
`object`	`blob`
`file_id`	`FK`	FK

`sensor_sensor_link`

Doctrine entity: Sensor\Entity\Sensor\Link

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`url`	`string`
`sensor_id`	`FK`	FK
`type_id`	`FK`	FK

`sensor_sensor_link_type`

Doctrine entity: Sensor\Entity\Sensor\Link\Type

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`

`sensor_sensor_property`

Doctrine entity: Sensor\Entity\Sensor\Property

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`valueArray`	`array`
`valueInteger`	`integer`
`valueDate`	`date`
`valueFloat`	`float`
`property_id`	`FK`	FK
`sensor_id`	`FK`	FK

`sensor_sensor_status`

Doctrine entity: Sensor\Entity\Sensor\Status

Column	Doctrine type	Key
`id`	`integer`
`active`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`description`	`text`
`sensor_id`	`FK`	FK
`status_id`	`FK`	FK
`user_id`	`FK`	FK

`sensor_status`

Doctrine entity: Sensor\Entity\Status

Column	Doctrine type	Key
`id`	`integer`
`status`	`string`
`frontColor`	`string`
`backColor`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`sensor_type`

Doctrine entity: Sensor\Entity\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`color`	`string`

`service_event_place`

Doctrine entity: Service\Entity\Service\Event\Place

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`
`isExternal`	`boolean`

`service_property`

Doctrine entity: Service\Entity\Property

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`showInList`	`boolean`
`label`	`text`
`values`	`text`
`defaultValue`	`text`
`sort`	`smallint`
`friendlyText`	`text`

`service_report_criterion`

Doctrine entity: Service\Entity\Report\Criterion

Column	Doctrine type	Key
`id`	`integer`
`criterion`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`helpBlock`	`text`
`inputType`	`string`
`values`	`text`
`backgroundColor`	`string`
`hasBackgroundColor`	`boolean`
`archived`	`boolean`

`service_report_criterion_category`

Doctrine entity: Service\Entity\Report\Criterion\Category

Column	Doctrine type	Key
`id`	`integer`
`sequence`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`category`	`string`

`service_report_criterion_type`

Doctrine entity: Service\Entity\Report\Criterion\Type

Column	Doctrine type	Key
`id`	`integer`
`sequence`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`category_id`	`FK`	FK

`service_report_criterion_version`

Doctrine entity: Service\Entity\Report\Criterion\Version

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sequence`	`integer`
`visualiseInServiceHistory`	`boolean`
`target`	`float`
`min`	`float`
`max`	`float`
`required`	`boolean`
`highlighted`	`boolean`
`defaultValue`	`string`
`criterion_id`	`FK`	FK
`reportVersion_id`	`FK`	FK
`type_id`	`FK`	FK

`service_report_type`

Doctrine entity: Service\Entity\Report\Type

Column	Doctrine type	Key
`id`	`integer`
`sequence`	`integer`
`type`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`

`service_report_version`

Doctrine entity: Service\Entity\Report\Version

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`description`	`text`
`archived`	`boolean`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`reportType_id`	`FK`	FK
`equipmentService_id`	`FK`	FK

`service_service`

Doctrine entity: Service\Entity\Service

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`serviceValidMonths`	`integer`
`minutesNeededForService`	`integer`
`preHoursNeededForService`	`integer`
`postHoursNeededForService`	`integer`
`serviceType_id`	`FK`	FK
`equipment_id`	`FK`	FK
`team_id`	`FK`	FK
`externalCompany_id`	`FK`	FK
`place_id`	`FK`	FK

`service_service_checklist`

Doctrine entity: Service\Entity\Service\Checklist

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`task`	`string`
`description`	`text`
`equipmentModuleChangelogType`	`integer`
`sequence`	`integer`
`service_id`	`FK`	FK

`service_service_event`

Doctrine entity: Service\Entity\Service\Event

Column	Doctrine type	Key
`id`	`integer`
`guid`	`guid`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`datePlanned`	`datetime`
`dateExecuted`	`datetime`
`dateFinished`	`datetime`
`performedBy`	`string`
`purchaseOrderNumber`	`string`
`service_id`	`FK`	FK
`externalCompany_id`	`FK`	FK
`place_id`	`FK`	FK

`service_service_event_checklist`

Doctrine entity: Service\Entity\Service\Event\Checklist

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateExecuted`	`datetime`
`task`	`string`
`description`	`text`
`sequence`	`integer`
`equipmentModuleChangelogType`	`integer`
`event_id`	`FK`	FK
`user_id`	`FK`	FK

`service_service_event_document`

Doctrine entity: Service\Entity\Service\Event\Document

Column	Doctrine type	Key
`id`	`integer`
`description`	`text`
`date_added`	`datetime`
`filename`	`text`
`user_id`	`FK`	FK
`event_id`	`FK`	FK

`service_service_event_document_file`

Doctrine entity: Service\Entity\Service\Event\Document\File

Column	Doctrine type	Key
`id`	`integer`
`file`	`blob`
`document_id`	`FK`	FK

`service_service_event_property`

Doctrine entity: Service\Entity\Service\Event\Property

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`value`	`text`
`valueArray`	`json`
`valueInteger`	`integer`
`valueDate`	`date`
`valueFloat`	`float`
`property_id`	`FK`	FK
`event_id`	`FK`	FK

`service_service_event_report`

Doctrine entity: Service\Entity\Service\Event\Report

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`reportStatus`	`string`
`version_id`	`FK`	FK
`user_id`	`FK`	FK
`event_id`	`FK`	FK

`service_service_event_report_result`

Doctrine entity: Service\Entity\Service\Event\Report\Result

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`dateChanged`	`datetime`
`value`	`text`
`valueArray`	`json`
`valueInteger`	`integer`
`valueDate`	`date`
`valueFloat`	`float`
`valueBool`	`boolean`
`comment`	`text`
`eventReport_id`	`FK`	FK
`criterionVersion_id`	`FK`	FK

`service_service_mailing_recipient`

Doctrine entity: Service\Entity\Service\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`service_service_property`

Doctrine entity: Service\Entity\Service\Property

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`value`	`text`
`valueArray`	`json`
`valueInteger`	`integer`
`valueDate`	`date`
`valueFloat`	`float`
`property_id`	`FK`	FK
`service_id`	`FK`	FK

`service_service_type`

Doctrine entity: Service\Entity\Service\ServiceType

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`name`	`string`

`substrate_io`

Doctrine entity: Substrate\Entity\Io

Column	Doctrine type	Key
`id`	`integer`
`amount`	`integer`
`dateCreated`	`datetime`
`reason`	`text`
`label`	`string`
`substrate_id`	`FK`	FK
`user_id`	`FK`	FK
`run_substrate_id`	`FK`	FK

`substrate_property`

Doctrine entity: Substrate\Entity\Property

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`label`	`text`
`showInList`	`boolean`
`isBoxSize`	`boolean`
`values`	`text`
`defaultValue`	`text`
`unit`	`string`
`sort`	`smallint`
`friendlyText`	`text`

`substrate_substrate`

Doctrine entity: Substrate\Entity\Substrate

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`information`	`text`
`status`	`smallint`
`approvalRequired`	`boolean`
`labelledStock`	`smallint`
`stockManaged`	`smallint`
`stockWarningLimit`	`smallint`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`user_id`	`FK`	FK
`location_id`	`FK`	FK
`project_id`	`FK`	FK
`type_id`	`FK`	FK

`substrate_substrate_property`

Doctrine entity: Substrate\Entity\Substrate\Property

Column	Doctrine type	Key
`id`	`integer`
`value`	`text`
`valueArray`	`array`
`valueInteger`	`integer`
`valueDate`	`date`
`valueFloat`	`float`
`property_id`	`FK`	FK
`substrate_id`	`FK`	FK

`substrate_type`

Doctrine entity: Substrate\Entity\Type

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`color`	`string`
`substrateNumberPrefix`	`string`

`template_changelog`

Doctrine entity: Template\Entity\Changelog

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`message`	`text`
`template_id`	`FK`	FK
`user_id`	`FK`	FK

`template_measurement`

Doctrine entity: Template\Entity\Measurement

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sequence`	`integer`
`title`	`string`
`definition`	`string`
`method`	`text`
`step_id`	`FK`	FK

`template_measurement_label`

Doctrine entity: Template\Entity\Measurement\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`measurement_id`	`FK`	FK

`template_measurement_logging_parameter`

Doctrine entity: Template\Entity\Measurement\LoggingParameter

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`measurement_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK

`template_part`

Doctrine entity: Template\Entity\Part

Column	Doctrine type	Key
`id`	`integer`
`partId`	`smallint`
`shortLabel`	`string`
`label`	`string`
`left`	`integer`
`level`	`integer`
`right`	`integer`
`template_id`	`FK`	FK
`root_id`	`FK`	FK
`parent_id`	`FK`	FK

`template_release`

Doctrine entity: Template\Entity\Release

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`version`	`integer`
`notes`	`string`
`template_id`	`FK`	FK
`user_id`	`FK`	FK

`template_requirement`

Doctrine entity: Template\Entity\Requirement

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`sequence`	`integer`
`title`	`string`
`definition`	`string`
`method`	`text`
`step_id`	`FK`	FK
`requirement_step_id`	`FK`	FK
`measurement_id`	`FK`	FK

`template_requirement_label`

Doctrine entity: Template\Entity\Requirement\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`requirement_id`	`FK`	FK

`template_requirement_target`

Doctrine entity: Template\Entity\Requirement\Target

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`minValue`	`float`
`maxValue`	`float`
`target`	`float`
`inclusive`	`smallint`
`unit`	`string`
`requirement_id`	`FK`	FK
`loggingParameter_id`	`FK`	FK

`template_role`

Doctrine entity: Template\Entity\Role

Column	Doctrine type	Key
`id`	`integer`
`title`	`text`
`description`	`text`
`order`	`integer`
`status`	`smallint`

`template_step`

Doctrine entity: Template\Entity\Step

Column	Doctrine type	Key
`id`	`integer`
`number`	`integer`
`sequence`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`time`	`time`
`processName`	`string`
`private`	`boolean`
`version`	`integer`
`partLevel`	`integer`
`split`	`integer`
`subSteps`	`integer`
`standard`	`smallint`
`remark`	`text`
`instructions`	`text`
`template_id`	`FK`	FK
`user_id`	`FK`	FK
`processmodule_id`	`FK`	FK
`stepgroup_id`	`FK`	FK
`process_module_recipe_version_id`	`FK`	FK

`template_step_group`

Doctrine entity: Template\Entity\Step\Group

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`label`	`string`
`locked`	`smallint`

`template_step_label`

Doctrine entity: Template\Entity\Step\Label

Column	Doctrine type	Key
`id`	`integer`
`label`	`string`
`open`	`smallint`
`step_id`	`FK`	FK

`template_step_parameter`

Doctrine entity: Template\Entity\Step\Parameter

Column	Doctrine type	Key
`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`	FK
`parameter_id`	`FK`	FK
`unit_id`	`FK`	FK

`template_step_parameter_value`

Doctrine entity: Template\Entity\Step\Parameter\Value

Column	Doctrine type	Key
`id`	`integer`
`value`	`string`
`sequence`	`integer`
`step_parameter_id`	`FK`	FK
`consumable_id`	`FK`	FK

`template_template`

Doctrine entity: Template\Entity\Template

Column	Doctrine type	Key
`id`	`integer`
`name`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`status`	`smallint`
`standard`	`smallint`
`numberOfParts`	`smallint`
`project_id`	`FK`	FK
`team_id`	`FK`	FK
`sampleType_id`	`FK`	FK
`trayType_id`	`FK`	FK
`user_id`	`FK`	FK

`template_template_role`

Doctrine entity: Template\Entity\Template\Role

Column	Doctrine type	Key
`id`	`integer`
`dateCreated`	`datetime`
`comment`	`text`
`status`	`smallint`
`template_id`	`FK`	FK
`user_id`	`FK`	FK
`role_id`	`FK`	FK

`template_template_variable`

Doctrine entity: Template\Entity\Template\Variable

Column	Doctrine type	Key
`id`	`integer`
`title`	`string`
`description`	`text`
`dateCreated`	`datetime`
`lastUpdate`	`datetime`
`stepParameterValue_id`	`FK`	FK

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`admin_action`	`transactional`	Many-to-one	`0..*`	`0..1`	`mailing_transactional`	`[admin_action]0..*-transactional 0..1>[mailing_transactional]`
`admin_authentication`	`oAuth2Service`	Many-to-one	`0..*`	`0..1`	`admin_oauth2_service`	`[admin_authentication]0..*-oAuth2Service 0..1>[admin_oauth2_service]`
`admin_environment`	`facilities`	Many-to-many	`0..*`	`0..*`	`location_facility`	`[admin_environment]0..-facilities 0..>[location_facility]`
`admin_environment`	`modules`	Many-to-many	`0..*`	`0..*`	`admin_module`	`[admin_environment]0..-modules 0..>[admin_module]`
`admin_environment`	`sites`	Many-to-many	`0..*`	`0..*`	`room_site`	`[admin_environment]0..-sites 0..>[room_site]`
`admin_goldstein_equipment_association`	`equipment`	Many-to-one	`0..*`	`0..1`	`equipment_equipment`	`[admin_goldstein_equipment_association]0..*-equipment 0..1>[equipment_equipment]`
`admin_goldstein_equipment_association`	`goldsteinClient`	Many-to-one	`0..*`	`1`	`admin_goldstein_client`	`[admin_goldstein_equipment_association]0..*-goldsteinClient 1>[admin_goldstein_client]`
`admin_oauth2_service`	`scope`	Many-to-one	`0..*`	`1`	`oauth_scopes`	`[admin_oauth2_service]0..*-scope 1>[oauth_scopes]`
`admin_permit_role`	`accessRole`	Many-to-many	`0..*`	`0..*`	`admin_role`	`[admin_permit_role]0..-accessRole 0..>[admin_role]`
`admin_permit_role`	`entity`	Many-to-one	`0..*`	`1`	`admin_permit_entity`	`[admin_permit_role]0..*-entity 1>[admin_permit_entity]`
`admin_permit_setter`	`entity`	Many-to-one	`0..*`	`1`	`admin_permit_entity`	`[admin_permit_setter]0..*-entity 1>[admin_permit_entity]`
`admin_permit_setter`	`role`	Many-to-many	`0..*`	`0..*`	`admin_permit_role`	`[admin_permit_setter]0..-role 0..>[admin_permit_role]`
`admin_permit_user`	`accessRole`	Many-to-one	`0..*`	`0..1`	`admin_role`	`[admin_permit_user]0..*-accessRole 0..1>[admin_role]`
`admin_permit_user`	`role`	Many-to-one	`0..*`	`1`	`admin_permit_role`	`[admin_permit_user]0..*-role 1>[admin_permit_role]`
`admin_permit_user`	`setter`	Many-to-one	`0..*`	`0..1`	`admin_permit_setter`	`[admin_permit_user]0..*-setter 0..1>[admin_permit_setter]`
`admin_permit_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[admin_permit_user]0..*-user 1>[admin_user]`
`admin_role`	`parent`	Many-to-one	`0..*`	`0..1`	`admin_role`	`[admin_role]0..*-parent 0..1>[admin_role]`
`admin_role`	`selection`	Many-to-many	`0..*`	`0..*`	`admin_selection`	`[admin_role]0..-selection 0..>[admin_selection]`
`admin_selection`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[admin_selection]0..*-user 1>[admin_user]`
`admin_selection_sql`	`selection`	One-to-one	`0..1`	`1`	`admin_selection`	`[admin_selection_sql]0..1-selection 1>[admin_selection]`
`admin_selection_user`	`selection`	Many-to-one	`0..*`	`1`	`admin_selection`	`[admin_selection_user]0..*-selection 1>[admin_selection]`
`admin_selection_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[admin_selection_user]0..*-user 1>[admin_user]`
`admin_session`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[admin_session]0..*-user 1>[admin_user]`
`admin_support`	`roles`	Many-to-many	`0..*`	`0..*`	`admin_role`	`[admin_support]0..-roles 0..>[admin_role]`
`admin_user`	`authentication`	Many-to-one	`0..*`	`1`	`admin_authentication`	`[admin_user]0..*-authentication 1>[admin_authentication]`
`admin_user`	`roles`	Many-to-many	`0..*`	`0..*`	`admin_role`	`[admin_user]0..-roles 0..>[admin_role]`
`admin_user_action`	`action`	Many-to-one	`0..*`	`1`	`admin_action`	`[admin_user_action]0..*-action 1>[admin_action]`
`admin_user_action`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[admin_user_action]0..*-user 0..1>[admin_user]`
`admin_user_action`	`deeplink`	One-to-one	`0..1`	`0..1`	`deeplink`	`[admin_user_action]0..1-deeplink 0..1>[deeplink]`
`admin_user_badge_card`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[admin_user_badge_card]0..*-user 0..1>[admin_user]`
`admin_user_preferences`	`environment`	Many-to-one	`0..*`	`0..1`	`admin_environment`	`[admin_user_preferences]0..*-environment 0..1>[admin_environment]`
`admin_user_preferences`	`modules`	Many-to-many	`0..*`	`0..*`	`admin_module`	`[admin_user_preferences]0..-modules 0..>[admin_module]`
`admin_user_preferences`	`user`	One-to-one	`0..1`	`0..1`	`admin_user`	`[admin_user_preferences]0..1-user 0..1>[admin_user]`
`admin_user_preferences_filter`	`preference`	Many-to-one	`0..*`	`1`	`admin_user_preferences`	`[admin_user_preferences_filter]0..*-preference 1>[admin_user_preferences]`
`admin_user_profile`	`user`	One-to-one	`0..1`	`0..1`	`admin_user`	`[admin_user_profile]0..1-user 0..1>[admin_user]`
`chemical_chemical`	`cmr`	Many-to-many	`0..*`	`0..*`	`chemical_cmr`	`[chemical_chemical]0..-cmr 0..>[chemical_cmr]`
`chemical_chemical`	`mainChemical`	Many-to-one	`0..*`	`0..1`	`chemical_main_chemical`	`[chemical_chemical]0..*-mainChemical 0..1>[chemical_main_chemical]`
`chemical_chemical`	`safetyIcons`	Many-to-many	`0..*`	`0..*`	`chemical_safety_icon`	`[chemical_chemical]0..-safetyIcons 0..>[chemical_safety_icon]`
`chemical_chemical`	`safetyStatements`	Many-to-many	`0..*`	`0..*`	`chemical_safety_statement`	`[chemical_chemical]0..-safetyStatements 0..>[chemical_safety_statement]`
`chemical_chemical_role`	`chemical`	Many-to-one	`0..*`	`1`	`chemical_chemical`	`[chemical_chemical_role]0..*-chemical 1>[chemical_chemical]`
`chemical_chemical_role`	`role`	Many-to-one	`0..*`	`1`	`chemical_role`	`[chemical_chemical_role]0..*-role 1>[chemical_role]`
`chemical_chemical_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[chemical_chemical_role]0..*-user 1>[admin_user]`
`chemical_container`	`chemical`	Many-to-one	`0..*`	`1`	`chemical_chemical`	`[chemical_container]0..*-chemical 1>[chemical_chemical]`
`chemical_container`	`location`	Many-to-one	`0..*`	`1`	`room_location`	`[chemical_container]0..*-location 1>[room_location]`
`chemical_container`	`methodOfUse`	Many-to-one	`0..*`	`0..1`	`chemical_container_method_of_use`	`[chemical_container]0..*-methodOfUse 0..1>[chemical_container_method_of_use]`
`chemical_container`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[chemical_container]0..*-project 0..1>[organisation_project]`
`chemical_container`	`purpose`	Many-to-one	`0..*`	`0..1`	`chemical_container_purpose`	`[chemical_container]0..*-purpose 0..1>[chemical_container_purpose]`
`chemical_container`	`type`	Many-to-one	`0..*`	`0..1`	`chemical_container_type`	`[chemical_container]0..*-type 0..1>[chemical_container_type]`
`chemical_container`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[chemical_container]0..*-user 1>[admin_user]`
`chemical_container_changelog`	`container`	Many-to-one	`0..*`	`1`	`chemical_container`	`[chemical_container_changelog]0..*-container 1>[chemical_container]`
`chemical_container_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[chemical_container_changelog]0..*-user 1>[admin_user]`
`chemical_container_external_label`	`container`	One-to-one	`0..1`	`0..1`	`chemical_container`	`[chemical_container_external_label]0..1-container 0..1>[chemical_container]`
`chemical_container_scanned`	`container`	Many-to-one	`0..*`	`1`	`chemical_container`	`[chemical_container_scanned]0..*-container 1>[chemical_container]`
`chemical_container_scanned`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[chemical_container_scanned]0..*-user 1>[admin_user]`
`chemical_container_type`	`label`	Many-to-one	`0..*`	`1`	`chemical_label`	`[chemical_container_type]0..*-label 1>[chemical_label]`
`chemical_container_user`	`container`	Many-to-one	`0..*`	`1`	`chemical_container`	`[chemical_container_user]0..*-container 1>[chemical_container]`
`chemical_container_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[chemical_container_user]0..*-user 1>[admin_user]`
`chemical_label_attachment`	`label`	Many-to-one	`0..*`	`1`	`chemical_label`	`[chemical_label_attachment]0..*-label 1>[chemical_label]`
`chemical_label_attachment_object`	`attachment`	Many-to-one	`0..*`	`1`	`chemical_label_attachment`	`[chemical_label_attachment_object]0..*-attachment 1>[chemical_label_attachment]`
`chemical_safety_statement`	`cmr`	Many-to-many	`0..*`	`0..*`	`chemical_cmr`	`[chemical_safety_statement]0..-cmr 0..>[chemical_cmr]`
`consumable_consumable`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[consumable_consumable]0..-file 0..>[file_file]`
`consumable_consumable`	`location`	Many-to-one	`0..*`	`1`	`room_location`	`[consumable_consumable]0..*-location 1>[room_location]`
`consumable_consumable`	`type`	Many-to-one	`0..*`	`1`	`consumable_type`	`[consumable_consumable]0..*-type 1>[consumable_type]`
`consumable_consumable`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[consumable_consumable]0..*-user 1>[admin_user]`
`consumable_consumable_io`	`consumable`	Many-to-one	`0..*`	`1`	`consumable_consumable`	`[consumable_consumable_io]0..*-consumable 1>[consumable_consumable]`
`consumable_consumable_io`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[consumable_consumable_io]0..*-user 1>[admin_user]`
`consumable_consumable_io_property`	`io`	Many-to-one	`0..*`	`1`	`consumable_consumable_io`	`[consumable_consumable_io_property]0..*-io 1>[consumable_consumable_io]`
`consumable_consumable_io_property`	`property`	Many-to-one	`0..*`	`1`	`consumable_property`	`[consumable_consumable_io_property]0..*-property 1>[consumable_property]`
`consumable_consumable_property`	`consumable`	Many-to-one	`0..*`	`1`	`consumable_consumable`	`[consumable_consumable_property]0..*-consumable 1>[consumable_consumable]`
`consumable_consumable_property`	`property`	Many-to-one	`0..*`	`1`	`consumable_property`	`[consumable_consumable_property]0..*-property 1>[consumable_property]`
`consumable_type`	`properties`	Many-to-many	`0..*`	`0..*`	`consumable_property`	`[consumable_type]0..-properties 0..>[consumable_property]`
`deeplink`	`target`	Many-to-one	`0..*`	`1`	`deeplink_target`	`[deeplink]0..*-target 1>[deeplink_target]`
`deeplink`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[deeplink]0..*-user 1>[admin_user]`
`equipment_category_type`	`category`	Many-to-one	`0..*`	`1`	`equipment_category`	`[equipment_category_type]0..*-category 1>[equipment_category]`
`equipment_category_type`	`properties`	Many-to-many	`0..*`	`0..*`	`equipment_property`	`[equipment_category_type]0..-properties 0..>[equipment_property]`
`equipment_document`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_document]0..*-equipment 1>[equipment_equipment]`
`equipment_document`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_document]0..*-user 1>[admin_user]`
`equipment_equipment`	`area`	Many-to-one	`0..*`	`0..1`	`location_area`	`[equipment_equipment]0..*-area 0..1>[location_area]`
`equipment_equipment`	`creator`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_equipment]0..*-creator 1>[admin_user]`
`equipment_equipment`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[equipment_equipment]0..-file 0..>[file_file]`
`equipment_equipment`	`group`	Many-to-one	`0..*`	`0..1`	`equipment_group`	`[equipment_equipment]0..*-group 0..1>[equipment_group]`
`equipment_equipment`	`label`	Many-to-one	`0..*`	`0..1`	`chemical_label`	`[equipment_equipment]0..*-label 0..1>[chemical_label]`
`equipment_equipment`	`location`	Many-to-one	`0..*`	`0..1`	`room_location`	`[equipment_equipment]0..*-location 0..1>[room_location]`
`equipment_equipment`	`manufacturer`	Many-to-one	`0..*`	`0..1`	`organisation_manufacturer`	`[equipment_equipment]0..*-manufacturer 0..1>[organisation_manufacturer]`
`equipment_equipment`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[equipment_equipment]0..*-project 0..1>[organisation_project]`
`equipment_equipment`	`room`	Many-to-one	`0..*`	`0..1`	`room_room`	`[equipment_equipment]0..*-room 0..1>[room_room]`
`equipment_equipment`	`types`	Many-to-many	`0..*`	`0..*`	`equipment_category_type`	`[equipment_equipment]0..-types 0..>[equipment_category_type]`
`equipment_equipment`	`zone`	Many-to-one	`0..*`	`0..1`	`room_zone`	`[equipment_equipment]0..*-zone 0..1>[room_zone]`
`equipment_equipment`	`zoneGroup`	Many-to-one	`0..*`	`0..1`	`room_zone_group`	`[equipment_equipment]0..*-zoneGroup 0..1>[room_zone_group]`
`equipment_equipment`	`mainModule`	One-to-one	`0..1`	`1`	`equipment_module`	`[equipment_equipment]0..1-mainModule 1>[equipment_module]`
`equipment_equipment`	`storageLocation`	One-to-one	`0..1`	`0..1`	`room_location`	`[equipment_equipment]0..1-storageLocation 0..1>[room_location]`
`equipment_equipment_document_file`	`document`	Many-to-one	`0..*`	`1`	`equipment_document`	`[equipment_equipment_document_file]0..*-document 1>[equipment_document]`
`equipment_equipment_link`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_equipment_link]0..*-equipment 1>[equipment_equipment]`
`equipment_equipment_link`	`type`	Many-to-one	`0..*`	`1`	`equipment_equipment_link_type`	`[equipment_equipment_link]0..*-type 1>[equipment_equipment_link_type]`
`equipment_equipment_preventive_maintenance_maintenance`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_equipment_preventive_maintenance_maintenance]0..*-equipment 1>[equipment_equipment]`
`equipment_equipment_preventive_maintenance_maintenance`	`schedule`	Many-to-one	`0..*`	`0..1`	`equipment_equipment_preventive_maintenance_schedule`	`[equipment_equipment_preventive_maintenance_maintenance]0..*-schedule 0..1>[equipment_equipment_preventive_maintenance_schedule]`
`equipment_equipment_preventive_maintenance_maintenance`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_equipment_preventive_maintenance_maintenance]0..*-user 1>[admin_user]`
`equipment_equipment_preventive_maintenance_maintenance`	`reservation`	One-to-one	`0..1`	`0..1`	`equipment_reservation`	`[equipment_equipment_preventive_maintenance_maintenance]0..1-reservation 0..1>[equipment_reservation]`
`equipment_equipment_preventive_maintenance_maintenance_file`	`file`	Many-to-one	`0..*`	`1`	`file_file`	`[equipment_equipment_preventive_maintenance_maintenance_file]0..*-file 1>[file_file]`
`equipment_equipment_preventive_maintenance_maintenance_file`	`maintenance`	Many-to-one	`0..*`	`1`	`equipment_equipment_preventive_maintenance_maintenance`	`[equipment_equipment_preventive_maintenance_maintenance_file]0..*-maintenance 1>[equipment_equipment_preventive_maintenance_maintenance]`
`equipment_equipment_preventive_maintenance_schedule`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_equipment_preventive_maintenance_schedule]0..*-equipment 1>[equipment_equipment]`
`equipment_equipment_preventive_maintenance_schedule_file`	`file`	Many-to-one	`0..*`	`1`	`file_file`	`[equipment_equipment_preventive_maintenance_schedule_file]0..*-file 1>[file_file]`
`equipment_equipment_preventive_maintenance_schedule_file`	`schedule`	Many-to-one	`0..*`	`1`	`equipment_equipment_preventive_maintenance_schedule`	`[equipment_equipment_preventive_maintenance_schedule_file]0..*-schedule 1>[equipment_equipment_preventive_maintenance_schedule]`
`equipment_equipment_property`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_equipment_property]0..*-equipment 1>[equipment_equipment]`
`equipment_equipment_property`	`property`	Many-to-one	`0..*`	`1`	`equipment_property`	`[equipment_equipment_property]0..*-property 1>[equipment_property]`
`equipment_equipment_request`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_equipment_request]0..*-equipment 1>[equipment_equipment]`
`equipment_equipment_request`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_equipment_request]0..*-user 1>[admin_user]`
`equipment_equipment_request_flow`	`request`	Many-to-one	`0..*`	`1`	`equipment_equipment_request`	`[equipment_equipment_request_flow]0..*-request 1>[equipment_equipment_request]`
`equipment_equipment_request_flow`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_equipment_request_flow]0..*-user 1>[admin_user]`
`equipment_equipment_role`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_equipment_role]0..*-equipment 1>[equipment_equipment]`
`equipment_equipment_role`	`role`	Many-to-one	`0..*`	`1`	`equipment_role`	`[equipment_equipment_role]0..*-role 1>[equipment_role]`
`equipment_equipment_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_equipment_role]0..*-user 1>[admin_user]`
`equipment_equipment_user`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_equipment_user]0..*-equipment 1>[equipment_equipment]`
`equipment_equipment_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_equipment_user]0..*-user 1>[admin_user]`
`equipment_logging`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_logging]0..*-equipment 1>[equipment_equipment]`
`equipment_logging`	`service`	Many-to-one	`0..*`	`0..1`	`equipment_logging_service`	`[equipment_logging]0..*-service 0..1>[equipment_logging_service]`
`equipment_logging_column`	`logging`	Many-to-one	`0..*`	`1`	`equipment_logging`	`[equipment_logging_column]0..*-logging 1>[equipment_logging]`
`equipment_logging_column`	`parameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[equipment_logging_column]0..*-parameter 1>[equipment_logging_parameter]`
`equipment_logging_direct_value`	`logging`	Many-to-one	`0..*`	`1`	`equipment_logging`	`[equipment_logging_direct_value]0..*-logging 1>[equipment_logging]`
`equipment_logging_direct_value`	`parameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[equipment_logging_direct_value]0..*-parameter 1>[equipment_logging_parameter]`
`equipment_logging_identifier_value`	`logging`	Many-to-one	`0..*`	`1`	`equipment_logging`	`[equipment_logging_identifier_value]0..*-logging 1>[equipment_logging]`
`equipment_logging_parameter`	`parameter`	Many-to-one	`0..*`	`0..1`	`process_parameter`	`[equipment_logging_parameter]0..*-parameter 0..1>[process_parameter]`
`equipment_logging_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[equipment_logging_parameter]0..*-unit 0..1>[process_unit]`
`equipment_logging_parameter_equipment`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_logging_parameter_equipment]0..*-equipment 1>[equipment_equipment]`
`equipment_logging_parameter_equipment`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[equipment_logging_parameter_equipment]0..*-loggingParameter 1>[equipment_logging_parameter]`
`equipment_logging_service_method`	`service`	Many-to-one	`0..*`	`1`	`equipment_logging_service`	`[equipment_logging_service_method]0..*-service 1>[equipment_logging_service]`
`equipment_logging_service_method_parameter`	`method`	Many-to-one	`0..*`	`1`	`equipment_logging_service_method`	`[equipment_logging_service_method_parameter]0..*-method 1>[equipment_logging_service_method]`
`equipment_logging_service_processing_method`	`logging`	Many-to-one	`0..*`	`1`	`equipment_logging`	`[equipment_logging_service_processing_method]0..*-logging 1>[equipment_logging]`
`equipment_logging_service_processing_method`	`loggingServiceMethod`	Many-to-one	`0..*`	`1`	`equipment_logging_service_method`	`[equipment_logging_service_processing_method]0..*-loggingServiceMethod 1>[equipment_logging_service_method]`
`equipment_logging_service_processing_method_parameter`	`loggingServiceMethodOptions`	Many-to-one	`0..*`	`0..1`	`equipment_logging_service_method`	`[equipment_logging_service_processing_method_parameter]0..*-loggingServiceMethodOptions 0..1>[equipment_logging_service_method]`
`equipment_logging_service_processing_method_parameter`	`loggingServiceMethodParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_service_method_parameter`	`[equipment_logging_service_processing_method_parameter]0..*-loggingServiceMethodParameter 1>[equipment_logging_service_method_parameter]`
`equipment_logging_service_processing_method_parameter`	`serviceProcessingMethod`	Many-to-one	`0..*`	`1`	`equipment_logging_service_processing_method`	`[equipment_logging_service_processing_method_parameter]0..*-serviceProcessingMethod 1>[equipment_logging_service_processing_method]`
`equipment_logging_service_processing_method_result`	`parameters`	Many-to-many	`0..*`	`0..*`	`equipment_logging_parameter`	`[equipment_logging_service_processing_method_result]0..-parameters 0..>[equipment_logging_parameter]`
`equipment_logging_service_processing_method_result`	`serviceProcessingMethod`	Many-to-one	`0..*`	`1`	`equipment_logging_service_processing_method`	`[equipment_logging_service_processing_method_result]0..*-serviceProcessingMethod 1>[equipment_logging_service_processing_method]`
`equipment_module`	`equipment`	Many-to-one	`0..*`	`0..1`	`equipment_equipment`	`[equipment_module]0..*-equipment 0..1>[equipment_equipment]`
`equipment_module`	`function`	Many-to-one	`0..*`	`0..1`	`equipment_module_function`	`[equipment_module]0..*-function 0..1>[equipment_module_function]`
`equipment_module`	`groups`	Many-to-many	`0..*`	`0..*`	`equipment_module_group`	`[equipment_module]0..-groups 0..>[equipment_module_group]`
`equipment_module`	`label`	Many-to-one	`0..*`	`0..1`	`chemical_label`	`[equipment_module]0..*-label 0..1>[chemical_label]`
`equipment_module`	`type`	Many-to-one	`0..*`	`0..1`	`equipment_module_type`	`[equipment_module]0..*-type 0..1>[equipment_module_type]`
`equipment_module_asset`	`function`	Many-to-one	`0..*`	`1`	`equipment_module_asset_function`	`[equipment_module_asset]0..*-function 1>[equipment_module_asset_function]`
`equipment_module_asset`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_asset]0..*-module 1>[equipment_module]`
`equipment_module_changelog`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_changelog]0..*-module 1>[equipment_module]`
`equipment_module_changelog`	`runStep`	Many-to-one	`0..*`	`0..1`	`run_step`	`[equipment_module_changelog]0..*-runStep 0..1>[run_step]`
`equipment_module_changelog`	`runStepChecklist`	Many-to-one	`0..*`	`0..1`	`run_step_checklist`	`[equipment_module_changelog]0..*-runStepChecklist 0..1>[run_step_checklist]`
`equipment_module_changelog`	`serviceEventChecklist`	Many-to-one	`0..*`	`0..1`	`service_service_event_checklist`	`[equipment_module_changelog]0..*-serviceEventChecklist 0..1>[service_service_event_checklist]`
`equipment_module_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_module_changelog]0..*-user 1>[admin_user]`
`equipment_module_ecn`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_ecn]0..*-module 1>[equipment_module]`
`equipment_module_ecn`	`owner`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_module_ecn]0..*-owner 1>[admin_user]`
`equipment_module_ecn`	`updatedBy`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[equipment_module_ecn]0..*-updatedBy 0..1>[admin_user]`
`equipment_module_ecn_attachment`	`ecn`	Many-to-one	`0..*`	`1`	`equipment_module_ecn`	`[equipment_module_ecn_attachment]0..*-ecn 1>[equipment_module_ecn]`
`equipment_module_ecn_attachment_file`	`attachment`	Many-to-one	`0..*`	`1`	`equipment_module_ecn_attachment`	`[equipment_module_ecn_attachment_file]0..*-attachment 1>[equipment_module_ecn_attachment]`
`equipment_module_external_activity`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_external_activity]0..*-module 1>[equipment_module]`
`equipment_module_external_activity`	`type`	Many-to-one	`0..*`	`1`	`equipment_module_external_activity_type`	`[equipment_module_external_activity]0..*-type 1>[equipment_module_external_activity_type]`
`equipment_module_external_activity`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_module_external_activity]0..*-user 1>[admin_user]`
`equipment_module_facility`	`facility`	Many-to-one	`0..*`	`1`	`facility_facility`	`[equipment_module_facility]0..*-facility 1>[facility_facility]`
`equipment_module_facility`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_facility]0..*-module 1>[equipment_module]`
`equipment_module_function`	`equipmentProperties`	Many-to-many	`0..*`	`0..*`	`equipment_property`	`[equipment_module_function]0..-equipmentProperties 0..>[equipment_property]`
`equipment_module_issue`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_issue]0..*-module 1>[equipment_module]`
`equipment_module_issue`	`owner`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_module_issue]0..*-owner 1>[admin_user]`
`equipment_module_issue`	`updatedBy`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[equipment_module_issue]0..*-updatedBy 0..1>[admin_user]`
`equipment_module_issue_attachment`	`issue`	Many-to-one	`0..*`	`1`	`equipment_module_issue`	`[equipment_module_issue_attachment]0..*-issue 1>[equipment_module_issue]`
`equipment_module_issue_attachment_file`	`attachment`	Many-to-one	`0..*`	`1`	`equipment_module_issue_attachment`	`[equipment_module_issue_attachment_file]0..*-attachment 1>[equipment_module_issue_attachment]`
`equipment_module_parameter`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_parameter]0..*-module 1>[equipment_module]`
`equipment_module_parameter`	`parameter`	Many-to-one	`0..*`	`1`	`process_parameter`	`[equipment_module_parameter]0..*-parameter 1>[process_parameter]`
`equipment_module_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[equipment_module_parameter]0..*-unit 0..1>[process_unit]`
`equipment_module_parameter_value`	`moduleParameter`	Many-to-one	`0..*`	`1`	`equipment_module_parameter`	`[equipment_module_parameter_value]0..*-moduleParameter 1>[equipment_module_parameter]`
`equipment_module_property`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_property]0..*-module 1>[equipment_module]`
`equipment_module_property`	`property`	Many-to-one	`0..*`	`1`	`equipment_property`	`[equipment_module_property]0..*-property 1>[equipment_property]`
`equipment_module_status`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[equipment_module_status]0..*-module 1>[equipment_module]`
`equipment_module_status`	`status`	Many-to-one	`0..*`	`1`	`equipment_status`	`[equipment_module_status]0..*-status 1>[equipment_status]`
`equipment_module_status`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_module_status]0..*-user 1>[admin_user]`
`equipment_module_status_attachment`	`status`	Many-to-one	`0..*`	`1`	`equipment_module_status`	`[equipment_module_status_attachment]0..*-status 1>[equipment_module_status]`
`equipment_module_status_attachment_file`	`attachment`	Many-to-one	`0..*`	`1`	`equipment_module_status_attachment`	`[equipment_module_status_attachment_file]0..*-attachment 1>[equipment_module_status_attachment]`
`equipment_module_status_rule`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_module_status_rule]0..*-equipment 1>[equipment_equipment]`
`equipment_module_status_rule`	`modules`	Many-to-many	`0..*`	`0..*`	`equipment_module`	`[equipment_module_status_rule]0..-modules 0..>[equipment_module]`
`equipment_module_status_rule`	`status`	Many-to-one	`0..*`	`1`	`equipment_status`	`[equipment_module_status_rule]0..*-status 1>[equipment_status]`
`equipment_monitor`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[equipment_monitor]0..-file 0..>[file_file]`
`equipment_monitor`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[equipment_monitor]0..*-project 0..1>[organisation_project]`
`equipment_monitor`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_monitor]0..*-user 1>[admin_user]`
`equipment_monitor`	`users`	Many-to-many	`0..*`	`0..*`	`admin_user`	`[equipment_monitor]0..-users 0..>[admin_user]`
`equipment_monitor_changelog`	`monitor`	Many-to-one	`0..*`	`1`	`equipment_monitor`	`[equipment_monitor_changelog]0..*-monitor 1>[equipment_monitor]`
`equipment_monitor_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_monitor_changelog]0..*-user 1>[admin_user]`
`equipment_monitor_measurement`	`step`	One-to-one	`0..1`	`1`	`equipment_monitor_step`	`[equipment_monitor_measurement]0..1-step 1>[equipment_monitor_step]`
`equipment_monitor_measurement_label`	`measurement`	One-to-one	`0..1`	`1`	`equipment_monitor_measurement`	`[equipment_monitor_measurement_label]0..1-measurement 1>[equipment_monitor_measurement]`
`equipment_monitor_measurement_logging_parameter`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[equipment_monitor_measurement_logging_parameter]0..*-loggingParameter 1>[equipment_logging_parameter]`
`equipment_monitor_measurement_logging_parameter`	`measurement`	Many-to-one	`0..*`	`1`	`equipment_monitor_measurement`	`[equipment_monitor_measurement_logging_parameter]0..*-measurement 1>[equipment_monitor_measurement]`
`equipment_monitor_measurement_result`	`file`	Many-to-one	`0..*`	`0..1`	`file_file`	`[equipment_monitor_measurement_result]0..*-file 0..1>[file_file]`
`equipment_monitor_measurement_result`	`logging`	Many-to-one	`0..*`	`0..1`	`equipment_logging`	`[equipment_monitor_measurement_result]0..*-logging 0..1>[equipment_logging]`
`equipment_monitor_measurement_result`	`measurement`	Many-to-one	`0..*`	`1`	`equipment_monitor_measurement`	`[equipment_monitor_measurement_result]0..*-measurement 1>[equipment_monitor_measurement]`
`equipment_monitor_measurement_result_process_parameter_value`	`monitorStepParameter`	Many-to-one	`0..*`	`1`	`equipment_monitor_step_parameter`	`[equipment_monitor_measurement_result_process_parameter_value]0..*-monitorStepParameter 1>[equipment_monitor_step_parameter]`
`equipment_monitor_measurement_result_process_parameter_value`	`result`	Many-to-one	`0..*`	`1`	`equipment_monitor_measurement_result`	`[equipment_monitor_measurement_result_process_parameter_value]0..*-result 1>[equipment_monitor_measurement_result]`
`equipment_monitor_measurement_result_value`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[equipment_monitor_measurement_result_value]0..*-loggingParameter 1>[equipment_logging_parameter]`
`equipment_monitor_measurement_result_value`	`result`	Many-to-one	`0..*`	`1`	`equipment_monitor_measurement_result`	`[equipment_monitor_measurement_result_value]0..*-result 1>[equipment_monitor_measurement_result]`
`equipment_monitor_requirement`	`requirementStep`	Many-to-one	`0..*`	`0..1`	`equipment_monitor_step`	`[equipment_monitor_requirement]0..*-requirementStep 0..1>[equipment_monitor_step]`
`equipment_monitor_requirement`	`measurement`	One-to-one	`0..1`	`1`	`equipment_monitor_measurement`	`[equipment_monitor_requirement]0..1-measurement 1>[equipment_monitor_measurement]`
`equipment_monitor_requirement`	`step`	One-to-one	`0..1`	`1`	`equipment_monitor_step`	`[equipment_monitor_requirement]0..1-step 1>[equipment_monitor_step]`
`equipment_monitor_requirement_label`	`requirement`	One-to-one	`0..1`	`1`	`equipment_monitor_requirement`	`[equipment_monitor_requirement_label]0..1-requirement 1>[equipment_monitor_requirement]`
`equipment_monitor_requirement_module_status_change`	`fromStatuses`	Many-to-many	`0..*`	`0..*`	`equipment_status`	`[equipment_monitor_requirement_module_status_change]0..-fromStatuses 0..>[equipment_status]`
`equipment_monitor_requirement_module_status_change`	`requirement`	Many-to-one	`0..*`	`1`	`equipment_monitor_requirement`	`[equipment_monitor_requirement_module_status_change]0..*-requirement 1>[equipment_monitor_requirement]`
`equipment_monitor_requirement_module_status_change`	`targets`	Many-to-many	`0..*`	`0..*`	`equipment_monitor_requirement_target`	`[equipment_monitor_requirement_module_status_change]0..-targets 0..>[equipment_monitor_requirement_target]`
`equipment_monitor_requirement_module_status_change`	`toStatus`	Many-to-one	`0..*`	`1`	`equipment_status`	`[equipment_monitor_requirement_module_status_change]0..*-toStatus 1>[equipment_status]`
`equipment_monitor_requirement_target`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[equipment_monitor_requirement_target]0..*-loggingParameter 1>[equipment_logging_parameter]`
`equipment_monitor_requirement_target`	`requirement`	Many-to-one	`0..*`	`1`	`equipment_monitor_requirement`	`[equipment_monitor_requirement_target]0..*-requirement 1>[equipment_monitor_requirement]`
`equipment_monitor_run`	`monitor`	Many-to-one	`0..*`	`1`	`equipment_monitor`	`[equipment_monitor_run]0..*-monitor 1>[equipment_monitor]`
`equipment_monitor_run`	`schedule`	Many-to-one	`0..*`	`0..1`	`equipment_monitor_schedule`	`[equipment_monitor_run]0..*-schedule 0..1>[equipment_monitor_schedule]`
`equipment_monitor_run`	`run`	One-to-one	`0..1`	`1`	`run_run`	`[equipment_monitor_run]0..1-run 1>[run_run]`
`equipment_monitor_schedule`	`group`	Many-to-one	`0..*`	`1`	`organisation_group`	`[equipment_monitor_schedule]0..*-group 1>[organisation_group]`
`equipment_monitor_schedule`	`monitor`	Many-to-one	`0..*`	`1`	`equipment_monitor`	`[equipment_monitor_schedule]0..*-monitor 1>[equipment_monitor]`
`equipment_monitor_schedule`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[equipment_monitor_schedule]0..*-project 1>[organisation_project]`
`equipment_monitor_schedule`	`team`	Many-to-one	`0..*`	`1`	`organisation_team`	`[equipment_monitor_schedule]0..*-team 1>[organisation_team]`
`equipment_monitor_step`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[equipment_monitor_step]0..-file 0..>[file_file]`
`equipment_monitor_step`	`monitor`	Many-to-one	`0..*`	`1`	`equipment_monitor`	`[equipment_monitor_step]0..*-monitor 1>[equipment_monitor]`
`equipment_monitor_step`	`processModule`	Many-to-one	`0..*`	`1`	`process_module`	`[equipment_monitor_step]0..*-processModule 1>[process_module]`
`equipment_monitor_step`	`processModuleRecipeVersion`	Many-to-one	`0..*`	`0..1`	`process_module_recipe_version`	`[equipment_monitor_step]0..*-processModuleRecipeVersion 0..1>[process_module_recipe_version]`
`equipment_monitor_step`	`stepGroup`	Many-to-one	`0..*`	`0..1`	`equipment_monitor_step_group`	`[equipment_monitor_step]0..*-stepGroup 0..1>[equipment_monitor_step_group]`
`equipment_monitor_step`	`tag`	Many-to-many	`0..*`	`0..*`	`organisation_project_tag`	`[equipment_monitor_step]0..-tag 0..>[organisation_project_tag]`
`equipment_monitor_step`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_monitor_step]0..*-user 1>[admin_user]`
`equipment_monitor_step_label`	`step`	One-to-one	`0..1`	`1`	`equipment_monitor_step`	`[equipment_monitor_step_label]0..1-step 1>[equipment_monitor_step]`
`equipment_monitor_step_parameter`	`parameter`	Many-to-one	`0..*`	`1`	`process_parameter`	`[equipment_monitor_step_parameter]0..*-parameter 1>[process_parameter]`
`equipment_monitor_step_parameter`	`step`	Many-to-one	`0..*`	`1`	`equipment_monitor_step`	`[equipment_monitor_step_parameter]0..*-step 1>[equipment_monitor_step]`
`equipment_monitor_step_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[equipment_monitor_step_parameter]0..*-unit 0..1>[process_unit]`
`equipment_monitor_step_parameter_value`	`consumable`	Many-to-one	`0..*`	`0..1`	`consumable_consumable`	`[equipment_monitor_step_parameter_value]0..*-consumable 0..1>[consumable_consumable]`
`equipment_monitor_step_parameter_value`	`stepParameter`	Many-to-one	`0..*`	`1`	`equipment_monitor_step_parameter`	`[equipment_monitor_step_parameter_value]0..*-stepParameter 1>[equipment_monitor_step_parameter]`
`equipment_monitor_variable`	`stepParameterValue`	One-to-one	`0..1`	`1`	`equipment_monitor_step_parameter_value`	`[equipment_monitor_variable]0..1-stepParameterValue 1>[equipment_monitor_step_parameter_value]`
`equipment_picture`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_picture]0..*-equipment 1>[equipment_equipment]`
`equipment_reservation`	`block`	Many-to-one	`0..*`	`0..1`	`equipment_reservation_block`	`[equipment_reservation]0..*-block 0..1>[equipment_reservation_block]`
`equipment_reservation`	`doubleReservations`	Many-to-many	`0..*`	`0..*`	`equipment_reservation`	`[equipment_reservation]0..-doubleReservations 0..>[equipment_reservation]`
`equipment_reservation`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_reservation]0..*-equipment 1>[equipment_equipment]`
`equipment_reservation`	`equipmentModule`	Many-to-many	`0..*`	`0..*`	`equipment_module`	`[equipment_reservation]0..-equipmentModule 0..>[equipment_module]`
`equipment_reservation`	`equipmentModuleAsset`	Many-to-many	`0..*`	`0..*`	`equipment_module_asset`	`[equipment_reservation]0..-equipmentModuleAsset 0..>[equipment_module_asset]`
`equipment_reservation`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[equipment_reservation]0..*-project 0..1>[organisation_project]`
`equipment_reservation`	`recurringLink`	Many-to-one	`0..*`	`0..1`	`equipment_reservation`	`[equipment_reservation]0..*-recurringLink 0..1>[equipment_reservation]`
`equipment_reservation`	`room`	Many-to-one	`0..*`	`0..1`	`room_room`	`[equipment_reservation]0..*-room 0..1>[room_room]`
`equipment_reservation`	`roomProject`	Many-to-one	`0..*`	`0..1`	`room_room_project`	`[equipment_reservation]0..*-roomProject 0..1>[room_room_project]`
`equipment_reservation`	`run`	Many-to-one	`0..*`	`0..1`	`run_run`	`[equipment_reservation]0..*-run 0..1>[run_run]`
`equipment_reservation`	`serviceEvent`	Many-to-one	`0..*`	`0..1`	`service_service_event`	`[equipment_reservation]0..*-serviceEvent 0..1>[service_service_event]`
`equipment_reservation`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_reservation]0..*-user 1>[admin_user]`
`equipment_reservation_block`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_reservation_block]0..*-user 1>[admin_user]`
`equipment_setup`	`mainEquipment`	One-to-one	`0..1`	`1`	`equipment_equipment`	`[equipment_setup]0..1-mainEquipment 1>[equipment_equipment]`
`equipment_setup_equipment`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[equipment_setup_equipment]0..*-equipment 1>[equipment_equipment]`
`equipment_setup_equipment`	`setup`	Many-to-one	`0..*`	`1`	`equipment_setup`	`[equipment_setup_equipment]0..*-setup 1>[equipment_setup]`
`equipment_statusmail`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[equipment_statusmail]0..*-user 1>[admin_user]`
`facility_facility`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[facility_facility]0..-file 0..>[file_file]`
`facility_facility`	`type`	Many-to-one	`0..*`	`1`	`facility_type`	`[facility_facility]0..*-type 1>[facility_type]`
`facility_facility_preventive_maintenance_maintenance`	`facility`	Many-to-one	`0..*`	`1`	`facility_facility`	`[facility_facility_preventive_maintenance_maintenance]0..*-facility 1>[facility_facility]`
`facility_facility_preventive_maintenance_maintenance`	`schedule`	Many-to-one	`0..*`	`0..1`	`facility_facility_preventive_maintenance_schedule`	`[facility_facility_preventive_maintenance_maintenance]0..*-schedule 0..1>[facility_facility_preventive_maintenance_schedule]`
`facility_facility_preventive_maintenance_maintenance`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[facility_facility_preventive_maintenance_maintenance]0..*-user 0..1>[admin_user]`
`facility_facility_preventive_maintenance_schedule`	`facility`	Many-to-one	`0..*`	`1`	`facility_facility`	`[facility_facility_preventive_maintenance_schedule]0..*-facility 1>[facility_facility]`
`facility_facility_property`	`facility`	Many-to-one	`0..*`	`1`	`facility_facility`	`[facility_facility_property]0..*-facility 1>[facility_facility]`
`facility_facility_property`	`property`	Many-to-one	`0..*`	`1`	`facility_property`	`[facility_facility_property]0..*-property 1>[facility_property]`
`facility_facility_status`	`facility`	Many-to-one	`0..*`	`1`	`facility_facility`	`[facility_facility_status]0..*-facility 1>[facility_facility]`
`facility_facility_status`	`status`	Many-to-one	`0..*`	`1`	`facility_status`	`[facility_facility_status]0..*-status 1>[facility_status]`
`facility_facility_status`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[facility_facility_status]0..*-user 1>[admin_user]`
`facility_type`	`properties`	Many-to-many	`0..*`	`0..*`	`facility_property`	`[facility_type]0..-properties 0..>[facility_property]`
`file_download`	`file`	Many-to-one	`0..*`	`1`	`file_file`	`[file_download]0..*-file 1>[file_file]`
`file_download`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[file_download]0..*-user 1>[admin_user]`
`file_file`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[file_file]0..*-user 1>[admin_user]`
`file_file_object`	`file`	Many-to-one	`0..*`	`1`	`file_file`	`[file_file_object]0..*-file 1>[file_file]`
`location_area`	`facility`	Many-to-one	`0..*`	`1`	`location_facility`	`[location_area]0..*-facility 1>[location_facility]`
`location_facility_logo`	`facility`	One-to-one	`0..1`	`1`	`location_facility`	`[location_facility_logo]0..1-facility 1>[location_facility]`
`location_message`	`owner`	Many-to-one	`0..*`	`1`	`admin_user`	`[location_message]0..*-owner 1>[admin_user]`
`location_message`	`rooms`	Many-to-many	`0..*`	`0..*`	`room_room`	`[location_message]0..-rooms 0..>[room_room]`
`location_message`	`type`	Many-to-one	`0..*`	`1`	`location_message_type`	`[location_message]0..*-type 1>[location_message_type]`
`location_message`	`updatedBy`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[location_message]0..*-updatedBy 0..1>[admin_user]`
`mailing_attachment`	`mailing`	Many-to-one	`0..*`	`1`	`mailing_mailing`	`[mailing_attachment]0..*-mailing 1>[mailing_mailing]`
`mailing_deeplink`	`target`	Many-to-one	`0..*`	`1`	`deeplink_target`	`[mailing_deeplink]0..*-target 1>[deeplink_target]`
`mailing_deeplink`	`mailing`	One-to-one	`0..1`	`1`	`mailing_mailing`	`[mailing_deeplink]0..1-mailing 1>[mailing_mailing]`
`mailing_distribution_list`	`selection`	Many-to-many	`0..*`	`0..*`	`admin_selection`	`[mailing_distribution_list]0..-selection 0..>[admin_selection]`
`mailing_distribution_list`	`transactional`	Many-to-one	`0..*`	`1`	`mailing_transactional`	`[mailing_distribution_list]0..*-transactional 1>[mailing_transactional]`
`mailing_distribution_list_sent`	`distributionList`	Many-to-one	`0..*`	`1`	`mailing_distribution_list`	`[mailing_distribution_list_sent]0..*-distributionList 1>[mailing_distribution_list]`
`mailing_distribution_list_user`	`distributionList`	Many-to-one	`0..*`	`1`	`mailing_distribution_list`	`[mailing_distribution_list_user]0..*-distributionList 1>[mailing_distribution_list]`
`mailing_distribution_list_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[mailing_distribution_list_user]0..*-user 1>[admin_user]`
`mailing_email_message`	`distributionListUser`	Many-to-one	`0..*`	`0..1`	`mailing_distribution_list_user`	`[mailing_email_message]0..*-distributionListUser 0..1>[mailing_distribution_list_user]`
`mailing_email_message`	`mailer`	Many-to-one	`0..*`	`1`	`mailing_mailer`	`[mailing_email_message]0..*-mailer 1>[mailing_mailer]`
`mailing_email_message`	`mailingUser`	Many-to-one	`0..*`	`0..1`	`mailing_user`	`[mailing_email_message]0..*-mailingUser 0..1>[mailing_user]`
`mailing_email_message`	`sender`	Many-to-one	`0..*`	`1`	`mailing_sender`	`[mailing_email_message]0..*-sender 1>[mailing_sender]`
`mailing_email_message`	`template`	Many-to-one	`0..*`	`1`	`mailing_template`	`[mailing_email_message]0..*-template 1>[mailing_template]`
`mailing_email_message`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[mailing_email_message]0..*-user 0..1>[admin_user]`
`mailing_email_message`	`queueEmail`	One-to-one	`0..1`	`0..1`	`scheduler_queue_email`	`[mailing_email_message]0..1-queueEmail 0..1>[scheduler_queue_email]`
`mailing_email_message_event`	`emailMessage`	Many-to-one	`0..*`	`1`	`mailing_email_message`	`[mailing_email_message_event]0..*-emailMessage 1>[mailing_email_message]`
`mailing_mailer`	`oAuth2Service`	Many-to-one	`0..*`	`0..1`	`admin_oauth2_service`	`[mailing_mailer]0..*-oAuth2Service 0..1>[admin_oauth2_service]`
`mailing_mailing`	`mailer`	Many-to-one	`0..*`	`1`	`mailing_mailer`	`[mailing_mailing]0..*-mailer 1>[mailing_mailer]`
`mailing_mailing`	`selection`	Many-to-many	`0..*`	`0..*`	`admin_selection`	`[mailing_mailing]0..-selection 0..>[admin_selection]`
`mailing_mailing`	`sender`	Many-to-one	`0..*`	`1`	`mailing_sender`	`[mailing_mailing]0..*-sender 1>[mailing_sender]`
`mailing_mailing`	`template`	Many-to-one	`0..*`	`1`	`mailing_template`	`[mailing_mailing]0..*-template 1>[mailing_template]`
`mailing_mailing`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[mailing_mailing]0..*-user 1>[admin_user]`
`mailing_queue`	`mailing`	Many-to-one	`0..*`	`1`	`mailing_mailing`	`[mailing_queue]0..*-mailing 1>[mailing_mailing]`
`mailing_queue`	`mailingUser`	Many-to-one	`0..*`	`1`	`mailing_user`	`[mailing_queue]0..*-mailingUser 1>[mailing_user]`
`mailing_transactional`	`mailer`	Many-to-one	`0..*`	`1`	`mailing_mailer`	`[mailing_transactional]0..*-mailer 1>[mailing_mailer]`
`mailing_transactional`	`sender`	Many-to-one	`0..*`	`1`	`mailing_sender`	`[mailing_transactional]0..*-sender 1>[mailing_sender]`
`mailing_transactional`	`target`	Many-to-one	`0..*`	`0..1`	`deeplink_target`	`[mailing_transactional]0..*-target 0..1>[deeplink_target]`
`mailing_transactional`	`template`	Many-to-one	`0..*`	`1`	`mailing_template`	`[mailing_transactional]0..*-template 1>[mailing_template]`
`mailing_transactional_recipient`	`chemicalMailingRecipient`	Many-to-one	`0..*`	`0..1`	`chemical_chemical_mailing_recipient`	`[mailing_transactional_recipient]0..*-chemicalMailingRecipient 0..1>[chemical_chemical_mailing_recipient]`
`mailing_transactional_recipient`	`equipmentMailingRecipient`	Many-to-one	`0..*`	`0..1`	`equipment_equipment_mailing_recipient`	`[mailing_transactional_recipient]0..*-equipmentMailingRecipient 0..1>[equipment_equipment_mailing_recipient]`
`mailing_transactional_recipient`	`generalMailingRecipient`	Many-to-one	`0..*`	`0..1`	`mailing_transactional_mailing_recipient`	`[mailing_transactional_recipient]0..*-generalMailingRecipient 0..1>[mailing_transactional_mailing_recipient]`
`mailing_transactional_recipient`	`roomMailingRecipient`	Many-to-one	`0..*`	`0..1`	`room_room_mailing_recipient`	`[mailing_transactional_recipient]0..*-roomMailingRecipient 0..1>[room_room_mailing_recipient]`
`mailing_transactional_recipient`	`runMailingRecipient`	Many-to-one	`0..*`	`0..1`	`run_run_mailing_recipient`	`[mailing_transactional_recipient]0..*-runMailingRecipient 0..1>[run_run_mailing_recipient]`
`mailing_transactional_recipient`	`schedulerMailingRecipient`	Many-to-one	`0..*`	`0..1`	`scheduler_scheduler_mailing_recipient`	`[mailing_transactional_recipient]0..*-schedulerMailingRecipient 0..1>[scheduler_scheduler_mailing_recipient]`
`mailing_transactional_recipient`	`selection`	Many-to-many	`0..*`	`0..*`	`admin_selection`	`[mailing_transactional_recipient]0..-selection 0..>[admin_selection]`
`mailing_transactional_recipient`	`serviceMailingRecipient`	Many-to-one	`0..*`	`0..1`	`service_service_mailing_recipient`	`[mailing_transactional_recipient]0..*-serviceMailingRecipient 0..1>[service_service_mailing_recipient]`
`mailing_transactional_recipient`	`transactional`	Many-to-one	`0..*`	`1`	`mailing_transactional`	`[mailing_transactional_recipient]0..*-transactional 1>[mailing_transactional]`
`mailing_user`	`mailing`	Many-to-one	`0..*`	`1`	`mailing_mailing`	`[mailing_user]0..*-mailing 1>[mailing_mailing]`
`mailing_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[mailing_user]0..*-user 1>[admin_user]`
`oauth_access_tokens`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_access_tokens]0..*-client 1>[oauth_clients]`
`oauth_access_tokens`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[oauth_access_tokens]0..*-user 0..1>[admin_user]`
`oauth_authorization_codes`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_authorization_codes]0..*-client 1>[oauth_clients]`
`oauth_authorization_codes`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[oauth_authorization_codes]0..*-user 0..1>[admin_user]`
`oauth_clients`	`scope`	Many-to-one	`0..*`	`1`	`oauth_scopes`	`[oauth_clients]0..*-scope 1>[oauth_scopes]`
`oauth_jwt`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_jwt]0..*-client 1>[oauth_clients]`
`oauth_public_keys`	`client`	One-to-one	`0..1`	`1`	`oauth_clients`	`[oauth_public_keys]0..1-client 1>[oauth_clients]`
`oauth_refresh_tokens`	`client`	Many-to-one	`0..*`	`1`	`oauth_clients`	`[oauth_refresh_tokens]0..*-client 1>[oauth_clients]`
`oauth_refresh_tokens`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[oauth_refresh_tokens]0..*-user 0..1>[admin_user]`
`organisation_group`	`environments`	Many-to-many	`0..*`	`0..*`	`admin_environment`	`[organisation_group]0..-environments 0..>[admin_environment]`
`organisation_group_role`	`group`	Many-to-one	`0..*`	`1`	`organisation_group`	`[organisation_group_role]0..*-group 1>[organisation_group]`
`organisation_group_role`	`role`	Many-to-one	`0..*`	`1`	`organisation_role`	`[organisation_group_role]0..*-role 1>[organisation_role]`
`organisation_group_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_group_role]0..*-user 1>[admin_user]`
`organisation_group_user`	`group`	Many-to-one	`0..*`	`1`	`organisation_group`	`[organisation_group_user]0..*-group 1>[organisation_group]`
`organisation_group_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_group_user]0..*-user 1>[admin_user]`
`organisation_program_role`	`program`	Many-to-one	`0..*`	`1`	`organisation_program`	`[organisation_program_role]0..*-program 1>[organisation_program]`
`organisation_program_role`	`role`	Many-to-one	`0..*`	`1`	`organisation_role`	`[organisation_program_role]0..*-role 1>[organisation_role]`
`organisation_program_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_program_role]0..*-user 1>[admin_user]`
`organisation_program_user`	`program`	Many-to-one	`0..*`	`1`	`organisation_program`	`[organisation_program_user]0..*-program 1>[organisation_program]`
`organisation_program_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_program_user]0..*-user 1>[admin_user]`
`organisation_project`	`environments`	Many-to-many	`0..*`	`0..*`	`admin_environment`	`[organisation_project]0..-environments 0..>[admin_environment]`
`organisation_project`	`team`	Many-to-many	`0..*`	`0..*`	`organisation_team`	`[organisation_project]0..-team 0..>[organisation_team]`
`organisation_project`	`wbsElements`	Many-to-many	`0..*`	`0..*`	`organisation_wbs`	`[organisation_project]0..-wbsElements 0..>[organisation_wbs]`
`organisation_project_property_value`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[organisation_project_property_value]0..*-project 1>[organisation_project]`
`organisation_project_property_value`	`property`	Many-to-one	`0..*`	`1`	`organisation_project_property`	`[organisation_project_property_value]0..*-property 1>[organisation_project_property]`
`organisation_project_role`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[organisation_project_role]0..*-project 1>[organisation_project]`
`organisation_project_role`	`role`	Many-to-one	`0..*`	`1`	`organisation_role`	`[organisation_project_role]0..*-role 1>[organisation_role]`
`organisation_project_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_project_role]0..*-user 1>[admin_user]`
`organisation_project_tag`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[organisation_project_tag]0..*-project 1>[organisation_project]`
`organisation_project_user`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[organisation_project_user]0..*-project 1>[organisation_project]`
`organisation_project_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_project_user]0..*-user 1>[admin_user]`
`organisation_team`	`environments`	Many-to-many	`0..*`	`0..*`	`admin_environment`	`[organisation_team]0..-environments 0..>[admin_environment]`
`organisation_team`	`group`	Many-to-one	`0..*`	`0..1`	`organisation_group`	`[organisation_team]0..*-group 0..1>[organisation_group]`
`organisation_team_role`	`role`	Many-to-one	`0..*`	`1`	`organisation_role`	`[organisation_team_role]0..*-role 1>[organisation_role]`
`organisation_team_role`	`team`	Many-to-one	`0..*`	`1`	`organisation_team`	`[organisation_team_role]0..*-team 1>[organisation_team]`
`organisation_team_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_team_role]0..*-user 1>[admin_user]`
`organisation_team_user`	`team`	Many-to-one	`0..*`	`1`	`organisation_team`	`[organisation_team_user]0..*-team 1>[organisation_team]`
`organisation_team_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[organisation_team_user]0..*-user 1>[admin_user]`
`organisation_wbs`	`environments`	Many-to-many	`0..*`	`0..*`	`admin_environment`	`[organisation_wbs]0..-environments 0..>[admin_environment]`
`organisation_wbs_property_value`	`property`	Many-to-one	`0..*`	`1`	`organisation_project_property`	`[organisation_wbs_property_value]0..*-property 1>[organisation_project_property]`
`organisation_wbs_property_value`	`wbs`	Many-to-one	`0..*`	`1`	`organisation_wbs`	`[organisation_wbs_property_value]0..*-wbs 1>[organisation_wbs]`
`page_news`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[page_news]0..*-user 1>[admin_user]`
`page_news_read`	`news`	Many-to-one	`0..*`	`1`	`page_news`	`[page_news_read]0..*-news 1>[page_news]`
`page_news_read`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[page_news_read]0..*-user 1>[admin_user]`
`page_page_tree`	`parentPage`	Many-to-one	`0..*`	`0..1`	`page_page`	`[page_page_tree]0..*-parentPage 0..1>[page_page]`
`page_page_tree`	`childPage`	One-to-one	`0..1`	`1`	`page_page`	`[page_page_tree]0..1-childPage 1>[page_page]`
`process_category`	`type`	Many-to-many	`0..*`	`0..*`	`process_type`	`[process_category]0..-type 0..>[process_type]`
`process_module`	`hiddenParameter`	Many-to-many	`0..*`	`0..*`	`process_parameter`	`[process_module]0..-hiddenParameter 0..>[process_parameter]`
`process_module`	`module`	Many-to-one	`0..*`	`1`	`equipment_module`	`[process_module]0..*-module 1>[equipment_module]`
`process_module`	`process`	Many-to-one	`0..*`	`1`	`process_process`	`[process_module]0..*-process 1>[process_process]`
`process_module_parameter`	`parameter`	Many-to-one	`0..*`	`1`	`process_parameter`	`[process_module_parameter]0..*-parameter 1>[process_parameter]`
`process_module_parameter`	`processModule`	Many-to-one	`0..*`	`1`	`process_module`	`[process_module_parameter]0..*-processModule 1>[process_module]`
`process_module_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[process_module_parameter]0..*-unit 0..1>[process_unit]`
`process_module_parameter_value`	`moduleParameter`	Many-to-one	`0..*`	`1`	`process_module_parameter`	`[process_module_parameter_value]0..*-moduleParameter 1>[process_module_parameter]`
`process_module_recipe`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[process_module_recipe]0..-file 0..>[file_file]`
`process_module_recipe`	`processModule`	Many-to-one	`0..*`	`1`	`process_module`	`[process_module_recipe]0..*-processModule 1>[process_module]`
`process_module_recipe`	`type`	Many-to-one	`0..*`	`0..1`	`process_module_recipe_type`	`[process_module_recipe]0..*-type 0..1>[process_module_recipe_type]`
`process_module_recipe`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[process_module_recipe]0..*-user 1>[admin_user]`
`process_module_recipe_changelog`	`recipe`	Many-to-one	`0..*`	`1`	`process_module_recipe`	`[process_module_recipe_changelog]0..*-recipe 1>[process_module_recipe]`
`process_module_recipe_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[process_module_recipe_changelog]0..*-user 1>[admin_user]`
`process_module_recipe_checklist`	`recipe`	Many-to-one	`0..*`	`1`	`process_module_recipe`	`[process_module_recipe_checklist]0..*-recipe 1>[process_module_recipe]`
`process_module_recipe_parameter`	`parameter`	Many-to-one	`0..*`	`1`	`process_parameter`	`[process_module_recipe_parameter]0..*-parameter 1>[process_parameter]`
`process_module_recipe_parameter`	`recipe`	Many-to-one	`0..*`	`1`	`process_module_recipe`	`[process_module_recipe_parameter]0..*-recipe 1>[process_module_recipe]`
`process_module_recipe_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[process_module_recipe_parameter]0..*-unit 0..1>[process_unit]`
`process_module_recipe_parameter_value`	`consumable`	Many-to-one	`0..*`	`0..1`	`consumable_consumable`	`[process_module_recipe_parameter_value]0..*-consumable 0..1>[consumable_consumable]`
`process_module_recipe_parameter_value`	`recipeParameter`	Many-to-one	`0..*`	`1`	`process_module_recipe_parameter`	`[process_module_recipe_parameter_value]0..*-recipeParameter 1>[process_module_recipe_parameter]`
`process_module_recipe_rework`	`recipe`	Many-to-one	`0..*`	`1`	`process_module_recipe`	`[process_module_recipe_rework]0..*-recipe 1>[process_module_recipe]`
`process_module_recipe_rework`	`template`	Many-to-one	`0..*`	`1`	`template_template`	`[process_module_recipe_rework]0..*-template 1>[template_template]`
`process_module_recipe_version`	`recipe`	Many-to-one	`0..*`	`1`	`process_module_recipe`	`[process_module_recipe_version]0..*-recipe 1>[process_module_recipe]`
`process_module_recipe_version`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[process_module_recipe_version]0..*-user 1>[admin_user]`
`process_module_recipe_version_checklist`	`recipeVersion`	Many-to-one	`0..*`	`1`	`process_module_recipe_version`	`[process_module_recipe_version_checklist]0..*-recipeVersion 1>[process_module_recipe_version]`
`process_module_recipe_version_parameter`	`parameter`	Many-to-one	`0..*`	`1`	`process_parameter`	`[process_module_recipe_version_parameter]0..*-parameter 1>[process_parameter]`
`process_module_recipe_version_parameter`	`recipeVersion`	Many-to-one	`0..*`	`1`	`process_module_recipe_version`	`[process_module_recipe_version_parameter]0..*-recipeVersion 1>[process_module_recipe_version]`
`process_module_recipe_version_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[process_module_recipe_version_parameter]0..*-unit 0..1>[process_unit]`
`process_module_recipe_version_parameter_value`	`consumable`	Many-to-one	`0..*`	`0..1`	`consumable_consumable`	`[process_module_recipe_version_parameter_value]0..*-consumable 0..1>[consumable_consumable]`
`process_module_recipe_version_parameter_value`	`recipeVersionParameter`	Many-to-one	`0..*`	`1`	`process_module_recipe_version_parameter`	`[process_module_recipe_version_parameter_value]0..*-recipeVersionParameter 1>[process_module_recipe_version_parameter]`
`process_parameter`	`consumableTypes`	Many-to-many	`0..*`	`0..*`	`consumable_type`	`[process_parameter]0..-consumableTypes 0..>[consumable_type]`
`process_parameter`	`type`	Many-to-one	`0..*`	`0..1`	`process_parameter_type`	`[process_parameter]0..*-type 0..1>[process_parameter_type]`
`process_parameter_type`	`unit`	Many-to-many	`0..*`	`0..*`	`process_unit`	`[process_parameter_type]0..-unit 0..>[process_unit]`
`process_process`	`category`	Many-to-one	`0..*`	`1`	`process_category`	`[process_process]0..*-category 1>[process_category]`
`process_process`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[process_process]0..-file 0..>[file_file]`
`process_process`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[process_process]0..*-user 1>[admin_user]`
`process_type`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[process_type]0..*-user 1>[admin_user]`
`reporting_storage_location`	`oAuth2Service`	Many-to-one	`0..*`	`0..1`	`admin_oauth2_service`	`[reporting_storage_location]0..*-oAuth2Service 0..1>[admin_oauth2_service]`
`reporting_sync_log`	`storageLocation`	Many-to-one	`0..*`	`0..1`	`reporting_storage_location`	`[reporting_sync_log]0..*-storageLocation 0..1>[reporting_storage_location]`
`room_building`	`site`	Many-to-one	`0..*`	`1`	`room_site`	`[room_building]0..*-site 1>[room_site]`
`room_document`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_document]0..*-room 1>[room_room]`
`room_document`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_document]0..*-user 1>[admin_user]`
`room_document_file`	`document`	One-to-one	`0..1`	`1`	`room_document`	`[room_document_file]0..1-document 1>[room_document]`
`room_floorplan`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_floorplan]0..*-room 1>[room_room]`
`room_location`	`childSubdivisionTemplate`	Many-to-one	`0..*`	`0..1`	`room_location_subdivision_template`	`[room_location]0..*-childSubdivisionTemplate 0..1>[room_location_subdivision_template]`
`room_location`	`label`	Many-to-one	`0..*`	`0..1`	`chemical_label`	`[room_location]0..*-label 0..1>[chemical_label]`
`room_location`	`parent`	Many-to-one	`0..*`	`0..1`	`room_location`	`[room_location]0..*-parent 0..1>[room_location]`
`room_location`	`root`	Many-to-one	`0..*`	`0..1`	`room_location`	`[room_location]0..*-root 0..1>[room_location]`
`room_location`	`zoneGroup`	Many-to-one	`0..*`	`1`	`room_zone_group`	`[room_location]0..*-zoneGroup 1>[room_zone_group]`
`room_room`	`building`	Many-to-one	`0..*`	`1`	`room_building`	`[room_room]0..*-building 1>[room_building]`
`room_room`	`equipmentProperties`	Many-to-many	`0..*`	`0..*`	`equipment_property`	`[room_room]0..-equipmentProperties 0..>[equipment_property]`
`room_room`	`label`	Many-to-one	`0..*`	`0..1`	`chemical_label`	`[room_room]0..*-label 0..1>[chemical_label]`
`room_room`	`modules`	Many-to-many	`0..*`	`0..*`	`admin_module`	`[room_room]0..-modules 0..>[admin_module]`
`room_room_link`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_room_link]0..*-room 1>[room_room]`
`room_room_link`	`type`	Many-to-one	`0..*`	`1`	`room_room_link_type`	`[room_room_link]0..*-type 1>[room_room_link_type]`
`room_room_program`	`program`	Many-to-one	`0..*`	`1`	`organisation_program`	`[room_room_program]0..*-program 1>[organisation_program]`
`room_room_program`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_room_program]0..*-room 1>[room_room]`
`room_room_project`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[room_room_project]0..*-project 1>[organisation_project]`
`room_room_project`	`room`	Many-to-one	`0..*`	`0..1`	`room_room`	`[room_room_project]0..*-room 0..1>[room_room]`
`room_room_project`	`wbs`	Many-to-one	`0..*`	`0..1`	`organisation_wbs`	`[room_room_project]0..*-wbs 0..1>[organisation_wbs]`
`room_room_request`	`mentor`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[room_room_request]0..*-mentor 0..1>[admin_user]`
`room_room_request`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_room_request]0..*-room 1>[room_room]`
`room_room_request`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_room_request]0..*-user 1>[admin_user]`
`room_room_request_flow`	`request`	Many-to-one	`0..*`	`1`	`room_room_request`	`[room_room_request_flow]0..*-request 1>[room_room_request]`
`room_room_request_flow`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_room_request_flow]0..*-user 1>[admin_user]`
`room_room_role`	`role`	Many-to-one	`0..*`	`1`	`room_role`	`[room_room_role]0..*-role 1>[room_role]`
`room_room_role`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_room_role]0..*-room 1>[room_room]`
`room_room_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_room_role]0..*-user 1>[admin_user]`
`room_room_user`	`mentor`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[room_room_user]0..*-mentor 0..1>[admin_user]`
`room_room_user`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_room_user]0..*-room 1>[room_room]`
`room_room_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_room_user]0..*-user 1>[admin_user]`
`room_site_floor_plan`	`site`	Many-to-one	`0..*`	`1`	`room_site`	`[room_site_floor_plan]0..*-site 1>[room_site]`
`room_zone`	`group`	Many-to-one	`0..*`	`1`	`room_zone_group`	`[room_zone]0..*-group 1>[room_zone_group]`
`room_zone`	`label`	Many-to-one	`0..*`	`0..1`	`chemical_label`	`[room_zone]0..*-label 0..1>[chemical_label]`
`room_zone_group`	`equipmentProperties`	Many-to-many	`0..*`	`0..*`	`equipment_property`	`[room_zone_group]0..-equipmentProperties 0..>[equipment_property]`
`room_zone_group`	`room`	Many-to-one	`0..*`	`1`	`room_room`	`[room_zone_group]0..*-room 1>[room_room]`
`room_zone_group_user`	`group`	Many-to-one	`0..*`	`1`	`room_zone_group`	`[room_zone_group_user]0..*-group 1>[room_zone_group]`
`room_zone_group_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_zone_group_user]0..*-user 1>[admin_user]`
`room_zone_reservation`	`recurringLink`	Many-to-one	`0..*`	`0..1`	`room_zone_reservation`	`[room_zone_reservation]0..*-recurringLink 0..1>[room_zone_reservation]`
`room_zone_reservation`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_zone_reservation]0..*-user 1>[admin_user]`
`room_zone_reservation`	`zone`	Many-to-one	`0..*`	`1`	`room_zone`	`[room_zone_reservation]0..*-zone 1>[room_zone]`
`room_zone_user`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[room_zone_user]0..*-user 1>[admin_user]`
`room_zone_user`	`zone`	Many-to-one	`0..*`	`1`	`room_zone`	`[room_zone_user]0..*-zone 1>[room_zone]`
`run_changelog`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_changelog]0..*-run 1>[run_run]`
`run_changelog`	`runStepChecklist`	Many-to-one	`0..*`	`0..1`	`run_step_checklist`	`[run_changelog]0..*-runStepChecklist 0..1>[run_step_checklist]`
`run_changelog`	`steps`	Many-to-many	`0..*`	`0..*`	`run_step`	`[run_changelog]0..-steps 0..>[run_step]`
`run_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_changelog]0..*-user 1>[admin_user]`
`run_consumable`	`consumable`	Many-to-one	`0..*`	`1`	`consumable_consumable`	`[run_consumable]0..*-consumable 1>[consumable_consumable]`
`run_consumable`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_consumable]0..*-run 1>[run_run]`
`run_consumable_matrix_consumable`	`consumableMatrix`	Many-to-one	`0..*`	`1`	`run_substrate_matrix`	`[run_consumable_matrix_consumable]0..*-consumableMatrix 1>[run_substrate_matrix]`
`run_consumable_matrix_consumable`	`runConsumable`	Many-to-one	`0..*`	`1`	`run_consumable`	`[run_consumable_matrix_consumable]0..*-runConsumable 1>[run_consumable]`
`run_measurement`	`step`	One-to-one	`0..1`	`1`	`run_step`	`[run_measurement]0..1-step 1>[run_step]`
`run_measurement_label`	`measurement`	One-to-one	`0..1`	`1`	`run_measurement`	`[run_measurement_label]0..1-measurement 1>[run_measurement]`
`run_measurement_logging_parameter`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[run_measurement_logging_parameter]0..*-loggingParameter 1>[equipment_logging_parameter]`
`run_measurement_logging_parameter`	`measurement`	Many-to-one	`0..*`	`1`	`run_measurement`	`[run_measurement_logging_parameter]0..*-measurement 1>[run_measurement]`
`run_measurement_part`	`measurement`	Many-to-one	`0..*`	`1`	`run_measurement`	`[run_measurement_part]0..*-measurement 1>[run_measurement]`
`run_measurement_part`	`stepPart`	One-to-one	`0..1`	`1`	`run_step_part`	`[run_measurement_part]0..1-stepPart 1>[run_step_part]`
`run_measurement_result`	`file`	Many-to-one	`0..*`	`0..1`	`file_file`	`[run_measurement_result]0..*-file 0..1>[file_file]`
`run_measurement_result`	`logging`	Many-to-one	`0..*`	`0..1`	`equipment_logging`	`[run_measurement_result]0..*-logging 0..1>[equipment_logging]`
`run_measurement_result`	`measurement`	Many-to-one	`0..*`	`1`	`run_measurement`	`[run_measurement_result]0..*-measurement 1>[run_measurement]`
`run_measurement_result`	`runPartMapping`	Many-to-one	`0..*`	`0..1`	`run_part_mapping`	`[run_measurement_result]0..*-runPartMapping 0..1>[run_part_mapping]`
`run_measurement_result_value`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[run_measurement_result_value]0..*-loggingParameter 1>[equipment_logging_parameter]`
`run_measurement_result_value`	`result`	Many-to-one	`0..*`	`1`	`run_measurement_result`	`[run_measurement_result_value]0..*-result 1>[run_measurement_result]`
`run_measurement_result_value`	`stepPart`	Many-to-one	`0..*`	`0..1`	`run_step_part`	`[run_measurement_result_value]0..*-stepPart 0..1>[run_step_part]`
`run_measurement_summary`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_measurement_summary]0..*-user 1>[admin_user]`
`run_measurement_summary_run`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_measurement_summary_run]0..*-run 1>[run_run]`
`run_measurement_summary_run`	`summary`	Many-to-one	`0..*`	`1`	`run_measurement_summary`	`[run_measurement_summary_run]0..*-summary 1>[run_measurement_summary]`
`run_measurement_summary_run_part`	`part`	Many-to-one	`0..*`	`1`	`run_part`	`[run_measurement_summary_run_part]0..*-part 1>[run_part]`
`run_measurement_summary_run_part`	`summary`	Many-to-one	`0..*`	`1`	`run_measurement_summary`	`[run_measurement_summary_run_part]0..*-summary 1>[run_measurement_summary]`
`run_parent`	`child`	Many-to-one	`0..*`	`1`	`run_run`	`[run_parent]0..*-child 1>[run_run]`
`run_parent`	`parent`	Many-to-one	`0..*`	`1`	`run_run`	`[run_parent]0..*-parent 1>[run_run]`
`run_parent`	`part`	Many-to-many	`0..*`	`0..*`	`run_part`	`[run_parent]0..-part 0..>[run_part]`
`run_part`	`baseline`	Many-to-one	`0..*`	`0..1`	`organisation_baseline`	`[run_part]0..*-baseline 0..1>[organisation_baseline]`
`run_part`	`layout`	Many-to-one	`0..*`	`0..1`	`run_part_layout`	`[run_part]0..*-layout 0..1>[run_part_layout]`
`run_part`	`parent`	Many-to-one	`0..*`	`0..1`	`run_part`	`[run_part]0..*-parent 0..1>[run_part]`
`run_part`	`root`	Many-to-one	`0..*`	`0..1`	`run_part`	`[run_part]0..*-root 0..1>[run_part]`
`run_part`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_part]0..*-run 1>[run_run]`
`run_part`	`tray`	Many-to-one	`0..*`	`0..1`	`run_run_tray`	`[run_part]0..*-tray 0..1>[run_run_tray]`
`run_part_consumable_creation`	`consumable`	One-to-one	`0..1`	`1`	`consumable_consumable`	`[run_part_consumable_creation]0..1-consumable 1>[consumable_consumable]`
`run_part_consumable_creation`	`part`	One-to-one	`0..1`	`1`	`run_part`	`[run_part_consumable_creation]0..1-part 1>[run_part]`
`run_part_mapping`	`part`	Many-to-one	`0..*`	`1`	`run_part`	`[run_part_mapping]0..*-part 1>[run_part]`
`run_requirement`	`requirementStep`	Many-to-one	`0..*`	`0..1`	`run_step`	`[run_requirement]0..*-requirementStep 0..1>[run_step]`
`run_requirement`	`measurement`	One-to-one	`0..1`	`1`	`run_measurement`	`[run_requirement]0..1-measurement 1>[run_measurement]`
`run_requirement`	`step`	One-to-one	`0..1`	`1`	`run_step`	`[run_requirement]0..1-step 1>[run_step]`
`run_requirement_label`	`runRequirement`	One-to-one	`0..1`	`1`	`run_requirement`	`[run_requirement_label]0..1-runRequirement 1>[run_requirement]`
`run_requirement_part`	`requirement`	Many-to-one	`0..*`	`1`	`run_requirement`	`[run_requirement_part]0..*-requirement 1>[run_requirement]`
`run_requirement_part`	`stepPart`	One-to-one	`0..1`	`1`	`run_step_part`	`[run_requirement_part]0..1-stepPart 1>[run_step_part]`
`run_requirement_target`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[run_requirement_target]0..*-loggingParameter 1>[equipment_logging_parameter]`
`run_requirement_target`	`requirement`	Many-to-one	`0..*`	`1`	`run_requirement`	`[run_requirement_target]0..*-requirement 1>[run_requirement]`
`run_run`	`environment`	Many-to-one	`0..*`	`1`	`admin_environment`	`[run_run]0..*-environment 1>[admin_environment]`
`run_run`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[run_run]0..-file 0..>[file_file]`
`run_run`	`group`	Many-to-one	`0..*`	`1`	`organisation_group`	`[run_run]0..*-group 1>[organisation_group]`
`run_run`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[run_run]0..*-project 1>[organisation_project]`
`run_run`	`relatedRuns`	Many-to-many	`0..*`	`0..*`	`run_run`	`[run_run]0..-relatedRuns 0..>[run_run]`
`run_run`	`sampleType`	Many-to-one	`0..*`	`0..1`	`run_sample_type`	`[run_run]0..*-sampleType 0..1>[run_sample_type]`
`run_run`	`team`	Many-to-one	`0..*`	`1`	`organisation_team`	`[run_run]0..*-team 1>[organisation_team]`
`run_run`	`trayType`	Many-to-one	`0..*`	`0..1`	`run_tray_type`	`[run_run]0..*-trayType 0..1>[run_tray_type]`
`run_run`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_run]0..*-user 1>[admin_user]`
`run_run_batch_card`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_run_batch_card]0..*-user 1>[admin_user]`
`run_run_batch_card`	`run`	One-to-one	`0..1`	`1`	`run_run`	`[run_run_batch_card]0..1-run 1>[run_run]`
`run_run_hold_code`	`holdCode`	Many-to-one	`0..*`	`1`	`run_hold_code`	`[run_run_hold_code]0..*-holdCode 1>[run_hold_code]`
`run_run_hold_code`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_run_hold_code]0..*-run 1>[run_run]`
`run_run_hold_code`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_run_hold_code]0..*-user 1>[admin_user]`
`run_run_priority`	`priority`	Many-to-one	`0..*`	`1`	`run_priority`	`[run_run_priority]0..*-priority 1>[run_priority]`
`run_run_priority`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_run_priority]0..*-run 1>[run_run]`
`run_run_priority`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_run_priority]0..*-user 1>[admin_user]`
`run_run_role`	`role`	Many-to-one	`0..*`	`1`	`run_role`	`[run_run_role]0..*-role 1>[run_role]`
`run_run_role`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_run_role]0..*-run 1>[run_run]`
`run_run_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_run_role]0..*-user 1>[admin_user]`
`run_run_tray`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_run_tray]0..*-run 1>[run_run]`
`run_run_tray`	`trayType`	Many-to-one	`0..*`	`1`	`run_tray_type`	`[run_run_tray]0..*-trayType 1>[run_tray_type]`
`run_run_variable`	`stepParameterValue`	One-to-one	`0..1`	`1`	`run_step_parameter_value`	`[run_run_variable]0..1-stepParameterValue 1>[run_step_parameter_value]`
`run_service_work`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_service_work]0..*-run 1>[run_run]`
`run_service_work`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_service_work]0..*-user 1>[admin_user]`
`run_service_work_comment`	`serviceWork`	Many-to-one	`0..*`	`1`	`run_service_work`	`[run_service_work_comment]0..*-serviceWork 1>[run_service_work]`
`run_service_work_comment`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_service_work_comment]0..*-user 1>[admin_user]`
`run_service_work_step`	`serviceWork`	Many-to-one	`0..*`	`1`	`run_service_work`	`[run_service_work_step]0..*-serviceWork 1>[run_service_work]`
`run_service_work_step`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[run_service_work_step]0..*-user 0..1>[admin_user]`
`run_service_work_step`	`runStep`	One-to-one	`0..1`	`1`	`run_step`	`[run_service_work_step]0..1-runStep 1>[run_step]`
`run_step`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[run_step]0..-file 0..>[file_file]`
`run_step`	`monitorStep`	Many-to-one	`0..*`	`0..1`	`equipment_monitor_step`	`[run_step]0..*-monitorStep 0..1>[equipment_monitor_step]`
`run_step`	`processModule`	Many-to-one	`0..*`	`1`	`process_module`	`[run_step]0..*-processModule 1>[process_module]`
`run_step`	`processModuleRecipeVersion`	Many-to-one	`0..*`	`0..1`	`process_module_recipe_version`	`[run_step]0..*-processModuleRecipeVersion 0..1>[process_module_recipe_version]`
`run_step`	`rework`	Many-to-one	`0..*`	`0..1`	`run_step_rework`	`[run_step]0..*-rework 0..1>[run_step_rework]`
`run_step`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_step]0..*-run 1>[run_run]`
`run_step`	`stepGroup`	Many-to-one	`0..*`	`0..1`	`run_step_group`	`[run_step]0..*-stepGroup 0..1>[run_step_group]`
`run_step`	`tag`	Many-to-many	`0..*`	`0..*`	`organisation_project_tag`	`[run_step]0..-tag 0..>[organisation_project_tag]`
`run_step`	`templateStep`	Many-to-one	`0..*`	`0..1`	`template_step`	`[run_step]0..*-templateStep 0..1>[template_step]`
`run_step`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_step]0..*-user 1>[admin_user]`
`run_step`	`userFinish`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[run_step]0..*-userFinish 0..1>[admin_user]`
`run_step`	`userStart`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[run_step]0..*-userStart 0..1>[admin_user]`
`run_step_checklist`	`runStep`	Many-to-one	`0..*`	`1`	`run_step`	`[run_step_checklist]0..*-runStep 1>[run_step]`
`run_step_checklist`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[run_step_checklist]0..*-user 0..1>[admin_user]`
`run_step_label`	`runStep`	One-to-one	`0..1`	`1`	`run_step`	`[run_step_label]0..1-runStep 1>[run_step]`
`run_step_parameter`	`parameter`	Many-to-one	`0..*`	`1`	`process_parameter`	`[run_step_parameter]0..*-parameter 1>[process_parameter]`
`run_step_parameter`	`step`	Many-to-one	`0..*`	`1`	`run_step`	`[run_step_parameter]0..*-step 1>[run_step]`
`run_step_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[run_step_parameter]0..*-unit 0..1>[process_unit]`
`run_step_parameter_value`	`assemblyRunStep`	Many-to-one	`0..*`	`0..1`	`run_step`	`[run_step_parameter_value]0..*-assemblyRunStep 0..1>[run_step]`
`run_step_parameter_value`	`consumable`	Many-to-one	`0..*`	`0..1`	`consumable_consumable`	`[run_step_parameter_value]0..*-consumable 0..1>[consumable_consumable]`
`run_step_parameter_value`	`stepParameter`	Many-to-one	`0..*`	`1`	`run_step_parameter`	`[run_step_parameter_value]0..*-stepParameter 1>[run_step_parameter]`
`run_step_parameter_value_realised`	`stepParameterValue`	One-to-one	`0..1`	`1`	`run_step_parameter_value`	`[run_step_parameter_value_realised]0..1-stepParameterValue 1>[run_step_parameter_value]`
`run_step_part`	`part`	Many-to-one	`0..*`	`1`	`run_part`	`[run_step_part]0..*-part 1>[run_part]`
`run_step_part`	`step`	Many-to-one	`0..*`	`1`	`run_step`	`[run_step_part]0..*-step 1>[run_step]`
`run_step_part_state`	`stepPart`	Many-to-one	`0..*`	`1`	`run_step_part`	`[run_step_part_state]0..*-stepPart 1>[run_step_part]`
`run_step_part_state`	`type`	Many-to-one	`0..*`	`1`	`run_step_part_state_type`	`[run_step_part_state]0..*-type 1>[run_step_part_state_type]`
`run_step_part_state`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_step_part_state]0..*-user 1>[admin_user]`
`run_step_part_state_action`	`toType`	Many-to-one	`0..*`	`0..1`	`run_step_part_state_type`	`[run_step_part_state_action]0..*-toType 0..1>[run_step_part_state_type]`
`run_step_part_state_type`	`availableActions`	Many-to-many	`0..*`	`0..*`	`run_step_part_state_action`	`[run_step_part_state_type]0..-availableActions 0..>[run_step_part_state_action]`
`run_step_part_tray`	`tray`	Many-to-one	`0..*`	`1`	`run_run_tray`	`[run_step_part_tray]0..*-tray 1>[run_run_tray]`
`run_step_part_tray`	`stepPart`	One-to-one	`0..1`	`1`	`run_step_part`	`[run_step_part_tray]0..1-stepPart 1>[run_step_part]`
`run_step_rework`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[run_step_rework]0..*-user 1>[admin_user]`
`run_substrate`	`run`	Many-to-one	`0..*`	`1`	`run_run`	`[run_substrate]0..*-run 1>[run_run]`
`run_substrate`	`substrate`	Many-to-one	`0..*`	`1`	`substrate_substrate`	`[run_substrate]0..*-substrate 1>[substrate_substrate]`
`run_substrate_matrix`	`parentPart`	Many-to-many	`0..*`	`0..*`	`run_part`	`[run_substrate_matrix]0..-parentPart 0..>[run_part]`
`run_substrate_matrix`	`part`	One-to-one	`0..1`	`1`	`run_part`	`[run_substrate_matrix]0..1-part 1>[run_part]`
`run_substrate_matrix_substrate`	`runSubstrate`	Many-to-one	`0..*`	`1`	`run_substrate`	`[run_substrate_matrix_substrate]0..*-runSubstrate 1>[run_substrate]`
`run_substrate_matrix_substrate`	`substrateMatrix`	Many-to-one	`0..*`	`1`	`run_substrate_matrix`	`[run_substrate_matrix_substrate]0..*-substrateMatrix 1>[run_substrate_matrix]`
`scheduler_job`	`program`	Many-to-one	`0..*`	`0..1`	`organisation_program`	`[scheduler_job]0..*-program 0..1>[organisation_program]`
`scheduler_job`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[scheduler_job]0..*-project 0..1>[organisation_project]`
`scheduler_job`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[scheduler_job]0..*-user 1>[admin_user]`
`scheduler_job`	`wbs`	Many-to-one	`0..*`	`0..1`	`organisation_wbs`	`[scheduler_job]0..*-wbs 0..1>[organisation_wbs]`
`scheduler_job_changelog`	`job`	Many-to-one	`0..*`	`1`	`scheduler_job`	`[scheduler_job_changelog]0..*-job 1>[scheduler_job]`
`scheduler_job_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[scheduler_job_changelog]0..*-user 1>[admin_user]`
`scheduler_job_equipment`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[scheduler_job_equipment]0..*-equipment 1>[equipment_equipment]`
`scheduler_job_equipment`	`job`	Many-to-one	`0..*`	`1`	`scheduler_job`	`[scheduler_job_equipment]0..*-job 1>[scheduler_job]`
`scheduler_job_equipment`	`equipmentReservation`	One-to-one	`0..1`	`0..1`	`equipment_reservation`	`[scheduler_job_equipment]0..1-equipmentReservation 0..1>[equipment_reservation]`
`scheduler_job_equipment`	`replacedJobEquipment`	One-to-one	`0..1`	`0..1`	`scheduler_job_equipment`	`[scheduler_job_equipment]0..1-replacedJobEquipment 0..1>[scheduler_job_equipment]`
`scheduler_job_status`	`job`	Many-to-one	`0..*`	`1`	`scheduler_job`	`[scheduler_job_status]0..*-job 1>[scheduler_job]`
`scheduler_job_status`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[scheduler_job_status]0..*-user 1>[admin_user]`
`scheduler_mailing`	`transactional`	Many-to-one	`0..*`	`1`	`mailing_transactional`	`[scheduler_mailing]0..*-transactional 1>[mailing_transactional]`
`scheduler_queue`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[scheduler_queue]0..*-equipment 1>[equipment_equipment]`
`scheduler_queue`	`job`	Many-to-one	`0..*`	`1`	`scheduler_job`	`[scheduler_queue]0..*-job 1>[scheduler_job]`
`scheduler_queue`	`quotaRule`	Many-to-one	`0..*`	`0..1`	`scheduler_quota_rule`	`[scheduler_queue]0..*-quotaRule 0..1>[scheduler_quota_rule]`
`scheduler_queue`	`equipmentReservation`	One-to-one	`0..1`	`1`	`equipment_reservation`	`[scheduler_queue]0..1-equipmentReservation 1>[equipment_reservation]`
`scheduler_queue_email`	`queue`	Many-to-one	`0..*`	`1`	`scheduler_queue`	`[scheduler_queue_email]0..*-queue 1>[scheduler_queue]`
`scheduler_queue_email`	`schedulerMailing`	Many-to-one	`0..*`	`1`	`scheduler_mailing`	`[scheduler_queue_email]0..*-schedulerMailing 1>[scheduler_mailing]`
`scheduler_queue_grace_request`	`queue`	Many-to-one	`0..*`	`1`	`scheduler_queue`	`[scheduler_queue_grace_request]0..*-queue 1>[scheduler_queue]`
`scheduler_queue_grace_request`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[scheduler_queue_grace_request]0..*-user 1>[admin_user]`
`scheduler_quota_header`	`equipment`	One-to-one	`0..1`	`0..1`	`equipment_equipment`	`[scheduler_quota_header]0..1-equipment 0..1>[equipment_equipment]`
`scheduler_quota_header`	`equipmentGroup`	One-to-one	`0..1`	`0..1`	`equipment_group`	`[scheduler_quota_header]0..1-equipmentGroup 0..1>[equipment_group]`
`scheduler_quota_rule`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[scheduler_quota_rule]0..*-project 0..1>[organisation_project]`
`scheduler_quota_rule`	`quotaHeader`	Many-to-one	`0..*`	`1`	`scheduler_quota_header`	`[scheduler_quota_rule]0..*-quotaHeader 1>[scheduler_quota_header]`
`scheduler_quota_rule`	`team`	Many-to-one	`0..*`	`0..1`	`organisation_team`	`[scheduler_quota_rule]0..*-team 0..1>[organisation_team]`
`sensor_calibration_type`	`properties`	Many-to-many	`0..*`	`0..*`	`sensor_property`	`[sensor_calibration_type]0..-properties 0..>[sensor_property]`
`sensor_request`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[sensor_request]0..*-project 1>[organisation_project]`
`sensor_request`	`requester`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[sensor_request]0..*-requester 0..1>[admin_user]`
`sensor_request`	`responsible`	Many-to-one	`0..*`	`1`	`admin_user`	`[sensor_request]0..*-responsible 1>[admin_user]`
`sensor_request`	`sensorTypes`	Many-to-many	`0..*`	`0..*`	`sensor_type`	`[sensor_request]0..-sensorTypes 0..>[sensor_type]`
`sensor_request_bonding`	`sensorRequest`	One-to-one	`0..1`	`1`	`sensor_request`	`[sensor_request_bonding]0..1-sensorRequest 1>[sensor_request]`
`sensor_request_calibration`	`sensorRequest`	One-to-one	`0..1`	`1`	`sensor_request`	`[sensor_request_calibration]0..1-sensorRequest 1>[sensor_request]`
`sensor_request_calibration_file`	`calibration`	Many-to-one	`0..*`	`1`	`sensor_request_calibration`	`[sensor_request_calibration_file]0..*-calibration 1>[sensor_request_calibration]`
`sensor_request_calibration_file`	`type`	Many-to-one	`0..*`	`1`	`sensor_file_type`	`[sensor_request_calibration_file]0..*-type 1>[sensor_file_type]`
`sensor_request_calibration_file_object`	`file`	Many-to-one	`0..*`	`1`	`sensor_request_calibration_file`	`[sensor_request_calibration_file_object]0..*-file 1>[sensor_request_calibration_file]`
`sensor_request_changelog`	`request`	Many-to-one	`0..*`	`1`	`sensor_request`	`[sensor_request_changelog]0..*-request 1>[sensor_request]`
`sensor_request_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[sensor_request_changelog]0..*-user 1>[admin_user]`
`sensor_request_fabrication_finish`	`sensorRequest`	One-to-one	`0..1`	`1`	`sensor_request`	`[sensor_request_fabrication_finish]0..1-sensorRequest 1>[sensor_request]`
`sensor_request_file_type`	`fileType`	Many-to-one	`0..*`	`1`	`sensor_file_type`	`[sensor_request_file_type]0..*-fileType 1>[sensor_file_type]`
`sensor_request_information`	`site`	Many-to-one	`0..*`	`0..1`	`room_site`	`[sensor_request_information]0..*-site 0..1>[room_site]`
`sensor_request_information`	`sensorRequest`	One-to-one	`0..1`	`1`	`sensor_request`	`[sensor_request_information]0..1-sensorRequest 1>[sensor_request]`
`sensor_request_information_file`	`information`	Many-to-one	`0..*`	`1`	`sensor_request_information`	`[sensor_request_information_file]0..*-information 1>[sensor_request_information]`
`sensor_request_information_file`	`type`	Many-to-one	`0..*`	`1`	`sensor_file_type`	`[sensor_request_information_file]0..*-type 1>[sensor_file_type]`
`sensor_request_information_file_object`	`file`	Many-to-one	`0..*`	`1`	`sensor_request_information_file`	`[sensor_request_information_file_object]0..*-file 1>[sensor_request_information_file]`
`sensor_request_sending_preparation`	`sensorRequest`	One-to-one	`0..1`	`1`	`sensor_request`	`[sensor_request_sending_preparation]0..1-sensorRequest 1>[sensor_request]`
`sensor_sensor`	`manufacturer`	Many-to-one	`0..*`	`0..1`	`sensor_manufacturer`	`[sensor_sensor]0..*-manufacturer 0..1>[sensor_manufacturer]`
`sensor_sensor`	`owner`	Many-to-one	`0..*`	`1`	`admin_user`	`[sensor_sensor]0..*-owner 1>[admin_user]`
`sensor_sensor`	`project`	Many-to-one	`0..*`	`1`	`organisation_project`	`[sensor_sensor]0..*-project 1>[organisation_project]`
`sensor_sensor`	`request`	Many-to-one	`0..*`	`0..1`	`sensor_request`	`[sensor_sensor]0..*-request 0..1>[sensor_request]`
`sensor_sensor`	`requester`	Many-to-one	`0..*`	`1`	`admin_user`	`[sensor_sensor]0..*-requester 1>[admin_user]`
`sensor_sensor`	`site`	Many-to-one	`0..*`	`1`	`room_site`	`[sensor_sensor]0..*-site 1>[room_site]`
`sensor_sensor`	`types`	Many-to-many	`0..*`	`0..*`	`sensor_type`	`[sensor_sensor]0..-types 0..>[sensor_type]`
`sensor_sensor_calibration`	`sensor`	Many-to-one	`0..*`	`1`	`sensor_sensor`	`[sensor_sensor_calibration]0..*-sensor 1>[sensor_sensor]`
`sensor_sensor_calibration`	`type`	Many-to-one	`0..*`	`1`	`sensor_calibration_type`	`[sensor_sensor_calibration]0..*-type 1>[sensor_calibration_type]`
`sensor_sensor_calibration`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[sensor_sensor_calibration]0..*-user 1>[admin_user]`
`sensor_sensor_calibration_property`	`calibration`	Many-to-one	`0..*`	`1`	`sensor_sensor_calibration`	`[sensor_sensor_calibration_property]0..*-calibration 1>[sensor_sensor_calibration]`
`sensor_sensor_calibration_property`	`property`	Many-to-one	`0..*`	`1`	`sensor_property`	`[sensor_sensor_calibration_property]0..*-property 1>[sensor_property]`
`sensor_sensor_changelog`	`sensor`	Many-to-one	`0..*`	`1`	`sensor_sensor`	`[sensor_sensor_changelog]0..*-sensor 1>[sensor_sensor]`
`sensor_sensor_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[sensor_sensor_changelog]0..*-user 1>[admin_user]`
`sensor_sensor_file`	`sensor`	Many-to-one	`0..*`	`1`	`sensor_sensor`	`[sensor_sensor_file]0..*-sensor 1>[sensor_sensor]`
`sensor_sensor_file`	`type`	Many-to-one	`0..*`	`1`	`sensor_file_type`	`[sensor_sensor_file]0..*-type 1>[sensor_file_type]`
`sensor_sensor_file_object`	`file`	Many-to-one	`0..*`	`1`	`sensor_sensor_file`	`[sensor_sensor_file_object]0..*-file 1>[sensor_sensor_file]`
`sensor_sensor_link`	`sensor`	Many-to-one	`0..*`	`1`	`sensor_sensor`	`[sensor_sensor_link]0..*-sensor 1>[sensor_sensor]`
`sensor_sensor_link`	`type`	Many-to-one	`0..*`	`1`	`sensor_sensor_link_type`	`[sensor_sensor_link]0..*-type 1>[sensor_sensor_link_type]`
`sensor_sensor_property`	`property`	Many-to-one	`0..*`	`1`	`sensor_property`	`[sensor_sensor_property]0..*-property 1>[sensor_property]`
`sensor_sensor_property`	`sensor`	Many-to-one	`0..*`	`1`	`sensor_sensor`	`[sensor_sensor_property]0..*-sensor 1>[sensor_sensor]`
`sensor_sensor_status`	`sensor`	Many-to-one	`0..*`	`1`	`sensor_sensor`	`[sensor_sensor_status]0..*-sensor 1>[sensor_sensor]`
`sensor_sensor_status`	`status`	Many-to-one	`0..*`	`1`	`sensor_status`	`[sensor_sensor_status]0..*-status 1>[sensor_status]`
`sensor_sensor_status`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[sensor_sensor_status]0..*-user 1>[admin_user]`
`sensor_type`	`calibrationTypes`	Many-to-many	`0..*`	`0..*`	`sensor_calibration_type`	`[sensor_type]0..-calibrationTypes 0..>[sensor_calibration_type]`
`sensor_type`	`properties`	Many-to-many	`0..*`	`0..*`	`sensor_property`	`[sensor_type]0..-properties 0..>[sensor_property]`
`service_report_criterion`	`reportTypes`	Many-to-many	`0..*`	`0..*`	`service_report_type`	`[service_report_criterion]0..-reportTypes 0..>[service_report_type]`
`service_report_criterion_type`	`category`	Many-to-one	`0..*`	`1`	`service_report_criterion_category`	`[service_report_criterion_type]0..*-category 1>[service_report_criterion_category]`
`service_report_criterion_version`	`criterion`	Many-to-one	`0..*`	`1`	`service_report_criterion`	`[service_report_criterion_version]0..*-criterion 1>[service_report_criterion]`
`service_report_criterion_version`	`reportVersion`	Many-to-one	`0..*`	`1`	`service_report_version`	`[service_report_criterion_version]0..*-reportVersion 1>[service_report_version]`
`service_report_criterion_version`	`type`	Many-to-one	`0..*`	`1`	`service_report_criterion_type`	`[service_report_criterion_version]0..*-type 1>[service_report_criterion_type]`
`service_report_version`	`equipmentService`	Many-to-one	`0..*`	`1`	`service_service`	`[service_report_version]0..*-equipmentService 1>[service_service]`
`service_report_version`	`reportType`	Many-to-one	`0..*`	`1`	`service_report_type`	`[service_report_version]0..*-reportType 1>[service_report_type]`
`service_service`	`equipment`	Many-to-one	`0..*`	`1`	`equipment_equipment`	`[service_service]0..*-equipment 1>[equipment_equipment]`
`service_service`	`externalCompany`	Many-to-one	`0..*`	`0..1`	`organisation_external_company`	`[service_service]0..*-externalCompany 0..1>[organisation_external_company]`
`service_service`	`modules`	Many-to-many	`0..*`	`0..*`	`equipment_module`	`[service_service]0..-modules 0..>[equipment_module]`
`service_service`	`place`	Many-to-one	`0..*`	`0..1`	`service_event_place`	`[service_service]0..*-place 0..1>[service_event_place]`
`service_service`	`serviceType`	Many-to-one	`0..*`	`1`	`service_service_type`	`[service_service]0..*-serviceType 1>[service_service_type]`
`service_service`	`team`	Many-to-one	`0..*`	`1`	`organisation_team`	`[service_service]0..*-team 1>[organisation_team]`
`service_service_checklist`	`service`	Many-to-one	`0..*`	`1`	`service_service`	`[service_service_checklist]0..*-service 1>[service_service]`
`service_service_event`	`externalCompany`	Many-to-one	`0..*`	`0..1`	`organisation_external_company`	`[service_service_event]0..*-externalCompany 0..1>[organisation_external_company]`
`service_service_event`	`place`	Many-to-one	`0..*`	`0..1`	`service_event_place`	`[service_service_event]0..*-place 0..1>[service_event_place]`
`service_service_event`	`service`	Many-to-one	`0..*`	`1`	`service_service`	`[service_service_event]0..*-service 1>[service_service]`
`service_service_event_checklist`	`event`	Many-to-one	`0..*`	`1`	`service_service_event`	`[service_service_event_checklist]0..*-event 1>[service_service_event]`
`service_service_event_checklist`	`user`	Many-to-one	`0..*`	`0..1`	`admin_user`	`[service_service_event_checklist]0..*-user 0..1>[admin_user]`
`service_service_event_document`	`event`	Many-to-one	`0..*`	`1`	`service_service_event`	`[service_service_event_document]0..*-event 1>[service_service_event]`
`service_service_event_document`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[service_service_event_document]0..*-user 1>[admin_user]`
`service_service_event_document_file`	`document`	Many-to-one	`0..*`	`1`	`service_service_event_document`	`[service_service_event_document_file]0..*-document 1>[service_service_event_document]`
`service_service_event_property`	`event`	Many-to-one	`0..*`	`1`	`service_service_event`	`[service_service_event_property]0..*-event 1>[service_service_event]`
`service_service_event_property`	`property`	Many-to-one	`0..*`	`1`	`service_property`	`[service_service_event_property]0..*-property 1>[service_property]`
`service_service_event_report`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[service_service_event_report]0..*-user 1>[admin_user]`
`service_service_event_report`	`version`	Many-to-one	`0..*`	`1`	`service_report_version`	`[service_service_event_report]0..*-version 1>[service_report_version]`
`service_service_event_report`	`event`	One-to-one	`0..1`	`1`	`service_service_event`	`[service_service_event_report]0..1-event 1>[service_service_event]`
`service_service_event_report_result`	`criterionVersion`	Many-to-one	`0..*`	`1`	`service_report_criterion_version`	`[service_service_event_report_result]0..*-criterionVersion 1>[service_report_criterion_version]`
`service_service_event_report_result`	`eventReport`	Many-to-one	`0..*`	`1`	`service_service_event_report`	`[service_service_event_report_result]0..*-eventReport 1>[service_service_event_report]`
`service_service_property`	`property`	Many-to-one	`0..*`	`1`	`service_property`	`[service_service_property]0..*-property 1>[service_property]`
`service_service_property`	`service`	Many-to-one	`0..*`	`1`	`service_service`	`[service_service_property]0..*-service 1>[service_service]`
`service_service_type`	`properties`	Many-to-many	`0..*`	`0..*`	`service_property`	`[service_service_type]0..-properties 0..>[service_property]`
`substrate_io`	`runSubstrate`	Many-to-one	`0..*`	`0..1`	`run_substrate`	`[substrate_io]0..*-runSubstrate 0..1>[run_substrate]`
`substrate_io`	`substrate`	Many-to-one	`0..*`	`1`	`substrate_substrate`	`[substrate_io]0..*-substrate 1>[substrate_substrate]`
`substrate_io`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[substrate_io]0..*-user 1>[admin_user]`
`substrate_substrate`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[substrate_substrate]0..-file 0..>[file_file]`
`substrate_substrate`	`location`	Many-to-one	`0..*`	`0..1`	`room_location`	`[substrate_substrate]0..*-location 0..1>[room_location]`
`substrate_substrate`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[substrate_substrate]0..*-project 0..1>[organisation_project]`
`substrate_substrate`	`type`	Many-to-one	`0..*`	`1`	`substrate_type`	`[substrate_substrate]0..*-type 1>[substrate_type]`
`substrate_substrate`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[substrate_substrate]0..*-user 1>[admin_user]`
`substrate_substrate_property`	`property`	Many-to-one	`0..*`	`1`	`substrate_property`	`[substrate_substrate_property]0..*-property 1>[substrate_property]`
`substrate_substrate_property`	`substrate`	Many-to-one	`0..*`	`1`	`substrate_substrate`	`[substrate_substrate_property]0..*-substrate 1>[substrate_substrate]`
`substrate_type`	`properties`	Many-to-many	`0..*`	`0..*`	`substrate_property`	`[substrate_type]0..-properties 0..>[substrate_property]`
`template_changelog`	`template`	Many-to-one	`0..*`	`1`	`template_template`	`[template_changelog]0..*-template 1>[template_template]`
`template_changelog`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[template_changelog]0..*-user 1>[admin_user]`
`template_measurement`	`step`	One-to-one	`0..1`	`1`	`template_step`	`[template_measurement]0..1-step 1>[template_step]`
`template_measurement_label`	`measurement`	One-to-one	`0..1`	`1`	`template_measurement`	`[template_measurement_label]0..1-measurement 1>[template_measurement]`
`template_measurement_logging_parameter`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[template_measurement_logging_parameter]0..*-loggingParameter 1>[equipment_logging_parameter]`
`template_measurement_logging_parameter`	`measurement`	Many-to-one	`0..*`	`1`	`template_measurement`	`[template_measurement_logging_parameter]0..*-measurement 1>[template_measurement]`
`template_part`	`parent`	Many-to-one	`0..*`	`0..1`	`template_part`	`[template_part]0..*-parent 0..1>[template_part]`
`template_part`	`root`	Many-to-one	`0..*`	`0..1`	`template_part`	`[template_part]0..*-root 0..1>[template_part]`
`template_part`	`template`	Many-to-one	`0..*`	`1`	`template_template`	`[template_part]0..*-template 1>[template_template]`
`template_release`	`template`	Many-to-one	`0..*`	`1`	`template_template`	`[template_release]0..*-template 1>[template_template]`
`template_release`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[template_release]0..*-user 1>[admin_user]`
`template_requirement`	`requirementStep`	Many-to-one	`0..*`	`0..1`	`template_step`	`[template_requirement]0..*-requirementStep 0..1>[template_step]`
`template_requirement`	`measurement`	One-to-one	`0..1`	`1`	`template_measurement`	`[template_requirement]0..1-measurement 1>[template_measurement]`
`template_requirement`	`step`	One-to-one	`0..1`	`1`	`template_step`	`[template_requirement]0..1-step 1>[template_step]`
`template_requirement_label`	`templateRequirement`	One-to-one	`0..1`	`1`	`template_requirement`	`[template_requirement_label]0..1-templateRequirement 1>[template_requirement]`
`template_requirement_target`	`loggingParameter`	Many-to-one	`0..*`	`1`	`equipment_logging_parameter`	`[template_requirement_target]0..*-loggingParameter 1>[equipment_logging_parameter]`
`template_requirement_target`	`requirement`	Many-to-one	`0..*`	`1`	`template_requirement`	`[template_requirement_target]0..*-requirement 1>[template_requirement]`
`template_step`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[template_step]0..-file 0..>[file_file]`
`template_step`	`processModule`	Many-to-one	`0..*`	`1`	`process_module`	`[template_step]0..*-processModule 1>[process_module]`
`template_step`	`processModuleRecipeVersion`	Many-to-one	`0..*`	`0..1`	`process_module_recipe_version`	`[template_step]0..*-processModuleRecipeVersion 0..1>[process_module_recipe_version]`
`template_step`	`stepGroup`	Many-to-one	`0..*`	`0..1`	`template_step_group`	`[template_step]0..*-stepGroup 0..1>[template_step_group]`
`template_step`	`tag`	Many-to-many	`0..*`	`0..*`	`organisation_project_tag`	`[template_step]0..-tag 0..>[organisation_project_tag]`
`template_step`	`template`	Many-to-one	`0..*`	`1`	`template_template`	`[template_step]0..*-template 1>[template_template]`
`template_step`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[template_step]0..*-user 1>[admin_user]`
`template_step_label`	`templateStep`	One-to-one	`0..1`	`1`	`template_step`	`[template_step_label]0..1-templateStep 1>[template_step]`
`template_step_parameter`	`parameter`	Many-to-one	`0..*`	`1`	`process_parameter`	`[template_step_parameter]0..*-parameter 1>[process_parameter]`
`template_step_parameter`	`step`	Many-to-one	`0..*`	`1`	`template_step`	`[template_step_parameter]0..*-step 1>[template_step]`
`template_step_parameter`	`unit`	Many-to-one	`0..*`	`0..1`	`process_unit`	`[template_step_parameter]0..*-unit 0..1>[process_unit]`
`template_step_parameter_value`	`consumable`	Many-to-one	`0..*`	`0..1`	`consumable_consumable`	`[template_step_parameter_value]0..*-consumable 0..1>[consumable_consumable]`
`template_step_parameter_value`	`stepParameter`	Many-to-one	`0..*`	`1`	`template_step_parameter`	`[template_step_parameter_value]0..*-stepParameter 1>[template_step_parameter]`
`template_template`	`file`	Many-to-many	`0..*`	`0..*`	`file_file`	`[template_template]0..-file 0..>[file_file]`
`template_template`	`project`	Many-to-one	`0..*`	`0..1`	`organisation_project`	`[template_template]0..*-project 0..1>[organisation_project]`
`template_template`	`sampleType`	Many-to-one	`0..*`	`0..1`	`run_sample_type`	`[template_template]0..*-sampleType 0..1>[run_sample_type]`
`template_template`	`team`	Many-to-one	`0..*`	`0..1`	`organisation_team`	`[template_template]0..*-team 0..1>[organisation_team]`
`template_template`	`trayType`	Many-to-one	`0..*`	`0..1`	`run_tray_type`	`[template_template]0..*-trayType 0..1>[run_tray_type]`
`template_template`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[template_template]0..*-user 1>[admin_user]`
`template_template_role`	`role`	Many-to-one	`0..*`	`1`	`template_role`	`[template_template_role]0..*-role 1>[template_role]`
`template_template_role`	`template`	Many-to-one	`0..*`	`1`	`template_template`	`[template_template_role]0..*-template 1>[template_template]`
`template_template_role`	`user`	Many-to-one	`0..*`	`1`	`admin_user`	`[template_template_role]0..*-user 1>[admin_user]`
`template_template_variable`	`stepParameterValue`	One-to-one	`0..1`	`1`	`template_step_parameter_value`	`[template_template_variable]0..1-stepParameterValue 1>[template_step_parameter_value]`

28 August 2026