Delete records in database instead of using "deleted" flag

Currently only a flag is used to indicate a deleted record.

We should use the room code as a key and remove the entire record to improve indexing

It will also reduce disk space usage and be more GDPR friendly