title: Database Design - "special" entry in one to many relationship
body: <p>Let's say I have two tables in a one-to-many relationship.  We'll call the first one Bros, and the second one Homies.  A bro can have multiple homies, but only one of which can be his 'main man'.</p>
  
  <p>(Look; examples are hard. Don't yell at me.)</p>
  
  <p>How would I represent that?  I could put a 'main_man' entry into the bros table, but that would duplicate entries I'd have in the homies table.</p>
  
  <p>I could also put an entry in the homies table, but that wouldn't restrict other homies from being the main man.</p>
  
  <p>Is there a proper way to do this?  Would it be easier to just do it a wrong way and handle it with the application instead?</p>