Database Table Relationships

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)
Doveman
Posts: 23
Joined: 06 Nov 2017, 20:59

Database Table Relationships

Post 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.

Thanks

User avatar
aimeos
Administrator
Posts: 3414
Joined: 01 Jan 1970, 00:00

Re: Database Table Relationships

Post by aimeos » 16 Nov 2017, 21:38

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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

kethrine10
Posts: 1
Joined: 11 Feb 2019, 12:29

Re: Database Table Relationships

Post 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.

Post Reply