title: Assigned multiple users to a 'task'
body: <p>Okay so I'm creating a task manager for my company. A user can assign assign a task to multiple other users. So I've though of 2 ways of implementing this.</p>
  
  <p>This is my tasks table for option one (at least the columns that are important in this discussion ):</p>
  
  <pre><code>----------------------------------------------
  |   id   |   assigned_to   | assigned_from   |
  ---------------------------------------------
  |   1    |    1,3,6       |      4           |
   --------------------------------------------
  |   2    |      1,4        |      2         |
  ---------------------------------------------
  </code></pre>
  
  <p>So here I pretty much just comma separate each user_id that is assigned to this particular task</p>
  
  <p>Option 2:</p>
  
  <pre><code>----------------------------------------------------------
  |   id   |   task_id   |   assigned_to   | assigned_from   |
  ------------------------------------------------------------
  |   1    |   335901    |      1          |      4          |
   -----------------------------------------------------------
  |   2    |   335901    |      3         |       4          |
  -----------------------------------------------------------
  |   3    |   335901    |      6         |       4          |
  -----------------------------------------------------------
  |   4    |   564520    |      1         |       2          |
  -----------------------------------------------------------
  |   4    |   564520    |      4         |       2          |
  -----------------------------------------------------------
  </code></pre>
  
  <p>So as you can see here instead of putting the assiged_to is's here I just create a task id which is a random number and then I can groupBy 'task_id'. This is currently they way I have built it but for some reason it feels like it might screw me over in the future (not that option one doesn't give me the same feeling). So my question is which way do you guys recommend or is there maybe a different better way that I could be doing this?</p>