ZenCart數(shù)據(jù)庫(kù)表結(jié)構(gòu)(含中文說(shuō)明)

1、address_book地址簿FieldTypeNullDefaultaddress_book_idint(11)Nocustomers_idint(11)No0entry_genderchar(1)Noentry_companyvarchar(64)YesNULLentry_firstnamevarchar(32)Noentry_lastnamevarchar(32)Noentry_street_addressvarchar(64)Noentry_suburbvarchar(32)YesNULLentry_postcodevarchar(10)Noentry_cityvarchar(32)N

2、oentry_statevarchar(32)YesNULLentry_country_idint(11)No0entry_zone_idint(11)No0address_format地址格式FieldTypeNullDefaultaddress_format_idint(11)Noaddress_formatvarchar(128)Noaddress_summaryvarchar(48)Noadmin管理員賬號(hào)FieldTypeNullDefaultadmin_idint(11)Noadmin_namevarchar(32)Noadmin_emailvarchar(96)Noadmin_p

3、rofileint(11)No0admin_passvarchar(40)Noprev_pass1varchar(40)Noprev_pass2varchar(40)Noprev_pass3varchar(40)Nopwd_last_change_datedatetimeNo0000-00-0000:00:00reset_tokenvarchar(60)Nolast_modifieddatetimeNo0000-00-0000:00:00last_login_datedatetimeNo0000-00-0000:00:00last_login_ipvarchar(15)Nofailed_log

4、inssmallint(4)No0lockout_expiresint(11)No0last_failed_attemptdatetimeNo0000-00-0000:00:00last_failed_ipvarchar(15)Noadmin_activity_log管理員操作日志FieldTypeNullDefaultlog_idbigint(15)Noaccess_datedatetimeNo0001-01-0100:00:00admin_idint(11)No0page_accessedvarchar(80)Nopage_parameterstextYesNULLip_addressva

5、rchar(20)Noflaggedtinyint(4)No0attentionvarchar(255)NogzpostmediumblobYesNULLadmin_menus管理員菜單權(quán)限FieldTypeNullDefaultmenu_keyvarchar(32)Nolanguage_keyvarchar(255)Nosort_orderint(11)No0admin_pages管理員頁(yè)面權(quán)限FieldTypeNullDefaultpage_keyvarchar(32)Nolanguage_keyvarchar(255)Nomain_pagevarchar(64)Nopage_params

6、varchar(64)Nomenu_keyvarchar(32)Nodisplay_on_menuchar(1)NoNsort_orderint(11)No0admin_pages_to_profiles管理員組頁(yè)面權(quán)限FieldTypeNullDefaultprofile_idint(11)No0page_keyvarchar(32)Noadmin_profiles管理員組FieldTypeNullDefaultprofile_idint(11)Noprofile_namevarchar(64)NoauthorizenetFieldTypeNullDefaultidint(11)Nocust

7、omer_idint(11)No0order_idint(11)No0response_codeint(1)No0response_textvarchar(255)Noauthorization_typevarchar(50)Notransaction_idbigint(20)YesNULLsentlongtextNoreceivedlongtextNotimevarchar(50)Nosession_idvarchar(255)NobannersBANNER廣告管理表FieldTypeNullDefaultbanners_idint(11)Nobanners_titlevarchar(64)

8、Nobanners_urlvarchar(255)Nobanners_imagevarchar(64)Nobanners_groupvarchar(15)Nobanners_html_texttextYesNULLexpires_impressionsint(7)Yes0expires_datedatetimeYesNULLdate_scheduleddatetimeYesNULLdate_addeddatetimeNo0001-01-0100:00:00date_status_changedatetimeYesNULLstatusint(1)No1banners_open_new_windo

9、wsint(1)No1banners_on_sslint(1)No1banners_sort_orderint(11)No0banners_historyBANNER廣告歷史記錄FieldTypeNullDefaultbanners_history_idint(11)Nobanners_idint(11)No0banners_shownint(5)No0banners_clickedint(5)No0banners_history_datedatetimeNo0001-01-0100:00:00categories分類設(shè)置信息FieldTypeNullDefaultcategories_idi

10、nt(11)Nocategories_imagevarchar(64)YesNULLparent_idint(11)No0sort_orderint(3)YesNULLdate_addeddatetimeYesNULLlast_modifieddatetimeYesNULLcategories_statustinyint(1)No1categories_description分類詳細(xì)信息FieldTypeNullDefaultcategories_idint(11)No0language_idint(11)No1categories_namevarchar(32)Nocategories_de

11、scriptiontextNoconfiguration配置設(shè)置FieldTypeNullDefaultconfiguration_idint(11)Noconfiguration_titletextNoconfiguration_keyvarchar(255)Noconfiguration_valuetextNoconfiguration_descriptiontextNoconfiguration_group_idint(11)No0sort_orderint(5)YesNULLlast_modifieddatetimeYesNULLdate_addeddatetimeNo0001-01-

12、0100:00:00use_functiontextYesNULLset_functiontextYesNULLconfiguration_group配置設(shè)置組FieldTypeNullDefaultconfiguration_group_idint(11)Noconfiguration_group_titlevarchar(64)Noconfiguration_group_descriptionvarchar(255)Nosort_orderint(5)YesNULLvisibleint(1)Yes1counter計(jì)數(shù)器FieldTypeNullDefaultstartdatechar(8)

13、YesNULLcounterint(12)YesNULLcounter_history計(jì)數(shù)器數(shù)據(jù)FieldTypeNullDefaultstartdatechar(8)Nocounterint(12)YesNULLsession_counterint(12)YesNULLcountries國(guó)家定義FieldTypeNullDefaultcountries_idint(11)Nocountries_namevarchar(64)Nocountries_iso_code_2char(2)Nocountries_iso_code_3char(3)Noaddress_format_idint(11)N

14、o0coupon_email_track優(yōu)惠券跟蹤FieldTypeNullDefaultunique_idint(11)Nocoupon_idint(11)No0customer_id_sentint(11)No0sent_firstnamevarchar(32)YesNULLsent_lastnamevarchar(32)YesNULLemailed_tovarchar(32)YesNULLdate_sentdatetimeNo0001-01-0100:00:00coupon_gv_customer客戶禮品券FieldTypeNullDefaultcustomer_idint(5)No0a

15、mountdecimal(15,4)No0coupon_gv_queue禮品券發(fā)送隊(duì)列FieldTypeNullDefaultunique_idint(5)Nocustomer_idint(5)No0order_idint(5)No0amountdecimal(15,4)No0date_createddatetimeNo0001-01-0100:00:00ipaddrvarchar(32)Norelease_flagchar(1)NoNcoupon_redeem_track優(yōu)惠券兌換跟蹤FieldTypeNullDefaultunique_idint(11)Nocoupon_idint(11)

16、No0customer_idint(11)No0redeem_datedatetimeNo0001-01-0100:00:00redeem_ipvarchar(32)Noorder_idint(11)No0coupon_restrict優(yōu)惠券限制設(shè)置FieldTypeNullDefaultrestrict_idint(11)Nocoupon_idint(11)No0product_idint(11)No0category_idint(11)No0coupon_restrictchar(1)NoNcoupons優(yōu)惠券FieldTypeNullDefaultcoupon_idint(11)Noco

17、upon_typechar(1)NoFcoupon_codevarchar(32)Nocoupon_amountdecimal(15,4)No0coupon_minimum_orderdecimal(15,4)No0coupon_start_datedatetimeNo0001-01-0100:00:00coupon_expire_datedatetimeNo0001-01-0100:00:00uses_per_couponint(5)No1uses_per_userint(5)No0restrict_to_productsvarchar(255)YesNULLrestrict_to_cate

18、goriesvarchar(255)YesNULLrestrict_to_customerstextYesNULLcoupon_activechar(1)NoYdate_createddatetimeNo0001-01-0100:00:00date_modifieddatetimeNo0001-01-0100:00:00coupon_zone_restrictionint(11)No0coupons_description優(yōu)惠券信息FieldTypeNullDefaultcoupon_idint(11)No0language_idint(11)No0coupon_namevarchar(32)

19、Nocoupon_descriptiontextYesNULLcurrencies貨幣FieldTypeNullDefaultcurrencies_idint(11)Notitlevarchar(32)Nocodechar(3)Nosymbol_leftvarchar(24)YesNULLsymbol_rightvarchar(24)YesNULLdecimal_pointchar(1)YesNULLthousands_pointchar(1)YesNULLdecimal_placeschar(1)YesNULLvaluefloat(13,8)YesNULLlast_updateddateti

20、meYesNULLcustomers客戶基本信息FieldTypeNullDefaultcustomers_idint(11)Nocustomers_genderchar(1)Nocustomers_firstnamevarchar(32)Nocustomers_lastnamevarchar(32)Nocustomers_dobdatetimeNo0001-01-0100:00:00customers_email_addressvarchar(96)Nocustomers_nickvarchar(96)Nocustomers_default_address_idint(11)No0custo

21、mers_telephonevarchar(32)Nocustomers_faxvarchar(32)YesNULLcustomers_passwordvarchar(40)Nocustomers_newsletterchar(1)YesNULLcustomers_group_pricingint(11)No0customers_email_formatvarchar(4)NoTEXTcustomers_authorizationint(1)No0customers_referralvarchar(32)Nocustomers_paypal_payeridvarchar(20)Nocustom

22、ers_paypal_ectinyint(1)No0customers_basket客戶購(gòu)物車信息FieldTypeNullDefaultcustomers_basket_idint(11)Nocustomers_idint(11)No0products_idtinytextNocustomers_basket_quantityfloatNo0final_pricedecimal(15,4)No0customers_basket_date_addedvarchar(8)YesNULLcustomers_basket_attributes客戶購(gòu)物車產(chǎn)品屬性FieldTypeNullDefault

23、customers_basket_attributes_idint(11)Nocustomers_idint(11)No0products_idtinytextNoproducts_options_idvarchar(64)No0products_options_value_idint(11)No0products_options_value_textblobYesNULLproducts_options_sort_ordertextNocustomers_info客戶詳細(xì)信息FieldTypeNullDefaultcustomers_info_idint(11)No0customers_in

24、fo_date_of_last_logondatetimeYesNULLcustomers_info_number_of_logonsint(5)YesNULLcustomers_info_date_account_createddatetimeYesNULLcustomers_info_date_account_last_modifieddatetimeYesNULLglobal_product_notificationsint(1)Yes0db_cache數(shù)據(jù)庫(kù)緩存表FieldTypeNullDefaultcache_entry_namevarchar(64)Nocache_datamed

25、iumblobYesNULLcache_entry_createdint(15)YesNULLemail_archive聯(lián)系我們郵件存檔FieldTypeNullDefaultarchive_idint(11)Noemail_to_namevarchar(96)Noemail_to_addressvarchar(96)Noemail_from_namevarchar(96)Noemail_from_addressvarchar(96)Noemail_subjectvarchar(255)Noemail_htmltextNoemail_texttextNodate_sentdatetimeNo0

26、001-01-0100:00:00modulevarchar(64)Noezpages簡(jiǎn)易頁(yè)面（拋棄使用）FieldTypeNullDefaultpages_idint(11)Nolanguages_idint(11)No1pages_titlevarchar(64)Noalt_urlvarchar(255)Noalt_url_externalvarchar(255)Nopages_html_textmediumtextYesNULLstatus_headerint(1)No1status_sideboxint(1)No1status_footerint(1)No1status_tocint(

27、1)No1header_sort_orderint(3)No0sidebox_sort_orderint(3)No0footer_sort_orderint(3)No0toc_sort_orderint(3)No0page_open_new_windowint(1)No0page_is_sslint(1)No0toc_chapterint(11)No0ezpages_content簡(jiǎn)易頁(yè)面內(nèi)容（拋棄使用）FieldTypeNullDefaultpc_idint(11)Nopages_idint(11)No0languages_idint(11)No1pages_titlevarchar(64)

28、Nopages_html_texttextYesNULLfeatured推薦產(chǎn)品FieldTypeNullDefaultfeatured_idint(11)Noproducts_idint(11)No0featured_date_addeddatetimeYesNULLfeatured_last_modifieddatetimeYesNULLexpires_datedateNo0001-01-01date_status_changedatetimeYesNULLstatusint(1)No1featured_date_availabledateNo0001-01-01files_uploade

29、d上傳文檔記錄FieldTypeNullDefaultfiles_uploaded_idint(11)Nosesskeyvarchar(32)YesNULLcustomers_idint(11)YesNULLfiles_uploaded_namevarchar(64)Nogeo_zonesGEO分區(qū)信息表FieldTypeNullDefaultgeo_zone_idint(11)Nogeo_zone_namevarchar(32)Nogeo_zone_descriptionvarchar(255)Nolast_modifieddatetimeYesNULLdate_addeddatetimeN

30、o0001-01-0100:00:00get_terms_to_filterFieldTypeNullDefaultget_term_namevarchar(255)Noget_term_tablevarchar(64)Noget_term_name_fieldvarchar(64)Nogroup_pricing等級(jí)價(jià)格FieldTypeNullDefaultgroup_idint(11)Nogroup_namevarchar(32)Nogroup_percentagedecimal(5,2)No0last_modifieddatetimeYesNULLdate_addeddatetimeNo

31、0001-01-0100:00:00languages語(yǔ)言FieldTypeNullDefaultlanguages_idint(11)Nonamevarchar(32)Nocodechar(2)Noimagevarchar(64)YesNULLdirectoryvarchar(32)YesNULLsort_orderint(3)YesNULLlayout_boxes側(cè)邊欄FieldTypeNullDefaultlayout_idint(11)Nolayout_templatevarchar(64)Nolayout_box_namevarchar(64)Nolayout_box_statust

32、inyint(1)No0layout_box_locationtinyint(1)No0layout_box_sort_orderint(11)No0layout_box_sort_order_singleint(11)No0layout_box_status_singletinyint(4)No0manufacturers廠商、品牌設(shè)置FieldTypeNullDefaultmanufacturers_idint(11)Nomanufacturers_namevarchar(32)Nomanufacturers_imagevarchar(64)YesNULLdate_addeddatetim

33、eYesNULLlast_modifieddatetimeYesNULLmanufacturers_info廠商、品牌詳情FieldTypeNullDefaultmanufacturers_idint(11)No0languages_idint(11)No0manufacturers_urlvarchar(255)Nourl_clickedint(5)No0date_last_clickdatetimeYesNULLmedia_clips媒體相關(guān)表?xiàng)売肍ieldTypeNullDefaultclip_idint(11)Nomedia_idint(11)No0clip_typesmallint(

34、6)No0clip_filenametextNodate_addeddatetimeNo0001-01-0100:00:00last_modifieddatetimeNo0001-01-0100:00:00media_manager媒體相關(guān)表?xiàng)売肍ieldTypeNullDefaultmedia_idint(11)Nomedia_namevarchar(255)Nolast_modifieddatetimeNo0001-01-0100:00:00date_addeddatetimeNo0001-01-0100:00:00media_to_products媒體相關(guān)表?xiàng)売肍ieldTypeNull

35、Defaultmedia_idint(11)No0product_idint(11)No0media_types媒體相關(guān)表?xiàng)売肍ieldTypeNullDefaulttype_idint(11)Notype_namevarchar(64)Notype_extvarchar(8)Nometa_tags_categories_description分類META優(yōu)化信息FieldTypeNullDefaultcategories_idint(11)Nolanguage_idint(11)No1metatags_titlevarchar(255)Nometatags_keywordstextYesNU

36、LLmetatags_descriptiontextYesNULLmeta_tags_products_description產(chǎn)品META優(yōu)化信息FieldTypeNullDefaultproducts_idint(11)Nolanguage_idint(11)No1metatags_titlevarchar(255)Nometatags_keywordstextYesNULLmetatags_descriptiontextYesNULLmusic_genre音樂(lè)相關(guān)表?xiàng)売肍ieldTypeNullDefaultmusic_genre_idint(11)Nomusic_genre_nameva

37、rchar(32)Nodate_addeddatetimeYesNULLlast_modifieddatetimeYesNULLnewsletters電子商情記錄FieldTypeNullDefaultnewsletters_idint(11)Notitlevarchar(255)NocontenttextNocontent_htmltextNomodulevarchar(255)Nodate_addeddatetimeNo0001-01-0100:00:00date_sentdatetimeYesNULLstatusint(1)YesNULLlockedint(1)Yes0orders訂單基

38、本信息FieldTypeNullDefaultorders_idint(11)Nocustomers_idint(11)No0customers_namevarchar(64)Nocustomers_companyvarchar(64)YesNULLcustomers_street_addressvarchar(64)Nocustomers_suburbvarchar(32)YesNULLcustomers_cityvarchar(32)Nocustomers_postcodevarchar(10)Nocustomers_statevarchar(32)YesNULLcustomers_cou

39、ntryvarchar(32)Nocustomers_telephonevarchar(32)Nocustomers_email_addressvarchar(96)Nocustomers_address_format_idint(5)No0delivery_namevarchar(64)Nodelivery_companyvarchar(64)YesNULLdelivery_street_addressvarchar(64)Nodelivery_suburbvarchar(32)YesNULLdelivery_cityvarchar(32)Nodelivery_postcodevarchar

40、(10)Nodelivery_statevarchar(32)YesNULLdelivery_countryvarchar(32)Nodelivery_address_format_idint(5)No0billing_namevarchar(64)Nobilling_companyvarchar(64)YesNULLbilling_street_addressvarchar(64)Nobilling_suburbvarchar(32)YesNULLbilling_cityvarchar(32)Nobilling_postcodevarchar(10)Nobilling_statevarcha

41、r(32)YesNULLbilling_countryvarchar(32)Nobilling_address_format_idint(5)No0payment_methodvarchar(128)Nopayment_module_codevarchar(32)Noshipping_methodvarchar(128)Noshipping_module_codevarchar(32)Nocoupon_codevarchar(32)Nocc_typevarchar(20)YesNULLcc_ownervarchar(64)YesNULLcc_numbervarchar(32)YesNULLcc

42、_expiresvarchar(4)YesNULLcc_cvvblobYesNULLlast_modifieddatetimeYesNULLdate_purchaseddatetimeYesNULLorders_statusint(5)No0orders_date_finisheddatetimeYesNULLcurrencychar(3)YesNULLcurrency_valuedecimal(14,6)YesNULLorder_totaldecimal(14,2)YesNULLorder_taxdecimal(14,2)YesNULLpaypal_ipn_idint(11)No0ip_ad

43、dressvarchar(96)Noorders_products訂單產(chǎn)品信息FieldTypeNullDefaultorders_products_idint(11)Noorders_idint(11)No0products_idint(11)No0products_modelvarchar(32)YesNULLproducts_namevarchar(64)Noproducts_pricedecimal(15,4)No0final_pricedecimal(15,4)No0products_taxdecimal(7,4)No0products_quantityfloatNo0onetime

44、_chargesdecimal(15,4)No0products_priced_by_attributetinyint(1)No0product_is_freetinyint(1)No0products_discount_typetinyint(1)No0products_discount_type_fromtinyint(1)No0products_pridtinytextNoorders_products_attributes訂單產(chǎn)品屬性FieldTypeNullDefaultorders_products_attributes_idint(11)Noorders_idint(11)No0

45、orders_products_idint(11)No0products_optionsvarchar(32)Noproducts_options_valuestextNooptions_values_pricedecimal(15,4)No0price_prefixchar(1)Noproduct_attribute_is_freetinyint(1)No0products_attributes_weightfloatNo0products_attributes_weight_prefixchar(1)Noattributes_discountedtinyint(1)No1attribute

46、s_price_base_includedtinyint(1)No1attributes_price_onetimedecimal(15,4)No0attributes_price_factordecimal(15,4)No0attributes_price_factor_offsetdecimal(15,4)No0attributes_price_factor_onetimedecimal(15,4)No0attributes_price_factor_onetime_offsetdecimal(15,4)No0attributes_qty_pricestextYesNULLattribut

47、es_qty_prices_onetimetextYesNULLattributes_price_wordsdecimal(15,4)No0attributes_price_words_freeint(4)No0attributes_price_lettersdecimal(15,4)No0attributes_price_letters_freeint(4)No0products_options_idint(11)No0products_options_values_idint(11)No0products_pridtinytextNoorders_products_download訂單下載

48、產(chǎn)品記錄棄用FieldTypeNullDefaultorders_products_download_idint(11)Noorders_idint(11)No0orders_products_idint(11)No0orders_products_filenamevarchar(255)Nodownload_maxdaysint(2)No0download_countint(2)No0products_pridtinytextNoorders_status訂單狀態(tài)定義表FieldTypeNullDefaultorders_status_idint(11)No0language_idint(1

49、1)No1orders_status_namevarchar(32)Noorders_status_history訂單狀態(tài)調(diào)整歷史FieldTypeNullDefaultorders_status_history_idint(11)Noorders_idint(11)No0orders_status_idint(5)No0date_addeddatetimeNo0001-01-0100:00:00customer_notifiedint(1)Yes0commentstextYesNULLorders_total訂單總額計(jì)算表FieldTypeNullDefaultorders_total_id

50、int(10)Noorders_idint(11)No0titlevarchar(255)Notextvarchar(255)Novaluedecimal(15,4)No0classvarchar(32)Nosort_orderint(11)No0paypalpaypal信息表FieldTypeNullDefaultpaypal_ipn_idint(11)Noorder_idint(11)No0txn_typevarchar(40)Nomodule_namevarchar(40)Nomodule_modevarchar(40)Noreason_codevarchar(40)YesNULLpay

51、ment_typevarchar(40)Nopayment_statusvarchar(32)Nopending_reasonvarchar(32)YesNULLinvoicevarchar(128)YesNULLmc_currencychar(3)Nofirst_namevarchar(32)Nolast_namevarchar(32)Nopayer_business_namevarchar(128)YesNULLaddress_namevarchar(64)YesNULLaddress_streetvarchar(254)YesNULLaddress_cityvarchar(120)Yes

52、NULLaddress_statevarchar(120)YesNULLaddress_zipvarchar(10)YesNULLaddress_countryvarchar(64)YesNULLaddress_statusvarchar(11)YesNULLpayer_emailvarchar(128)Nopayer_idvarchar(32)Nopayer_statusvarchar(10)Nopayment_datedatetimeNo0001-01-0100:00:00businessvarchar(128)Noreceiver_emailvarchar(128)Noreceiver_

53、idvarchar(32)Notxn_idvarchar(20)Noparent_txn_idvarchar(20)YesNULLnum_cart_itemstinyint(4)No1mc_grossdecimal(7,2)No0mc_feedecimal(7,2)No0payment_grossdecimal(7,2)YesNULLpayment_feedecimal(7,2)YesNULLsettle_amountdecimal(7,2)YesNULLsettle_currencychar(3)YesNULLexchange_ratedecimal(4,2)YesNULLnotify_ve

54、rsionvarchar(6)Noverify_signvarchar(128)Nolast_modifieddatetimeNo0001-01-0100:00:00date_addeddatetimeNo0001-01-0100:00:00memotextYesNULLpaypal_payment_statuspaypal付款狀態(tài)表FieldTypeNullDefaultpayment_status_idint(11)Nopayment_status_namevarchar(64)Nopaypal_payment_status_historypaypal付款狀態(tài)歷史FieldTypeNull

55、Defaultpayment_status_history_idint(11)Nopaypal_ipn_idint(11)No0txn_idvarchar(64)Noparent_txn_idvarchar(64)Nopayment_statusvarchar(17)Nopending_reasonvarchar(14)YesNULLdate_addeddatetimeNo0001-01-0100:00:00paypal_sessionpaypalSESSIONFieldTypeNullDefaultunique_idint(11)Nosession_idtextNosaved_session

56、mediumblobNoexpiryint(17)No0paypal_testingpaypal測(cè)試表FieldTypeNullDefaultpaypal_ipn_idint(11)Noorder_idint(11)No0customvarchar(255)Notxn_typevarchar(40)Nomodule_namevarchar(40)Nomodule_modevarchar(40)Noreason_codevarchar(40)YesNULLpayment_typevarchar(40)Nopayment_statusvarchar(32)Nopending_reasonvarch

57、ar(32)YesNULLinvoicevarchar(128)YesNULLmc_currencychar(3)Nofirst_namevarchar(32)Nolast_namevarchar(32)Nopayer_business_namevarchar(128)YesNULLaddress_namevarchar(64)YesNULLaddress_streetvarchar(254)YesNULLaddress_cityvarchar(120)YesNULLaddress_statevarchar(120)YesNULLaddress_zipvarchar(10)YesNULLadd

58、ress_countryvarchar(64)YesNULLaddress_statusvarchar(11)YesNULLpayer_emailvarchar(128)Nopayer_idvarchar(32)Nopayer_statusvarchar(10)Nopayment_datedatetimeNo0001-01-0100:00:00businessvarchar(128)Noreceiver_emailvarchar(128)Noreceiver_idvarchar(32)Notxn_idvarchar(20)Noparent_txn_idvarchar(20)YesNULLnum

59、_cart_itemstinyint(4)No1mc_grossdecimal(7,2)No0mc_feedecimal(7,2)No0payment_grossdecimal(7,2)YesNULLpayment_feedecimal(7,2)YesNULLsettle_amountdecimal(7,2)YesNULLsettle_currencychar(3)YesNULLexchange_ratedecimal(4,2)YesNULLnotify_versiondecimal(2,1)No0verify_signvarchar(128)Nolast_modifieddatetimeNo

60、0001-01-0100:00:00date_addeddatetimeNo0001-01-0100:00:00memotextYesNULLproduct_music_extra音樂(lè)相關(guān)表?xiàng)売肍ieldTypeNullDefaultproducts_idint(11)No0artists_idint(11)No0record_company_idint(11)No0music_genre_idint(11)No0product_type_layout不同類型產(chǎn)品布局FieldTypeNullDefaultconfiguration_idint(11)Noconfiguration_title