Finding your way in the tables
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.
How to do it...
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 –lcommand in the
app/code/core/Magefolder. This will give you the following output:
drwxrwxr-x 7 ...