Magento will create 6 tables when we add a new EAV module in Magento.Eav module cretaes below tables
-module Table :- This is the main entity table
-module_datetime :- This is to hold the attribute data of DATETIME data type
-module_decimal :-This is to hold the attribute data of Float data type eg. Price
-module_int :- This is to hold the attribute data of Integer data type eg. quantity
-module_text :- This is to hold the attribute data of long text data type e.g Description
-module_varchar ;- This is to hold the attribute alpahnumeric data e.g name and address
