Indexes in EM logging tables include a:
Primary key index on the joined timestamp and sequence number columns.
Secondary key index on the joined timestamp_utc and sequence number columns.
Secondary index on the timestamp alone.
Secondary index on the timestamp_utc alone.
If you have selected the project name table attribute, the primary key index also includes the project name column.
The primary key includes an MSEC column, if milliseconds is enabled.
Columns and rows in EM logging tables are as follows.
Column Name |
Data Type |
Description |
Constant fields |
|
|
timestamp |
date/time |
Timestamp of the logging event. |
timestamp_utc |
date/time |
UTC timestamp of the logging event. |
sequence_number |
number |
Identity column to ensure uniqueness. |
time |
string |
|
event_type |
string |
The type of Event Manager event associated with the event source. |
event_source |
string |
Identifier that triggered the event. |
action_type |
string |
The type of Event Manager action associated with the action source. |
action_target |
string |
Identifier of the action's target. |
|
|
|
Optional fields |
|
|
project |
string |
Name of the CIMPLICITY project. |
msec |
number |
Actual number of milliseconds in the timestamp. |
Event Management logging. |