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

[Horst Herb]

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.

Horst