SQL Profiling 2.0.3: Database Table Structure

The table structure in the database contains the following tables, which are described in more detail below:

Table	Description
`ProcessBeforeEvent`	Contains an entry for every process execution. This will be logged directly upon the start of the process.
`ProcessAfterEvent`	Will be logged when the process is finished. Will also be logged when the process finishes with an error.
`ProcessStepBeforeEvent`	Is the same as `ProcessBeforeEvent`, but for process steps. An entry will be created before the step is executed.
`ProcessStepAfterEvent`	When the step is finished, this table contains the corresponding information.

There are no foreign keys. .The relation of entries is done implicitly by the eventId column. ProcessBeforeEvent can be joined by the eventId into the ProcessAfterEvent. This also applies to ProcessStepBeforeEvent and ProcessStepAfterEvent. To get the relation between a process executions and its steps, the ProcessBeforeEvent table can be joined by the processid into the ProcessStepBeforeEvent/ProcessStepAfterEvent.