Product data is stored across a number of tables. The main one is catalog_product_entity. Anything not in that table will be stored in catalog_product_entity_int, catalog_product_entity_text, catalog_product_entity_decimal, catalog_product_entity_varchar, catalog_product_entity_datetime. Additionally you need to use the eav_attribute table which will tell you which values in the other tables are for which attributes.
