Reference & Data Model
Equipment usage (equipment_usage)
An equipment usage assigns a piece of equipment from the master data to a task.
Purpose
Section titled “Purpose”The equipment usage records which equipment a task needs. The Optimizer creates equipment bookings from it and checks unavailabilities. (Transactional data)
Where in the app
Section titled “Where in the app”Task › sheet „Ressourceneinsatz“ (Resource usage) › equipment table (columns „Symbol“, „Titel“, „Bezeichnung“, „Seriennummer“ — icon, title, designation, serial number). „+“ opens „Neues Equipment hinzufügen“ (Add new equipment) with a search across active equipment. „Equipmenteinsatz entfernen“ (Remove equipment usage) deletes the row.
Fields
Section titled “Fields”| Field | Technical | Type | Required | Meaning | Notes |
|---|---|---|---|---|---|
| Equipment | equipment_id |
Reference | yes | Selected equipment (title, key, serial number from Equipment) | Only active equipment selectable; once per task |
| Task | task_id |
Reference | no (always set) | Task of the usage |
Not displayed: cadence_kind, usage_hours, cadence (system; the user interface always sets „Durchgehend“ (throughout)).
Relations
Section titled “Relations”| Related to | Kind | Required | On archive | On delete |
|---|---|---|---|---|
| Equipment | belongs to | yes | — | deleted along |
| Task | belongs to | no | archived along | deleted along |
| Equipment booking | has many | — | kept | deleted along |
Rules & automation
Section titled “Rules & automation”- No effort value; the Optimizer books the equipment across the whole task window (Optimizer commit).
- Equipment unavailabilities within the booked period appear as the conflict „Gebucht & Ausfall“ (booked & unavailable).
Equipment utilization and conflicts – see Resources & workload.