Postgres Pro
Downloads
Home   >   mailing lists

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

From gargoyle60
Subject Re: Table-design for categories, suggestions needed
Date
Msg-id j33q5693gk91nbu98rc64audgkm873ah49@4ax.com
Whole thread Raw
In response to Table-design for categories, suggestions needed  (Rikard Bosnjakovic <rikard.bosnjakovic@gmail.com>)
Responses Re: Table-design for categories, suggestions needed  (Victor Hugo <vh.clemente@gmail.com>)
Re: Table-design for categories, suggestions needed  (Lew <noone@lewscanon.com>)
List pgsql-novice
Tree view 
On Fri, 06 Aug 2010 19:54:01 -0400, Lew <noone@lewscanon.com> wrote:

>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.

Something like that, probably with (category_level, category_code).
Like I said, I never got around to implementing the provisional design and there may be more to it
than that.

pgsql-novice by date:

Previous
From: Leon Starr
Date:
Subject: Re: Best way to test/develop lots of nested functions?
Next
From: Lew
Date:
Subject: Re: Table-design for categories, suggestions needed