财务软件数据库设计
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
2.4 财产清查模块 ............................................................................................ 9 现金盘点信息 ..................................................................................................... 9 实物盘点信息 ..................................................................................................... 9
2.6 系统实体关系图 ...................................................................................... 11
3 数据字典 ........................................................................................................... 12
(用户表 )basInfo_user ................................................................................................ 14
(权限表 )basInfo_right................................................................................................ 14
2.5 出纳管理模块 ............................................................................................ 9 日记账信息 ......................................................................................................... 9 银行对账单 ....................................................................................................... 10 企业银行帐 ....................................................................................................... 10
2.2 凭证管理模块 ............................................................................................ 7 凭证信息 ............................................................................................................. 7 结算方式信息 ..................................................................................................... 7
1.1 表名命名规范 ............................................................................................ 5 1.2 表字段命名规范 ........................................................................................ 5 1.3 序列命名规范 ............................................................................................ 5 1.4 视图命名规范 ............................................................................................ 5 1.5 触发器命名规范 ..........Leabharlann Baidu............................................................................. 5 1.6 存储过程命名规范 .................................................................................... 5
(用户权限关联表 )basInfo_userRightRelation .......................................................... 14
2 实体关系 ............................................................................................................. 5
2.1 基础信息模块 ............................................................................................ 5 科目信息 ............................................................................................................. 5 账户类型信息 ..................................................................................................... 5 科目类别 ............................................................................................................. 5 帐套信息 ............................................................................................................. 6 会计期间信息 ..................................................................................................... 6 用户信息 ............................................................................................................. 6 权限信息 ............................................................................................................. 6 凭证类别 ............................................................................................................. 7
2.3 账簿管理模块 ............................................................................................ 8 账簿基本信息 ..................................................................................................... 8 三栏式账簿信息 ................................................................................................. 8 多栏式账簿信息 ................................................................................................. 8 数量三栏式账簿信息 ......................................................................................... 8
作者： seraph
1
财务管理软件数据库设计说明书
版本 1.0 日期： 2009-11-27
31916041.doc
1
作者： seraph
2
1 实体，对象命名规范 ......................................................................................... 5
31916041.doc
2
作者： seraph
3
3.1 基础信息模块 .......................................................................................... 12
3.1.1
表 ...................................................................................................... 12
(科目表 )basInfo_subject ............................................................................................ 12
(科目类别表 )basInfo_subjectType ............................................................................ 13
(账簿表 )basInfo_accountBook .................................................................................. 13
(账簿类别表 )basInfo_accountBookType .................................................................. 13
(帐套表 )basInfo_accountOver ................................................................................... 12
(会计期间表 )basInfo_period ..................................................................................... 12
2.6 系统实体关系图 ...................................................................................... 11
3 数据字典 ........................................................................................................... 12
(用户表 )basInfo_user ................................................................................................ 14
(权限表 )basInfo_right................................................................................................ 14
2.5 出纳管理模块 ............................................................................................ 9 日记账信息 ......................................................................................................... 9 银行对账单 ....................................................................................................... 10 企业银行帐 ....................................................................................................... 10
2.2 凭证管理模块 ............................................................................................ 7 凭证信息 ............................................................................................................. 7 结算方式信息 ..................................................................................................... 7
1.1 表名命名规范 ............................................................................................ 5 1.2 表字段命名规范 ........................................................................................ 5 1.3 序列命名规范 ............................................................................................ 5 1.4 视图命名规范 ............................................................................................ 5 1.5 触发器命名规范 ..........Leabharlann Baidu............................................................................. 5 1.6 存储过程命名规范 .................................................................................... 5
(用户权限关联表 )basInfo_userRightRelation .......................................................... 14
2 实体关系 ............................................................................................................. 5
2.1 基础信息模块 ............................................................................................ 5 科目信息 ............................................................................................................. 5 账户类型信息 ..................................................................................................... 5 科目类别 ............................................................................................................. 5 帐套信息 ............................................................................................................. 6 会计期间信息 ..................................................................................................... 6 用户信息 ............................................................................................................. 6 权限信息 ............................................................................................................. 6 凭证类别 ............................................................................................................. 7
2.3 账簿管理模块 ............................................................................................ 8 账簿基本信息 ..................................................................................................... 8 三栏式账簿信息 ................................................................................................. 8 多栏式账簿信息 ................................................................................................. 8 数量三栏式账簿信息 ......................................................................................... 8
作者： seraph
1
财务管理软件数据库设计说明书
版本 1.0 日期： 2009-11-27
31916041.doc
1
作者： seraph
2
1 实体，对象命名规范 ......................................................................................... 5
31916041.doc
2
作者： seraph
3
3.1 基础信息模块 .......................................................................................... 12
3.1.1
表 ...................................................................................................... 12
(科目表 )basInfo_subject ............................................................................................ 12
(科目类别表 )basInfo_subjectType ............................................................................ 13
(账簿表 )basInfo_accountBook .................................................................................. 13
(账簿类别表 )basInfo_accountBookType .................................................................. 13
(帐套表 )basInfo_accountOver ................................................................................... 12
(会计期间表 )basInfo_period ..................................................................................... 12