[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 00:29:56 +1000
User-agent: KMail/1.6.2

On Mon, 30 Aug 2004 08:22, Richard Terry 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)
>          How come has not got an address type_ID (eg mailing/home/office
> etc
> if id_street is aforeign key for public.street, how come public.street has
> id_urb, and id_postcode?

suburb was not there in the original version, don't know who put it there, 
it's a mistake.
id_street is indeed a foreign key and there should be a "references 
street(id)" after the deinition of the id_street column.

street of course needs urb and postcode, because that's needed to uniquely 
identify a street (large urbs can have several streets of the same name, but 
then they are generally allocated different postcods)


reply via email to

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