What is the difference between all the tables where user data used?

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Sabir_Ali
Posts: 30
Joined: 12 Feb 2024, 06:43

What is the difference between all the tables where user data used?

Post by Sabir_Ali » 10 Apr 2024, 06:36

PHP: 8.2.7
Laravel Framework: 10.48.4
System: Debian GNU/Linux 12

My task is to implement users checkout and shipping functionality. But there are a couple of tables where addresses and other many the same columns used:

users
users_address
mshop_customer
mshop_customer_address
mshop_order_address

I have two questions.
1. Which table we must use to store user delivery (shipping) addresses.
2. What is the purpose of the last three tables (in terms of storing user data).

PS. I you have any resource with describing of each table in your system, I will be very grateful. Maybe I didn't search well.

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

Re: What is the difference between all the tables where user data used?

Post by aimeos » 11 Apr 2024, 07:58

Sabir_Ali wrote: 10 Apr 2024, 06:36 users
It contains the basic customer data and the billing address as well as the accounts for the admin backend.
Sabir_Ali wrote: 10 Apr 2024, 06:36 users_address
Here are the delivery address of the customers stored.
Sabir_Ali wrote: 10 Apr 2024, 06:36 mshop_customer
mshop_customer_address
They are the standard customer/account tables in Aimeos but they are not used in the Laravel context. Nevertheless, the setup tasks create them automatically.
Sabir_Ali wrote: 10 Apr 2024, 06:36 mshop_order_address
There, the billing and delivery address (optional) for each order is stored. These addresses are immutable compared to the addresses in the users_address table.
Sabir_Ali wrote: 10 Apr 2024, 06:36 PS. I you have any resource with describing of each table in your system, I will be very grateful. Maybe I didn't search well.
Here, the data domains are documented where the tables belong to:
https://aimeos.org/docs/latest/develope ... ata-access

The page also contains a link to the ERM diagram of the Aimeos tables and relations at the top.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

kdim95
Advanced
Posts: 213
Joined: 26 Aug 2022, 12:17

Re: What is the difference between all the tables where user data used?

Post by kdim95 » 11 Apr 2024, 11:07

Hello,

To add to the topic, I never understood why mshop_customer and mshop_customer_address are created if they are never used. It is a bit confusing when looking at the database structure, could they be removed in the future for less confusion?

Best regards

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

Re: What is the difference between all the tables where user data used?

Post by aimeos » 11 Apr 2024, 13:21

Unfortunately, that's not so easy. Otherwise, we would have done that already.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply