Am using the products module for the first time and need to know how it fits together.

I can see that adding a new product to the catalog populates product_templates table, but what are the others for (products, product_products, product_bundle)?

When creating a product category, it can have a parent category from the same table. What would this be used for?

What is 'product_types' used for?

Thanks.