Database Structure
Here are descriptions of the database tables in PrestaShop v1.4.2. By default, each table has a prefix of ps_
. When you install PrestaShop, you have the option of changing this prefix, which lets you install PrestaShop multiple times in the same database, and also helps to prevent table name conflicts with other shopping carts installed in the same database. The table names are all lowercase and use underscores between words, and include the types of objects in the table. For example, the ps_product
table contains all the product information. Tables that end with _lang
contain translations for the object. For example, ps_product_lang
contains all the product translations. When a table links together two types of objects, both objects are included in the table name. For example, ps_category_product
links products to categories. The ID of each table starts with id_
followed by the object name. For example, the ID of the ps_product
table is id_product
.
Table Name |
Description |
Primary Key |
---|---|---|
ps_access |
The employee profile permissions. |
id_profile, id_tab |
ps_accessory |
Product accessories. |
id_product_1, id_product_2 |
ps_address |
Customer, manufacturer and supplier addresses. |
id_address |
ps_address_format |
Address format for each country. |
id_country |
ps_alias |
Search keyword alias |
id_alias |
ps_attachment |
Product attachments. |
id_attachment |
ps_attachment_lang |
Product attachment names and descriptions. |
id_attachment, id_lang |
ps_attribute |
Product attributes. |
id_attribute |
ps_attribute_group |
Product attribute groups. |
id_attribute_group |
ps_attribute_group_lang |
Product attribute group names. |
id_attribute_group, id_lang |
ps_attribute_impact |
Product attribute price and weight impacts. |
id_attribute_impact |
ps_attribute_lang |
Product attribute names. |
id_attribute, id_lang |
ps_carrier |
Carriers. |
id_carrier |
ps_carrier_group |
Carrier customer group restrictions. |
id_carrier, id_group |
ps_carrier_lang |
Carrier transit time messages. |
id_carrier |
ps_carrier_zone |
Zones each carrier is available |
id_carrier, id_zone |
ps_cart |
Customer and guest carts. |
id_cart |
ps_cart_discount |
Voucher codes used in carts. |
id_cart, id_discount |
ps_cart_product |
Products in customer carts. |
id_cart, id_product, id_product_attribute |
ps_category |
Product categories. |
id_category |
ps_category_group |
Product category customer group restrictions. |
id_category, id_group |
ps_category_lang |
Product category names and descriptions. |
id_category, id_lang |
ps_category_product |
Products in each category. |
id_category, id_product |
ps_cms |
CMS pages. |
id_cms |
ps_cms_block |
CMS blocks. |
id_cms_block |
ps_cms_block_lang |
CMS block names. |
id_cms_block, id_lang |
ps_cms_block_page |
CMS block pages. |
id_cms_block_page |
ps_cms_category |
CMS categories. |
id_cms_category |
ps_cms_category_lang |
CMS category names. |
id_cms_category, id_lang |
ps_cms_lang |
CMS page content. |
id_cms, id_lang |
ps_configuration |
Configuration settings. |
id_configuration |
ps_configuration_lang |
Configuration setting translations. |
id_configuration, id_lang |
ps_connections |
Visitor IP addresses, referrers and pages visited. |
id_connections |
ps_connections_page |
Start and end times of page visits. |
id_connections, id_page, time_start |
ps_connections_source |
Visitor referrers and search engine keywords. |
id_connections_source |
ps_contact |
Contact form subjects. |
id_contact |
ps_contact_lang |
Contact form subject names. |
id_contact, id_lang |
ps_country |
Countries. |
id_country |
ps_country_lang |
Country names. |
id_country, id_lang |
ps_county |
Counties |
id_county |
ps_county_zip_code |
County zip codes. |
id_county, from_zip_code, to_zip_code |
ps_currency |
Currencies. |
id_currency |
ps_customer |
Customers. |
id_customer |
ps_customer_group |
Customer groups. |
id_customer, id_group |
ps_customer_message |
Customer messages through contact form. |
id_customer_message |
ps_customer_thread |
Threads of messages through contact form. |
id_customer_thread |
ps_customization |
Customised product data in cart. |
id_customization, id_cart, id_product |
ps_customization_field |
Product customisation fields. |
id_customization_field |
ps_customization_field_lang |
Product customisation field names. |
id_customization_field, id_lang |
ps_customized_data |
Customised product data entered by customers. |
id_customization, type, index |
ps_date_range |
Page view date ranges. |
id_date_range |
ps_delivery |
Carrier delivery prices. |
id_delivery |
ps_discount |
Vouchers. |
id_discount |
ps_discount_category |
Voucher category restrictions. |
id_category, id_discount |
ps_discount_lang |
Voucher descriptions. |
id_discount, id_lang |
ps_discount_type |
Voucher types. |
id_discount_type |
ps_discount_type_lang |
Voucher type names. |
id_discount_type, id_lang |
ps_editorial |
Homepage logo links. |
id_editorial |
ps_editorial_lang |
Homepage text. |
id_editorial, id_lang |
ps_employee |
Back Office employees. |
id_employee |
ps_feature |
Product features. |
id_feature |
ps_feature_lang |
Product feature names. |
id_feature, id_lang |
ps_feature_product |
Links feature values to products. |
id_feature, id_product |
ps_feature_value |
Product feature values. |
id_feature_value |
ps_feature_value_lang |
Product feature value names. |
id_feature_value, id_lang |
ps_group |
Customer groups and reductions. |
id_group |
ps_group_lang |
Customer group names. |
id_group, id_lang |
ps_group_reduction |
Customer group category reductions. |
id_group_reduction |
ps_guest |
Guests. |
id_guest |
ps_help_access |
Viewed help articles and versions. |
id_help_access |
ps_hook |
Module hook names and descriptions. |
id_hook |
ps_hook_module |
Position of modules in each hook. |
id_module, id_hook |
ps_hook_module_exceptions |
Page exceptions for each module. |
id_hook_module_exceptions |
ps_image |
Product images. |
id_image |
ps_image_lang |
Product image legends. |
id_image, id_lang |
ps_image_type |
Product image thumbnail sizes. |
id_image_type |
ps_import_match |
Saved CSV import configurations. |
id_import_match |
ps_lang |
Languages. |
id_lang |
ps_log |
Log of PHP errors and warnings. |
id_log |
ps_manufacturer |
Manufacturers. |
id_manufacturer |
ps_manufacturer_lang |
Manufacturer descriptions. |
id_manufacturer, id_lang |
ps_memcached_servers |
Memcached servers. |
id_memcached_server |
ps_message |
Order messages. |
id_message |
ps_message_readed |
Order messages that have been marked as read. |
id_message, id_employee |
ps_meta |
Page names. |
id_meta |
ps_meta_lang |
Page meta information. |
id_meta, id_lang |
ps_module |
Modules directories. |
id_module |
ps_module_country |
Module country restrictions. |
id_module, id_country |
ps_module_currency |
Module currency restrictions. |
id_module, id_currency |
ps_module_group |
Module customer group restrictions. |
id_module, id_group |
ps_operating_system |
Recognised operating systems. |
id_operating_system |
ps_orders |
Orders. |
id_order |
ps_order_detail |
Order products. |
id_order_detail |
ps_order_discount |
Order vouchers. |
id_order_discount |
ps_order_history |
Order status history. |
id_order_history |
ps_order_message |
Predefined order messages. |
id_order_message |
ps_order_message_lang |
Predefined order message names. |
id_order_message, id_lang |
ps_order_return |
Merchandise returns. |
id_order_return |
ps_order_return_detail |
Merchandise return products. |
id_order_return, id_order_detail, id_customization |
ps_order_return_state |
Merchandise return statuses. |
id_order_return_state |
ps_order_return_state_lang |
Merchandise return status names. |
id_order_return_state, id_lang |
ps_order_slip |
Credit slips |
id_order_slip |
ps_order_slip_detail |
Credit slip products. |
id_order_slip, id_order_detail |
ps_order_state |
Order statuses. |
id_order_state |
ps_order_state_lang |
Order status names. |
id_order_state, id_lang |
ps_pack |
Product packs. |
id_product_pack, id_product_item |
ps_page |
Pages. |
id_page |
ps_pagenotfound |
Page not found data. |
id_pagenotfound |
ps_page_type |
Page names. |
id_page_type |
ps_page_viewed |
Viewed pages. |
id_page, id_date_range |
ps_payment_cc |
Credit card information. |
id_payment_cc |
ps_product |
Product information. |
id_product |
ps_product_attribute |
Product attribute information. |
id_product_attribute |
ps_product_attribute_combination |
Product attribute combinations. |
id_attribute, id_product_attribute |
ps_product_attribute_image |
Product attribute images. |
id_product_attribute, id_image |
ps_product_country_tax |
Product country taxes. |
id_product, id_country, id_tax |
ps_product_download |
Downloadable products. |
id_product_download |
ps_product_group_reduction_cache |
Product customer group reductions. |
id_product, id_group |
ps_product_lang |
Product names and descriptions. |
id_product, id_lang |
ps_product_sale |
Product sale data. |
id_product |
ps_product_tag |
Product tags. |
id_product, id_tag |
ps_profile |
Employee profile. |
id_profile |
ps_profile_lang |
Employee profile name. |
id_profile, id_lang |
ps_quick_access |
Back Office quick accesses. |
id_quick_access |
ps_quick_access_lang |
Back Office quick access names. |
id_quick_access, id_lang |
ps_range_price |
Carrier price ranges. |
id_range_price |
ps_range_weight |
Carrier weight ranges. |
id_range_weight |
ps_referrer |
Affiliate program accounts. |
id_referrer |
ps_referrer_cache |
Affiliate program referrals. |
id_connections_source, id_referrer |
ps_required_field |
Required fields. |
id_required_field |
ps_scene |
Category page product banners. |
id_scene |
ps_scene_category |
Links product banners to categories. |
id_scene, id_category |
ps_scene_lang |
Category page product banner names. |
id_scene, id_lang |
ps_scene_products |
Category page banner products. |
id_scene, id_product, x_axis, y_axis |
ps_search_engine |
Recognised search engines. |
id_search_engine |
ps_search_index |
PrestaShop search engine keyword index. |
id_product, id_word |
ps_search_word |
PrestaShop search engine keywords. |
id_word |
ps_sekeyword |
External search engine keywords. |
id_sekeyword |
ps_specific_price |
Specific prices. |
id_specific_price |
ps_specific_price_priority |
Specific price priorities. |
id_specific_price_priority, id_product |
ps_state |
States. |
id_state |
ps_statssearch |
PrestaShop search engine statistics. |
id_statssearch |
ps_stock_mvt |
Stock movements. |
id_stock_mvt |
ps_stock_mvt_reason |
Stock movement reasons. |
id_stock_mvt_reason |
ps_stock_mvt_reason_lang |
Stock movement reason names. |
id_stock_mvt_reason, id_lang |
ps_store |
Store addresses. |
id_store |
ps_subdomain |
Cookie subdomains. |
id_subdomain |
ps_supplier |
Suppliers. |
id_supplier |
ps_supplier_lang |
Supplier names. |
id_supplier, id_lang |
ps_tab |
Back Office tabs. |
id_tab |
ps_tab_lang |
Back Office tab names. |
id_tab, id_lang |
ps_tag |
Product tags used in tag cloud. |
id_tag |
ps_tax |
Taxes. |
id_tax |
ps_tax_lang |
Tax names. |
id_tax, id_lang |
ps_tax_rule |
Tax rules. |
id_tax_rule |
ps_tax_rules_group |
Tax rule names. |
id_tax_rules_group |
ps_timezone |
Timezones. |
id_timezone |
ps_webservice_account |
Webservice accounts. |
id_webservice_account |
ps_webservice_permission |
Webservice permissions. |
id_webservice_permission |
ps_web_browser |
Recognised web browsers |
id_web_browser |
ps_zone |
Carrier zones. |
id_zone |