title: Inventory design database with colors and sizes
body: <p>I'm planning on making a inventory database design to keep track of what we have in our shop. I'm thinking of storing an array in the database with all sizes and colors like:</p>
  
  <pre><code>array('S-groen' =&gt; 6,'M-groen' =&gt; 0,'L-groen' =&gt; 2,'S-zwart' =&gt; 9,'M-zwart' =&gt; 0,'L-zwart' =&gt; 3);
  </code></pre>
  
  <p>Where S is the size, and groen is the color.</p>
  
  <p>But is it good practice to do it like this, or is there a better way?</p>
  
  <p>So my database will be: <strong>ID - product_id - aantal</strong>. In aantal will be the array.</p>