爱妃科技DATABASE STRUCT | | 爱妃科技
正在加载
请稍等

菜单

红楼飞雪 梦

15526773247

文章

Home prestashop DATABASE STRUCT
Home prestashop DATABASE STRUCT

DATABASE STRUCT

prestashop by

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.

这里是在的PrestaShop 5.0上的数据库中的表的说明。默认情况下,每个表具有PS_的前缀。当您安装的Prestashop,你必须改变这个前缀,它可以让你在同一个数据库安 装的PrestaShop多次的选择,同时也有助于防止安装在同一个数据库等购物车表名称冲突。该表的名称都是小写字母和单词之间使用下划线,并包含在表 对象的类型。例如,ps_product表包含了所有的产品信息。与_lang结束表包含翻译的对象。例如,ps_product_lang包含的所有产 物的翻译。当一个表两种类型的对象连接在一起,这两个对象都包含在表的名称。例如,ps_category_product链接产品类别。各表的ID开始 ID_后跟对象名称。例如,ps_product表的ID是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.CMS的网页 id_cms
ps_cms_block CMS blocks.CMS块。 id_cms_block
ps_cms_block_lang CMS block names.CMS块名称。 id_cms_block, id_lang
ps_cms_block_page CMS block pages.

 CMS块页

id_cms_block_page
ps_cms_category CMS categories.CMS类 id_cms_category
ps_cms_category_lang CMS category names.CMS类别名称 id_cms_category, id_lang
ps_cms_lang CMS page content.CMS的页面内容。 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.访问者的IP地址,引荐和访问的页面。 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.首页LOGO链接 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.

保存CSV导入配置

id_import_match
ps_lang Languages.语言 id_lang
ps_log Log of PHP errors and warnings.php错误和警告的日志 id_log
ps_manufacturer Manufacturers.生产厂家 id_manufacturer
ps_manufacturer_lang Manufacturer descriptions.生产厂家说明 id_manufacturer, id_lang
ps_memcached_servers Memcached servers.Memcached的服务器 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_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_orders Orders.订单 id_order
ps_pack Product packs.订单 id_product_pack, id_product_item
ps_page Pages.页面 id_page
ps_page_type Page names.页面名称 id_page_type
ps_page_viewed Viewed pages.浏览过的网页 id_page, id_date_range
ps_pagenotfound Page not found data.找不到网页数据 id_pagenotfound
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.

Prestashop搜索引擎关键字索引。

id_product, id_word
ps_search_word PrestaShop search engine keywords

Prestashop搜索引擎关键词。

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.

的Prestashop搜索引擎的统计数据。

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.

Cookie的子域。

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_web_browser Recognised web browsers认可的网络浏览器 id_web_browser
ps_webservice_account Webservice accounts.

Webservice的账户。

id_webservice_account
ps_webservice_permission Webservice permissions.

Web服务的权限。

id_webservice_permission
ps_zone Carrier zones.配送的区域 id_zone

mpd16-mini

 

01 2015-08

 

我要 分享

 

 

本文 作者

 

相关 文章