[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ShopSuite-dev] new shop.psql

From: Tomasz Wegrzanowski
Subject: Re: [ShopSuite-dev] new shop.psql
Date: Wed, 22 Aug 2001 02:32:43 +0200
User-agent: Mutt/1.3.20i

On Tue, Aug 21, 2001 at 08:07:47PM +0100, Davi Leal wrote:
> > There's a question whether we need active if we have inactivation
> > that may be NULL. I prefer second version, as active field gives no new 
> > data.
> > Following is always true:
> >     active ::= (inactivation != NULL)
> The " ::= (transform.inactivation != NULL)" rule is wrong. I
> think you mix the 'products' and 'transform' tables. On the one hand, the
> 'active' field of the table products means if a product has been removed or 
> not,
> that is to say, if it is active or not. On the other, the 'inactivation' field
> of the table transform shows if a 'transformid' is history, that is to say, 
> its
> 'inactivation' field IS NOT NULL; or if it is the current transform, that is 
> to
> say, its inactivation IS NULL. See below, and see the attached xfig figure.

Oops, you're right.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]