I always store a timestamp and have an "is_deleted" flag on the business object that checks if the "deleted_timestamp" is null or depending on the use case, whe

I always store a timestamp and have an "is_deleted" flag on the business object that checks if the "deleted_timestamp" is null or depending on the use case, whether the timestamp is in the future for records that are to be deleted. I can also use the timestamp later if I want to move deleted records to a different table or database to improve performance depending on requirements.