InvestigatorAction Table

The [InvestigatorAction] table holds information about what someone did while using the Analyst Desktop.

SQL

CREATE TABLE "InvestigatorAction" (
    "ID" uuid NOT NULL,
    "InvestigationID" uuid NOT NULL,
    "InvestigatorID" uuid NOT NULL,
    "When" timestamp without time zone DEFAULT (clock_timestamp() at time zone 'utc') NOT NULL,
    "Message" text DEFAULT ''::text NOT NULL,
    "State" text DEFAULT ''::text NOT NULL
);

The [State] column allows applications to store some information about the event. It is rarely used.

Columns

ID

The globally unique identifier for this record.

InvestigationID

The globally unique identifier of investigation the investigator was working on. This corresponds to the [ID] column of the [Investigation] table.

InvestigatorID

The globally unique identifier of the investigator that performed an action. This corresponds to the [ID] column of the [Investigator] table.

When

When the action took place.

Message

A description of what took place.

State

A column where applications can store their state when the action occurred.