CIMPLICITYIndexes and Columns in COR_LOG Tables
Indexes in COR_LOG tables include the following:
- A primary key index in the joined timestamp_utc and sequence number columns.
- A secondary key index in the joined timestamp and sequence number columns.
- A secondary index in the timestamp_utc alone. This is the clustered index for the table.
The columns and rows in COR_LOG tables are as follows:
| Column Name | Data Type | Description |
|---|---|---|
| timestamp | datetime | Timestamp of the logging event. |
| timestamp_utc | datetime | UTC timestamp of the logging event. |
| sequence_number | number | Identity column to ensure uniqueness. |
| date_time | datetime | Date/Time field in Status Log. |
| project | varchar(21) | Name of the project from where this Status Log record originated. |
| severity | int | Severity field in the Status Log. |
| pid | int | Process id of the process logging the Status record. |
| process | varchar(33) | Process field in the Status Log. |
| procedure | varchar(33) | Procedure field in the Status Log. |
| status | int | Status field in the Status Log. |
| reference | int | Reference field in the Status Log. |
| code | int | Code field in the Status Log. |
| source | varchar(21) | Source field in the Status Log. |
| message | varchar(1024) | Message field in the Status Log. |
