Spaces must not be hard deleted
I don't like the fact that when I delete a Space, it gets completely deleted. Reservations show "Unassigned" for "Assigned Space", and it can be no longer retrieved via the API.
This basically breaks the referential integrity of the data, which is a rather serious issue. Such deletions should only be done as a soft delete - ie. the Space should be marked as deleted, and deletion date captured. It must no longer be assignable, but it should stay there so past reservations can still reference it.
We have buildings where we add / remove spaces from time to time, and this causes us serious issues when we try to understand how many rooms we had at any given moment in time. It also breaks referential integrity of data that we pull into our Data Warehouse.
Martin Hapl
shared this idea