Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why??

I've been wrestling with this for a while and can't quite figure out what's happening. I have a Card entity which c...