On 23 March 2012 16:48, bingo bob <[email protected]> wrote: > Colin Law wrote in post #1052938: >> On 23 March 2012 09:24, bingo bob <[email protected]> wrote: >>> "owned" by different users who may have it as a different position in >>> Freddy >>> Rod (3, male) >> A couple of questions >> Are all the Rod records identical except for which user they belong to? > > No they're not - for example one user might have rod as position 3 and > another user might love the name and have it as the number 1 choice. > >>> Freddy (2, male) >> >> What if one of the Freddys is female? Maybe not likely with this name >> but there are names that can be both. > > True - in my system the user simply designates a name as either M or F, > gender is an attribute of name...quite possible to have the same name as > both M and F and rightly so, actually current schema attached in case it > helps.
In that case your problem is more complex as you need to differentiate between the m and f Freddys, presumably. So in your example you would need Freddy(1, female) and Freddy(1,male) Colin > > Attachments: > http://www.ruby-forum.com/attachment/7181/schema.rb > > > -- > Posted via http://www.ruby-forum.com/. > > -- > 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 [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. > -- gplus.to/clanlaw -- 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 [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.

