Where can I see the list of products ordered by the client in the Bitrix database tables?

Question

MySQL

Good afternoon!
Tell me how and in which table of the Bitrix database to see which goods the client ordered?
I did not find such data in the b_sale_order table.
As I understand it, the IDs of the ordered goods are stored in the database, at least this information can be obtained for each order?
I just need to parse the orders into a new table so that it contains the full data.
With a list of ordered items.
And tell me in which table is the list of store products with their characteristics?
To be able to upload product data with pictures (desirable, but not required).

Answer 1

b_sale_basket, and it has a reference to ORDER_ID.

Answer 2

It's better to collect information through the API.
All products are in a common table (and in general, all elements of all infoblocks), but properties, depending on the infoblock settings, can be in a common property table, or separately (Infoblocks 2.0, properties are stored “in a separate table”)