Message-ID: <2064237915.377730.1711640264229.JavaMail.root@confluence-doc2-production> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_377729_1864807291.1711640264215" ------=_Part_377729_1864807291.1711640264215 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Here are descriptions of the database tables in PrestaShop v1.4.2. By de=
fault, each table has a prefix of ps_
. When you install Presta=
Shop, you have the option of changing this prefix, which lets you install P=
restaShop multiple times in the same database, and also helps to prevent ta=
ble 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_produc=
t
table contains all the product information. Tables that end with <=
code>_lang contain translations for the object. For example, p=
s_product_lang
contains all the product translations. When a table l=
inks together two types of objects, both objects are included in the table =
name. For example, ps_category_product
links products to categ=
ories. The ID of each table starts with id_
followed by the ob=
ject name. For example, the ID of the ps_product
table is
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 <= /td> | Product attribute group names. |
id_attribute_group, id_lang |
ps_attribute_impact |
Product attribute price and weight impacts.= p> |
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. <= /td> | 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 vis= ited. |
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. = td> | 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 = td> | Product customisation fields. |
id_customization_field |
ps_customization_field_lang<= /p> |
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 = td> | Merchandise return products. |
id_order_return, id_order_detail, id_customiz= ation |
ps_order_return_state | Merchandise return statuses. |
id_order_return_state |
ps_order_return_state_lang= p> |
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= p> |
Product attribute images. |
id_product_attribute, id_image |
ps_product_country_tax = td> | 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. = td> | 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= p> |
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 |