I''m trying to create a Secret Santa application. The basic entities are users, groups, relationships, and suggestions. (If User1 has a relationship with User2, then User1 will not be assigned to be Secret Santa for User2). I''m trying to figure out how to model this so that I can leverage Rails. The users table contains: id, full_name, email, username, password The groups table contains: id, group_name, group_password The relationships table contains: user1id, user2id, group_id The suggestions table contains: user_id, group_id, suggestion The users_groups table contais: user_id, group_id, assigned_pick I''m a bit confused as how to model the relationship between the users, relationships, and groups table. Also, the group_id is a foreign key in almost every table. Am I missing something here? Any feedback is greatly appreciated! --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---