Page 1 of 1

Database Table Relationships

Posted: 16 Nov 2017, 17:51
by Doveman
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

Re: Database Table Relationships

Posted: 16 Nov 2017, 21:38
by aimeos
Prices are associated to products using the mshop_product_list table just like attributes, media, texts and product variants are. Here you can find the ERM for Aimeos: https://aimeos.org/docs/Developers#Database

Re: Database Table Relationships

Posted: 11 Feb 2019, 12:34
by kethrine10
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.