All the database entries are hard deleted from the database currently. This doesn't ensure data integrity.
Also, there is no track of the user who is creating or updating the table. If we do not maintain this, we won't be able to check for transaction info in the future.
Fix:
Set a flag deleted with every data entity that is being created and change it when the object is actually deleted.
Set created, update user and time fields in all the entities.
Problem:
Fix:
deletedwith every data entity that is being created and change it when the object is actually deleted.