Difference between revisions of "InvestigatorAction Table"
Jump to navigation
Jump to search
(Created page with "The <code>[InvestigatorAction]</code> table holds information about what someone did while using the Analyst Desktop. <source lang="SQL"> CREATE TABLE "InvestigatorAction" (...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
The <code>[InvestigatorAction]</code> table holds information about what someone did while using the Analyst Desktop. | The <code>[InvestigatorAction]</code> table holds information about what someone did while using the Analyst Desktop. | ||
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "InvestigatorAction" ( | CREATE TABLE "InvestigatorAction" ( | ||
| Line 14: | Line 15: | ||
The <code><nowiki>[</nowiki>State<nowiki>]</nowiki></code> column allows applications to store some information about the event. | The <code><nowiki>[</nowiki>State<nowiki>]</nowiki></code> column allows applications to store some information about the event. | ||
It is rarely used. | It is rarely used. | ||
| + | |||
| + | =Columns= | ||
| + | ==<code>ID</code>== | ||
| + | The globally unique identifier for this record. | ||
| + | |||
| + | ==<code>InvestigationID</code>== | ||
| + | The globally unique identifier of investigation the investigator was working on. This corresponds to the <code>[ID]</code> column of the <code>[Investigation]</code> table. | ||
| + | |||
| + | ==<code>InvestigatorID</code>== | ||
| + | The globally unique identifier of the investigator that performed an action. This corresponds to the <code>[ID]</code> column of the <code>[Investigator]</code> table. | ||
| + | |||
| + | ==<code>When</code>== | ||
| + | When the action took place. | ||
| + | |||
| + | ==<code>Message</code>== | ||
| + | A description of what took place. | ||
| + | |||
| + | ==<code>State</code>== | ||
| + | A column where applications can store their state when the action occurred. | ||
Latest revision as of 07:25, 3 February 2024
The [InvestigatorAction] table holds information about what someone did while using the Analyst Desktop.
Contents
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.
