title: Database for an online store
body: <p>I'm about to make an <strong>online e-commerce</strong> site for selling some <strong>products like footwear,clothes etc</strong>. but I'm unable to figure out how to set up the schema for that (tables and all). I'm doing it in <strong>Ruby on Rails</strong> with <strong>Mysql</strong> and I'm newbie in ROR.</p>
  
  <p>Details are as follows:-</p>
  
  <p>I have Different <strong>categories</strong> in <strong>products</strong> like <strong>Footwear,Clothing,Accessories,Bags,etc</strong> separate each for <strong>Men and Women</strong>.</p>
  
  <p>The buyer selects the products and <strong>add it to cart</strong> and proceed to chekout. We just have a <strong>cash on delivery type Payment system.</strong> We wont be creating any user accounts.<strong>No user accounts</strong></p>
  
  <p><strong>How should I achieve that in Rails with all the controllers and the models?</strong><br>
  Should I make <strong>separate table for each of the category</strong>?<br>
  How should I categories the required Products in <strong>Men and Women</strong>?<br>
  Provide a complete schema and relationships table <strong>the Rails way.</strong></p>