title: MySQL data modeling
body: <p>I have this current problem with data I have to represent in a MySQL database:</p>
  
  <p>I have to support different kinds of products with different data each one, for example, cars, hotel rooms, books, etc. For my application there is some data which is common for each product, like name, description, price, etc. </p>
  
  <p>So I think of having a product table, with common data, with cars, hotel_rooms, books and whatever tables referencing this product table in a 1:1 relationship.</p>
  
  <p>The problem is having the product table as a master table, so I can query the product table and get the extra data "automagically" with those queries, so I can make the application more "generic".</p>
  
  <p>Any ideas of how can this be accomplished? I have a few ideas, but I don't think they are the best way of doing it and I don't want to go for dirty hacks when this problem may be more common than I think.</p>
  
  <p>Using: PHP + Zend Framework + MySQL.</p>