title: DB design to store different products for each customer order
body: <p>I'm building a simple way to insert customer orders into the db.
  We have several products, each one needs different properties.</p>
  
  <p>I've started designing the following tables:</p>
  
  <pre><code>CUSTOMER -&gt; Order (FK to CUSTOMER) -&gt; OrderItem (FK to Order)
  </code></pre>
  
  <p>Now I'm thinking How could I link product-specific tables to <strong>OrderItem</strong>.
  Suppose I've two products: <strong>product1 (room_name, width, height, color) and product2 (number, width, height, type, optionals)</strong>. I'd create two different tables and link them with the <strong>OrderItem</strong>, to get specific options, am I wrong? (of course there will be more than just two products)</p>
  
  <p>How can I do this?</p>