Are there links to photos of goods in the Bitrix database?

Question

MySQL

Hello!
Is there a direct link in the Bitrix database to the main photo of each product in the online store.
As I understand it, the photos themselves are stored on the hosting, and not in the database.
And in the database itself there are links to each photo.
The task is to get these links in the query to the database.
I'm just developing an application that works with the MySQL database and I need to load the catalog.
Actually, in the tables related to the goods, I found the following fields:
PREVIEW_PICTURE, with a digital value of the form 33254
and DETAIL_PICTURE, also with a digital value.
Question.. How can I get a photo through MySQL? Or links to these photo URLs.

Answer 1

Table b_file:
- field SUBDIR - location relative to the folder for downloads (usually upload in the root)
- field FILE_NAME - the file itself.
Accordingly, add the values ​​​​and get the path to the file.

Answer 2

I am developing an application that works with MySQL database

It is better to make an API (Rest Full API) on the Bitrix itself, through D7 and in the application, access this API and receive data from it