shopex數(shù)據(jù)庫(kù)設(shè)計(jì)(文件)
【正文】 9disabledenum否false10remarklongtext是表名：tb_goods序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明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否20pricedecimal203否21bnvarchar200是22namevarchar200否23marketableenum否true24weightdecimal203是25unitvarchar20是26storemediumint8是27store_placevarchar255是28score_settingenum是number29scoremediumint8是30speclongtext是31pdt_desclongtext是32spec_desclongtext是33paramslongtext是34uptimeint10是35downtimeint10是36last_modifyint10是37disabledenum否false38notify_nummediumint8否039rankdecimal53是40rank_countint10是041ments_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序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明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序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1goods_idmediumint8是否02keywordvarchar40是否3refervarchar255是4res_typeenum是否goods表名：tb_goods_lv_price序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1product_idmediumint8是否02level_idmediumint8是否03goods_idmediumint8是否04pricedecimal203是表名：tb_goods_memo序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1goods_idmediumint8是否02p_keyvarchar20是否3p_valuelongtext是表名：tb_goods_rate序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1goods_1mediumint8是否02goods_2mediumint8是否03manualenum是4ratemediumint8否1表名：tb_goods_spec_index序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1type_idint10否02spec_idmediumint8否03spec_value_idmediumint8是否04spec_valuevarchar100是否5goods_idmediumint8否06product_idmediumint8是否0表名：tb_goods_type序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明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序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說(shuō)明1spec_idmediumint8是0
規(guī)章制度相關(guān)推薦
鄂ICP備17016276號(hào)-1