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

[Richard Terry]

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