added soft delete and published field on project