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@example.com.
To unsubscribe from this group, send email to firstname.lastname@example.org.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.