¶ requirements and scenarios driving the model
IMPEXP: at some point I prefer to export the data (areas and tasks), edit with my text editor and re-import
- the areas "workout" with id=734 must be re-imported with the same id. → the id must be valid user-wise, not system-wide.
SCD: at some point I delete a goal or I rename an area or a migrate a task to a different area
- the past is gone. That implies that the user_hour dataset must be detached from the live areas & tasks data model. No foreign keys.
- the delete should be logical and the id of areas and tasks should not be reassigned.
back to app-planner