二手交易網(wǎng)站數(shù)據(jù)庫設計需求說明書畢業(yè)論文(編輯修改稿)
2025-07-21 14:38 本頁面
【文章內(nèi)容簡介】 50主鍵自動加1，主鍵唯一Da4UserName用戶名稱Varchar50Da5RealName真實名稱Varchar50Da6Password密碼Varchar255密碼大于六位數(shù)Da7Address地址varchar200Da8Phone電話varchar20Da9Mobile移動電話varchar20Da10Email電子郵件varchar200Da11CreateDate創(chuàng)建日期datetimeDa12Status狀態(tài)bitDa13RoleID角色IDFKint引用Role表的RoleIDDa14Remark備注textDa15CategoryIDIDPKint主鍵自動加1Da16Desn名稱varchar200Da17ParentID上級種類IDintDa18OrderBy排序順序號intDa19Remark備注textDa20ProductIDIDPKint主鍵自動加1Da21Name名稱varchar200Da22CaregoryID所屬種類IDFKint引用Category表的CategoryIDDa23Desn詳細描述textDa24Sell供應商varchar200Da25CreateDate生產(chǎn)日期datetime不為空Da26SellInDate進貨日期datetime不為空Da27Unit單位varchar50Da28Quantity數(shù)量intDa29Upper最高庫存量intDa30Lower最低庫存量intDa31InPrice進貨價格moneyDa32OutPrice銷售價格moneyDa33PictureID圖片IDFKint引用Picture表的PictureIDda34Type類型varchar200Da35Data數(shù)據(jù)imageDa34CommentID評論IDPKint主鍵自動加1Da35Body評論內(nèi)容textDa36TotalNumber訂單商品的總數(shù)量intDa37TotalMoney訂單總費用money大于0Da38OrderDate創(chuàng)建日期datetimeDa39State訂單狀態(tài)intDa40OrderItemID訂單子項IDPKint主鍵自動加1Da41number商品數(shù)量intDa42NewsIDIDPKint主鍵自動加1Da43L
試題試卷相關(guān)推薦
鄂ICP備17016276號-1