Creating a database to utilize hashtags
I was trying to do research on Twitter's use of hashtags, as well as Flickr's. However, all I found were support articles for people to place them in their posts, not the actual development side of how to store it.
I know the # will be used to "scrape" it out of a post and store it in a table if it hadn't already been entered, but I was curious of that table was one BIG table - or segmented into categories such as "Comments", "Tags" (for a profile or YouTube video even). Then I know they probably have a relational table that binds the hashtag one to whatever content was posted.
Does anyone know of a data model that coinsides with best practices? I just want to make sure I do it right.
Thanks in advance! Feel free to ask me other questions if I hadn't really described it well.