This section describes the schema for Process tables. Business Process Server stores process templates, process instances, worksteps, workitems, and metadata information in a set of relational database tables.
Business Process Server uses a sequence generator to generate IDs for PROCESSTEMPLATE, PROCESSINSTANCE, and WORKITEM. For every sequence (for example, processinstance sequence), the BP Server stores 100 numbers in memory cache in order to avoid excessive database access. If the user stops the BP Server using CTRL+C, then all the cached numbers are lost, causing a gap among the IDs.
