圖書館管理系統建模設計由PDM對象自動生成旳數據庫腳本文獻代碼如下：ifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('books')='FK_BOOKS_管理書籍_ADMIN')altertablebooksdropconstraintFK_BOOKS_管理書籍_ADMINgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('borrow_information')='FK_BORROW_I_BORROW_IN_BOOKS')altertableborrow_informationdropconstraintFK_BORROW_I_BORROW_IN_BOOKSgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('borrow_information')='FK_BORROW_I_BORROW_IN_READER')altertableborrow_informationdropconstraintFK_BORROW_I_BORROW_IN_READERgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('login')='FK_LOGIN_LOGIN_ADMIN')altertablelogindropconstraintFK_LOGIN_LOGIN_ADMINgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('login')='FK_LOGIN_LOGIN2_READER')altertablelogindropconstraintFK_LOGIN_LOGIN2_READERgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('reversation')='FK_REVERSAT_REVERSATI_BOOKS')altertablereversationdropconstraintFK_REVERSAT_REVERSATI_BOOKSgoifexists(select1fromdbo.sysreferencesrjoindbo.sysobjectsoon(o.id=r.constidando.type='F')wherer.fkeyid=object_id('reversation')='FK_REVERSAT_REVERSATI_READER')altertablereversationdropconstraintFK_REVERSAT_REVERSATI_READERgoifexists(select1fromsysindexeswhereid=object_id('admin')andname='權限_FK'andindid>0andindid<255)dropindexadmin.權限_FKgoifexists(select1fromsysobjectswhereid=object_id('admin')andtype='U')droptableadmingoifexists(select1fromsysindexeswhereid=object_id('books')andname='管理書籍_FK'andindid>0andindid<255)dropindexbooks.管理書籍_FKgoifexists(select1fromsysindexeswhereid=object_id('books')andname='圖書類型_FK'andindid>0andindid<255)dropindexbooks.圖書類型_FKgoifexists(select1fromsysobjectswhereid=object_id('books')andtype='U')droptablebooksgoifexists(select1fromsysobjectswhereid=object_id('booktype')andtype='U')droptablebooktypegoifexists(select1fromsysindexeswhereid=object_id('borrow_information')andname='Association_2_FK'andindid>0andindid<255)dropindexborrow_information.Association_2_FKgoifexists(select1fromsysindexeswhereid=object_id('borrow_information')andname='Association_1_FK'andindid>0andindid<255)dropindexborrow_information.Association_1_FKgoifexists(select1fromsysobjectswhereid=object_id('borrow_information')andtype='U')droptableborrow_informationgoifexists(select1fromsysindexeswhereid=object_id('login')andname='login2_FK'andindid>0andindid<255)dropindexlogin.login2_FKgoifexists(select1fromsysindexeswhereid=object_id('login')andname='login_FK'andindid>0andindid<255)dropindexlogin.login_FKgoifexists(select1fromsysobjectswhereid=object_id('login')andtype='U')droptablelogingoifexists(select1fromsysindexeswhereid=object_id('reader')andname='顧客權限_FK'andindid>0andindid<255)dropindexreader.顧客權限_FKgoifexists(select1fromsysobjectswhereid=object_id('reader')andtype='U')droptablereadergoifexists(select1fromsysindexeswhereid=object_id('reversation')andname='reversation2_FK'andindid>0andindid<255)dropindexreversation.reversation2_FKgoifexists(select1fromsysindexeswhereid=object_id('reversation')andname='reversation_FK'andindid>0andindid<255)dropindexreversation.reversation_FKgoifexists(select1fromsysobjectswhereid=object_id('reversation')andtype='U')droptablereversationgocreatetableadmin(admin_idintnotnull,admin_namechar(20)null,admin_passwordchar(16)null,loginsintnull,last_loginchar(10)null,"right"intnull,constraintPK_ADMINprimarykeynonclustered(admin_id))gocreateindex權限_FKonadmin()gocreatetablebooktype(type_idintnull)gocreatetablebooks(book_idintnotnull,admin_idintnull,titlechar(20)null,type_idintnull,authorchar(40)null,pricemoneynull,"bookconcern"char(50)null,addtimedatetimenull,amountintnull,remainintnull,constraintPK_BOOKSprimarykeynonclustered(book_id),constraintFK_BOOKS_管理書籍_ADMINforeignkey(admin_id)referencesadmin(admin_id),constraintFK_BOOKS_BOOKTYPE_BOOKTYPEforeignkey()referencesbooktype)gocreateindex圖書類型_FKonbooks()gocreateindex管理書籍_FKonbooks(admin_idASC)gocreatetablereader(reader_idintnotnull,reader_namechar(20)null,sexchar(2)null,agetinyintnull,classchar(15)null,addresstextnull,memotextnull,maxborrowedintnull,reader_passwordchar(16)null,"right"intnull,constraintPK_READERprimarykeynonclustered(reader_id))gocreatetableborrow_information(book_idintnotnull,reader_idintnotnull,borrow_timedatetimenull,end_timedatetimenull,amountintnull,return_timedatetimenull,constraintPK_BORROW_INFORMATIONprimarykey(book_id,reader_id),constraintFK_BORROW_I_BORROW_IN_BOOKSforeignkey(book_id)referencesbooks(book_id),constraintFK_BORROW_I_BORROW_IN_READERforeignkey(reader_id)referencesreader(reader_id))gocreateindexAssociation_1_FKonborrow_information(book_idASC)gocreateindexAssociation_2_FKonborrow_information(reader_idASC)gocreatetablelogin(admin_idintnotnull,reader_idintnotnull,"right"intnull,constraintPK_LOGINprimarykey(admin_id,reader_id),constraintFK_LOGIN_LOGIN_ADMIN