This line checks that the foreign key matches the primary key of the referred table. This is needlessly restrictive as foreign keys are allowed to point to unique constraints too.

I was trying to work around persistent's inability to define unique constraints that involve the id key, but now I've been hamstrung by the fact that even if I define them myself I can't define the proper foreign keys because they are different from the primary key...