On 10 May 2012 16:05, Greg Akins <angryg...@gmail.com> wrote: > > > On Thu, May 10, 2012 at 10:57 AM, Mauro <mrsan...@gmail.com> wrote: > >> I have problems on a simple design problem. >> I have many companies. Each company have one or more commercial activity. >> Activities types are: ecommerce, local unit, television, automatic >> vending machines, and so on. >> > > So can each Company have many CommercialActivities > > Then.. CommercialActivity is STI, which means it has a type column and > sub-types can be ECommerceActivity, TelevisionActivity, etc.. > > The only warning is that if each type is dramatically different, you might > want to investigate doing it with multiple tables so you dont have a lot of > redundant fields trying model things with additional attributes that aren't > shared. > > I think this post might help you > http://stackoverflow.com/questions/1634668/multiple-table-inheritance-vs-single-table-inheritance-in-ruby-on-rails > >
You can also use a project of mine (Super STI) to help you. It helps you use STI in Rails while keeping your database clean. Read about it at https://github.com/ihid/super_sti and http://www.ihid.co.uk/projects/super_sti Message me off-list if you want some help with using it. > -- > Greg Akins > http://twitter.com/akinsgre > > > > -- > 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+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > -- 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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
