I’m starting to build a simple (?!) FAQ system, and I’d like some
advice on setting up the model relationships.
I was going to go with a simple system of a Category table and a FAQ
table (holding questions and answers) - where one FAQ belongs to one
That’s all nice - a simple has_many / belongs_to relationship. Then I
decided to add another level - Area. So I could make the system work
for a wider audience (IT area has it’s own categories and FAQ’s, Sales
area has it’s own categories and FAQ’s, etc.)
I’m not sure how the best way to set this up - areas has_many
categories has_many faqs, or areas has_many faqs and categories
Given the page will probably have a menu at the top to select the
area, then will display the categories and faqs (with searching, etc.)
ie. For area X, I’d need to select the faqs in that area, or the faqs
within a category of an area.