My question here:
- what is the best strategy to expose data when it deals to the lifecycle of an object?
For example, I have work orders (let’s say about maintenance). It goes through different steps/statuses where it can be on-hold, paused, ongoing,finalized, etc.
If I want to fully expose this data later through Workshops, Machinery, etc., how should I build it?
- Events dataset ( From/To timestamps for each period of time)
- Logs dataset (only 1 From timestamp for each step)
Is there any pros/cons on both solutions? Should I create both (the logs dataset becoming the output of the event dataset?
Thanks for your feedbacks!!