How are images set on products and variants in DB

-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.2.4

I have 16 products, each of which has variants which means I have a large total number variants. Each variant has 3 images applied to it and I need to make some changes to the images (names and assignments). The most efficient way for me to to do this would be to work directly in the database but I am unsure of how the images are applied to the variants. I see the #__hikashop_file table and it's fields for id, file name and path etc. I am thinking that the file_id is applied to the variants somewhere. Is this correct?

EDIT: Looking into it further it seems to be done via the #__hikashop_file.file_ref_id field and the insertion of the product id (of any product that uses the image) into that field. Is this accurate?

Hi,

Yes indeed, the file_ref_id refer to the product id.