超市進(jìn)銷存管理信息系統(tǒng)設(shè)計(jì)與開發(fā)-在線瀏覽
2025-05-25 22:19本頁面
【正文】 數(shù)據(jù)表如下表所示： 騰宇超市進(jìn)銷存管理數(shù)據(jù)表表名說明功能作用tbcustomer客戶信息表儲存客戶的基本信息tbgoods商品信息表儲存商品的基本信息tbinport進(jìn)貨單信息表儲存進(jìn)貨單信息tboperator系統(tǒng)操作員信息表儲存系統(tǒng)操作員的信息tboutport退貨信息表儲存退貨單信息tbprovider供貨商信息表存儲供貨商的信息tbsales銷售信息表儲存銷售單信息tbsalesback退貨信息表儲存退貨單信息tbstoragecheck庫存盤點(diǎn)信息表儲存庫存商品信息下圖為njue數(shù)據(jù)庫的表截圖： 騰宇超市進(jìn)銷存管理信息系統(tǒng)數(shù)據(jù)庫總表在邏輯數(shù)據(jù)模型（即關(guān)系模型）的基礎(chǔ)上，構(gòu)建物理數(shù)據(jù)模型（即數(shù)據(jù)庫與數(shù)據(jù)表結(jié)構(gòu)），將關(guān)系模型轉(zhuǎn)換為具體的表結(jié)構(gòu)，如下列表所示：表 客戶信息表結(jié)構(gòu)序號字段名主鍵否外鍵否數(shù)值類型長度缺省值可為空1IdYNchar10NN2customernameNNvarchar50NN3zipNNchar6NY4addressNNvarchar50NY5telephoneNNvarchar20NY6connectionpersonNNvarchar20NY7phoneNNvarchar20NY8bankNNvarchar50NY9accountNNvarchar50NY10NNvarchar50NY11faxNNvarchar20NY12availableNNint11NN表 商品信息表結(jié)構(gòu)序號字段名主鍵否外鍵否數(shù)值類型長度缺省值可為空1idYNchar10NN2goodsnameNNvarchar50NN3produceplaceNNvarchar50NY4sizeNNvarchar50NY5packageNNvarchar50NY6productcodeNNvarchar20NY7promitcodeNNvarchar20NY8descriptionNNvarchar50NY9priceNNfloatNN10provideridNYchar10NN11availableNNint11NN表 進(jìn)貨單信息表結(jié)構(gòu)序號字段名主鍵否外鍵否數(shù)值類型長度缺省值可為空1idYNchar20NN2provideridNYchar10NN3paytypeNNvarchar50NN4inporttimeNNdetatimeNN5operatepersonNNvarchar50NN6numberNNint11NN7priceNNfloatNN8mentNNvarchar100NY9goodsidNYchar10NN表 系統(tǒng)操作員信息表結(jié)構(gòu)序號字段名主鍵否外鍵否數(shù)值類型長度缺省值可為空1usernameYNvarchar20NN2passwordNNvarcharr20NN3nameNNvarchar20NN4powerNNchar10NN表 退貨信息表結(jié)構(gòu)序號字段名主鍵否外鍵否數(shù)值類型長度缺省值可為空1idYNchar20NN2provideridNYchar10NN3paytypeNNvarchar50NN4outporttimeNNdatatimeNN5operatepersonNNvarchar50NN6numberNNint11NN7priceNNfloatNN8mentNNvarchar100NY9goodsidNYchar10NN表 供貨商信息表結(jié)構(gòu)序號字段名主鍵否外鍵否數(shù)值類型長度缺省值可為空1idYNchar10NN2providernameNNvarchar50NN3zipNNchar6NY4addressNNvarchar50NY5telephoneNNvarchar20NY6connectionpersonNNvarchar20NY7phoneNNvarchar20NY8bankNNvarchar50NY9accountNNvarchar50NY10NNvarchar50NY11faxNNvarchar20NY12availableNNint11NN表 銷售信息表結(jié)構(gòu)序號字段名主鍵否外鍵否數(shù)值類型長度缺省值可為空1idYNchar20NN2customeridNYchar10NN3paytypeNNvarchar50NN4salestimeNNdatetimeNN5operatepersonNNvarchar50NN6n
公司管理相關(guān)推薦
鄂ICP備17016276號-1