Thanks for the explanation.

The first case I was thinking about was a merger of two accounts. Second case would be a db-wide update of one or more keys for some reason. That’s why I tend to leave it ON UPDATE CASCADE.

Although both of these cases are more diffuse muscle memory than rational foresight.