title: How should I create this customized e-commerce database model?
body: <p>I am building an e-commerce website from scratch and have to make a special product configuration page.</p>
  
  <p>It's only 1 type of product, but it is configurable on several levels:</p>
  
  <ol>
  <li>Color (about 4 different options).  Value is a VARCHAR.</li>
  <li>Material (about 10 different options).  Value is a VARCHAR.</li>
  <li>Size (About 30 different options).  Has 2 Values, a width column and a height column.</li>
  <li>Finish (About 20 different options). Value is a VARCHAR.</li>
  <li>Other various VARCHAR options etc.</li>
  </ol>
  
  <p>My question is what would this look like in a typical MySQL database.  Do I have a table for each type of option or just one table and somehow give it enough columns and have it store all options?  I will need to store orders and be able to store the information for the order in a table as well.</p>
  
  <p>I also want to be able to have off the shelf products that aren't customizeable, just like a normal store.</p>
  
  <p>Any help is appreciated!!</p>