How many takes database tables will Magento create when you make a new EAV mod..?

[techsoluti4a73]

How many takes database tables will Magento create when you make a new EAV mod..?

192.168.10.1 

[namitapare2a78]

Hello @techsoluti4a73,

Greetings!

In Magento, the creation of database tables depends on what you are creating. But the simplest module will create the following tables:

1. eav_table
2. eav_table_datetime
3. eav_table_decimal
4. eav_table_int
5. eav_table_text
6. eav_table_varchar

Hope this will help you!

If not, feel free to contact us.

Solved?

Click KUDOS and accept as a solution.

Thank you!

[ravikumarca627]

Hi @techsoluti4a73,

Basically, the Magento EAV modal having the 6 tables which are as below, and the EAV model is in normalized form of database and all tables depend on each other it means database relation exist of each other tables. So if you are creating the EAV model-based module in Magento 2 then follow the following reference link. 

1. eav_table
2. eav_table_datetime
3. eav_table_decimal
4. eav_table_int
5. eav_table_text
6. eav_table_varchar

Reference link: https://www.rohanhapani.com/create-eav-module-in-magento-2/

If you get the solution then please, "Kudos" and "Accept as Solution" for Token of Appreciation. Thank you.

[arjunkumar9fce]

It depends on what's you are creating, but the simplest module creates the following table.
1. eav_table
2. eav_table_datetime

3. eav_table_decimal
4. eav_table_int

5. eav_table_text

6. eav_table_varchar

Thanks.