We're currently building an application where some of the data (for legal reasons) have an extra dimension - time.
For instance, we have a bunch of
locations that is owned by a single
company. However, a location might be sold from one company to another, and the users need to enter when this takes in effect (in the future or the past) as well as see the history over time for these updates. The dates are important, due to the legal aspect of it all.
Do you have any examples / best practices when working with time in this way?
Right now I'm thinking of opening a new screen when editing this data, allowing to input updates in a table-like view along the lines of:
Update company for location: New York
- Company Entity 1 - [DATE_FROM] -- [DATE_TO]
- Company Entity 2 - [DATE_FROM] -- [DATE_TO]
- Company Entity 3 - [DATE_FROM] -- [DATE_TO]
- Company Entity 4 - [DATE_FROM] -- [DATE_TO]
- Add new