[Top][All Lists]

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

Re: [Gnumed-devel] Sorry, but gmgis and gmidentity have changed

From: Horst Herb
Subject: Re: [Gnumed-devel] Sorry, but gmgis and gmidentity have changed
Date: Mon, 8 Apr 2002 22:29:35 +1000

On Mon, 8 Apr 2002 21:40, Karsten Hilbert wrote:
> Address is of type (adr_id_pivot.type == home) for person 1
> but of type (adr_id_pivot.type == holidy) for person 2 and
> thereby avoid duplication of address 1 which wouldn't be
> possible if adr_type was an attribute of the address table
> itself ?

That's the whole point of normalisation. If you look back at my old SQL 
scripts before I broke the monolithic database into "services", you will 
see that it always has been that way - this bug was introduced when I, 
tired as I was, broke the tables up the wrong way without thinking.


reply via email to

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