How is the short/long description text linked to Product

nevaf · Post by **nevaf** » 14 Sep 2021, 09:38

Hi Aimeos community, does anyone know how the short/long description text is linked to a product?
In this overview https://aimeos.org/fileadmin/download/A ... abase.svgz you can't see the connection.
So please could anyone tell me in which table the relation between product and for example short description text is located?
I found the text in the table mshop_text but there is no prodid or parentid Field.
Thnx

Post by **aimeos** » 14 Sep 2021, 16:46

mshop_product.id -> mshop_product_list.(parentid,domain,refid) -> mshop_text_id

nevaf · Post by **nevaf** » 14 Sep 2021, 16:50

Thank you.

nevaf · Post by **nevaf** » 18 Sep 2021, 23:03

Excuse, but with your information I cant get the id from the mshop_text table.
In the tabel mshop_product_list I can select all information you mentioned:
For example:
parentid 17
domain text
refid 323134

But now with this information how can I get the id from the table mshop_text?
Could you please write a bit more in detail?

Post by **aimeos** » 19 Sep 2021, 07:12

The mshop_product_list.refid equals mshop_text.id if domain is "text"

nevaf · Post by **nevaf** » 19 Sep 2021, 09:16

by this way my sql select returns refid 323134 but I'cant find the id in the mshop_text table.
When I search the content field for the text itself I see the id 214.
And its strange but I can't find this id in the mshop_product_list in the refid field.
what am I doing wrong?

Help for Aimeos