Re: Database Schema for delicious ( Tag Structure)

friend.05 wrote:
> Hi,
>
> I have design database model for Tag structure. Do u think del.icio.us
> has same structure ?
> I am also including heirarchy of tags, which delicious has not
> implemented.
>
>
> Database Schema :
>
> create user ( userid integer,
> login varchar (255) )
>
>
> create tag ( tagid integer,
> tagname varchar (255)
> tagitemcount integer )
>
> create item ( itemid integer,
> itemdescription varchar (255),
> itemurl varchar (255) )
>
> create hierarchy ( hierarchyid integer,
> hierarchyname varchar(255) )
>
>
> All these tables I have consider has many - many to relation so
> associated tables will be there.
>
> create usertag ( userid integer
> tagid integer )
>
> create useritem ( itemid integer,
> userid integer )
>
> create tagitem ( tagid integer,
> itemid integer )
>
> create taghierarchy ( tagid integer,
> hierarchyid integer )
>
>
>
> I want to write query for popular tags. and queries related to tag
> database.
>
>
> Reference site :
>
> del.icio.us
> http://flickr.com/photos/tonreg/tags/landscape/

What language is that? Not valid SQL anyway. With not a single key in sight a list of column names doesn't tell us much and may generate false assumptions.

What is your question?

--
David Portas