sql.server.設計、命名、編碼規(guī)范

1、1SQLServer設計、命名、編碼規(guī)范SQLServerDatabaseDesignCodeDevelopmentStards1.更改..................................................................................................42.簡介.................................................

2、.................................................43.開發(fā)環(huán)境.............................................................................................53.1數(shù)據(jù)庫模型..............................................................

3、....................53.2Diagrams..................................................................................53.3版本控制.....................................................................................53.4源碼目錄結構...

4、...........................................................................54.物理數(shù)據(jù)庫模型&字典.............................................................................64.1物理數(shù)據(jù)模型.............................................

5、.................................64.2IDEF1X方法..............................................................................74.3物理數(shù)據(jù)庫數(shù)據(jù)字典......................................................................74.4性能設計......

6、..............................................................................75命名協(xié)定...........................................................................................85.1數(shù)據(jù)庫命名原則及版本控制.............................

7、.................................85.1.1數(shù)據(jù)庫命名原則....................................................................85.1.2數(shù)據(jù)庫版本控制...................................................................85.2Server命名實例的命名.........

8、.........................................................85.3數(shù)據(jù)庫命名.................................................................................95.4數(shù)據(jù)庫對象—表，視圖，列名，約束，規(guī)則，默認值..............................115.5縮寫規(guī)范.......

9、...........................................................................125.6列名........................................................................................125.7存儲過程命名.......................................

10、......................................145.8游標命名..................................................................................145.9觸發(fā)器命名...............................................................................15

11、5.10索引命名................................................................................155.11主鍵和外鍵命名........................................................................155.12Check約束命名................................

12、........................................165.13源文件命名..............................................................................165.14Job的命名..............................................................................1

13、65.15用戶自定義函數(shù)命名...................................................................1731.更改更改ChangeNameDate命名原則：表意性原則（增加）DavidDongJan05數(shù)據(jù)庫命名DavidDongJan05表命名DavidDongJan05ServerInstance命名DavidDongJan05JOB復制命名DavidDongJan052

14、.簡介簡介數(shù)據(jù)庫設計是指對于一個給定的應用環(huán)境，構造最優(yōu)的數(shù)據(jù)庫模式，建立數(shù)據(jù)庫及其應用系統(tǒng)，有效存儲數(shù)據(jù)，滿足用戶信息要求和處理要求數(shù)據(jù)庫設計和開發(fā)標準是使NeweggSupptCenter的數(shù)據(jù)庫系統(tǒng)的設計和開發(fā)正式化的標準。通過此標準，來規(guī)范數(shù)據(jù)庫設計。通過一致的系統(tǒng)解決方案，能給我們的系統(tǒng)帶來以下優(yōu)點：?開發(fā)出高可管理性的高質量系統(tǒng)?能夠快速的進行開發(fā)?減少維護代碼的時間??非常容易的把代碼從一個項目拷貝至另一個項目??節(jié)省把游