shopEx数据库表结构说明文档

数据库表结构说明文档第22页共44页shopEx数据库表结构说明文档目录sdb_admin_roles 3sdb_advance_logs 3sdb_articles 4sdb_autosync_rule 4sdb_autosync_rule_relation 5sdb_autosync_task 5sdb_brand 5sdb_cachemgr 5sdb_comments 6sdb_cost_sync 6sdb_coupons 7sdb_coupons_p_items 7sdb_coupons_u_items 7sdb_ctlmap 7sdb_currency 8sdb_dapi 8sdb_dbver 8sdb_delivery 8sdb_delivery_item 9sdb_dly_area 9sdb_dly_center 10sdb_dly_corp 10sdb_dly_h_area 10sdb_dly_type 11sdb_gift 11sdb_gift_cat 12sdb_gift_items 12sdb_gimages 13sdb_gnotify 13sdb_goods 13sdb_goods_cat 15sdb_goods_keywords 16sdb_goods_lv_price 16sdb_goods_memo 16sdb_goods_rate 17sdb_goods_spec_index 17sdb_goods_type 17sdb_goods_type_spec 18sdb_goods_virtual_cat 18sdb_gtask 18sdb_image_sync 18sdb_job_apilist 19sdb_job_data_sync 19sdb_job_goods_download 19sdb_link 20sdb_lnk_acts 20sdb_lnk_roles 20sdb_magicvars 20sdb_members 21sdb_member_addrs 22sdb_member_attr 23sdb_member_coupon 23sdb_member_lv 23sdb_member_mattrvalue 24sdb_message 24sdb_msgqueue 25sdb_operators 25sdb_op_sessions 26sdb_orders 26sdb_order_items 28sdb_order_log 28sdb_order_pmt 28sdb_package_product 29sdb_pages 29sdb_payments 29sdb_payment_cfg 30sdb_plugins 30sdb_pmt_gen_coupon 31sdb_pmt_goods 31sdb_pmt_goods_cat 31sdb_pmt_member_lv 31sdb_point_history 32sdb_print_tmpl 32sdb_products 32sdb_product_memo 33sdb_promotion 33sdb_promotion_activity 34sdb_promotion_scheme 34sdb_pub_files 34sdb_refunds 35sdb_regions 35sdb_return_product 36sdb_sell_logs 36sdb_sendbox 36sdb_seo 37sdb_settings 37sdb_sfiles 37sdb_sitemaps 37sdb_specification 38sdb_spec_values 38sdb_status 39sdb_supplier 39sdb_supplier_pdtbn 39sdb_sync_tmp 40sdb_systmpl 40sdb_tags 40sdb_tag_rel 40sdb_taobao_goods_goods 41sdb_tb_order_ctl_orders 41sdb_tb_order_ctl_order_items 41sdb_tb_order_ctl_regions 42sdb_tb_sales_download_sell_log 42sdb_template_relation 42sdb_themes 42sdb_tpl_source 43sdb_triggers 43sdb_trust_login 43sdb_type_brand 44sdb_widgets_set 44sdb_admin_roles描述：序号字段名称字段描述字段类型长度允许空缺省值1role_idint10,02role_namevarchar1003role_memotext65535√4disabledenum5falsesdb_advance_logs描述：序号字段名称字段描述字段类型长度允许空缺省值1log_idmediumint7,02member_idmediumint7,003moneydecimal20,30.0004messagevarchar255√5mtimeint10,006payment_idvarchar20√7order_idbigint19,0√8paymethodvarchar100√9memovarchar100√10import_moneydecimal20,30.00011explode_moneydecimal20,30.00012member_advancedecimal20,30.00013shop_advancedecimal20,30.00014disabledenum5falsesdb_articles描述：序号字段名称字段描述字段类型长度允许空缺省值1article_idmediumint7,02node_idmediumint7,003titlevarchar200√4contentlongtext4294967295√5uptimeint10,0√6ifpubenum1√7alignvarchar12√8filetypevarchar15√9filenamevarchar80√10orderlistmediumint7,0√11pubtimeint10,0√12disabledenum5√false13goodsinfotext65535√sdb_autosync_rule描述：序号字段名称字段描述字段类型长度允许空缺省值1rule_idmediumint7,02supplier_op_idtinyint3,003local_op_idtinyint3,004disabledenum5false5memovarchar255√6rule_namevarchar255sdb_autosync_rule_relation描述：序号字段名称字段描述字段类型长度允许空缺省值1rule_idmediumint7,002supplier_idint10,003pline_idtinyint3,004memotext65535√sdb_autosync_task描述：序号字段名称字段描述字段类型长度允许空缺省值1supplier_idint10,002command_idint10,003local_op_idmediumint7,0√0sdb_brand描述：序号字段名称字段描述字段类型长度允许空缺省值1brand_idmediumint7,02supplier_idint10,0√3supplier_brand_idmediumint7,0√4brand_namevarchar505brand_urlvarchar255√6brand_desclongtext4294967295√7brand_logovarchar255√8brand_keywordslongtext4294967295√9disabledenum5√false10ordernummediumint7,0√sdb_cachemgr描述：序号字段名称字段描述字段类型长度允许空缺省值1cnamevarchar302modifiedint10,00sdb_comments描述：序号字段名称字段描述字段类型长度允许空缺省值1comment_idmediumint7,02for_comment_idmediumint7,0√3goods_idmediumint7,004object_typeenum7ask5author_idmediumint7,0√6authorvarchar100√7levelnamevarchar50√8contactvarchar255√9mem_read_statusenum5false10adm_read_statusenum5false11timeint10,0012lastreplyint10,0013reply_namevarchar100√14titlevarchar255√15commentlongtext4294967295√16ipvarchar15√17displayenum5false18p_indexenum1√019disabledenum5√falsesdb_cost_sync描述：序号字段名称字段描述字段类型长度允许空缺省值1supplier_idint10,002bnvarchar303costdecimal20,30.0004version_idint10,005product_idmediumint7,006goods_idmediumint7,00sdb_coupons描述：序号字段名称字段描述字段类型长度允许空缺省值1cpns_idmediumint7,02cpns_namevarchar255√3pmt_idmediumint7,0√4cpns_prefixvarchar505cpns_gen_quantitymediumint7,006cpns_keyvarchar207cpns_statusenum118cpns_typeenum119cpns_pointmediumint7,0√10disabledenum5√falsesdb_coupons_p_items描述：序号字段名称字段描述字段类型长度允许空缺省值1order_idbigint19,002cpns_idmediumint7,003cpns_namevarchar255√4numsmediumint7,0√sdb_coupons_u_items描述：序号字段名称字段描述字段类型长度允许空缺省值1order_idbigint19,002cpns_idmediumint7,003cpns_namevarchar255√4memc_codevarchar255√5cpns_typeenum1√sdb_ctlmap描述：序号字段名称字段描述字段类型长度允许空缺省值1controllervarchar1002pluginvarchar100sdb_currency描述：序号字段名称字段描述字段类型长度允许空缺省值1cur_codevarchar82cur_namevarchar203cur_signvarchar5√4cur_ratedecimal10,41.00005def_curenum5false6disabledenum5√falsesdb_dapi描述：序号字段名称字段描述字段类型长度允许空缺省值1funcvarchar602last_updateint10,003checksumvarchar32√4codetext65535sdb_dbver描述：序号字段名称字段描述字段类型长度允许空缺省值1dbvervarchar255√sdb_delivery描述：序号字段名称字段描述字段类型长度允许空缺省值1delivery_idbigint19,02order_idbigint19,0√3member_idmediumint7,0√4moneydecimal20,30.0005typeenum8delivery6is_protectenum5false7deliveryvarchar20√8logi_idvarchar50√9logi_namevarchar100√10logi_novarchar50√11ship_namevarchar50√12ship_areavarchar255√13ship_addrvarchar100√14ship_zipvarchar20√15ship_telvarchar30√16ship_mobilevarchar50√17ship_emailvarchar150√18t_beginint10,0√19t_endint10,0√20op_namevarchar50√21statusenum8ready22memolongtext4294967295√23disabledenum5√false24supplier_idint10,0√25supplier_delivery_idvarchar30√sdb_delivery_item描述：序号字段名称字段描述字段类型长度允许空缺省值1item_idint10,02delivery_idbigint19,003item_typeenum5goods4product_idbigint19,005product_bnvarchar30√6product_namevarchar200√7numbermediumint7,00sdb_dly_area描述：序号字段名称字段描述字段类型长度允许空缺省值1area_idmediumint7,02namevarchar803disabledenum5√false4ordernumsmallint5,0√sdb_dly_center描述：序号字段名称字段描述字段类型长度允许空缺省值1dly_center_idint10,02namevarchar503addressvarchar2004regionvarchar255√5zipvarchar20√6phonevarchar100√7unamevarchar100√8cellphonevarchar100√9sexenum6√10memolongtext4294967295√11disabledenum5falsesdb_dly_corp描述：序号字段名称字段描述字段类型长度允许空缺省值1corp_idmediumint7,02typevarchar6√3namevarchar200√4disabledenum5√false5ordernumsmallint5,0√6websitevarchar200√sdb_dly_h_area描述：序号字段名称字段描述字段类型长度允许空缺省值1dha_idmediumint7,02dt_idmediumint7,0√3area_idmediumint7,0√04pricevarchar100√05has_codtinyint3,006areaname_grouplongtext4294967295√7areaid_grouplongtext4294967295√8configvarchar255√9expressionsvarchar255√10ordernumsmallint5,0√sdb_dly_type描述：序号字段名称字段描述字段类型长度允许空缺省值1dt_idmediumint7,02dt_namevarchar50√3dt_configlongtext4294967295√4dt_expressionslongtext4294967295√5detaillongtext4294967295√6pricelongtext42949672957typeenum118gatewaymediumint7,0√09protectenum1010protect_ratefloat6,3√11ordernumsmallint5,0√012has_codenum1013minpricefloat10,20.0014disabledenum5√false15corp_idint10,0√16dt_statusenum1√1sdb_gift描述：序号字段名称字段描述字段类型长度允许空缺省值1gift_idmediumint7,02giftcat_idmediumint7,0√3insert_timeint10,004update_timeint10,005namevarchar2556thumbnail_picvarchar255√7small_picvarchar255√8big_picvarchar255√9image_filelongtext4294967295√10introvarchar255√11gift_describelongtext4294967295√12weightint10,0013storagemediumint7,0014pricevarchar255√15orderlistmediumint7,0√016shop_iffbenum1117limit_nummediumint7,0√018limit_start_timeint10,0019limit_end_timeint10,0020limit_levelvarchar255√21ifrecommendenum1022pointmediumint7,0023freezmediumint7,0√024disabledenum5√falsesdb_gift_cat描述：序号字段名称字段描述字段类型长度允许空缺省值1giftcat_idmediumint7,02catvarchar255√3orderlistmediumint7,0√4shop_iffbenum1√15disabledenum5√falsesdb_gift_items描述：序号字段名称字段描述字段类型长度允许空缺省值1order_idbigint19,002gift_idmediumint7,003namevarchar200√4pointint10,0√5numsmediumint7,0√6amountint10,0√7sendnummediumint7,0√08getmethodenum8presentsdb_gimages描述：序号字段名称字段描述字段类型长度允许空缺省值1gimage_idmediumint7,02goods_idmediumint7,0√3is_remoteenum5false4sourcevarchar2555orderbytinyint3,006src_size_widthint10,007src_size_heightint10,008smallvarchar255√9bigvarchar255√10thumbnailvarchar255√11up_timeint10,0012supplier_idint10,0√13supplier_gimage_idmediumint7,0√14sync_timeint10,0√0sdb_gnotify描述：序号字段名称字段描述字段类型长度允许空缺省值1gnotify_idmediumint7,02goods_idmediumint7,0√3member_idmediumint7,0√4product_idmediumint7,0√5emailvarchar200√6statusenum8ready7send_timeint10,0√8creat_timeint10,0√9disabledenum5false10remarklongtext4294967295√sdb_goods描述：序号字段名称字段描述字段类型长度允许空缺省值1goods_idmediumint7,02cat_idint10,003type_idint10,0√4goods_typeenum6normal5brand_idmediumint7,0√6brandvarchar100√7supplier_idint10,0√8supplier_goods_idmediumint7,0√9wss_paramslongtext4294967295√10image_defaultlongtext4294967295√11udfimgenum5√false12thumbnail_picvarchar255√13small_picvarchar255√14big_picvarchar255√15image_filelongtext4294967295√16briefvarchar255√17introlongtext4294967295√18mktpricedecimal20,3√19costdecimal20,30.00020pricedecimal20,30.00021bn商品货号varchar200√22namevarchar20023marketableenum5true24weightdecimal20,3√25unitvarchar20√26storemediumint7,0√27store_placevarchar255√28score_settingenum7√number29scoremediumint7,0√30speclongtext4294967295√31pdt_desclongtext4294967295√32spec_desclongtext4294967295√33paramslongtext4294967295√34uptimeint10,0√35downtimeint10,0√36last_modifyint10,0√37disabledenum5false38notify_nummediumint7,0039rankdecimal5,3√5.00040rank_countint10,0√041comments_countint10,0042view_w_countint10,0043view_countint10,0044buy_countint10,0045buy_w_countint10,0046count_statlongtext4294967295√47p_ordermediumint7,03048d_ordermediumint7,03049p_1varchar255√50p_2varchar255√51p_3varchar255√52p_4varchar255√53p_5varchar255√54p_6varchar255√55p_7varchar255√56p_8varchar255√57p_9varchar255√58p_10varchar255√59p_11varchar255√60p_12varchar255√61p_13varchar255√62p_14varchar255√63p_15varchar255√64p_16varchar255√65p_17varchar255√66p_18varchar255√67p_19varchar255√68p_20varchar255√69p_21varchar255√70p_22varchar255√71p_23varchar255√72p_24varchar255√73p_25varchar255√74p_26varchar255√75p_27varchar255√76p_28varchar255√77goods_info_update_statusenum5√false78stock_update_statusenum5√false79marketable_update_statusenum5√false80img_update_statusenum5√falsesdb_goods_cat描述：序号字段名称字段描述字段类型长度允许空缺省值1cat_idint10,02parent_idint10,0√3supplier_idint10,0√4supplier_cat_idmediumint7,0√5cat_pathvarchar100√,6is_leafenum5false7type_idint10,0√8cat_namevarchar1009disabledenum5false10p_ordermediumint7,0√11goods_countmediumint7,0√12tabslongtext4294967295√13finderlongtext4294967295√14addonlongtext4294967295√15child_countmediumint7,00sdb_goods_keywords描述：序号字段名称字段描述字段类型长度允许空缺省值1goods_idmediumint7,002keywordvarchar403refervarchar255√4res_typeenum7goodssdb_goods_lv_price描述：序号字段名称字段描述字段类型长度允许空缺省值1product_idmediumint7,002level_idmediumint7,003goods_idmediumint7,004pricedecimal20,3√sdb_goods_memo描述：序号字段名称字段描述字段类型长度允许空缺省值1goods_idmediumint7,002p_keyvarchar203p_valuelongtext4294967295√sdb_goods_rate描述：序号字段名称字段描述字段类型长度允许空缺省值1goods_1mediumint7,002goods_2mediumint7,003manualenum4√4ratemediumint7,01sdb_goods_spec_index描述：序号字段名称字段描述字段类型长度允许空缺省值1type_idint10,002spec_idmediumint7,003spec_value_idmediumint7,004spec_valuevarchar1005goods_idmediumint7,006product_idmediumint7,00sdb_goods_type描述：序号字段名称字段描述字段类型长度允许空缺省值1type_idint10,02namevarchar1003aliaslongtext4294967295√4is_physicalenum115supplier_idint10,0√6supplier_type_idmediumint7,0√7schema_idvarchar30custom8propslongtext4294967295√9speclongtext4294967295√10settinglongtext4294967295√11minfolongtext4294967295√12paramslongtext4294967295√13dly_funcenum1014ret_funcenum1015reshipenum8normal16disabledenum5√false17is_defenum5false18lastmodifyint10,0√sdb_goods_type_spec描述：序号字段名称字段描述字段类型长度允许空缺省值1spec_idmediumint7,0√02type_idint10,0√03spec_styleenum8flatsdb_goods_virtual_cat描述：序号字段名称字段描述字段类型长度允许空缺省值1virtual_cat_idmediumint7,02virtual_cat_namevarchar1003filterlongtext4294967295√4addonlongtext4294967295√5type_idint10,0√6disabledenum5false7parent_idmediumint7,0√08cat_idint10,0√9p_ordermediumint7,0√10cat_pathvarchar100√,11child_countmediumint7,0√0sdb_gtask描述：序号字段名称字段描述字段类型长度允许空缺省值1goods_idmediumint7,0√2tasktimeint10,003actionenum7onlinesdb_image_sync描述：序号字段名称字段描述字段类型长度允许空缺省值1img_sync_idint10,02typeenum10gimage3supplier_idint10,004supplier_object_idmediumint7,005add_timeint10,006command_idint10,007failedenum5falsesdb_job_apilist描述：序号字段名称字段描述字段类型长度允许空缺省值1job_idint10,02supplier_idint10,003api_namevarchar1004api_paramslongtext4294967295√5api_versionvarchar106api_actionvarchar1007pagemediumint7,008limitmediumint7,00sdb_job_data_sync描述：序号字段名称字段描述字段类型长度允许空缺省值1job_idint10,02from_timeint10,003to_timeint10,004pagemediumint7,005limitmediumint7,006supplier_idint10,007supplier_plinelongtext4294967295√8auto_downloadenum5false9to_cat_idmediumint7,0√sdb_job_goods_download描述：序号字段名称字段描述字段类型长度允许空缺省值1job_idint10,02supplier_idint10,003supplier_goods_idmediumint7,004supplier_goods_countint10,015command_idint10,006failedenum5false7to_cat_idmediumint7,0√sdb_link描述：序号字段名称字段描述字段类型长度允许空缺省值1link_idmediumint7,02link_namevarchar1283hrefvarchar2554image_urlvarchar255√5orderlistmediumint7,006disabledenum5√falsesdb_lnk_acts描述：序号字段名称字段描述字段类型长度允许空缺省值1role_idint10,002action_idint10,00sdb_lnk_roles描述：序号字段名称字段描述字段类型长度允许空缺省值1op_idmediumint7,002role_idint10,00sdb_magicvars描述：序号字段名称字段描述字段类型长度允许空缺省值1var_namevarchar202var_titlevarchar100√3var_remarkvarchar1004var_valuetext65535√5var_typeenum6custom6disabledenum5falsesdb_members描述：序号字段名称字段描述字段类型长度允许空缺省值1member_idIDmediumint7,02member_lv_id会员等级mediumint7,003uname用户名varchar504name姓名varchar50√5lastnamevarchar50√6firstnamevarchar50√7passwordvarchar32√8areavarchar255√9mobilevarchar30√10telvarchar30√11emailvarchar20012zipvarchar20√13addrvarchar255√14provincevarchar20√15cityvarchar20√16order_nummediumint7,0√017refer_id首次来源IDvarchar50√18refer_url首次来源URLvarchar200√19refer_time首次来源时间int10,0√20c_refer_id本次来源IDvarchar50√21c_refer_url本次来源URLvarchar200√22c_refer_time本次来源时间int10,0√23b_yearsmallint5,0√24b_monthtinyint3,0√25b_daytinyint3,0√26sex性别enum1127addonlongtext4294967295√28wedlockenum1029educationvarchar30√30vocationvarchar50√31interestlongtext4294967295√32advance预存款decimal20,30.00033advance_freezedecimal20,30.00034point_freezemediumint7,0035point_historymediumint7,0036point积分mediumint7,0037score_ratedecimal5,3√38reg_ip注册IPvarchar16√39regtime注册时间int10,0√40state验证状态tinyint3,0041pay_timemediumint7,0√42biz_moneydecimal20,30.00043pw_answervarchar250√44pw_questionvarchar250√45fav_tagslongtext4294967295√46customlongtext4294967295√47cur货币varchar20√48lang语言varchar20√49unreadmsg未读信息smallint5,0050disabledenum5√false51remark备注text65535√52remark_typevarchar2b153login_countint10,0054experience经验值int10,0√055foreign_idvarchar255√56member_refervarchar50√localsdb_member_addrs描述：序号字段名称字段描述字段类型长度允许空缺省值1addr_idmediumint7,02member_idmediumint7,003namevarchar50√4area地区varchar255√5countryvarchar30√6provincevarchar30√7cityvarchar50√8addr地址varchar255√9zip邮编varchar20√10tel固定电话varchar30√11mobile手机varchar30√12def_addrtinyint3,0√0sdb_member_attr描述：序号字段名称字段描述字段类型长度允许空缺省值1attr_idint10,02attr_namevarchar203attr_typevarchar204attr_requiredenum5false5attr_searchenum5false6attr_optiontext65535√7attr_valtypevarchar208disabledenum5false9attr_tynamevarchar2010attr_groupvarchar2011attr_showenum5true12attr_orderint10,00sdb_member_coupon描述：序号字段名称字段描述字段类型长度允许空缺省值1memc_codevarchar2552cpns_idmediumint7,003member_idmediumint7,004memc_gen_orderidvarchar15√5memc_sourceenum1a6memc_enabledenum5true7memc_used_timesmediumint7,0√08memc_gen_timeint10,0√sdb_member_lv描述：序号字段名称字段描述字段类型长度允许空缺省值1member_lv_idmediumint7,02namevarchar1003dis_countdecimal5,21.004pre_idmediumint7,0√5default_lvenum106deposit_freeze_timeint10,0√07depositint10,0√08more_pointint10,0√19pointmediumint7,0010lv_typeenum9retail11disabledenum5√false12show_other_priceenum5true13order_limittinyint3,0014order_limit_pricedecimal20,30.00015lv_remarktext65535√16experienceint10,00sdb_member_mattrvalue描述：序号字段名称字段描述字段类型长度允许空缺省值1attr_idint10,002member_idmediumint7,003valuevarchar1004idint10,0sdb_message描述：序号字段名称字段描述字段类型长度允许空缺省值1msg_idmediumint7,02for_idmediumint7,003msg_fromvarchar304from_idmediumint7,0√05from_typetinyint3,006to_idmediumint7,007to_typetinyint3,008unreadenum109folderenum6inbox10emailvarchar255√11telvarchar30√12subjectvarchar10013messagelongtext429496729514rel_orderbigint19,0√015date_lineint10,0016is_secenum5true17del_statusenum1√018disabledenum5false19msg_ipvarchar2020msg_typeenum7defaultsdb_msgqueue描述：序号字段名称字段描述字段类型长度允许空缺省值1queue_idmediumint7,02titlevarchar250√3targetvarchar2504event_namevarchar50√5datalongtext4294967295√6tmpl_namevarchar507leveltinyint3,058sendervarchar509sender_ordertinyint3,05sdb_operators描述：序号字段名称字段描述字段类型长度允许空缺省值1op_idmediumint7,02usernamevarchar203userpassvarchar324namevarchar30√5configlongtext4294967295√6favoritelongtext4294967295√7superenum108lastipvarchar20√9logincountmediumint7,0010lastloginint10,0011statusenum1112disabledenum5false13op_novarchar50√14departmentvarchar50√15memotext65535√sdb_op_sessions描述：序号字段名称字段描述字段类型长度允许空缺省值1sess_idvarchar322op_idmediumint7,0√3login_timeint10,0√4last_timeint10,0√5api_idmediumint7,0√6sess_datalongtext4294967295√7statustinyint3,0√08ipvarchar17√sdb_orders描述：序号字段名称字段描述字段类型长度允许空缺省值1order_idbigint19,002member_idmediumint7,0√3confirmenum1N4statusenum6active5pay_statusenum106ship_statusenum107user_statusenum7null8is_deliveryenum1Y9shipping_idsmallint5,0√10shippingvarchar100√11shipping_areavarchar50√12paymentmediumint7,0√13weightdecimal20,3√14tostrlongtext4294967295√15itemnummediumint7,0√16acttimeint10,0√17createtimeint10,0√18refer_idvarchar50√19refer_urlvarchar200√20refer_timeint10,0√21c_refer_idvarchar50√22c_refer_urlvarchar200√23c_refer_timeint10,0√24ipvarchar15√25ship_namevarchar50√26ship_areavarchar255√27ship_addrvarchar100√28ship_zipvarchar20√29ship_telvarchar30√30ship_emailvarchar150√31ship_timevarchar50√32ship_mobilevarchar50√33cost_itemdecimal20,30.00034is_taxenum5false35cost_taxdecimal20,30.00036tax_companyvarchar255√37cost_freightdecimal20,30.00038is_protectenum5false39cost_protectdecimal20,30.00040cost_paymentdecimal20,3√41currencyvarchar8√42cur_ratedecimal10,4√1.000043score_udecimal20,30.00044score_gdecimal20,30.00045score_edecimal20,30.00046advancedecimal20,3√0.00047discountdecimal20,30.00048use_pmtvarchar30√49total_amountdecimal20,30.00050final_amountdecimal20,30.00051pmt_amountdecimal20,3√52payeddecimal20,3√0.00053markstarenum1√N54memolongtext4294967295√55print_statustinyint3,0056mark_textlongtext4294967295√57disabledenum5√false58last_change_timeint10,0059use_registerinfoenum5√false60mark_typevarchar2b161extendvarchar255√false62is_has_remote_pdtsenum5false63order_refervarchar20local64print_idvarchar20√sdb_order_items描述：序号字段名称字段描述字段类型长度允许空缺省值1item_idmediumint7,02order_idbigint19,003product_idmediumint7,004dly_statusenum8storage5type_idint10,0√6bnvarchar40√7namevarchar200√8costdecimal20,3√9pricedecimal20,30.00010amountdecimal20,3√11scoremediumint7,0√12numsmediumint7,0113minfolongtext4294967295√14sendnummediumint7,0015addonlongtext4294967295√16is_typeenum5goods17pointmediumint7,0√18supplier_idint10,0√sdb_order_log描述：序号字段名称字段描述字段类型长度允许空缺省值1log_idint10,02order_idbigint19,0√3op_idmediumint7,0√4op_namevarchar30√5log_textlongtext4294967295√6acttimeint10,0√7behaviorvarchar20√8resultenum7√successsdb_order_pmt描述：序号字段名称字段描述字段类型长度允许空缺省值1pmt_idbigint19,002order_idbigint19,003pmt_amountdecimal20,3√4pmt_memolongtext4294967295√5pmt_describelongtext4294967295√sdb_package_product描述：序号字段名称字段描述字段类型长度允许空缺省值1product_idmediumint7,002goods_idmediumint7,003discountdecimal5,3√4pkgnummediumint7,01sdb_pages描述：序号字段名称字段描述字段类型长度允许空缺省值1page_idmediumint7,02page_namevarchar903page_titlevarchar904page_contentlongtext4294967295√5page_timeint10,00sdb_payments描述：序号字段名称字段描述字段类型长度允许空缺省值1payment_idvarchar202order_idbigint19,0√3member_idmediumint7,0√4accountvarchar50√5bankvarchar50√6pay_accountvarchar50√7currencyvarchar10√8moneydecimal20,30.0009paycostdecimal20,3√10cur_moneydecimal20,30.00011pay_typeenum8online12paymentmediumint7,0013paymethodvarchar100√14op_idmediumint7,0√15ipvarchar20√16t_beginint10,0√17t_endint10,0√18statusenum8ready19memolongtext4294967295√20disabledenum5√false21trade_novarchar30√sdb_payment_cfg描述：序号字段名称字段描述字段类型长度允许空缺省值1idmediumint7,02custom_namevarchar100√3pay_typevarchar304configlongtext4294967295√5feedecimal9,50.000006deslongtext4294967295√7order_numsmallint5,008disabledenum5√false9orderlistmediumint7,0√sdb_plugins描述：序号字段名称字段描述字段类型长度允许空缺省值1plugin_idmediumint7,02plugin_identvarchar1003plugin_namevarchar1004plugin_typeenum9io5app_typevarchar1006plugin_baseenum107plugin_versionvarchar100√1.08plugin_authorvarchar100√9plugin_packagevarchar100√10plugin_websitevarchar200√11plugin_updatechecvarchar200√12plugin_desctext65535√13plugin_hasoptsenum5false14plugin_structtext65535√15plugin_configtext65535√16plugin_pathvarchar25517plugin_modeenum4file18statusenum6unused19disabledenum5false20plugin_mtimeint10,00sdb_pmt_gen_coupon描述：序号字段名称字段描述字段类型长度允许空缺省值1pmt_idmediumint7,002cpns_idmediumint7,003disabledenum5√falsesdb_pmt_goods描述：序号字段名称字段描述字段类型长度允许空缺省值1pmt_idmediumint7,002goods_idmediumint7,003countmediumint7,0√0sdb_pmt_goods_cat描述：序号字段名称字段描述字段类型长度允许空缺省值1cat_idint10,002brand_idmediumint7,003pmt_idmediumint7,00sdb_pmt_member_lv描述：序号字段名称字段描述字段类型长度允许空缺省值1member_lv_idmediumint7,0√2pmt_idmediumint7,0√sdb_point_history描述：序号字段名称字段描述字段类型长度允许空缺省值1idmediumint7,02member_idmediumint7,003pointint10,004timeint10,005reasonvarchar506related_idbigint19,0√7typetinyint3,018operatorvarchar50√sdb_print_tmpl描述：序号字段名称字段描述字段类型长度允许空缺省值1prt_tmpl_idint10,02prt_tmpl_titlevarchar1003shortcutenum5√false4disabledenum5√false5prt_tmpl_widthtinyint3,01006prt_tmpl_heighttinyint3,01007prt_tmpl_datalongtext4294967295√sdb_products描述：序号字段名称字段描述字段类型长度允许空缺省值1product_idmediumint7,02goods_idmediumint7,003barcodevarchar128√4titlevarchar255√5bnvarchar30√6pricedecimal20,30.0007costdecimal20,3√0.0008mktpricedecimal20,3√9namevarchar20010weightdecimal20,3√11unitvarchar20√12storemediumint7,0√13store_placevarchar255√14freezmediumint7,0√15pdt_desclongtext4294967295√16propslongtext4294967295√17uptimeint10,0√18last_modifyint10,0√19disabledenum5√false20marketableenum5true21is_local_stockenum5truesdb_product_memo描述：序号字段名称字段描述字段类型长度允许空缺省值1product_idmediumint7,002p_keyvarchar203p_valuelongtext4294967295√sdb_promotion描述：序号字段名称字段描述字段类型长度允许空缺省值1pmt_idmediumint7,02pmts_idvarchar2553pmta_idmediumint7,0√4pmt_time_beginint10,0√5pmt_time_endint10,0√6order_money_fromdecimal20,30.0007order_money_todecimal20,39999999.0008seqtinyint3,009pmt_typeenum1010pmt_belongenum1011pmt_bond_typeenum1012pmt_describelongtext4294967295√13pmt_solutionlongtext4294967295√14pmt_ifcoupontinyint3,0115pmt_update_timeint10,0√016pmt_basic_typeenum5√goods17disabledenum5√false18pmt_ifsaleenum5true19pmt_distypetinyint3,00sdb_promotion_activity描述：序号字段名称字段描述字段类型长度允许空缺省值1pmta_idmediumint7,02pmta_namevarchar200√3pmta_enabledenum5√4pmta_time_beginint10,0√5pmta_time_endint10,0√6pmta_describelongtext4294967295√7disabledenum5√falsesdb_promotion_scheme描述：序号字段名称字段描述字段类型长度允许空缺省值1pmts_idmediumint7,02pmts_namevarchar250√3pmts_memolongtext4294967295√4pmts_solutionlongtext4294967295√5pmts_typetinyint3,00sdb_pub_files描述：序号字段名称字段描述字段类型长度允许空缺省值1file_idint10,02file_namevarchar50√3file_identvarchar1004cdateint10,005memovarchar250√6disabledenum5falsesdb_refunds描述：序号字段名称字段描述字段类型长度允许空缺省值1refund_idbigint19,02order_idbigint19,0√3member_idmediumint7,0√4accountvarchar50√5bankvarchar50√6pay_accountvarchar250√7currencyvarchar8√8moneydecimal20,30.0009pay_typeenum8√offline10paymentmediumint7,0011paymethodvarchar100√12ipvarchar20√13t_readyint10,0014t_sentint10,0√15t_receivedint10,0√16statusenum8ready17memolongtext4294967295√18titlevarchar25519send_op_idmediumint7,0√20disabledenum5falsesdb_regions描述：序号字段名称字段描述字段类型长度允许空缺省值1region_idint10,02packagevarchar203p_region_idint10,0√4region_pathvarchar255√5region_grademediumint7,0√6local_namevarchar507en_namevarchar50√8p_1varchar50√9p_2varchar50√10ordernummediumint7,0√11disabledenum5√falsesdb_return_product描述：序号字段名称字段描述字段类型长度允许空缺省值1order_idbigint19,002member_idmediumint7,003return_idbigint19,04titlevarchar2005contentlongtext4294967295√6statusenum117image_filevarchar2558product_datalongtext4294967295√9commentlongtext4294967295√10add_timeint10,0011disabledenum5falsesdb_sell_logs描述：序号字段名称字段描述字段类型长度允许空缺省值1log_idmediumint7,02member_idmediumint7,003namevarchar50√4pricedecimal20,3√0.0005product_idmediumint7,006goods_idmediumint7,007product_namevarchar200√8pdt_descvarchar200√9numbermediumint7,0√010createtimeint10,0√sdb_sendbox描述：序号字段名称字段描述字段类型长度允许空缺省值1out_idint10,02tmpl_namevarchar50√3sendervarchar504creattimeint10,005targetlongtext4294967295√6sendcountmediumint7,0√7contentvarchar200√8subjectvarchar100√sdb_seo描述：序号字段名称字段描述字段类型长度允许空缺省值1seo_idmediumint7,02source_idvarchar1003typevarchar504store_keyvarchar1005valuetext65535sdb_settings描述：序号字段名称字段描述字段类型长度允许空缺省值1s_namevarchar162s_datalongtext4294967295√3s_timeint10,004disabledenum5√falsesdb_sfiles描述：序号字段名称字段描述字段类型长度允许空缺省值1file_idvarchar322file_namevarchar323usedbyvarchar32√4file_typevarchar32√5file_sizeint10,006cdateint10,007miscvarchar255√sdb_sitemaps描述：序号字段名称字段描述字段类型长度允许空缺省值1node_idmediumint7,02p_node_idmediumint7,003node_typevarchar304depthtinyint3,005pathvarchar200√6titlevarchar1007actionvarchar2558manualenum119item_idmediumint7,0√10p_ordermediumint7,0√11hiddenenum5false12child_countmediumint7,0√sdb_specification描述：序号字段名称字段描述字段类型长度允许空缺省值1spec_idmediumint7,02spec_namevarchar503aliasvarchar255√4spec_show_typeenum6flat5spec_typeenum5text6spec_memovarchar507p_ordermediumint7,008disabledenum5false9supplier_spec_idmediumint7,0√10supplier_idint10,0√11lastmodifyint10,0√sdb_spec_values描述：序号字段名称字段描述字段类型长度允许空缺省值1spec_value_idmediumint7,02spec_idmediumint7,003spec_valuevarchar1004aliasvarchar255√5spec_imagevarchar2556p_ordermediumint7,0507supplier_idint10,0√8supplier_spec_value_idmediumint7,0√sdb_status描述：序号字段名称字段描述字段类型长度允许空缺省值1status_keyvarchar202date_affectdate0000-00-003status_valuevarchar10004last_updateint10,00sdb_supplier描述：序号字段名称字段描述字段类型长度允许空缺省值1sp_idmediumint7,02supplier_idint10,003supplier_brief_namevarchar30√4statustinyint3,015supplier_plinelongtext4294967295√6sync_timeint10,007domainvarchar2558has_newenum5true9has_cost_newenum5false10sync_time_for_platint10,00