[unicornfinder]

That and why not allow null for the foreign key constraint and set it to nullify upon deletion? Or indeed, anonymise data.

[sopooneo]

I have used that pattern in my apps and found it works well. But then I've watched video from respected DB experts, that I learn a great deal from, where they practically beg you to stop using nullable columns.

So I'm torn, because I think there may just be a major problem I've not yet grown my apps big enough to suffer. Anyone have thoughts either way?

[dmux]

Any particular videos you'd recommend?