The other party, i.e. the recipient still has an copy, so it could be a DB flag indeed. Although when both persons delete the message it might still lay around for who knows how long.