财务管理软件数据库设计说明书版本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财产清查模块 (12)3.4.1表 ......................................................................................................... (现金盘点)chkProp_checkCash ................................................................................... (实物盘点) chkProp_checkArticle .............................................. 错误!未定义书签。