一个典型的数据库设计实例2

SpbhcharPSpmcvarchar2t1Sslbchar8Jgmoney8sIurl4bmhhchar4xfzjemoney8kcxxbhcharkclintXsrqt1tctimc8›ZjeMoney6HybhC’har8$yyhhcharPcreatedatabaseglxt(nameosdat,filename='D:\posdat.andf',size-5,maxsize-20,fiiegrowth-1)LOGon(narne=poslog,filenarne='D:\poslog.ldf,size-5,createtablebin(bmbhchar(8)notnullconstraintPKbiroprimarykey,bmmcchar(4)notnull)g°createtablesp(spbhchar(8)riotnullconstraintPKcnoprimarykey,apmcvarchar(20)notnull,sslbchar(8)notnull,stintriotnull,jgmoneynotnull)4.createtablegys(gysbhchart8)notnullconstraintBKdnoprimarygysmcchait8)notnull,dzvarchart20)riotnull,yzbmchar(P)netnull,dhhmvarchar(15)notnull,shvarchar(3)riotnull,yhzhvarchaq20)notnull,key,khyhchar(8›)notnull,lxrchart8)notnull,beizhutextnull5.createtablehy(hybhcha58)riotnutIconstraintPKenoJirimorykey.hynamechar(6)notrimI,sexchur(2)checkCKhysexin(’’,’V’)nornulI,sfzhvarcha520)ncitnull,xfzjemoneynotnull,jIintnotnull6.createtableyg(ygbhchart8)notnuIIconstraintPKfireprimarykey,ygnamcchar(8)notiiulI,sexchor(2)checkC'Kygsexin(’’,k’)notnull,zvvcharfP)notrimI,kIvarchar(20)riotnull,qxjbcharl4)notmlI,sfzhvarcha518)notriuII,ss1›mbhchai(8)notinnIconstraintFKanoforeignkeyreferencesbin(bmhh)7.createtablerk(rkbhchar(8)notnulIconstraintPKquoprimarykey,xsjgmoiicynotnuII,rkrqdatetimcnotnutI,spbhchart8)notnullconstraintFKbnoforeignkeyreferencessp(spbh),ywybhcharf8)notnullconstraintFKcueforeignkeyreferencesyg(ygbhJ,jItlwchan2)notnull,rkjgmoneynotnull,wbhchart8)notnutIconstraintFKduoforeignkeyreferencesgystgysbh),zjemtiiicynotnuII,sliiitnotnull8.createtablezhuxx(xsrqdatetimenotmlI,zjemoneynotnull,constraintFKermforeignkeyrefcrcricesfry(hybh),syybhchart8)notnullconstraintFKfnoforeignkeyrefereiacesyg(ygbh)9.createtablezixx(spbhcha98)notnullconstraintFKgunforeignkeyreferencessp(spbh),slintnotnull,djmoneynotnull,zkblchar(10)notnull,jemoneynotntill,g*10.createtablekc(kcxxbhchar(8)notn\tlIconstraintPKJino(Primarykey,spbhchar(8)notnutIconstraintFKinoforeignkeyrefereiicessp(spbh),kclininotnullI.CREATETIIlCiGERtrigersIONrkafterinsert2.CREATETRlGCiERtrigerkcClNzixxafterdeleteASupdatekcsetkcl=kcl-(selectstfmmdeletedJwherespbh=(selectspbhfromdeleted)