Magento Certified Developer GuideCategory: 10. CustomersWhat is the structure of tables in which customer information is stored
Manish Prakash Staff asked 5 years ago

Customer Information uses EAV structure to store all information, the entity tables are as follows

customer_entity : This is the main entity table, where customer information is stored

customer_entity_datetime, customer_entity_decimal, customer_entity_int, customer_entity_text, customer_entity_varchart: these are the customer entity attribute tables

customer_form_attribute: This table is used by magento to define in which form which customer attributes are required. e.g which fields to validate in checkout shipping method form, admin customer forms, etc