[thelist] Tables referencing each other

[Matt Warden]

On Wed, Mar 25, 2009 at 1:32 PM, Bill Moseley <moseley at hank.org> wrote:
>        current_profile integer NOT NULL

This is an example of problems that can be created from data modeling
issues. You have an attribute in your customer table that describes
the active/current status of a profile. Move this status information
to the profile table itself.

Good luck,

-- 
Matt Warden
Cincinnati, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.