[Top][All Lists]

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

Re: [Gnumed-devel] Questions re database schema:street:address:urb:count

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Date: Tue, 31 Aug 2004 11:56:32 +0200
User-agent: Mutt/

> > I take it that public.street  is an attempt to normalise street names, if 
> > so, 
> > why is _urb and postcode included in this.
> Yes. The idea is that is several patients live on one street, there is only
> one entry in street.
However, with a twist. One cannot securely normalize out
"street". It is far safer to normalize out
"street-at-urb-with-postcode" -- which is what we do here.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

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