Deleting elements should reflect correctly when reading

[isuru89]

Requirements:

• Once deleted, it should not be visible through read/list end points
• Once deleted, corresponding cache entries must be cleared
• Once deleted, an element should be able to add again with the same unique id
• Deletion history should be preserved for critical entities

Notes:

• Player records cannot be deleted. They should be soft-deleted.
• Team records cannot be deleted nor deactivated.
• Game records cannot be deleted
• Event sources can be deleted.
• Rule records can be deleted.