When you look at the tables, you will realize that the number of tables is very high. In a standard installation, there are more than 300 database tables. A structured naming convention is needed to find your way in this maze of tables.
In this recipe, we will make some queries to the database to get an idea of the tables and their purpose.
Here, you have to firstly make a connection with your database client using phpMyAdmin.
In the next steps, we will learn some methods to familiarize you with the database model in Magento:
Get a list of the core modules. You can do this by running the
ls –l
command in theapp/code/core/Mage
folder. This will give you the following output:drwxrwxr-x 7 www-data www-data Admin drwxrwxr-x 8 www-data www-data Adminhtml drwxrwxr-x 6 www-data www-data AdminNotification drwxrwxr-x 8 www-data www-data Api drwxrwxr-x 8 www-data www-data Api2 drwxrwxr-x 7 www-data www-data Authorizenet drwxrwxr-x 5...