Customers tables

Can some of the Solidres staff explain exactly how clients are organized in database tables?

I need to create queries to export them from the datase but informations are slitted in many tables

Hi,

Customers info are stored in 03 tables:

1. #__users
2. #__sr_customers (FK = user_id)
3. #__sr_customer_groups

You can export the customer information by joining these 3 tables.

Regards,

Ok, but in sr_customers table I can see only registered customers (customers which have a user_id)

But I have a lot of reservations made by "customers" which are not in sr_customers table: where are them?

Hi,

For non-registered users, their info are stored in table #__sr_reservations.

Regards,