By default, PrestaShop’s database tables start with the ps_
prefix. This can be customized during installation
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.