#68 Support Soft deletes to preserve record integrity and sync

[peppervine]

Add a record status flag to all entities and perform a soft delete for better performance and for keeping a change log for sync . Hard delete would only be performed by scheduled cleanup routines which will wipe the relations clean.