In parts this may depend on the table structure.
I would avoid having too much tables here (forum + category) and
if possible go for a single table.
But in general avoid duplicate data. If a topic is linked to
a sub category and this sub category is already linked
to a category, there is not much need in adding another
field to the topic. That would just bring the risk, that the
data gets inconsistent if you need to relink the subforum
You should provide a function that for a given forum gets the ids of
all subforums (including sub sub forums, categories…) and
then get all the topics linked with those forum ids
For example, I was reading a tutorial earlier in which the author
demonstrated that you can make a Forum “has_many :posts, :through =>
:topics”, but you can’t make it “has_many :users, :through => :posts”,
because the relationship won’t go that deep.
So I wonder if it’s even possible for a Forum to have sub-categories
through categories through sub-forums.
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.