Database Table Relationships
Posted: 16 Nov 2017, 17:51
I need to reference some data from some external tables so I have been working on understanding the relationships between the aimeos tables. One issue came up when trying to understand products to prices. The schema would imply that the product is related to price via the mshop_price_list table, but looking at the actual data in the table I realized the mshop_price_list table is empty, yet if I call up a product in the admin the prices are there. So how did the system find the prices as I see no other way of getting to them?
Also is there a diagram of the table relations? If not I guess I will have to create one.
Thanks
Also is there a diagram of the table relations? If not I guess I will have to create one.
Thanks