gnumed-devel
[Top][All Lists]
Advanced

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

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


From: Richard Terry
Subject: Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Date: Wed, 1 Sep 2004 08:03:27 +1000
User-agent: KMail/1.5.4

On Tue, 31 Aug 2004 07:53 pm, 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.

But it is a duplication of information (suburbs) contained in another table 
hence should be a foreign key.

Richard

>
> > id_street is indeed a foreign key and there should be a "references
> > street(id)" after the deinition of the id_street column.
>
> There is. Deficient viewers are in use here.
>
> Karsten





reply via email to

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