This is a technical table that contains the links between workorders and assets.
By definition, there is a many-to-many relationship between workorders and assets:
- 1 workorder can be linked to many assets, e.g. 1 maintenance task for a group of 6 elevators
- 1 asset can be part of many work orders over a period of time, e.g. monthly inspections per elevator
Any data engineer that wants to combine assets and workorders in reports and data analysis should include this link table in queries and data sets.
Data structure
| Column | Meaning | Comment |
|---|---|---|
| wo_id | Foreign database key of the workorder | |
| wo_reference | Reference of the workorder | e.g. WRK-123456 |
| asset_id | Foreign database key of the asset | |
| asset_reference | Reference of the asset | e.g. AST-12345 |
| wo_creation_datetime | Date and time of workorder creation | In local timezone |
| wo_update_datetime | Date and time of workorder creation | In local timezone |