物流管理系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)文檔

1、1AugustAugust物流配送系統(tǒng)物流配送系統(tǒng)數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書(shū)數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明書(shū)編寫(xiě)：鄭宇孫海翰日期：2011年9月9日審核：日期：批準(zhǔn)：日期：受控狀態(tài)：是發(fā)布版次：1.0日期：編號(hào)：31引言...........................................................................................................................

2、.....................41.1預(yù)期的讀者........................................................................................................................41.2數(shù)據(jù)庫(kù)...............................................................

3、.................................................................41.3目的和作用........................................................................................................................42數(shù)據(jù)字典設(shè)計(jì)..................

4、..............................................................................................................52.4城市........................................................................................................

5、.............................72.5城市區(qū)域.............................................................................................................................72.6管理員...................................................

6、..............................................................................72.7交接單.................................................................................................................................82.8路線

7、.....................................................................................................................................92.9配送點(diǎn)................................................................................

8、.................................................92.10配送范圍.........................................................................................................................102.11省份.................................

9、................................................................................................102.12用戶組...................................................................................................................

10、..........103數(shù)據(jù)庫(kù)設(shè)計(jì)..................................................................................................................................113.1系統(tǒng)物理結(jié)構(gòu)設(shè)計(jì)...........................................................

11、................................................113.2數(shù)據(jù)庫(kù)概念設(shè)計(jì)...............................................................................................................113.3數(shù)據(jù)庫(kù)物理模型設(shè)計(jì)...................................

12、....................................................................123.4數(shù)據(jù)庫(kù)表設(shè)計(jì)...................................................................................................................133.4.1消費(fèi)者................

13、....................................................................................................133.4.2訂單...............................................................................................................

14、.........143.4.3車輛........................................................................................................................143.4.4城市.........................................................................

15、...............................................153.4.5城市區(qū)域................................................................................................................153.4.6管理員........................................

16、.............................................................................153.4.7交接單....................................................................................................................153.4.8路線........

17、................................................................................................................163.4.9配送點(diǎn)..................................................................................................

18、..................163.4.10配送范圍..............................................................................................................173.4.11省份......................................................................

19、................................................173.4.12用戶組..................................................................................................................173.5表之間的關(guān)聯(lián)關(guān)系..................................

20、.........................................................................173.5.1配送點(diǎn)與配送范圍關(guān)系........................................................................................173.5.2配送點(diǎn)與省份關(guān)系...........................

21、.....................................................................183.5.3配送點(diǎn)與城市關(guān)系................................................................................................183.5.4路線與城市關(guān)系..........................

22、..........................................................................183.5.5訂單與報(bào)表關(guān)系....................................................................................................183.5.6客戶與訂單關(guān)系..................

23、..................................................................................183.6存儲(chǔ)過(guò)程設(shè)計(jì)...................................................................................................................183.6.1用戶信息存

24、儲(chǔ)過(guò)程（UserInfo）...................................193.6.2車輛存儲(chǔ)過(guò)程（WLBus）..........................................193.6.3信息檢驗(yàn)存儲(chǔ)過(guò)程（WLCheckInfo）................................193.6.4常用查詢存儲(chǔ)過(guò)程（WLCommonSearch）...................