[Feature]: Soft delete transactions

[RubenLWF]

What would you like?

I would like transactions (And other entities that can be deleted through the frontend) to be soft deleted when they are deleted through the frontend.

Why is this needed?

Sometimes, when an issue occurs with a transaction, this transaction is deleted before the bug can be investigated. If the database entry is deleted, it is very difficult to debug.

How could it be implemented?

This can be accomplished by adding a deleted_at column to the relevant tables. When the entity should be deleted, rather than dropping the row, we set the value of the cell to the current timestamp. (We will need to make sure that GET endpoints ignore rows where this cell has a value.

Other information

No response

[JustSamuel]

This does mean we need to change the balance query, which is almost forbidden by the gods. A possibility would be a "credit transfer".