On Fri, 06 Aug 2010 19:54:01 -0400, Lew <noone(at)lewscanon(dot)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.