[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/1.3.22.1i |
> > 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.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] Questions re database schema:street:address:urb:country, (continued)
Re: [Gnumed-devel] Questions re database schema:street:address:urb:country, Ian Haywood, 2004/08/31
- Re: [Gnumed-devel] Questions re database schema:street:address:urb:country,
Karsten Hilbert <=
Re: [Gnumed-devel] Questions re database schema - naming, Karsten Hilbert, 2004/08/31
Re: [Gnumed-devel] Questions re database schema - nomenclature, Karsten Hilbert, 2004/08/31
Re: [Gnumed-devel] Questions re database schema - normalization, Karsten Hilbert, 2004/08/31
Re: [Gnumed-devel] Questions re database schema:street:address:urb:country, sjtan, 2004/08/31