财务管理软件数据库设计说明书版本1.0日期：2009-11-271实体，对象命名规范 ..............................1.1表名命名规范.................................1.2表字段命名规范...............................1.3序列命名规范.................................1.4视图命名规范.................................1.5触发器命名规范...............................1.6存储过程命名规范.............................2实体关系.........................................2.1基础信息模块 (5)科目信息............................................账户类型信息........................................科目类别............................................帐套信息............................................会计期间信息........................................用户信息............................................权限信息............................................凭证类别............................................2.2凭证管理模块.................................凭证信息............................................结算方式信息........................................2.3账簿管理模块................................. 账簿基本信息........................................ 三栏式账簿信息...................................... 多栏式账簿信息...................................... 数量三栏式账簿信息..................................2.4财产清查模块................................. 现金盘点信息........................................ 实物盘点信息........................................2.5出纳管理模块................................. 日记账信息.......................................... 银行对账单.......................................... 企业银行帐..........................................2.6系统实体关系图............................... 3数据字典.........................................3.1基础信息模块.................................3.1.1表........................................ (帐套表)basInfo_accountOver......................... (会计期间表)basInfo_period.......................... (科目表)basInfo_subject............................. (科目类别表)basInfo_subjectType..................... (账簿表)basInfo_accountBook......................... (账簿类别表)basInfo_accountBookType.................(用户表)basInfo_user................................ (权限表)basInfo_right............................... (用户权限关联表)basInfo_userRightRelation (14)(凭证类别表)basInfo_voucherType.....................3.1.2视图......................................3.1.3存储过程..................................3.1.4触发器....................................3.2凭证管理模块.................................3.2.1表........................................ (凭证表)vouMng_voucher.............................. (分录表)vouMng_entry................................ (结算方式表)vouMng_closeAccount.....................3.2.2视图......................................3.2.3存储过程..................................3.2.4触发器....................................3.3账簿管理模块.................................3.3.1表........................................ (多栏账关系表)accBookMng_ multicolumnRelation.......3.3.2视图......................................3.3.3存储过程..................................3.3.4触发器....................................3.4财产清查模块 (24)3.4.1表........................................(现金盘点)chkProp_checkCash......................... (实物盘点) chkProp_checkArticle... 错误！未定义书签。

3.4.2视图......................................3.4.3存储过程..................................3.4.4触发器....................................3.5出纳管理模块.................................3.5.1表........................................ (日记账)cashierMng_dayBook.......................... (日记账记录) cashierMng_record...................... (银行对账单)cashierMng_bankStatement................ (企业银行帐)cashierMng_enterBankAccount错误！未定义书签。

3.5.2视图......................................3.5.3存储过程..................................3.5.4触发器....................................1 实体，对象命名规范1.1表名命名规范模块名_+表名1.2表字段命名规范字段名1.3序列命名规范字段名_+id1.4视图命名规范Vw_+视图名1.5触发器命名规范Tig_+触发器名1.6存储过程命名规范Proc_+存储过程名2实体关系2.1基础信息模块科目信息账户类型信息科目类别帐套信息会计期间信息用户信息权限信息凭证类别2.2凭证管理模块凭证信息结算方式信息2.3账簿管理模块账簿基本信息三栏式账簿信息多栏式账簿信息数量三栏式账簿信息2.4财产清查模块现金盘点信息实物盘点信息2.5出纳管理模块日记账信息银行对账单企业银行帐2.6系统实体关系图3数据字典3.1基础信息模块3.1.1表(帐套表)basInfo_accountOver(会计期间表)basInfo_period(科目表)basInfo_subject(科目类别表)basInfo_subjectType(账簿表)basInfo_accountBook(账簿类别表)basInfo_accountBookType(用户表)basInfo_user(权限表)basInfo_right(用户权限关联表)basInfo_userRightRelation(凭证类别表)basInfo_voucherType3.1.2视图(科目账户视图) Vw_subjectAndAccountBook =(科目表)basInfo_subject+(科目类别表)basInfo_subjectType+(账簿表)basInfo_accountBook+(账簿类别表)basInfo_accountBookType(科目视图)Vw_subjects=(科目表)basInfo_subject+(科目类别表)basInfo_subjectType(帐套期间视图)Vw_accountBookAndPeriod=(帐套表)basInfo_accountOver+(会计期间表)basInfo_period(用户权限视图)Vw_userAndRights=(用户表)basInfo_user+(权限表)basInfo_right+(用户权限关联表)basInfo_userRightRelation3.1.3存储过程暂无3.1.4触发器暂无3.2凭证管理模块3.2.1表(凭证表)vouMng_voucher(分录表)vouMng_entry(结算方式表)vouMng_closeAccount3.2.2视图(凭证信息视图)Vw_voucherInfo=(凭证表)vouMng_voucher+(凭证类别表)basInfo_voucherType+(用户表)basInfo_user+(帐套表)basInfo_accountOver(凭证分录视图)Vw_voucherEntry=(分录表)vouMng_entry+(科目表)basInfo_subject+(结算方式表)vouMng_closeAccount3.2.3存储过程暂无3.2.4触发器暂无3.3账簿管理模块3.3.1表(多栏账关系表)accBookMng_ multicolumnRelation3.3.2视图(账簿信息视图) Vw_accountBookInfo=(科目表)basInfo_subject+(账簿表)basInfo_accountBook+(账簿类别表)basInfo_accountBookType+(会计期间表)basInfo_period(账簿记录视图)Vw_accountBookAndEntry=(分录表)vouMng_entry+(凭证表)vouMng_voucher3.3.3存储过程暂无3.3.4触发器暂无3.4财产清查模块3.4.1表(现金盘点)chkProp_checkCash(实物盘点) chkProp_checkArticle3.4.2视图(实物盘点视图)Vw_checkArticle=(实物盘点) chkProp_checkArticle+(科目表)basInfo_subject+(用户表)basInfo_user(现金盘点视图)Vw_checkCash=(现金盘点)chkProp_checkCash+(科目表)basInfo_subject+(用户表)basInfo_user3.4.3存储过程暂无3.4.4触发器暂无3.5出纳管理模块3.5.1表(日记账)cashierMng_dayBook(日记账记录) cashierMng_record(银行对账单)cashierMng_bankStatement(企业银行帐)cashierMng_enterBankAccount3.5.2视图(日记账簿信息视图)Vw_dayBookInfo=(会计期间表)basInfo_period+(用户表)basInfo_user+(日记账)cashierMng_dayBook(日记账记录视图)Vw_dayBookdRecord =(日记账记录) cashierMng_record+(凭证表)vouMng_voucher(企业银行对账视图)Vw_ enterBankAccount=(企业银行帐)cashierMng_enterBankAccount +(结算方式表)vouMng_closeAccount(银行对账视图)Vw_bankStatement=(银行对账单)cashierMng_bankStatement+(结算方式表)vouMng_closeAccount3.5.3存储过程暂无3.5.4触发器暂无。