Help for Aimeos

Hello,

Laravel: 5.6.
Aimeos: 2018.07.
OS: Centos7.

We are customizing Aimeos to our needs, and it's been very hard to understand the relationship between mshop_orders and mhop_orders_base.

It seems order_base is the unique order, and records in mshop_orders are like transactions (payments/delivery changes) that share the same baseid. Seeing that on admin/orders the mhsop_orders records are listed under the invoice tab, there can be multiple records for an order. Why is mshop_order id used for the order id and not the mshop_order_base id. that is the unique value for the order number?

Maybe it is something we are not understanding or a different setup than we are imagining?. Trying to understand your thinking on the design may help us with our project.

As always, we really appreciate your help in this.

Thanks a lot.

Regards,

The mshop_order contains the invoice and status data like (invoice) ID, payment and delivery status. The mshop_order_base and related tables contains the persisted basket (basket and order base is in fact the same data structure).