Re: Partial foreign keys, check constraints and inheritance

> On 11/17/05, Eric E  wrote:
> >
> > What's the best way to do this?  My immediate reaction is that I want a
> > partial foreign key, but perhaps this is not a good way to go about such
> > a design.  

Normally I just have multiple columns with all but one NULL.

Alternatively you can make it a many-to-many relationship. So you have a
problem table and then you have a problem_product, problem_customer, and a
problem_order table.

-- 
greg