On 8 April 2010 08:07, Joe <[email protected]> wrote: > My schema looks like > > create_table "people", :force => true do |t| > t.string "name" > t.string "sex" > t.integer "father_id" > t.integer "mother_id" > end
PS Here's a couple of links to DB designs for family relationships: http://www.familyhistorysa.info/dbDesign.html http://www.databaseanswers.org/data_models/genealogy/index.htm And here's one for modelling marriages (not strictly what you're talking about, but the principle of husband/wife not being as simple as first thought is similar to your issue with mother/father): http://qntm.org/gay -- 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.
