I need to create a query that will list me as in the admin panel all registred customers, of course, I can do it through the tables customer_entity. However, it does not contain the customer type whether it is "Company user" or "Individual user". Where can I find this type of information by default? In which table to look for this in Magento 2?

2 Answers 2


This is too vague question to advise anything concrete.

Customer model is based on EAV(Entity Attribute Value) and related customer data stored in tables like customer_entity_*

EAV metadata for link data is stored in eav_* tables

It's present a lot of information in internet which will be helpful. You can search it by keywords like Magento 2 EAV

If you have more specific question, please update your Ask


I would like to call a SQL query something to list customers (e-mail addresses and customer type). In most standard tables, this is determined only by a number, but I want the table to appear whether it is "Company user" or "Individual User "

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.