InvestigatorAction Table

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

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.