I've always hated "isDeleted" flags because it adds something that you have to remember to every query you write.
I would almost prefer some way to "ghost" a row where without a specific switch the DBMS will never return it from a query.
I would almost prefer some way to "ghost" a row where without a specific switch the DBMS will never return it from a query.