Postgres Pro
Downloads
Home   >   mailing lists

Re: Table-design for categories, suggestions needed - Mailing list pgsql-novice

From Lew
Subject Re: Table-design for categories, suggestions needed
Date
Msg-id i3i79q$ad0$1@news.albasani.net
Whole thread Raw
In response to Table-design for categories, suggestions needed  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
List pgsql-novice
Tree view 
On 08/05/2010 04:06 AM, gargoyle60 wrote:
> Oops, that should read...
>       ...
>         FOREIGN KEY (parent_level)
>             REFERENCES category (category_level)

So category (category_level) is a unique or primary key, then.

--
Lew

pgsql-novice by date:

Previous
From: gargoyle60
Date:
Subject: Re: Table-design for categories, suggestions needed
Next
From: Victor Hugo
Date:
Subject: Re: Table-design for categories, suggestions needed