title: e-commerce structure for products (MySQL)
body: <p>I am considering how to structure my MySQL database in e-commerce solution. To be more specific I am looking at the product structure.</p>
  
  <p>These are the tables I have come up with so far. What do you think?</p>
  
  <p><b>Explanation of structure</b></p>
  
  <p>The application is multilingual. Therefore the product table are split in 2 tables.</p>
  
  <p>If a products has e.g. 2 variants (Small, Medium) a total of 3 rows will be inserted. This is because each variant can have different information for each variant. When the product is shown on the webpage product 1 will be shown with a drop down box with Small &amp; Medium. A product with no variants will naturally only insert 1 row.
  <code><pre>
  products
  id  master  product_number
  1   0       123
  2   1       456
  3   1       678</p>
  
  <p>products_descriptions
  id  product_id  country_code  image      name     description   vat  price
  1   1           en-us         image.jpg  t-shirt  Nice t-shirt  25   19.99
  2   2           en-us         image.jpg  t-shirt  Nice t-shirt  25   19.99
  3   3           en-us         image.jpg  t-shirt  Nice t-shirt  25   19.99</p>
  
  <p>products_to_options
  product_id  option_id
  2           1
  3           2</p>
  
  <p>options
  id  name
  1   Small
  2   Medium
  </pre></code></p>