title: Linking 2nd row to different database table, in rails
body: <p>lets say I have the Users table, and the Team table. </p>
  
  <p>In Rails, I know how to link the user_id column in the Team table to the Users table. But what if I have a second column I also want to link to the user's table, such as user_id2 (this essentially creates an order in the team table)?</p>
  
  <p>Is there a solution, or something I don't know about to do what I'm trying? I also don't think the "has_many" is what I'm looking for, because user_id might be the team manager, and user_id2 might be the team captain, i.e. they have different roles affiliated with them, and order is important. </p>
  
  <p>Thanks!</p>
  
  <p>Edit: for my purposes, I also wouldn't need more than these two user relations. (i.e. cases for three wont be relevant)</p>