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

[Sabir_Ali]

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.

[aimeos]

users

It contains the basic customer data and the billing address as well as the accounts for the admin backend.

users_address

Here are the delivery address of the customers stored.

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.

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.

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.

[kdim95]

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

[aimeos]

Unfortunately, that's not so easy. Otherwise, we would have done that already.