What if instead of creating forums and subforums, we could assign "labels" to posts, just like the way you can label emails in Gmail? Kinda hard to explain but here's an example:
- A user starts a thread: "Shaq to be traded in 3 team deal"
- The user then assigns the following labels to that post: NBA Rumors, LA Lakers, Houston Rockets, Orlando Magic.
- Now you can visit any of those four forums (NBA Rumors, LA Lakers, Houston Rockets, Orlando Magic) and that same post will be shown in each one.
What do you guys think? I'm not a database specialist...would the database queries be realistic/reasonable? Could someone try to do this?