Warning: You are browsing the documentation for PrestaShop 1.7, which is outdated.
You might want to read an updated version of this page for the current version, PrestaShop 8. Read the updated version of this page
By default, PrestaShop’s database tables start with the
ps_ prefix. This can be customized during installation
For security reasons We strongly recommend to customize your database prefix instead of using the default one. Changing it will help protect your shop against any attacks (some SQL injection for example) targeting the default table names
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:
_langsuffix. For instance,
ps_product_langcontains all the translations for the
_shopsuffix. For instance,
ps_category_shopcontains the position of each category depending on the store.
There is also a couple of standard practices for data rows within a table:
id_langfield to store the language associated with a record.
id_shopfield to store the store associated with a record.
The preferred way to access the database is through the Db component.