Hi everyone,

I'm having some trouble with my models, here's the case.

I have an Activity table, wich has many Task ( another table), and
then I have a table called Assignment.
Between Assignment and Activity there's a many-to-many relation, so I
have another table AssignmentActivity

When I want to enter data I start by filling activities, after that I
create a group of tasks for that activity. Lets say that I have create
5 activities and each one has 7 tasks.

Now I create an assignment, and after that I create the activities for
this assignment. Let's say that I only choose 3 of the 5 activities
and for those 3 activites I only choose 2 tasks of the 7 I had. If
thats the case I've made my tables this way

Activity Task

Assignment AssignmentActivity

But I realized that the difference between ASSIGNMENTACTIVITY and
ACTIVITY table is only 3 columns, and it happens the same between TASK
and ASSIGNMENTACTIVITYTASK, and I'm not sure if I could use single
table inheritance in this case, or maybe I'm doing it in a wrong way.

Is my approach ok? Hope someone can help me with this

Thanks in advance

Javier Q.

You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouprubyonrails-talk @
postedDec 29, '11 at 7:00p
activeDec 29, '11 at 7:00p

1 user in discussion

JavierQQ: 1 post



site design / logo © 2022 Grokbase