How to configure and adapt Aimeos based shops as developer
Forum rules: Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
#5001 by Doveman
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.

#7646 by kethrine10
11 Feb 2019, 12:34
Database relationships are very similar in that they're associations between tables. There are three types of relationships: One-to-one: Both tables can have only one record on either side of the relationship. Each primary key value relates to only one (or no) record in the related table.