[thelist] Foreign Key constraints

[Anthony Baratta]

I'd recommend leaving the Foreign Key Contraints in. This ensures data integrity for those columns you have contraints on.

-----Original message-----
From: Andrew Kamm akamm at demicooper.com
Date: Fri, 09 Jun 2006 06:53:21 -0700
To: theList thelist at lists.evolt.org
Subject: Re: [thelist] Foreign Key constraints

> > 
> > 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
>