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 names are in lowercase, and words are separated with an underscore character (“_”):
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.