搜索
BSSPDB设计说明书香港集中化影像IM预审系统DB设计说明书项目：香港集中化影像处理系统编写：集中营运项目组BSSPDB设计说明书交通银行软件开发中心第2页共24页文档修改历史版本号修改日期编写评审批准修改内容1.0初始编写BSSPDB设计说明书交通银行软件开发中心第3页共24页1引言..................................................................................................................................................41.2读者对象.................................................................................................................................41.3编写原则.................................................................................................................................42概念结构设计..................................................................................................................................42.2方法说明.................................................................................................................................42.3语义描述.................................................................................................................................42.4视图集成.................................................................................................................................42.4.1流水类基本ER图..........................................................................................................42.4.2参数类基本ER图..........................................................................................................82.5数据字典.................................................................................................................................92.5.1公共数据字典.................................................................................................................93逻辑结构设计................................................................................................................................213.1视图.......................................................................................................................................214.1脚本.......................................................................................................................................235物理结构设计................................................................................................................................24BSSPDB设计说明书交通银行软件开发中心第4页共24页1引言1.2读者对象DB设计人员、应用设计人员、应用开发人员1.3编写原则采用结构化建模方法2概念结构设计2.2方法说明使用自底向上方式进行分析，使用ER图+数据字典进行描述；2.3语义描述实体关系主键属性实体-属性关系实体-实体关系2.4视图集成2.4.1流水类基本ER图1.公共流水ER图BSSPDB设计说明书交通银行软件开发中心第5页共24页CPIM_TASK_INFOSNPROCESSIDNAMEAPP_IDLOGOID_PPCPIM_BILL_INFOSNPAGE_NOREMARKPAGE_TYPEPAGE_TYPE_NAMECBE_FLAG关系1nCPIM_FACTOR_INFO关系1nFACTOR_NAMESNPAGE_NOFACTOR_IDFACTOR_ALIASFACTOR_VALUECPIM_IMGPIGE_INFO关系11SNDOC_IDAPP_IDCPIM_RENEWIMG_SEQUENCE_INFODOC_IDDOC_NAMEDOC_PAGELOAD_DATE关系nDOC_PAGE......1关系1CPIM_NODE_TASK_INFOTASKIDPROCESSIDSNNODEIDORGIDUSERIDSTARTDATEDONEDATEAPPNO1CUST_IDREC_DATE1BSSPDB设计说明书交通银行软件开发中心第6页共24页WORKFLOW_ACTIVITYpoidprocessPOIDmpidnodeHandlestatuslocalServerIdnodeIdnodeNamenodeKindbackupStatusremoteServerIdexecModeflagcallModeoverduedeadlinepreActionCursortaskAssignActionCursorstartDatetimetaskActionCursorpostActionCursorvalvedoneDatetimeisReversableisAssertBackableholeFlagassignExecTypeWORKFLOW_PROCESSpoidmpidtemplateHandletemplateIdstartModetriggerSourcetemplateNamemainVersionsubVersionsubjectparentProcPOIDlocalServerIdparentActivityPOIDexecModeinitiatorNamedoneDatetimeinitiatorPositionIdownerOrgIddeadlinestatusflagbackupStatusref1ref2ref3ref4ref5initiatorIdstartDatetimeoverdue关系n1WORKFLOW_MESSAGE_CURRENTMSG_CREATE_TIMEMSG_IDMSG_NODE_NAMEMSG_SNMSG_TYPEBSSPDB设计说明书交通银行软件开发中心第7页共24页WORKFLOW_TASK_READYpoidmpidactivityPOIDnodeIdtemplateNamemainVersionnodeNamenodeKindpackageIdtriggerSourceownerServerIdpackageNamecreateModesubVersionassignModeuserExtString2isAssertBackablecreatedDatetimeuserExtString1startDatetimedeadlinedoneDatetimeuserExtString3userExtString4userExtString5userExtString6userExtString7subjectoriginalTaskPOIDmemooverduetaskSequencetaskKindprocessPOIDtemplateIduserExtString8assignTargetTypeownerIdownerNameownerPositionIdownerUnitIdownerGroupIdassignTargetIdowernOrgIdexecutorNameexecutorPositionIdpriorityweightstatusflagexecutorIdbackupStatusWORKFLOW_TASK_LISTpoidmpidactivityPOIDnodeIdtemplateNamemainVersionnodeNamenodeKindpackageIdtriggerSourceownerServerIdpackageNamecreateModesubVersionassignModeuserExtString2isAssertBackablecreatedDatetimeuserExtString1startDatetimedeadlinedoneDatetimeuserExtString3userExtString4userExtString5userExtString6userExtString7subjectoriginalTaskPOIDmemooverduetaskSequencetaskKindprocessPOIDtemplateIduserExtString8assignTargetTypeownerIdownerNameownerPositionIdownerUnitIdownerGroupIdassignTargetIdowernOrgIdexecutorNameexecutorPositionIdpriorityweightstatusflagexecutorIdbackupStatusBSSPDB设计说明书交通银行软件开发中心第8页共24页WORKFLOW_TASK_STARTpoidmpidactivityPOIDnodeIdtemplateNamemainVersionnodeNamenodeKindpackageIdtriggerSourceownerServerIdpackageNamecreateModesubVersionassignModeuserExtString2isAssertBackablecreatedDatetimeuserExtString1startDatetimedeadlinedoneDatetimeuserExtString3userExtString4userExtString5userExtString6userExtString