> For the complete documentation index, see [llms.txt](https://docs.prestashop-project.org/1-4-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.prestashop-project.org/1-4-documentation/english-documentation/developer-guide/rockys-guides/prestashop-1.4.3-development-guide/database-structure.md). # 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 | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.prestashop-project.org/1-4-documentation/english-documentation/developer-guide/rockys-guides/prestashop-1.4.3-development-guide/database-structure.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.