最新商店進(jìn)銷存管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)免費(fèi)下載(編輯修改稿)
2025-05-04 23:13 本頁面
【文章內(nèi)容簡介】 數(shù)據(jù)類型長度說明意義IDIntPrimary key客戶編號(hào)khnamevarchar50Not null客戶全稱addressvarchar100Not null地址Lxrvarchar50聯(lián)系人lxrtellvarchar50Not null聯(lián)系電話khyhvarchar50開戶銀行g(shù)ysvarchar50電子信箱表26 tb_user(業(yè)務(wù)員)字段名數(shù)據(jù)類型長度說明意義IDIntPrimary key業(yè)務(wù)員編號(hào)usernameVarchar40用戶名Passwordvarchar40密碼表27 tb_rkd(入庫單)字段名數(shù)據(jù)類型長度說明意義IDvarcahr20Primary key供應(yīng)單號(hào)GysIDIntForeign key供應(yīng)商號(hào)czyvarcahr10操作員yfMoney應(yīng)付sfMoney實(shí)付WfMoney未付whetherVarchar2是否付清rkdatedatetime驗(yàn)收日期表28 tb_ruku(供應(yīng)詳單)字段名數(shù)據(jù)類型長度說明意義spIDVarchar 20Foreign key商品號(hào)ckIDVarchar 20Foreign key供應(yīng)單號(hào)slInt數(shù)量JeMoney金額RkidVarchar20入庫單號(hào)表29 tbselld(銷售單)字段名數(shù)據(jù)類型長度說明意義IDVarchar20Primary key流水號(hào)kyIDIntForeign key客戶號(hào)ysmoney應(yīng)收ssmoney實(shí)收WsMoney未收jqVarchar2是否結(jié)清xsdatedate銷售日期表210 tb_sell(銷售詳單)字段名數(shù)據(jù)類型長度說明意義spIDVarchar10Foreign key商品號(hào)SelldVarchar20Foreign key流水號(hào)slint數(shù)量jeMoney金額表211 tb_zc(轉(zhuǎn)倉單)字段名數(shù)據(jù)類型長度說明意義IDvarchar20主鍵spIDVarchar20Foreign key商品號(hào)ZcckIntForeign key轉(zhuǎn)出庫編號(hào)ZrckIntForeign key轉(zhuǎn)入庫編號(hào)
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1