The following table describes the list of database tables related to execution history management of process instances:

Table 2-10 TableList of database tables related to execution history management of process instances

Classification	Table name	Description
Basic information table	CSCBP_<Cluster name>_PROCESS	Store process instance status.
	CSCBP_<Cluster name>_ACTIVITY	Store activity instance status.
	CSCBP_<Cluster name>_LINK	Store link status.
	CSCBP_<Cluster name>_CORRELATIONSET	Store correlation set value.
Variable information table	CSCBP_<Cluster name>_STR_VARIABLE	Store string type variable value.
	CSCBP_<Cluster name>_NUM_VARIABLE	Store numeric type variable value.
	CSCBP_<Cluster name>_BOOL_VARIABLE	Store boolean type variable value.
	CSCBP_<Cluster name>_MSG_VARIABLE	Store message type variable value (XML, non-XML, any).
Message history correlated information table	CSCBP_<Cluster name>_MSG_RELATION	Store correlated information of message ID and process instance identifier or activity instance identification number.

While designing a database, see all types of database manuals and estimate contents on the basis of the following information:

(a) Table and index definitions

For details on table and index definitions, see "Appendix C.1 Table information about process instance execution log management".

(b) Estimation methods of number of records

Calculate estimation of the number of records for each table as follows:

• CSCBP_<Cluster name>_PROCESS table
  

• CSCBP_<Cluster name>_ACTIVITY table
  

  Number of activities={Number of activity definitions in business process definition

  +Number of activity definitions in repeat activities

  x (Repeat activity loop frequency-1)}

  x Number of processes

• CSCBP_<Cluster name>_LINK table
  

  Number of links={Number of link definitions in business process definition

  +Number of link definitions in repeat activities

  x (Repeat activity loop frequency-1)}

  x Number of processes

• CSCBP_<Cluster name>_CORRELATION-SET table
  

• CSCBP_<Cluster name>_STR_VARIABLE table
  

• CSCBP_<Cluster name>_NUM_VARIABLE table
  

• CSCBP_<Cluster name>_BOOL_VARIABLE table
  

• CSCBP_<Cluster name>_MSG_VARIABLE table
  

• CSCBP_<Cluster name>_MSG_RELATION table
  

  Number of messages sent and received=Number of reception activity definitions

  + Number of invoke service activity definitions

(c) All types of index estimation methods

All types of index estimation methods are derived from index definitions and the number of records. For estimation methods, see the used database manual.

The following table describes the list of database tables related to execution environment settings:

Table 2-11 TableList of database tables related to execution environment settings

Classification	Table name	Description
Basic HCSC information table	CSCMSG_S<HCSC server name>_CSC_PERSIST	HCSC server status persists.
HCSC linkage directory information table	CSCMSG_C<Cluster name>_CSC_CONNECT	This table is not used.
Location directory information table	CSCMSG_S<HCSC server name>_LC_DIRECTORY	Store location information of service adapter, business process and service group.
	CSCMSG_S<HCSC server name>_LC_BPFORMAT	Store business process format information.
Routing rules directory information table	CSCMSG_S<HCSC server name>_RT_RULE	Store rule information for service routing.
Directory information table for data transformation definition	CSCMSG_S<HCSC server name>_CV_MAPPING	Store data transformation definition information.
	CSCMSG_S<HCSC server name>_CV_FORMAT	Store message format definition information for data transformation.
Basic cluster information table	CSCMSG_C<Cluster name>_CLUSTER	Store set up HCSC server name.
Management table of asynchronous adapter service ID	CSCMSG_C<Cluster name>_HA_ASYNC_ADP	Store deployed asynchronous adapter service ID.

While designing a database, see all types of database manuals and estimate contents on the basis of the following information:

• Table and index definitions
• Estimation methods of number of records
• All types of index estimation methods

(a) Table and index definitions

For details on table and index definitions, see "Appendix C.3 Table information about execution environment setup".

(b) Estimation methods of number of records

Calculation of the number of records for each table as follows:

• CSCMSG_S<HCSC server name>_CSC_PERSIST table
  

• CSCMSG_C<Cluster name>_CSC_CONNECT table
  

• CSCMSG_S<HCSC server name>_LC_DIRECTORY table
  

• CSCMSG_S<HCSC server name >_LC_BPFORMAT table
  

• CSCMSG_S<HCSC server name>_RT_RULE table
  

• CSCMSG_S<HCSC server name>_CV_MAPPING table
  

• CSCMSG_S<HCSC server name>_CV_FORMAT table
  

• CSCMSG_C<Cluster name>_CLUSTER table
  

• CSCMSG_C<Cluster name>_HA_ASYNC_ADP table
  

(c) All types of index estimation methods

All types of index estimation methods are derived from index definitions and the number of records. For estimation methods, see the used database manual.