[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: Horst Herb
Subject: Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Date: Tue, 31 Aug 2004 20:26:23 +1000
User-agent: KMail/1.6.2

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 


reply via email to

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