Reference & Data Model
Equipment booking (equipment_booking)
An equipment booking is a period created by the Optimizer in which a piece of equipment is occupied for an equipment usage.
Purpose
Section titled “Purpose”The equipment booking occupies a device for the time window of a task. It serves the workload and conflict display for equipment. (Transactional data, system)
Where in the app
Section titled “Where in the app”Projekt & Portfolio › Ressourcenauslastung (Resource workload) › switch „Equipments“: bars per device, utilization badge, conflicts (Guides › Resource workload). Also taken into account in the „Auswirkung“ (impact) of unavailabilities. There is no dialog for manual creation.
Fields
Section titled “Fields”| Field | Technical | Type | Required | Meaning | Notes |
|---|---|---|---|---|---|
| Start | start |
Date + time | yes | Start of the occupation | System (Optimizer) |
| End | end |
Date + time | yes | End of the occupation | System (Optimizer) |
| Equipment | equipment_id |
Reference | yes | Occupied device | System |
| Equipment usage | equipment_usage_id |
Reference | yes | Associated usage (task) | System |
Not displayed: plan, type, address, optimization_run_id (system; the Optimizer sets plan = true, type = usage, address = project address).
Relations
Section titled “Relations”| Related to | Kind | Required | On archive | On delete |
|---|---|---|---|---|
| Equipment usage | belongs to | yes | kept | deleted along |
| Equipment | belongs to | yes | — | deleted along |
Rules & automation
Section titled “Rules & automation”- Created only when an Optimizer run is applied; earlier Optimizer bookings of the project are replaced in the process and removed on rollback (Optimizer commit).
- Conflict „Doppelbuchung“ (double booking) for overlapping bookings of the same device, „Gebucht & Ausfall“ (booked & unavailable) for overlap with an equipment unavailability.
Equipment utilization % (booked hours ÷ calendar hours in the active period), conflicts – see Resources & workload.