Hi there people. After lot of reading regarding how Rails works (controllers,models,views,routing,templating etc) and doing some tutorial apps, I've decided to start building my own application. It will be a real-world app that my and the other members of my team will use.
It will be a project management & collaboration app, crafted to fit exactly our needs: We have an online store running so we want to have a place where we will be able to post TO-DOs, ideas & messages. Now let's get to the point: These are the database tables as of now (I'm ommiting the ideas & messages tables since they're similar to the todos): [ users ] [ sections ] [ subsections ] [ todos ] The main point is that first of all will be sections, for example "Site design", "Marketing & Promotion", "Checkout process" etc. I might call this table Projects instead, not sure about that yet. Now, a section may (or may not) have one or more subsections. For example the "Site design" section may have a "Footer" subsection and a "Logo" subsection. Inside these subsections (or if there aren't any, straight inside the section) there will be to-do lists, messages & ideas. I hope you get the point by now. Well, now comes the important part, the associations. These are my initial thoughts which I think are kinda off, since there's a problem if I decide to use a seperate table for the subsections, because the to-dos etc maybe also in a section. So this is my question for now: should I have a separate table for subsections or should I do it with one table only (sections)? In other words, I want to implement a "nested sections" system. [ sections ] has_many: [ subsections ] [ subsections ] belongs_to: [sections] After I solve this issue, the other tables relations would be like this: [ sections ] (or subsections) has_many: todos [ todos ] belongs_to: sections -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/Ka5e2dAxFDkJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
