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.

Getting ready

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:

  1. Get a list of the core modules. You can do this by running the ls –l command in the app/code/core/Mage folder. This will give you the following output:
    drwxrwxr-x 7 ...

Get Magento 1.8 Development Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.