财务软件数据库设计

：seraph11.0日期：31916041.doc1：seraph21.........................................................................................51.1............................................................................................5........................................................................................5............................................................................................5............................................................................................5........................................................................................5....................................................................................51.21.31.41.51.62实体关系.............................................................................................................52.1............................................................................................5科目信息.............................................................................................................5账户类型信息.....................................................................................................5科目类别.............................................................................................................5帐套信息.............................................................................................................6会计期间信息.....................................................................................................6用户信息.............................................................................................................6权限信息.............................................................................................................6凭证类别.............................................................................................................72.2............................................................................................7凭证信息.............................................................................................................7结算方式信息.....................................................................................................72.3............................................................................................8账簿基本信息.....................................................................................................8三栏式账簿信息.................................................................................................8多栏式账簿信息.................................................................................................8数量三栏式账簿信息.........................................................................................82.4............................................................................................9现金盘点信息.....................................................................................................9实物盘点信息.....................................................................................................92.5............................................................................................9日记账信息.........................................................................................................9银行对账单.......................................................................................................10企业银行帐.......................................................................................................102.6......................................................................................3数据字典...........................................................................................................1231916041.doc2：seraph33.13.1.1..........................................................................................12表......................................................................................................12(帐套表)basInfo_accountOver...................................................................................12(会计期间表)basInfo_period.....................................................................................12(科目表)basInfo_subject............................................................................................12(科目类别表)basInfo_subjectType............................................................................13(账簿表)basInfo_accountBook..................................................................................13(账簿类别表)basInfo_accountBookType..................................................................13(用户表)basInfo_user................................................................................................14(权限表)basInfo_right................................................................................................14(用户权限关联表)basInfo_userRightRelation..........................................................14(凭证类别表)basInfo_voucherType...........................................................................143.1.23.1.33.1.43.23.2.1视图..................................................................................................15存储过程..........................................................................................16触发器..............................................................................................16..........................................................................................16表......................................................................................................16(凭证表)vouMng_voucher.........................................................................................16(分录表)vouMng_entry.............................................................................................17(结算方式表)vouMng_closeAccount........................................................................173.2.2视图..................................................................................................17存储过程..........................................................................................18触发器..............................................................................................18..........................................................................................18表......................................................................................................183.2.33.2.43.33.3.1(多栏账关系表)accBookMng_multicolumnRelation...............................................183.3.2视图..................................................................................................18存储过程..........................................................................................19触发器..............................................................................................19..........................................................................................19表......................................................................................................193.3.33.3.43.43.4.1(现金盘点)chkProp_checkCash.................................................................................19(实物盘点)chkProp_checkArticle.............................................................................193.4.2视图..................................................................................................20存储过程..........................................................................................20触发器..............................................................................................20..........................................................................................20表......................................................................................................203.4.33.4.43.53.5.131916041.doc3：seraph4(日记账)cashierMng_dayBook..................................................................................20(日记账记录)cashierMng_record.............................................................................21(银行对账单)cashierMng_bankStatement.................................................................21(企业银行帐)cashierMng_enterBankAccount...........................................................223.5.2视图..................................................................................................22存储过程............................