Before PrestaShop 9 and by default, PrestaShop’s database tables start with the ps_ prefix. This can be customized during installation
Since PrestaShop 9, prefix is randomized by default.
All table and column names use snake case: lowercase letters only, with words separated by underscores (“_”). For example:
When a table establishes the links between two entities, the names of both entities are mentioned in the table’s name. For instance, ps_category_product links products to their category.
A few details to note about tables:
_lang suffix. For instance, ps_product_lang contains all the translations for the ps_product table._shop suffix. For instance, ps_category_shop contains the position of each category depending on the store.There is also a couple of standard practices for data rows within a table:
id_lang field to store the language associated with a record.id_shop field to store the store associated with a record.The preferred way to access the database is through the Db component.