What table links a simple product to a configurable product

Question

I have imported some products and for some items, I can see all the children linked in the associated tab but for some others, I can only see one or 2 of the options.

If I do

select * from catalog_product_super_link where parent_id = {my parent id}

Then it shows ALL the correct product ids linked. Is there another table which links the two?

Answer 1

The table catalog_product_super_link but the other tables that start with catalog_product_super_ are involved in the relation.

1. catalog_product_super_attribute - holds the configurable attributes
2. catalog_product_super_attribute_label - holds the store view labels for the configurable attributes - this is not that important
3. catalog_product_super_attribute_pricing - holds the price differences for the simple variations

There is also the table catalog_product_relation that seam to remember the configurable products relations.
[EDIT]
After checking I confirm that the configurable products relations are remembered in 2 tables. This seams redundant but I'm sure there is a reason.
In the method Mage_Catalog_Model_Resource_Product_Type_Configurable::saveProducts() there is this that inserts the data in catalog_product_super_link :

 $this->_getWriteAdapter()->insertMultiple($this->getMainTable(), $data);

And after that there is this that saves the data in catalog_product_relation:

Mage::getResourceSingleton('catalog/product_relation')
    ->processRelations($mainProductId, $productIds);