区域决策分析数据库设计说明书

区域决策分析系统数据库设

计说明书

文档编号：

当前版本：V0.1

发布日期：2014年3月

审阅者：

读者：

版权所有：

保密等级:

修订记录

A-新增M-修改D-删除

变更类型

版本日期修订原因修订人

(A-M-D)

0.12013年10月23日A初稿

1.02013年10月31日M根据设计评审结果修改完善。

1.02014年2月3日M添加部分字典的字典描述

1.12014年3月26日M补充完善基础管理子系统相关设计。

目录

1.概述...................................................................................6

1-1-编写目的..........................................................................6

1.2.适用范围..........................................................................6

1.3.术语和缩写.......................................................................6

1.4.参考资料..........................................................................6

4.数据库环境.............................................................................7

4.1.命名约定..........................................................................7

4.2.数据库平台........................................................................7

4.3.物理文件..........................................................................7

5.物理设计...................................................................................8

5.1.实体表关系图.....................................................................8

5.2.实体表字段设置...................................................................9

CBB_FUWUJG.............................................................................................................................................................9

CBB_FUWUJGZLKM.................................................................................................................................................10

CDD_GANGWCI.........................................................................................................................................................10

CBB_GANGWEIGNZH...............................................................................................................................................11

CBB_GANGWEIJB.....................................................................................................................................................11

CBB_GONGNENGMX...............................................................................................................................................11

CBB_GONGNENGZH................................................................................................................................................12

CBB_GONGNENGZHGN...........................................................................................................................................12

CBBJICHUZD............................................................................................................................................................12

CBBJICHUZDMX.....................................................................................................................................................13

CBB_LOG_ERROR.....................................................................................................................................................13

CBB_LOG_LOGIN.....................................................................................................................................................14

CBB_LOG_OPERATE.................................................................................................................................................14

CBB_SHENGSHIQX...................................................................................................................................................15

CBB_YONGHU...........................................................................................................................................................15

CBB_YONGHUGW....................................................................................................................................................16

CBB_YONGHUSY.......................................................................................................................................................16

CBB_YONGHUXT......................................................................................................................................................16

GY_XITONGXX...........................................................................................................................................................17

GY_YHXT...................................................................................................................................................................17

GY_YHGXJG...............................................................................................................................................................17

GY_YHSSQH..............................................................................................................................................................18

GY_YONGHU.............................................................................................................................................................18

GY_ZH_WSTJZB.........................................................................................................................................................19

GY_ZH_WSYWYDM..................................................................................................................................................19

GY_ZH_ZBKJ..............................................................................................................................................................19

XT_GXY_BFZFL..........................................................................................................................................................19

XT_GXY_GFGLRS......................................................................................................................................................20

XTGXYNLTJ............................................................................................................................................................20

XT_GXY_XBFL............................................................................................................................................................20

XT_GXY_XYKZRS.......................................................................................................................................................21

XT_GXY_ZYRQ...........................................................................................................................................................21

XT_JCDA_NLTJ...........................................................................................................................................................21

XT_JKYS_CJRYFL.......................................................................................................................................................22

XT_JKYS_XWXG........................................................................................................................................................22

XT_JSB_GFGLRS.......................................................................................................................................................23

XT_LRBJ_GFGLRS.....................................................................................................................................................23

XT_LRBJ_JGRS...........................................................................................................................................................23

XT_LRBJ_LNZFL........................................................................................................................................................23

XT_LRBJ_LSSLRRS.....................................................................................................................................................24

XT_MONTH...............................................................................................................................................................24

XT_NCZ_BFZFL..........................................................................................................................................................24

XT_NCZ_GFGLRS......................................................................................................................................................25

XT_NCZ_XBFL............................................................................................................................................................25

XT_RKQK_HYGC.......................................................................................................................................................25

XT_RKQK_JTLXGC.....................................................................................................................................................26

XT_RKQK_JTRKGC....................................................................................................................................................2G

XT_RKQK_MZGC......................................................................................................................................................26

XT_RKQK_SLTJ...........................................................................................................................................................27

XT_RKQK_WHTJ.......................................................................................................................................................27

XT_RKQK_YLDY........................................................................................................................................................27

XT_RKQK_ZYGC........................................................................................................................................................28

XT_TJ_NLTJ................................................................................................................................................................28

XT_TNB_BFZFL..........................................................................................................................................................28

XT_TNB_GFGLRS......................................................................................................................................................29

XT_TNB_NLTJ............................................................................................................................................................29

XT_TNB_XBFL............................................................................................................................................................29

XT_TNB_XTKZRS......................................................................................................................................................30

XT_TNB_ZYRQ...........................................................................................................................................................30

XT_ZH_CRBBKRS......................................................................................................................................................30

XT_ZH_GHZRC..........................................................................................................................................................31

XT_ZH_GRJDS...........................................................................................................................................................31

XT_ZH_GXYFCRC......................................................................................................................................................31

XT_ZH_GXYGLRS......................................................................................................................................................32

XT_ZH_GXYPGRC.....................................................................................................................................................32

XT_ZH_GXYSFRC......................................................................................................................................................32

XT_ZH_JSBDJRS........................................................................................................................................................33

XT_ZH_JTDAS............................................................................................................................................................33

XT_ZH_LRGLRS..........................................................................................................................................................33

XT_ZH_LRPGRC........................................................................................................................................................34

XT_ZH_LRSFRC..........................................................................................................................................................34

XT_ZH_MZCF............................................................................................................................................................34

XTZHMZRC............................................................................................................................................................35

XT_ZH_MZSR............................................................................................................................................................35

XT_ZH_NZZGLRS......................................................................................................................................................35

XT_ZH_NZZPGRC.....................................................................................................................................................36

XT_ZH_NZZSFRC......................................................................................................................................................36

XT_ZH_PJZYTS...........................................................................................................................................................36

XT_ZH_SYSBG...........................................................................................................................................................37

XT_ZH_TJFWJG..........................................................................................................................................................37

XT_ZH_TJRS...............................................................................................................................................................38

XT_ZH_TJXZQH..........................................................................................................................................................38

XT_ZH_TJZB..............................................................................................................................................................38

XT_ZH_TNBGLRS......................................................................................................................................................39

XT_ZH_TNBPGRC.....................................................................................................................................................39

XT_ZH_TNBSFRC......................................................................................................................................................39

XT_ZH_YPSR..............................................................................................................................................................40

XT_ZH_YXWZBG.......................................................................................................................................................40

XT_ZH_ZLGLRS.........................................................................................................................................................40

XT_ZH_ZLSFRC.........................................................................................................................................................41

XT_ZIl_ZYDRSS.........................................................................................................................................................41

XT_ZH_ZYCY..............................................................................................................................................................41

XT_ZH_ZYRY..............................................................................................................................................................42

XT_ZH_ZYSF..............................................................................................................................................................42

XT_ZH_ZYYZ..............................................................................................................................................................42

6.备份方案.............................................................................44

7.安全设计.............................................................................44

8.数据迁移与性能设计..................................................................44

9.待解决问题...........................................................................44

1.概述

1.1.编写目的

在需求分析和系统概要设计的基础上对数据进行分析设计，以此作为详细功能设计、编码、测试的依

据。

1.2.适用范围

适用于功能设计阶段、编码阶段数据流转的依据。

1.3.术语和缩写

术语和缩写解释备注

RHM区域决策分析系统简称

ZHGL区域决策分析系统的数据库

1.4.参考资料

1.《区域决策分析系统需求规格说明书.doc》

2.《区域决策分析系统原理和效果.doc》

3.《项目技术方案.doc》

4.数据库环境

4.1.命名约定

1）表命名规则：

公用表类：公用模块均在基础管理系统内，前缀采用CBB,CBB_+实体类的英文名或者汉字全拼，如

CBB_YONGHU；

系统类：子系统简拼_+实体类的英文名或者汉字简拼，如XT_ZH_TJFWJG；

'业务类：子系统简拼业务拼音（如：高血压专项就用GXY）+_+实体类的英文名或者汉字简拼，如

XT_GXY_GFGLRS；

2）视图命名规则

V_+子系统简拼（如I：决策分析就用JCFX）+_+业务类拼音（如：高血压专项就用GXY）+实体类的英

文名或者汉字简拼；

3）过程包命名

PKG_+子系统简拼（如：决策分析就用JCFX）+_+实体类的英文名或者汉字全拼；

4）存储过程和函数命名规则

存储过程和函数都放到某块定义的包里，存储过程用USP_+（查询用〃G",删除用"D〃，新增用修改用"U〃）

+实体类的英文名或者汉字全拼；函数用F_+函数名。

4.2.数据库平台

1）数据库是使用Oracle10g版本。

2）数据库访问，若使用Oracle提供的ODAC,统一使用ODAC10g版本。

4.3.物理文件

■表空间文件：

>命名规则：ZHGL」文件序号，从01开始］.DBF,如ZHGLJH.DBF；

>大小：单个数据库表空间文件大小不超过4G,若空间需求量较大，则多创建几个文件；

■数据库备份文件：

>命名规则：ZHGL_Backup_［备份日期，yyyyMMddl.dmp,$11ZHGL_Backup_2O121O2O.dmp；

5.物理设计

5.1.实体表关系图

图1决策分析数据表关系图

GBCXNGME1JB

JHiBlKWIMWR(8)<pk>

J1I«IEMCVARaiAR2(5(l)

J1EBIEMSVARaiAR2(200)

XITOWIDVARCH.\R2(32)

SIIIHXZXXIWER(I)

K1LGAIRQPATH

CB8YONGHlCBSGANG咱CB8(XWGXENG2WCBBCOXG5ENGMX

YONGtR,BHKIMBER(10)<pk>GANGVElBliMWKR(8)<pk>GONC；XH?«ZIIWIVA!iCIUR2(ll)<pk>(XWGXENGWIYAKCIUK2(6)<pk>

I-lVIJGWIVl\RCHAR2(22)GANGVE1VCVARtHAR2(32)G0NGSENGZ1IMCVARCI«R2()00)GOftGM-NGWCVARCIUR2(50)

FIWJGWCVi\RCHAR2(IOO)XHONGIDVARCHAR2C32)G0NGXEW2HJCVARCIUR2(32)GOWNEVXKVARCIWR2(100)

Y0NGIRID1.MVARCHAR2<32)GANCVE1若VARCHAR2(l00>GONGNENGZHJBMMBEJt(l)GOWNENGBSYARCIUR2(50)

MIMAVWHAR2(100)JIEBIE8HMM?原⑻<fk>SHASGCEKG8HVARCIWQ(ll)XJTONGIDYARCIUR2(32)

Y<mRIXMVi\RGIAR(a2)XIAKSHISXMVRI-RGONGXENGZJIIAVARCIUR2(32)URLV.MiCmR2(200)

XINGBIECHAR⑴SHirovzxMWhR(l)SHHWGKDKWR⑴I如GENUffiEK⑴

CHUSIIENGRQDATEXIIGAIRQIW1EXITOWIDYARCHAR2(32)l加阳IRLVARCIUR2(100)

SMEXFEXZIMYARGKR2(⑻XI^SMISXNIVtOSHIFUIZXM喇区⑴

DIAMRIAVi\RCHAR2(5O>IRLVARCIUR2(300)RRI2MIYAW-IUR2(200)

NKENUMBER⑴

SHOUJIVl\RCHAR2(50)CBBGAXGAElGNai

EMAILV.WIAR2(5O)iUWEVRLVARCmR2(IOO)

GANGVE1WINIYBER(8)仙，fkJ>

QQVi\RaiAR2(5O)SHIRXJZX

VARaiAR2(32)

MSNV»\RaiAR2(5O)GAYGE1WCBEIZIJLYAUCIUR2(300)

V：\RaiAR2<ll)<pc.fk2>

CAV>WIAR2(32)GWGNI-NGZIiBH

GONGKENGZIOICV.XRUimClOO)

YONGIULBM'llI

XIIONGIDVARUIAR2Q2)

XIAXSMISXMMP-k

ZIIKERQDATEXIAX5H1SXNIMBFR

XIUGMRODATE

X1UGAIRQDATECB8OONGXEWZIDN

BEI7MVVARGMR2(300)

YOJXIAOXSKQDATEGOXOSI-JiGZIBHSRQIAR2UD<pk,fkl>

raixiAojzjjoDATECOXGSENG8HVARCHAR2(6)<DkJk2>

SHIRUZXNIMBER(1>GOXGS&iGMCVARCHAR2(5C)

CBBYWailiGyIRLV,\Raii\R2(2CO)

X1ANSH1SX