Database Table Relationships
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Database Table Relationships
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
Re: Database Table Relationships
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, give us a star
If you like Aimeos, give us a star
-
- Posts: 1
- Joined: 11 Feb 2019, 12:29
Re: Database Table Relationships
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.