[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