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:
_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.