Magento save the thumb,small_image and large image name in catalog_product_entity_varchar
table.
Since Magento is using the eav architecture, the thumbnail,small_image and large image is stored in the catalog_product_entity_varchar
with the reference ids from the eav_attribute
table.
In catalog_product_entity_varchar
table, entity_id
represents the product id and the attribute_id
represents the reference id from the attribute table.
Generally the attribute id 74 - image
, 75- small_image
and 76- thumbnail
. You can check the corresponding id in the eav_attribute
table.
For example, if a product with entity_id 1,
If we check the value for the catalog_product_entity_varchar
table, the value with respect to the attribute id 74 represents its image, 75 represents its small image and 76 represents its thumbnail..
Hope it helps..