Scratch a simple data model, find a complex one

I seem to have a knack for discovering corner cases – or in many situations being a corner case. One category of this is where I find myself using a data model which appears simple to start with – and then the real world interferes. I’ve always found this sort of thing interesting, and recently I’ve come across a pretty good example which I...