Doo Suk Yang wrote:
>
> I'm novice in database world.
> Now I have to make design a database where categorized items should be
> stored. It resembles the structure something like seen in Yahoo.
>
> Thanks for reading and generous comments of yours.
I do it something like this..
create table category (title text, category oid);
so that categories have parent categories. If the category attribute is
null then it's a parent category. For urllinks (like in yahoo) I have
create table urllink (title text, url text, category oid);