Just out of curiosity, it seems like a lot of people are putting a lot of faith in foreign key constraints I'm wondering why? Compared to a primary key or unique constraint where I can tell you exactly what it's enforcing all a foreign key constraint enforces is that some arbitrary matching record exists in the parent table? A foreign key has no way of knowing whether it's referencing the right record at all and no way to handle errors when something goes wrong.