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