title: E-commerce product filter db design
body: <p>I'm creating an e-commerce site and my products are grouped in categories (like in any other e-commerce system).</p>
  
  <p>The problem is the following: different categories (and products in it) need to have different attributes (like TV's smart tv or not).</p>
  
  <p>So someone could help me with some product filtering "theory" (db design) what are the good practices to follow? </p>
  
  <p>And how can I "build" these product category pages automatically (to build up automatically the filters for ex.: in the TV category a switch for smart tv or not and in Phones category smart phone or not ).</p>
  
  <p>Thanks for the help!</p>