DIY primary/foreign key relationships, again

One table has a primary key field and the other has a foreign key field that should refer back to the first table. This isn’t always the case, because the tables don’t’t always come from a database with referential integrity. Sometimes the two tables have their primary and foreign keys entered manually. This post describes a shell script that checks for this and related problems.