快遞物流管理系統(tǒng)需求分析課程-全文預(yù)覽
【正文】 r(50)性別Gendervarchar(50)出生日期Birthdayvarchar(50)狀態(tài)Statevarchar(50)車(chē)號(hào)CarNOvarchar(50)準(zhǔn)載體積AllowCarryVolumevarchar(50)準(zhǔn)載重量AllowCarryWeightvarchar(50)住址Addressvarchar(50)車(chē)型CarTypevarchar(50)車(chē)廂長(zhǎng)度CarLengthvarchar(50)車(chē)屬單位CarDeptvarchar(50)車(chē)屬單位電話(huà)CarDeptTelvarchar(50)駕駛證DriveLicencevarchar(50)行駛證RunLicencevarchar(50)營(yíng)運(yùn)證BizLicencevarchar(50)保險(xiǎn)證InsuranceCardvarchar(50)車(chē)廂寬度CarWidthvarchar(50)載物高度GoodsHeightvarchar(50)車(chē)架號(hào)CarFrameNOvarchar(50)發(fā)動(dòng)機(jī)號(hào)EngineNOvarchar(50)備注Remarkvarchar(50)公司車(chē)CompanyCarbit 地區(qū)城市表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint城市Cityvarchar(50) 城市擴(kuò)充表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint城市PKIDCityPKIDint范圍城市RangeCityvarchar(50) 線(xiàn)路信息名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint起點(diǎn)StartStationvarchar(50)終點(diǎn)EndStationvarchar(50)里程Distancereal抵運(yùn)時(shí)間FetchTimereal 功能表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint頁(yè)面功能PageFunctionvarchar(50)頁(yè)面名稱(chēng)PageNamevarchar(50) 用戶(hù)組表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint組名稱(chēng)GroupNamevarchar(50)描述Descriptionvarchar(255) 用戶(hù)表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint登錄IDLoginIDvarchar(50)密碼Passwordvarchar(50)是否在線(xiàn)IfOnlinebit 功能與組表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint功能PKIDFunctionPKIDint組PKIDGroupPKIDint 用戶(hù)與組表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint用戶(hù)PKIDUserPKIDint組PKIDGroupPKIDint 職員用戶(hù)關(guān)系表名稱(chēng)字段數(shù)據(jù)類(lèi)型PKIDPKIDint職員PKIDEmployeePKIDint用戶(hù)PKIDUserPKIDint 打印客戶(hù)運(yùn)量名稱(chēng)字段數(shù)據(jù)類(lèi)型發(fā)貨客戶(hù)SendGoodsCustomervarchar(50)運(yùn)費(fèi)總計(jì)CarriageTotalmoney保險(xiǎn)費(fèi)總計(jì)InsuranceTotalmoney件數(shù)總計(jì)PieceAmountTotalint 打印專(zhuān)線(xiàn)整體名稱(chēng)字段數(shù)據(jù)類(lèi)型裝貨地點(diǎn)LoadStationvarchar(50)交貨地點(diǎn)DealGoodsStationvarchar(50)總運(yùn)費(fèi)總計(jì)AllCarriageTotalmoney保險(xiǎn)費(fèi)總計(jì)InsuranceTotalmoney次數(shù)Timesint 裝貨發(fā)車(chē)清單名稱(chēng)字段數(shù)據(jù)類(lèi)型用戶(hù)IDUserIDvarchar(50)序號(hào)IDvarchar(50)發(fā)貨客戶(hù)SendGoodsCustomervarchar(50)貨物名稱(chēng)GoodsNamevarchar(50)貨物編號(hào)GoodsCodevarchar(50)中轉(zhuǎn)目的地TransferDestinationvarchar(50)發(fā)貨客戶(hù)電話(huà)SendGoodsCustomerTelvarchar(50)現(xiàn)付CashPaymoney提付PickupPaymoney回結(jié)BackCostmoney代收款HelpAcceptFundvarchar(50)備注Remarkvarchar(50)司機(jī)名稱(chēng)DriverNamevarchar(50)車(chē)牌號(hào)CarCardNOvarchar(50)手機(jī)Mobilevarchar(50)件數(shù)PieceAmountint貨運(yùn)回執(zhí)單編號(hào)GoodsRevertBillCodevarchar(50) 打印司機(jī)運(yùn)量名稱(chēng)字段數(shù)據(jù)類(lèi)型車(chē)號(hào)CarNOvarchar(50)承運(yùn)費(fèi)總計(jì)CarryFeeTotalmoney加運(yùn)費(fèi)總計(jì)AddCarriageTotalmoney總計(jì)Totalmoney 打印業(yè)務(wù)統(tǒng)計(jì)日?qǐng)?bào)表名稱(chēng)字段數(shù)據(jù)類(lèi)型提貨點(diǎn)PickupStationvarchar(50)收貨地址1ReceiveGoodsAddr1varchar(50)應(yīng)收金額1MoneyReceivable1varchar(50)已收金額1ReceivedMoney1varchar(50)余額1Balance1varchar(50)應(yīng)收件數(shù)1PieceCountReceivable1varchar(50)已收件數(shù)1ReceivedPieceCount1varchar(50)剩余件數(shù)1RemainPieceCount1varchar(50)收貨地址2ReceiveGoodsAddr2varchar(50)應(yīng)收金額2MoneyReceivable2varchar(50)已收金額2ReceivedMoney2varchar(50)余額2Balance2varchar(50)應(yīng)收件數(shù)2PieceCountReceivable2varchar(50)已收件數(shù)2ReceivedPieceCount2varchar(50)剩余件數(shù)2RemainPieceCount2varchar(50)收貨地址3ReceiveGoodsAddr3varchar(50)應(yīng)收金額3MoneyReceivable3varchar(50)已收金額3ReceivedMoney3varchar(50)余額3Balance3varchar(50)應(yīng)收件數(shù)3PieceCountReceivable3varchar(50)已收件數(shù)3ReceivedPieceCount3varchar(50)剩余件數(shù)3RemainPieceCount3varchar(50) 打印車(chē)輛成本名稱(chēng)字段數(shù)據(jù)類(lèi)型司機(jī)名稱(chēng)DriverNamevarchar(50)車(chē)號(hào)CarNOvarchar(50)車(chē)型CarTypevarchar(50)準(zhǔn)載重量AllowCarryWeightvarchar(50)車(chē)廂寬度CarWidthvarchar(50)載物高度GoodsHeightvarchar(50)承運(yùn)費(fèi)總計(jì)CarryFeeTotalmoney加運(yùn)費(fèi)總計(jì)AddCarriageTotalmoney實(shí)際總運(yùn)費(fèi)FactCarriageTotalmoney裝貨地點(diǎn)LoadStationvarchar(50)交貨地點(diǎn)DealGoodsStationvarchar(50)回執(zhí)單編號(hào)BackBillCodevarchar(50)結(jié)算時(shí)間BalanceTimedatetime 打印往來(lái)業(yè)務(wù)名稱(chēng)字段數(shù)據(jù)類(lèi)型發(fā)貨客戶(hù)SendGoodsCustomervarchar(50)貨運(yùn)單編號(hào)GoodsBillCodevarchar(50)發(fā)貨地址SendGoodsAddrvarchar(50)
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1