Associate images to product by database tables

[davidbranco]

Hello,
I have uploaded the photos from more than 3000 products to the directory img/p
Now, i want to associate a image to your product, but i don't saw the table of database where i put this information.
The names of the images are not the default 1-1, 2-1, ...

Waht is the way, and waht is the table to associate a image to a product?
Can you help me please?
thanks

[mhuebmer]

I know this topic is old, but I did not find any solution in this board where to find the pictures in the database. So I want to add this information. Hope it helps someone else

 

In the database, at ps_image, there are id_image and id_product. Knowing the id_product (I use my own article number) I can search for it and find the associated images. In my current case, the id_image for multiple pictures will show 1331, 1332, 1333,... for this product.

 

This id_image is separated to the path to the image. In this case: 

/shop/img/p/1/3/3/1/ containing:

1331.jpg

1331-cart_default.jpg

1331-small_default.jpg

1331-medium_default.jpg

1331-home_default.jpg

1331-large_default.jpg

1331-thickbox_default.jpg

1331-watermark.jpg

 

This helped me to find the images to any product. Now I can update them by FTP.