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

[Horst Herb]

On Tue, 31 Aug 2004 19:53, Karsten Hilbert wrote:
> > > public.address
> > >           id serial NOT NULL,
> > >           id_street int4 NOT NULL, (presumably for key to
> > > public.street??) suburb text,    (then why not for key to public.urb)
> > > number char(10) NOT NULL,
> > >           addendum text, (what is addendum)
> >
> > suburb was not there in the original version, don't know who put it
> > there, it's a mistake.
>
> Well, no one spoke up when I put it there. I recently even
> asked how to handle it right here on the list. Also, WHY is it
> a mistake ? It makes perfect sense in DE.

An urb is definitely defined by urb name and country -> table for urbs
A street is definitely defined by urb plus postcode plus street name -> table 
for streets
And address is definitely defined by house number / flat number plus street -> 
address table
There is no place for (sub)urb in the address table if e follow the rules for 
normalization!

Horst