Ben Reiniger wrote on Sun, Nov 19, 2017 12:21 PM EST:
I made the Tags table. I think I was intending to have a separate table of (ItemID, tagID) for the actual tagging of pages. I wanted to display a page for each tag, which would have tagParagraph as a long-ish descriptor, followed by a list of games tagged. tagSentence was meant for a mouse-hover helptext, and/or the short description used in an index page of all tags.
I had invisioned a heirarchy of tags, which is what tagParent was for. For example, a tag "drops" might have children "pocket" (for self-pocketing pieces), "turncoat" (for dropping captured opponent pieces), etc.
I'm not sure if the number of users giving a game the same tag is particularly useful on this site. On the other hand, I was thinking of tags mostly describing the game, and I suppose you could have tags about player preferences, which would care a lot about number of responses.
I made the Tags table. I think I was intending to have a separate table of (ItemID, tagID) for the actual tagging of pages. I wanted to display a page for each tag, which would have tagParagraph as a long-ish descriptor, followed by a list of games tagged. tagSentence was meant for a mouse-hover helptext, and/or the short description used in an index page of all tags.
I had invisioned a heirarchy of tags, which is what tagParent was for. For example, a tag "drops" might have children "pocket" (for self-pocketing pieces), "turncoat" (for dropping captured opponent pieces), etc.
I'm not sure if the number of users giving a game the same tag is particularly useful on this site. On the other hand, I was thinking of tags mostly describing the game, and I suppose you could have tags about player preferences, which would care a lot about number of responses.