ShopEX数据库设计.doc

数据库名：shopex表名：tb_admin_roles序号列名数据类型长度小数位标识主键允许空默认值说明1role_idint10是是否auto_increment2role_namevarchar100否3role_memotext是4disabledenum否false表名：tb_advance_logs序号列名数据类型长度小数位标识主键允许空默认值说明1log_idmediumint8是是否auto_increment2member_idmediumint8否03moneydecimal203否0.0004messagevarchar255是5mtimeint10否06payment_idvarchar20是7order_idbigint20是8paymethodvarchar100是9memovarchar100是10import_moneydecimal203否0.00011explode_moneydecimal203否0.00012member_advancedecimal203否0.00013shop_advancedecimal203否0.00014disabledenum否false表名：tb_articles序号列名数据类型长度小数位标识主键允许空默认值说明1article_idmediumint8是是否auto_increment2node_idmediumint8否03titlevarchar200是4contentlongtext是5uptimeint10是6ifpubenum是7alignvarchar12是8filetypevarchar15是9filenamevarchar80是10orderlistmediumint6是11pubtimeint10是12disabledenum是false13goodsinfotext是表名：tb_autosync_rule序号列名数据类型长度小数位标识主键允许空默认值说明1rule_idmediumint8是是否auto_increment2supplier_op_idtinyint3否03local_op_idtinyint3否04disabledenum否false5memovarchar255是6rule_namevarchar255否表名：tb_autosync_rule_relation序号列名数据类型长度小数位标识主键允许空默认值说明1rule_idmediumint8否02supplier_idint10否03pline_idtinyint3否04memotext是表名：tb_autosync_task序号列名数据类型长度小数位标识主键允许空默认值说明1supplier_idint10是否02command_idint10是否03local_op_idmediumint8是0表名：tb_brand序号列名数据类型长度小数位标识主键允许空默认值说明1brand_idmediumint8是是否auto_increment2supplier_idint10是3supplier_brand_idmediumint8是4brand_namevarchar50否5brand_urlvarchar255是6brand_desclongtext是7brand_logovarchar255是8brand_keywordslongtext是9disabledenum是false10ordernummediumint8是表名：tb_cachemgr序号列名数据类型长度小数位标识主键允许空默认值说明1cnamevarchar30是否2modifiedint10否0表名：tb_comments序号列名数据类型长度小数位标识主键允许空默认值说明1comment_idmediumint8是是否auto_increment2for_comment_idmediumint8是3goods_idmediumint8否04object_typeenum否ask5author_idmediumint8是6authorvarchar100是7levelnamevarchar50是8contactvarchar255是9mem_read_statusenum否false10adm_read_statusenum否false11timeint10否012lastreplyint10否013reply_namevarchar100是14titlevarchar255是15commentlongtext是16ipvarchar15是17displayenum否false18p_indexenum是019disabledenum是false表名：tb_cost_sync序号列名数据类型长度小数位标识主键允许空默认值说明1supplier_idint10是否02bnvarchar30是否3costdecimal203否0.0004version_idint10否05product_idmediumint8否06goods_idmediumint8否0表名：tb_coupons序号列名数据类型长度小数位标识主键允许空默认值说明1cpns_idmediumint8是是否auto_increment2cpns_namevarchar255是3pmt_idmediumint8是4cpns_prefixvarchar50否5cpns_gen_quantitymediumint8否06cpns_keyvarchar20否7cpns_statusenum否18cpns_typeenum否19cpns_pointmediumint8是10disabledenum是false表名：tb_coupons_p_items序号列名数据类型长度小数位标识主键允许空默认值说明1order_idbigint20是否02cpns_idmediumint8是否03cpns_namevarchar255是4numsmediumint8是表名：tb_coupons_u_items序号列名数据类型长度小数位标识主键允许空默认值说明1order_idbigint20是否02cpns_idmediumint8是否03cpns_namevarchar255是4memc_codevarchar255是5cpns_typeenum是表名：tb_ctlmap序号列名数据类型长度小数位标识主键允许空默认值说明1controllervarchar100是否2pluginvarchar100否表名：tb_currency序号列名数据类型长度小数位标识主键允许空默认值说明1cur_codevarchar8是否2cur_namevarchar20否3cur_signvarchar5是4cur_ratedecimal104否1.00005def_curenum否false6disabledenum是false表名：tb_dapi序号列名数据类型长度小数位标识主键允许空默认值说明1funcvarchar60是否2last_updateint10否03checksumvarchar32是4codetext否表名：tb_dbver序号列名数据类型长度小数位标识主键允许空默认值说明1dbvervarchar255是表名：tb_delivery序号列名数据类型长度小数位标识主键允许空默认值说明1delivery_idbigint20是是否auto_increment2order_idbigint20是3member_idmediumint8是4moneydecimal203否0.0005typeenum否delivery6is_protectenum否false7deliveryvarchar20是8logi_idvarchar50是9logi_namevarchar100是10logi_novarchar50是11ship_namevarchar50是12ship_areavarchar255是13ship_addrvarchar100是14ship_zipvarchar20是15ship_telvarchar30是16ship_mobilevarchar50是17ship_emailvarchar150是18t_beginint10是19t_endint10是20op_namevarchar50是21statusenum否ready22memolongtext是23disabledenum是false24supplier_idint10是25supplier_delivery_idvarchar30是表名：tb_delivery_item序号列名数据类型长度小数位标识主键允许空默认值说明1item_idint10是是否auto_increment2delivery_idbigint20否03item_typeenum否goods4product_idbigint20否05product_bnvarchar30是6product_namevarchar200是7numbermediumint8否0表名：tb_dly_area序号列名数据类型长度小数位标识主键允许空默认值说明1area_idmediumint6是是否auto_increment2namevarchar80否3disabledenum是false4ordernumsmallint4是表名：tb_dly_center序号列名数据类型长度小数位标识主键允许空默认值说明1dly_center_idint10是是否auto_increment2namevarchar50否3addressvarchar200否4regionvarchar255是5zipvarchar20是6phonevarchar100是7unamevarchar100是8cellphonevarchar100是9sexenum是10memolongtext是11disabledenum否false表名：tb_dly_corp序号列名数据类型长度小数位标识主键允许空默认值说明1corp_idmediumint8是是否auto_increment2typevarchar6是3namevarchar200是4disabledenum是false5ordernumsmallint4是6websitevarchar200是表名：tb_dly_h_area序号列名数据类型长度小数位标识主键允许空默认值说明1dha_idmediumint8是是否auto_increment2dt_idmediumint8是3area_idmediumint6是04pricevarchar100是05has_codtinyint1否06areaname_grouplongtext是7areaid_grouplongtext是8configvarchar255是9expressionsvarchar255是10ordernumsmallint4是表名：tb_dly_type序号列名数据类型长度小数位标识主键允许空默认值说明1dt_idmediumint8是是否auto_increment2dt_namevarchar50是3dt_configlongtext是4dt_expressionslongtext是5detaillongtext是6pricelongtext否7typeenum否18gatewaymediumint8是09protectenum否010protect_ratefloat63是11ordernumsmallint4是012has_codenum否013minpricefloat102否0.0014disabledenum是false15corp_idint10是16dt_statusenum是1表名：tb_gift序号列名数据类型长度小数位标识主键允许空默认值说明1gift_idmediumint8是是否auto_increment2giftcat_idmediumint8是3insert_timeint10否04update_timeint10否05namevarchar255否6thumbnail_picvarchar255是7small_picvarchar255是8big_picvarchar255是9image_filelongtext是10introvarchar255是11gift_describelongtext是12weightint11否013storagemediumint8否014pricevarchar255是15orderlistmediumint8是016shop_iffbenum否117limit_nummediumint8是018limit_start_timeint10否019limit_end_timeint10否020limit_levelvarchar255是21ifrecommendenum否022pointmediumint8否023freezmediumint8是024disabledenum是false表名：tb_gift_cat序号列名数据类型长度小数位标识主键允许空默认值说明1giftcat_idmediumint8是是否auto_increment2catvarchar255是3orderlistmediumint6是4shop_iffbenum是15disabledenum是false表名：tb_gift_items序号列名数据类型长度小数位标识主键允许空默认值说明1order_idbigint20是否02gift_idmediumint8是否03namevarchar200是4pointint8是5numsmediumint8是6amountint10是7sendnummediumint8是08getmethodenum否present表名：tb_gimages序号列名数据类型长度小数位标识主键允许空默认值说明1gimage_idmediumint8是是否auto_increment2goods_idmediumint8是3is_remoteenum否false4sourcevarchar255否5orderbytinyint3否06src_size_widthint10否07src_size_heightint10否08smallvarchar255是9bigvarchar255是10thumbnailvarchar255是11up_timeint10否012supplier_idint10是13supplier_gimage_idmediumint8是14sync_timeint10是0表名：tb_gnotify序号列名数据类型长度小数位标识主键允许空默认值说明1gnotify_idmediumint8是是否auto_increment2goods_idmediumint8是3member_idmediumint8是4product_idmediumint8是5emailvarchar200是6statusenum否ready7send_timeint10是8creat_timeint10是9disabledenum否false10remarklongtext是表名：tb_goods序号列名数据类型长度小数位标识主键允许空默认值说明1goods_idmediumint8是是否auto_increment2cat_idint10否03type_idint10是4goods_typeenum否normal5brand_idmediumint8是6brandvarchar100是7supplier_idint10是8supplier_goods_idmediumint8是9wss_paramslongtext是10image_defaultlongtext是11udfimgenum是false12thumbnail_picvarchar255是13small_picvarchar255是14big_picvarchar255是15image_filelongtext是16briefvarchar255是17introlongtext是18mktpricedecimal203是19costdecimal203否0.00020pricedecimal203否0.00021bnvarchar200是22namevarchar200否23marketableenum否true24weightdecimal203是25unitvarchar20是26storemediumint8是27store_placevarchar255是28score_settingenum是number29scoremediumint8是30speclongtext是31pdt_desclongtext是32spec_desclongtext是33paramslongtext是34uptimeint10是35downtimeint10是36last_modifyint10是37disabledenum否false38notify_nummediumint8否039rankdecimal53是5.00040rank_countint10是041comments_countint10否042view_w_countint10否043view_countint10否044buy_countint10否045buy_w_countint10否046count_statlongtext是47p_ordermediumint8否3048d_ordermediumint8否3049p_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_statusenum是false78stock_update_statusenum是false79marketable_update_statusenum是false80img_update_statusenum是false表名：tb_goods_cat序号列名数据类型长度小数位标识主键允许空默认值说明1cat_idint10是是否auto_increment2parent_idint10是3supplier_idint10是4supplier_cat_idmediumint8是5cat_pathvarchar100是,6is_leafenum否false7type_idint10是8cat_namevarchar100否9disabledenum否false10p_ordermediumint8是11goods_countmediumint8是12tabslongtext是13finderlongtext是14addonlongtext是15child_countmediumint8否0表名：tb_goods_keywords序号列名数据类型长度小数位标识主键允许空默认值说明1goods_idmediumint8是否02keywordvarchar40是否3refervarchar255是4res_typeenum是否goods表名：tb_goods_lv_price序号列名数据类型长度小数位标识主键允许空默认值说明1product_idmediumint8是否02level_idmediumint8是否03goods_idmediumint8是否04pricedecimal203是表名：tb_goods_memo序号列名数据类型长度小数位标识主键允许空默认值说明1goods_idmediumint8是否02p_keyvarchar20是否3p_valuelongtext是表名：tb_goods_rate序号列名数据类型长度小数位标识主键允许空默认值说明1goods_1mediumint8是否02goods_2mediumint8是否03manualenum是4ratemediumint8否1表名：tb_goods_spec_index序号列名数据类型长度小数位标识主键允许空默认值说明1type_idint10否02spec_idmediumint8否03spec_value_idmediumint8是否04spec_valuevarchar100是否5goods_idmediumint8否06product_idmediumint8是否0表名：tb_goods_type序号列名数据类型长度小数位标识主键允许空默认值说明1type_idint10是是否auto_increment2namevarchar100否3aliaslongtext是4is_physicalenum否15supplier_idint10是6supplier_type_idmediumint8是7schema_idvarchar30否custom8propslongtext是9speclongtext是10settinglongtext是11minfolongtext是12paramslongtext是13dly_funcenum否014ret_funcenum否015reshipenum否normal16disabledenum是false17is_defenum否false18lastmodifyint10是表名：tb_goods_type_spec序号列名数据类型长度小数位标识主键允许空默认值说明1spec_idmediumint8是02type_idint10是03spec_styleenum否flat表名：tb_goods_virtual_cat序号列名数据类型长度小数位标识主键允许空默认值说明1virtual_cat_idmediumint8是是否auto_increment2virtual_cat_namevarchar100否3filterlongtext是4addonlongtext是5type_idint10是6disabledenum否false7parent_idmediumint8是08cat_idint10是9p_ordermediumint8是10cat_pathvarchar100是,11child_countmediumint8是0表名：tb_gtask序号列名数据类型长度小数位标识主键允许空默认值说明1goods_idmediumint8是2tasktimeint10否03actionenum否online表名：tb_image_sync序号列名数据类型长度小数位标识主键允许空默认值说明1img_sync_idint10是是否auto_increment2typeenum否gimage3supplier_idint10否04supplier_object_idmediumint8否05add_timeint10否06command_idint10否07failedenum否false表名：tb_job_apilist序号列名数据类型长度小数位标识主键允许空默认值说明1job_idint10是是否auto_increment2supplier_idint10否03api_namevarchar100否4api_paramslongtext是5api_versionvarchar10否6api_actionvarchar100否7pagemediumint8否08limitmediumint8否0表名：tb_job_data_sync序号列名数据类型长度小数位标识主键允许空默认值说明1job_idint10是是否auto_increment2from_timeint10否03to_timeint10否04pagemediumint8否05limitmediumint8否06supplier_idint10否07supplier_plinelongtext是8auto_downloadenum否false9to_cat_idm