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 Database Structure

Database Structure

Database Structure

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 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

<= /td>

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.

<= /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.

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<= /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

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

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

------=_Part_377729_1864807291.1711640264215--