Difference between revisions of "Log Table"
| Line 19: | Line 19: | ||
==<code>MediaID</code>== | ==<code>MediaID</code>== | ||
The globally unique identifier for the Media this message belongs. | The globally unique identifier for the Media this message belongs. | ||
| − | This corresponds to the <code>ID</code> column of the <code>[Media]</code> table. | + | This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table. |
==<code>When</code>== | ==<code>When</code>== | ||
| Line 28: | Line 28: | ||
==<code>LogStringSourceID</code>== | ==<code>LogStringSourceID</code>== | ||
| − | The identifier for the source of the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table. | + | The identifier for the source of the message. |
| + | This corresponds to the <code>[ID]</code> column of the <code>[LogString]</code> table. | ||
==<code>ProcessID</code>== | ==<code>ProcessID</code>== | ||
| Line 34: | Line 35: | ||
==<code>ThreadID</code>== | ==<code>ThreadID</code>== | ||
| − | The identifier for the thread that generated the message. This comes from the operating system on the machine that generated the message. | + | The identifier for the thread that generated the message. |
| + | This comes from the operating system on the machine that generated the message. | ||
==<code>LogStringClientID</code>== | ==<code>LogStringClientID</code>== | ||
| − | The identifier of the client machine that generated the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table. | + | The identifier of the client machine that generated the message. |
| + | This corresponds to the <code>[ID]</code> column of the <code>[LogString]</code> table. | ||
==<code>LogStringUserID</code>== | ==<code>LogStringUserID</code>== | ||
| − | The identifier for the user that generated the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table. | + | The identifier for the user that generated the message. |
| + | This corresponds to the <code>[ID]</code> column of the <code>[LogString]</code> table. | ||
==<code>LogStringMessageID</code>== | ==<code>LogStringMessageID</code>== | ||
| − | The text of the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table. | + | The text of the message. |
| + | This corresponds to the <code>[ID]</code> column of the <code>[LogString]</code> table. | ||
Latest revision as of 07:28, 3 February 2024
This is where Truxton stores messages to be gathered to create the Load Log.
Contents
SQL
CREATE TABLE "Log" (
"MediaID" uuid NOT NULL,
"When" timestamp without time zone NOT NULL,
"LogStringTypeID" integer DEFAULT 0 NOT NULL,
"LogStringSourceID" bigint DEFAULT 0 NOT NULL,
"ProcessID" integer DEFAULT 0 NOT NULL,
"ThreadID" integer DEFAULT 0 NOT NULL,
"LogStringClientID" bigint DEFAULT 0 NOT NULL,
"LogStringUserID" bigint DEFAULT 0 NOT NULL,
"LogStringMessageID" bigint DEFAULT 0 NOT NULL
);
Columns
MediaID
The globally unique identifier for the Media this message belongs.
This corresponds to the [ID] column of the [Media] table.
When
When this message was generated. This time comes from the machine that generated the message, not the time on the database server when this message arrived.
LogStringTypeID
The type of message. Values are: 0 - Error, 1 - Warning, 2 - Information, 3 - Debug, 4 - Message Queue, 5 - Black Box, 6 - SQL
LogStringSourceID
The identifier for the source of the message.
This corresponds to the [ID] column of the [LogString] table.
ProcessID
The process identifier for the program that generated the log message.
ThreadID
The identifier for the thread that generated the message. This comes from the operating system on the machine that generated the message.
LogStringClientID
The identifier of the client machine that generated the message.
This corresponds to the [ID] column of the [LogString] table.
LogStringUserID
The identifier for the user that generated the message.
This corresponds to the [ID] column of the [LogString] table.
LogStringMessageID
The text of the message.
This corresponds to the [ID] column of the [LogString] table.
