lechowski / 13.11.2021

Prestashop Database Structure

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