Ecstore商品相关表结构

1、 商品导入商品导入相关潘璠一sdb_b2c_brand 商品品牌表 表结构 colnamedescribetypenullextrapkeybrand_id品牌idmediumint(8) unsignedYauto_incrementYbrand_name品牌名称varchar(50)YNbrand_url品牌网址varchar(255)NNbrand_desc品牌介绍longtextNNbrand_logo品牌图片标识varchar(255)NNbrand_keywords品牌别名longtextNNbrand_setting品牌设置longtextNNdisabled是否失效enum(t

2、rue,false)NNordernum排序mediumint(8) unsignedNNlast_modify更新时间int(10) unsignedNN 索引 indexnamecolumnsind_disableddisabledind_ordernumordernum二sdb_b2c_goods_cat 商品分类 表结构 colnamedescribetypenullextrapkeycat_id分类IDmediumint(8) unsignedYauto_incrementYparent_id分类IDmediumint(8) unsignedNNcat_path分类路径(从根至本结点

3、的路径,逗号分隔,首部有逗号)varchar(100)NNis_leaf是否叶子结点（true：是；false：否）enum(true,false)YNtype_id类型序号mediumint(9)NNcat_name分类名称varchar(100)YNgallery_setting商品分类设置longtextNNdisabled是否失效enum(true,false)YNp_order排序mediumint(8) unsignedNNgoods_count商品数mediumint(8) unsignedNNtabs子视图longtextNNfinder渐进式筛选容器longtextNNadd

4、on附加项longtextNNchild_count子类别数量mediumint(8) unsignedYNlast_modify更新时间int(10) unsignedNN 索引 indexnamecolumnsind_cat_pathcat_pathind_disableddisabledind_last_modifylast_modify三sdb_b2c_goods_type 商品类型 表结构 colnamedescribetypenullextrapkeytype_id类型序号mediumint(8) unsignedYauto_incrementYname类型名称varchar(10

5、0)YNfloatstore小数型库存enum(0,1)YNalias类型别名(|分隔,前后|)longtextNNis_physical实体商品enum(0,1)YNschema_id供应商序号varchar(30)YNsetting类型设置longtextNNprice设置价格区间，用于列表页搜索使用longtextNNminfo用户购买时所需输入信息的字段定义序列化数组方式 array(字段名,字段含义,类型(input,select,radio)longtextNNparams参数表结构(序列化) array(参数组名=array(参数名1=别名1|别名2,参数名2=别名1|别名2)l

6、ongtextNNtab商品详情页的自定义tab设置longtextNNdly_func是否包含发货函数enum(0,1)YNret_func是否包含退货函数enum(0,1)YNreship退货方式 disabled:不允许退货 func:函数式 disabled:不支持退货;func:通过函数退货;normal:物流退货;mixed:物流退货+函数式动作;enum(disabled,func,normal,mixed)YNdisabled是否失效enum(true,false)NNis_def是否系统默认enum(true,false)YNlastmodify上次修改时间int(10) u

7、nsignedNN 索引 indexnamecolumnsind_disableddisabled四sdb_b2c_goods_type_spec 商品规格表 表结构 colnamedescribetypenullextrapkeyspec_id规格IDmediumint(8) unsignedNYtype_id类型IDmediumint(8) unsignedNYspec_style渐进式搜索时的样式 select:下拉;flat:平面;disabled:禁用;enum(select,flat,disabled)YNordernumordernummediumint(8) unsignedY

8、N五sdb_b2c_goods 商品主表 表结构 colnamedescribetypenullextrapkeygoods_id商品IDbigint(20) unsignedYauto_incrementYbn商品编号varchar(200)NNname商品名称varchar(200)YNprice销售价decimal(20,3)YNtype_id类型mediumint(8) unsignedNNcat_id分类mediumint(8) unsignedYNbrand_id品牌mediumint(8) unsignedNNmarketable上架enum(true,false)YNstore

9、库存mediumint(8) unsignedNNnotify_num缺货登记mediumint(8) unsignedYNuptime上架时间int(10) unsignedNNdowntime下架时间int(10) unsignedNNlast_modify更新时间int(10) unsignedNNp_order排序mediumint(8) unsignedYNd_order动态排序mediumint(8) unsignedYNscore积分mediumint(8) unsignedNNcost成本价decimal(20,3)YNmktprice市场价decimal(20,3)NNwei

10、ght重量decimal(20,3)NNunit单位varchar(20)NNbrief商品简介varchar(255)NNgoods_type销售类型 normal:普通商品;bind:捆绑商品;gift:赠品;enum(normal,bind,gift)YNimage_default_id默认图片varchar(32)NNudfimg是否用户自定义图enum(true,false)NNthumbnail_pic缩略图varchar(32)NNsmall_pic小图varchar(255)NNbig_pic大图varchar(255)NNintro详细介绍longtextNNstore_pl

11、ace库位varchar(255)NNmin_buy起定量mediumint(8) unsignedNNpackage_scale打包比例decimal(20,2)NNpackage_unit打包单位varchar(20)NNpackage_use是否开启打包enum(0,1)NNscore_settingscore_setting percent:百分比;number:实际值;enum(percent,number)NNstore_prompt库存提示规则mediumint(8) unsignedNNnostore_sell是否开启无库存销售enum(0,1)NNgoods_setting商

12、品设置longtextNNspec_desc货品规格序列化longtextNNparams商品规格序列化longtextNNdisabled是否失效enum(true,false)YNrank_countgoogle page rank countint(10) unsignedYNcomments_count评论次数int(10) unsignedYNview_w_count周浏览次数int(10) unsignedYNview_count浏览次数int(10) unsignedYNcount_stat统计数据序列化longtextNNbuy_count购买次数int(10) unsigne

13、dYNbuy_w_count购买次数int(10) unsignedYNp_1p_1mediumint(8) unsignedNNp_2p_2mediumint(8) unsignedNNp_3p_3mediumint(8) unsignedNNp_4p_4mediumint(8) unsignedNNp_5p_5mediumint(8) unsignedNNp_6p_6mediumint(8) unsignedNNp_7p_7mediumint(8) unsignedNNp_8p_8mediumint(8) unsignedNNp_9p_9mediumint(8) unsignedNNp_1

14、0p_10mediumint(8) unsignedNNp_11p_11mediumint(8) unsignedNNp_12p_12mediumint(8) unsignedNNp_13p_13mediumint(8) unsignedNNp_14p_14mediumint(8) unsignedNNp_15p_15mediumint(8) unsignedNNp_16p_16mediumint(8) unsignedNNp_17p_17mediumint(8) unsignedNNp_18p_18mediumint(8) unsignedNNp_19p_19mediumint(8) uns

15、ignedNNp_20p_20mediumint(8) unsignedNNp_21p_21varchar(255)NNp_22p_22varchar(255)NNp_23p_23varchar(255)NNp_24p_24varchar(255)NNp_25p_25varchar(255)NNp_26p_26varchar(255)NNp_27p_27varchar(255)NNp_28p_28varchar(255)NNp_29p_29varchar(255)NNp_30p_30varchar(255)NNp_31p_31varchar(255)NNp_32p_32varchar(255)

16、NNp_33p_33varchar(255)NNp_34p_34varchar(255)NNp_35p_35varchar(255)NNp_36p_36varchar(255)NNp_37p_37varchar(255)NNp_38p_38varchar(255)NNp_39p_39varchar(255)NNp_40p_40varchar(255)NNp_41p_41varchar(255)NNp_42p_42varchar(255)NNp_43p_43varchar(255)NNp_44p_44varchar(255)NNp_45p_45varchar(255)NNp_46p_46varc

17、har(255)NNp_47p_47varchar(255)NNp_48p_48varchar(255)NNp_49p_49varchar(255)NNp_50p_50varchar(255)NN 索引 indexnamecolumnsuni_bnbnind_p_1p_1ind_p_2p_2ind_p_3p_3ind_p_4p_4ind_p_5p_5ind_p_6p_6ind_p_7p_7ind_p_8p_8ind_p_9p_9ind_p_10p_10ind_p_11p_11ind_p_12p_12ind_p_13p_13ind_p_14p_14ind_p_15p_15ind_p_16p_16

18、ind_p_17p_17ind_p_18p_18ind_p_19p_19ind_p_20p_20ind_p_23p_23ind_p_22p_22ind_p_21p_21ind_p_24p_24ind_p_25p_25ind_p_26p_26ind_p_27p_27ind_p_28p_28ind_p_29p_29ind_p_30p_30ind_p_31p_31ind_p_32p_32ind_p_33p_33ind_p_34p_34ind_p_35p_35ind_p_36p_36ind_p_37p_37ind_p_38p_38ind_p_39p_39ind_p_40p_40ind_p_41p_41

19、ind_p_42p_42ind_p_43p_43ind_p_44p_44ind_p_45p_45ind_p_46p_46ind_p_47p_47ind_p_48p_48ind_p_49p_49ind_p_50p_50ind_frontenddisabled goods_type marketableidx_goods_typegoods_typeidx_d_orderd_orderidx_goods_type_d_ordergoods_type d_orderidx_marketablemarketable六sdb_b2c_products 商品货品表 表结构 colnamedescribet

20、ypenullextrapkeyproduct_id货品IDmediumint(8) unsignedYauto_incrementYgoods_id商品IDbigint(20) unsignedYNbarcode条码varchar(128)NNtitle标题varchar(255)NNbn货号varchar(30)NNprice销售价格decimal(20,3)YNcost成本价decimal(20,3)YNmktprice市场价decimal(20,3)NNname货品名称varchar(200)YNweight单位重量decimal(20,3)NNunit单位varchar(20)NNs

21、tore库存mediumint(8) unsignedNNstore_place库位varchar(255)NNfreez冻结库存mediumint(8) unsignedNNgoods_type销售类型 normal:普通商品;bind:捆绑商品;gift:赠品;enum(normal,bind,gift)YNspec_info物品描述longtextNNspec_desc规格值,序列化longtextNNis_defaultis_defaultenum(true,false)YNqrcode_image_id二维码图片IDvarchar(32)NNuptime录入时间int(10) uns

22、ignedNNlast_modify最后修改时间int(10) unsignedNNdisabled是否失效enum(true,false)NNmarketable上架enum(true,false)YN 索引 indexnamecolumnsind_goods_idgoods_idind_disableddisabledind_barcodebarcodeind_bnbnidx_goods_typegoods_typeidx_storestore七sdb_image_image 图片表 表结构 colnamedescribetypenullextrapkeyimage_id图片IDchar(

23、32)YYstorage存储引擎varchar(50)YNimage_name图片名称varchar(50)NNidentidentvarchar(200)YNurl网址varchar(200)YNl_ident大图唯一标识varchar(200)NNl_url大图URL地址varchar(200)NNm_ident中图唯一标识varchar(200)NNm_url中图URL地址varchar(200)NNs_ident小图唯一标识varchar(200)NNs_url小图URL地址varchar(200)NNwidth宽度mediumint(8) unsignedNNheight高度mediumint(8) unsignedNNwatermark有水印enum(true,false)NNlast_modified更新时间int(10) unsignedYN八sdb_image_image_attach 图片关联表 表结构 colnamedescribetypenullextrapkeyattach_id图片关联表IDmediumint(8) unsignedYauto_increme