ESB平台服务业务监控概要设计说明书

4.1.3 业务种类类代码表单

BIZ_KIND_CODEBIZ_KIND_IDNUMBER(10)INFO_SYS_IDNUMBER(10)CODEVARCHAR2(20)NAMEVARCHAR2(100)STATUSNUMBER(1)NOTESVARCHAR2(1000) 说明：业务种类代码表。 主键：Oracle Sequence 外键：INFO_SYS_ID 索引：无

4.1.4 业务流程代码表单

BIZ_PROC_CODEBIZ_PROC_IDNUMBER(10)BIZ_KIND_IDNUMBER(10)CODEVARCHAR2(20)NAMEVARCHAR2(100)STATUSNUMBER(1)NOTESVARCHAR2(1000) 说明：业务流程代码表。 主键：Oracle Sequence 外键：BIZ_KIND_ID 索引：无

22

4.2业务基础信息管理代码表 4.2.1 业务信息字段名称对照表

BIZ_INFO_DISP_TITLEBIZ_INFO_IDNUMBER(10)BIZ_PROC_IDNUMBER(10)STATUS_CODEVARCHAR2(20)REQ_SYS_CODEVARCHAR2(100)REQ_ORG_CODEVARCHAR2(100)TARGET_ORG_CODEVARCHAR2(100)TARGET_SYS_CODEVARCHAR2(100)BIZ_KINDVARCHAR2(100)AMOUNTVARCHAR2(100)PAY_MONEY_UNITVARCHAR2(20)PAY_MONEY_ACCOUNTVARCHAR2(100)RECEIVE_MONEY_UNITVARCHAR2(20)RECEIVE_MONEY_ACCOUNTVARCHAR2(100)BASIS_OF_POSTINGVARCHAR2(1000)ORG_OF_POSTINGVARCHAR2(200)OPERATOR_OF_POSTINGVARCHAR2(100)NOTESVARCHAR2(1000)FIELD1VARCHAR2(500)FIELD2VARCHAR2(500)FIELD3VARCHAR2(500)FIELD4VARCHAR2(500)FIELD5VARCHAR2(500)FIELD6VARCHAR2(500)FIELD7VARCHAR2(500)FIELD8VARCHAR2(500)FIELD9VARCHAR2(500)FIELD10VARCHAR2(500)FIELD11VARCHAR2(500)FIELD12VARCHAR2(500)FIELD13VARCHAR2(500)FIELD14VARCHAR2(500)FIELD15VARCHAR2(500)FIELD16VARCHAR2(500)FIELD17VARCHAR2(500)FIELD18VARCHAR2(500)FIELD19VARCHAR2(500)FIELD20VARCHAR2(500)FIELD21VARCHAR2(500)FIELD22VARCHAR2(500)FIELD23VARCHAR2(500)FIELD24VARCHAR2(500)FIELD25VARCHAR2(500)FIELD_INT1NUMBER(10)FIELD_INT2NUMBER(10)FIELD_INT3NUMBER(10)FIELD_INT4NUMBER(10)FIELD_INT5NUMBER(10) 说明：业务信息字段名称对照表。 主键：Oracle Sequence 外键：BIZ_PROC_ID 索引：无

23

4.2.2 业务信息表

BIZ_INFOBIZ_INFO_IDNUMBER(10)BIZ_PROC_IDNUMBER(10)STATUS_CODEVARCHAR2(20)NOTESVARCHAR2(1000)CREATE_TIMETIMESTAMPUPDATE_TIMETIMESTAMPOP_USER_IDNUMBER(10) 说明：业务信息表。 主键：Oracle Sequence

外键：BIZ_PROC_ID,STATUS_CODE 索引：无

4.2.3 结点信息表扩展

BIZ_NODE_MSG_EXTIDNUMBER(10)MSG_IDNUMBER(10)REQ_SYS_CODEVARCHAR2(100)REQ_ORG_CODEVARCHAR2(100)TARGET_ORG_CODEVARCHAR2(100)TARGET_SYS_CODEVARCHAR2(100)BIZ_KINDVARCHAR2(100)AMOUNTVARCHAR2(100)PAY_MONEY_UNITVARCHAR2(20)PAY_MONEY_ACCOUNTVARCHAR2(100)RECEIVE_MONEY_UNITVARCHAR2(20)RECEIVE_MONEY_ACCOUNTVARCHAR2(100)BASIS_OF_POSTINGVARCHAR2(1000)ORG_OF_POSTINGVARCHAR2(200)OPERATOR_OF_POSTINGVARCHAR2(100)NOTESVARCHAR2(1000)CREATE_TIMETIMESTAMPUPDATE_TIMETIMESTAMPOP_USER_IDNUMBER(10)FIELD1VARCHAR2(500)FIELD2VARCHAR2(500)FIELD3VARCHAR2(500)FIELD4VARCHAR2(500)FIELD5VARCHAR2(500)FIELD6VARCHAR2(500)FIELD7VARCHAR2(500)FIELD8VARCHAR2(500)FIELD9VARCHAR2(500)FIELD10VARCHAR2(500)FIELD11VARCHAR2(500)FIELD12VARCHAR2(500)FIELD13VARCHAR2(500)FIELD14VARCHAR2(500)FIELD15VARCHAR2(500)FIELD16VARCHAR2(500)FIELD17VARCHAR2(500)FIELD18VARCHAR2(500)FIELD19VARCHAR2(500)FIELD20VARCHAR2(500)FIELD21VARCHAR2(500)FIELD22VARCHAR2(500)FIELD23VARCHAR2(500)FIELD24VARCHAR2(500)FIELD25VARCHAR2(500)FIELD_INT1NUMBER(10)FIELD_INT2NUMBER(10)FIELD_INT3NUMBER(10)FIELD_INT4NUMBER(10)FIELD_INT5NUMBER(10)

24

说明：结点信息扩展表。 主键：Oracle Sequence 外键：MSG_ID 索引：无

4.2.4 业务流程状态代码表单

BIZ_PROC_STATUS_CODESTATUS_CODEVARCHAR2(20)NAMEVARCHAR2(100)NOTESVARCHAR2(1000) 说明：业务流程状态代码表。 主键：Oracle Sequence 外键：无 索引：无

4.3业务流进程管理表 4.3.1 业务进程消息表单

BIZ_NODE_MSGMSG_IDNUMBER(10)NODE_IDNUMBER(10)STATUS_CODEVARCHAR2(20)BIZ_INFO_IDNUMBER(10)备注VARCHAR2(1000)CREATE_TIMETIMESTAMPUPDATE_TIMETIMESTAMPOP_USER_IDNUMBER(10) 说明：业务进程消息表。 主键：Oracle Sequence

外键：NODE_ID，STATUS_CODE，BIZ_INFO_ID 索引：无

25