Difference between revisions of "Log Table"
(Created page with "This is where Truxton stores messages to be gathered to create the Load Log. <source lang="SQL"> CREATE TABLE "Log" ( "MediaID" uuid NOT NU...") |
|||
| Line 1: | Line 1: | ||
This is where Truxton stores messages to be gathered to [[Finished|create]] the [[Type_Load_Log|Load Log]]. | This is where Truxton stores messages to be gathered to [[Finished|create]] the [[Type_Load_Log|Load Log]]. | ||
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "Log" ( | CREATE TABLE "Log" ( | ||
| Line 14: | Line 15: | ||
); | ); | ||
</source> | </source> | ||
| + | |||
| + | =Columns= | ||
| + | ==<code>MediaID</code>== | ||
| + | The globally unique identifier for the Media this message belongs. | ||
| + | This corresponds to the <code>ID</code> column of the <code>[Media]</code> table. | ||
| + | |||
| + | ==<code>When</code>== | ||
| + | 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. | ||
| + | |||
| + | ==<code>LogStringTypeID</code>== | ||
| + | The type of message. Values are: 0 - Error, 1 - Warning, 2 - Information, 3 - Debug, 4 - Message Queue, 5 - Black Box, 6 - SQL | ||
| + | |||
| + | ==<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. | ||
| + | |||
| + | ==<code>ProcessID</code>== | ||
| + | The process identifier for the program that generated the log message. | ||
| + | |||
| + | ==<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. | ||
| + | |||
| + | ==<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. | ||
| + | |||
| + | ==<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. | ||
| + | |||
| + | ==<code>LogStringMessageID</code>== | ||
| + | The text of the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table. | ||
Revision as of 05:38, 27 January 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.
