I am actually implementing onsite tags into lifetype. They should work similar to categories.
I am thinking about making everyting taggable: Users, Blogs, Articles, (Resources?) and it should be as easy as the technorati plugin ( seperating the tags with a commata)
I am actually thinking about which sql table structure to choose.
I've thought about a similar structure to the article_categories_link but I'd have to create 3 different tables, so I am actually thinking about creating just one big tags_link table.
The problem that would arise is that we have all different kind of ids mixed in this very table ... user ids, resource ids, articles ids, blog ids.
That's why I am asking for suggestions on which way to go. We'd also need some kind of boolean flag which shows whether it is a user, resource etc.
I added for testing purpose just a column with a text field with either 1 or 0 in it to indicate which kind of id this tag belongs to.
My favorite is the one big table solution. So you'd be easily able to get all tags e.g. for the summary, but you'd have to differentiate between all kind of different objects ...