Log Table

This is where Truxton stores messages to be gathered to create the Load Log.

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.