二維碼數(shù)據(jù)庫(kù)設(shè)計(jì)報(bào)告

1、數(shù)據(jù)庫(kù)設(shè)計(jì)報(bào)告文件狀態(tài)：V草稿正式發(fā)布正在修改文件標(biāo)識(shí)當(dāng)前版本1.0作 者完成日期版本歷史 TOC o 1-5 h z HYPERLINK l bookmark1 o Current Document 0.文檔介紹40.1文檔目的40.2文檔圍40.3讀者對(duì)象40.4參考文獻(xiàn)40.5術(shù)語(yǔ)與縮寫(xiě)解釋4 HYPERLINK l bookmark4 o Current Document 1.數(shù)據(jù)庫(kù)環(huán)境說(shuō)明5 HYPERLINK l bookmark8 o Current Document 2.數(shù)據(jù)庫(kù)的命名規(guī)則5 HYPERLINK l bookmark12 o Current Document 3.

2、物理設(shè)計(jì)5 HYPERLINK l bookmark16 o Current Document 3.1管理員用戶(hù)表5 HYPERLINK l bookmark19 o Current Document 3.2管理員登錄記錄表。5 HYPERLINK l bookmark22 o Current Document 3.2公告表6 HYPERLINK l bookmark25 o Current Document 3.3公告分類(lèi)表6 HYPERLINK l bookmark28 o Current Document 3.5廠(chǎng)商表6 HYPERLINK l bookmark31 o Current

3、Document 3.6廠(chǎng)商用戶(hù)表7 HYPERLINK l bookmark34 o Current Document 3.7廠(chǎng)商用戶(hù)登錄記錄表7 HYPERLINK l bookmark37 o Current Document 3.8廠(chǎng)商經(jīng)銷(xiāo)商表7 HYPERLINK l bookmark40 o Current Document 3.9經(jīng)銷(xiāo)類(lèi)型表8 HYPERLINK l bookmark43 o Current Document 3.10廠(chǎng)商商品表8 HYPERLINK l bookmark46 o Current Document 3.11商品分類(lèi)表93.12商品規(guī)格表93.13商

4、品平臺(tái)表93.14二維碼表93.15二維碼掃描記錄表103.16二維碼動(dòng)作記錄表10 HYPERLINK l bookmark49 o Current Document 3.17用戶(hù)表10 HYPERLINK l bookmark52 o Current Document 3.18用戶(hù)登錄記錄表11 HYPERLINK l bookmark55 o Current Document 3.19用戶(hù)收藏表11 HYPERLINK l bookmark58 o Current Document 3.20商品物流鏈表11 HYPERLINK l bookmark61 o Current Documen

5、t 3.21基礎(chǔ)配置表120.文檔介紹0.1文檔目的開(kāi)發(fā)人員編寫(xiě)。0.2文檔圍所用到的數(shù)據(jù)庫(kù)。0.3讀者對(duì)象開(kāi)發(fā)人員0.4參考文獻(xiàn)無(wú)0.5術(shù)語(yǔ)與縮寫(xiě)解釋數(shù)據(jù)庫(kù)環(huán)境說(shuō)明(1)數(shù)據(jù)庫(kù)系統(tǒng)：SQLSERVER2005。數(shù)據(jù)庫(kù)的命名規(guī)則參考SQL編程規(guī)方案書(shū)。物理設(shè)計(jì)3.1管理員用戶(hù)表表名sysAdmin列名備注數(shù)據(jù)類(lèi)型空/非 空約束條件AdminID管理員編號(hào)intN自增Account賬號(hào)varchar(50)NPassword密碼VarChar(100 )NIsLock是否啟用0啟用1鎖定IntNRemark備注varchar(200)NReaName真實(shí)varchar(50)NPhone聯(lián)系va

6、rchar(50)NQQQQvarchar(50)NEmail管理員varchar(50)NLastLoginTime最后登錄時(shí)間datetimeNLastLoginIP最后登錄ipVarchar(5 0)NRegTime注冊(cè)時(shí)間datetimeNLoginNum登錄次數(shù)intNAdminIMG管理員頭像varchar(200)N0補(bǔ)充說(shuō)明3.2管理員登錄記錄表。表名sysAdminLoginLog列名備注數(shù)據(jù)類(lèi)型空/非約束條件空ID自增IDintNAdminlD管理員編號(hào)intNAccount賬號(hào)varchar(50)NPassword輸入的密碼VarChar(500 )NLoginlnTi

7、me登錄時(shí)間datetimeNLoginIP登錄IPvarchar(50)NMemo備注varchar(500)N補(bǔ)充說(shuō)明3.2公告表表名sysArticle列名備注數(shù)據(jù)類(lèi)型空/非 空約束條件ArticleID文章編號(hào)intN自增CateID分類(lèi)idnc_article_cateintNUrl跳轉(zhuǎn)varchar(15 0)NIsShow是否顯示，0為否， 1為是，默認(rèn)為1intNTitle標(biāo)題varchar(15 0)NConver文章封面圖片varchar(15 0)NContent容textNSort排序intNStaticpage靜態(tài)頁(yè)面路徑varchar(10 0)NSeoKeywor

8、d文章SEO關(guān)鍵詞varchar(50 0)NSeoSescription文章SEO描述varchar(50 0)NTime添加時(shí)間datetimeNIsRecommend文章是否推薦intN補(bǔ)充說(shuō)明3.3公告分類(lèi)表表名sysArticleCate列名備注數(shù)據(jù)類(lèi)型空/非 空約束條件CateID分類(lèi)編號(hào)intN自增Code分類(lèi)標(biāo)識(shí)碼varchar(10 0)NName分類(lèi)名稱(chēng)varchar(15 0)NSort排序intNDir生成目錄varchar(15 0)NSeoKeyword分類(lèi)SEO關(guān)鍵詞varchar(50 0)NSeoDescription分類(lèi)SEO描述varchar(50 0)N

9、補(bǔ)充說(shuō)明3.5廠(chǎng)商表表名firmFirm列名備注數(shù)據(jù)類(lèi)型空/非空約束條件FirmID廠(chǎng)商編號(hào)intN自增FirmName廠(chǎng)商名稱(chēng)varchar(200)NPosition所在地varchar(100)NCompanySize規(guī)模Varchar(500 )NPhone聯(lián)系Varchar(50)NAddress聯(lián)系地址Varchar(200 )NSummary廠(chǎng)商簡(jiǎn)介ntextNImage廠(chǎng)商圖片Varchar(500 )NAlibabaWW旺旺Varchar(50)YQQ廠(chǎng)商qqVarchar(50)YEmail電子Varchar(50)YIsCheck是否審核，0為未 審核，1為已審 核，默認(rèn)

10、為0.intN補(bǔ)充說(shuō)明3.6廠(chǎng)商用戶(hù)表表名firm FirmUser列名備注數(shù)據(jù)類(lèi)型空/非空約束條件FirmUserID自增idintN自增Account賬號(hào)Varchar(200 )N唯一Password密碼Varchar(500 )NFirmID廠(chǎng)商IDintNLastLoginTime最后登錄時(shí)間datetimeNLastLoginIP最后登錄ipVarchar(50)NRealName真實(shí)Varchar(200 )YEmail找回密碼varchar(50)N補(bǔ)充說(shuō)明3.7廠(chǎng)商用戶(hù)登錄記錄表表名firmFirmUserLoginLog列名備注數(shù)據(jù)類(lèi)型空/非空約束條件ID自增IDintNF

11、irmUserID廠(chǎng)商用戶(hù)賬號(hào)IDintNFirmID廠(chǎng)商IDintNAccount賬號(hào)varchar(50)NPassword輸入的密碼VarChar(500 )NLoginInTime登錄時(shí)間datetimeNLoginIP登錄IPvarchar(50)NMemo備注varchar(500)N補(bǔ)充說(shuō)明3.8廠(chǎng)商經(jīng)銷(xiāo)商表表名firmFirmDealer列名備注數(shù)據(jù)類(lèi)型空/非空約束條件DealerID經(jīng)銷(xiāo)商IDintN自增DealerName經(jīng)銷(xiāo)商名稱(chēng)varchar(100)NPosition經(jīng)銷(xiāo)商所在地varchar(100)NDeliveryAddress發(fā)貨地址varchar(200)N

12、Phone聯(lián)系Varchar(50)NGoodIDs經(jīng)銷(xiāo)商品（多個(gè) 商品id用“，” 隔開(kāi)）varchar(200 0)NSummary經(jīng)銷(xiāo)商簡(jiǎn)介ntextNImage經(jīng)銷(xiāo)商圖片varchar(500)NBusinessTypeID經(jīng)銷(xiāo)類(lèi)型IDintNAlibabaWW旺旺Varchar(50)YQQ經(jīng)銷(xiāo)商qqVarchar(50)YEmail電子Varchar(50)YFirmID廠(chǎng)商IDintNParentID上級(jí)經(jīng)銷(xiāo)商IDintNRank經(jīng)銷(xiāo)商階級(jí)intN3.9經(jīng)銷(xiāo)類(lèi)型表表名svsBusinessTvoe列名備注數(shù)據(jù)類(lèi)型空/非空約束條件ID編號(hào)intN自增BusinessTvpeName

13、經(jīng)銷(xiāo)類(lèi)型名varchar(50)NAddTime添加時(shí)間datetimeNModifyTime修改時(shí)間datetimeN補(bǔ)充說(shuō)明3.10廠(chǎng)商商品表表名firmFirmGoods列名備注數(shù)據(jù)類(lèi)型空/非空約束條件GoodID商品編號(hào)intN自增FirmID所屬?gòu)S商IDintNGoodName商品名稱(chēng)varchar(200)NGoodTypelD商品分類(lèi)IDintNGoodSpecID商品規(guī)格IDintNReserve商品庫(kù)存intNColor商品顏色varchar(100)NPhoto商品圖片varchar(500)NDetail商品詳情NtextNMarketPrice商品市場(chǎng)價(jià)moneyNWe

14、bPrice商品平臺(tái)價(jià)moneyNSource商品源（用于朔 源）ntextN補(bǔ)充說(shuō)明3.11商品分類(lèi)表表名sysGoodType列名備注數(shù)據(jù)類(lèi)型空/非空約束條件GoodTypeID分類(lèi)編號(hào)intN自增GoodTypeName分類(lèi)名稱(chēng)varchar(255)NParentID上級(jí)分類(lèi)idintN補(bǔ)充說(shuō)明3.12商品規(guī)格表表名sys GoodSpec列名備注數(shù)據(jù)類(lèi)型空/非空約束條件GoodSpecID規(guī)格IDintN自增Value規(guī)格值varchar(150)N補(bǔ)充說(shuō)明3.13商品平臺(tái)表表名firmFirmGoodsPlatform列名備注數(shù)據(jù)類(lèi)型空/非空約束條件GoodsPlatformID商

15、品平臺(tái)IDintN自增GoodID商品IDintNFirmID廠(chǎng)商IDintNDealerID經(jīng)銷(xiāo)商ID（多個(gè) 經(jīng)銷(xiāo)商id用,” 隔開(kāi)）Varchar(200 0)NPlatformName平臺(tái)名稱(chēng)Varchar(200 )NPlatformURL平臺(tái)Varchar(200 )NClickNum平臺(tái)點(diǎn)擊次數(shù)intN補(bǔ)充說(shuō)明3.14二維碼表表名arQRCode列名備注數(shù)據(jù)類(lèi)型空/非空約束條件QRCodeID自增IDintN自增FirmID廠(chǎng)商IDintNGoodID廠(chǎng)商商品idintNIdentification辨識(shí)字符串（md5 加密）varchar(200 0)N唯一值PhotosAddre

16、ss圖片地址varchar(200)NScanningNum被掃描次數(shù)intNJumpNum跳轉(zhuǎn)次數(shù)intN補(bǔ)充說(shuō)明3.15二維碼掃描記錄表表名qr QRCodeScanning列名備注數(shù)據(jù)類(lèi)型空/非空約束條件QRCodelD被掃描的二維碼idintN自增FirmID廠(chǎng)商IDintNGoodID廠(chǎng)商商品idintNIdentification辨識(shí)字符串（md5 加密）Varchar(200 0)NConsumerID消費(fèi)者ID （如未登 陸則為0）intNScanningIP掃描來(lái)源ipvarchar(50)NTime掃描時(shí)間DatetimeN3.16二維碼動(dòng)作記錄表表名qr QRCodeOp

17、erating g列名備注數(shù)據(jù)類(lèi)型空/非空約束條件QRCodeID被掃描的二維碼idIntN自增FirmID廠(chǎng)商IDintGoodID廠(chǎng)商商品idintIdentification辨識(shí)字符串（md5 加密）Varchar(200 0)NConsumerID消費(fèi)者ID （如未 登陸則為0）varchar(300)NOperatingIP記錄IPVarchar(50)NUserOperating用戶(hù)動(dòng)作varchar(200)NTime記錄時(shí)間datetimeN補(bǔ)充說(shuō)明3.17用戶(hù)表表名svsUser列名備注數(shù)據(jù)類(lèi)型空/非空約束條件UserID用戶(hù)idintN自增UserName用戶(hù)名varcha

18、r(100)NPassword密碼Varchar(200 )NUserIMG用戶(hù)頭像Varchar(200 )NPhone手機(jī)varchar(100)NPosition所在地varchar(100)NSex性別intNAge年齡intNAlibabaWW旺旺varchar(50)NWeChat微信varchar(50)NEmailvarchar(50)NShippingAddress收貨地址varchar(200)NZipCode郵編varchar(50)NPoints用戶(hù)積分intNRegistrationTime注冊(cè)時(shí)間DatetimeN補(bǔ)充說(shuō)明3.18用戶(hù)登錄記錄表表名svsUserLoginLog列名備注數(shù)據(jù)類(lèi)型空/非空約束條件ID自增IDintNUserID用戶(hù)idintNUserName賬號(hào)varchar(50)NPassword輸入的密碼VarChar(500 )NLoginInTime登錄時(shí)間datetimeNLoginIP登錄IPvarchar(50)NMemo備注varchar(500)N補(bǔ)充說(shuō)明3.19用戶(hù)收藏表表名sysUserFavorites列名備注數(shù)據(jù)類(lèi)型空/非空約束條件F avoritesID收藏商品或廠(chǎng)商 的編號(hào)intNUserID用戶(hù)IDintNF avoritesType收藏類(lèi)型（商品 或廠(chǎng)商）varchar(50)NTim