title: Friends table for a social networking site
body: <p>I have been working on a social networking site. Here a user requests another user to be his friend (friend request). I thought of a 'Friends' table which looks like</p>
  
  <pre><code>Table Name: Friends
  Coloumns :
      User1   - Int - FK
      User2   - Int - FK
      Request - Enum('0','1')
      Time    - DateTime
  
  PK - (User1, User2)
  </code></pre>
  
  <p>In Request field '0' is stored when a request is made by User1 to User2 and '1' is stored when the request has been approved by User2.</p>
  
  <p>The problem arises when i want to retrieve all friends of a user. I had to check whether the Request field is '0' or '1' each time. Is there another way to do so? Is it better if i have another table which stores all the details of Friend requests?</p>