[thelist] Foreign Key constraints

Andrew Kamm akamm at demicooper.com
Fri Jun 9 09:50:30 CDT 2006

> One way to deal with this is not to delete records from your reference tables.
> Use an active / inactive flag instead. This way as you assign new
> relationships you pull only those records that are active. And those that are
> inactive, still have a relationship - they just won't get more relationships
> assigned.

Actually I did build that in (an 'Active' column on things like this). So I
guess I'll just ditch those foreign keys.

I wonder if other DB's handle FK's the same way (MySQL 5+, PostgreSQL, etc).

Thanks for the response-

Andrew Kamm

More information about the thelist mailing list