option column for flagging deletes allowing unique keys to work properly