title: Database design for wishlist
body: <p>I am currently working on small travel application in which users can add other users' trips in their wishlist. I am facing difficulty in designing database for wishlist.</p>
  
  <p>What I have tried so far is:</p>
  
  <pre><code> user (user_id(pk), user_name)
  
   trip(trip_id(pk), trip_name, user_id(fk))
  
   wishlist(trip_id(fk), user_id(fk))
  </code></pre>
  
  <p>But, since  multiple users can add multiple trips into their wishlist, How to associate these relations?</p>
  
  <p>And if user retrieves his personal wishlist, the associated trips in the wishlist for 'that' particular user can be shown?</p>
  
  <p><strong>EDIT:</strong> </p>
  
  <p>For clarification, the problem is: <strong>One user can have multiple trips and many users can add each-other's trips to their one 'own' wishlist"</strong></p>