Difference between revisions of "Alert Table"
Jump to navigation
Jump to search
(Created page with "The <code>[Alert]</code> table holds information gleaned from exploited media. <source lang="SQL"> CREATE TABLE "Alert" ( "ID" uuid NOT NULL, "BOLOID" uuid NOT NULL, "F...") |
|||
| Line 1: | Line 1: | ||
| − | The <code>[Alert]</code> table holds | + | The <code>[Alert]</code> table holds holds alerts generated by BOLOs. |
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "Alert" ( | CREATE TABLE "Alert" ( | ||
| Line 12: | Line 13: | ||
); | ); | ||
</source> | </source> | ||
| + | |||
| + | =Columns= | ||
| + | ==<code>ID</code>== | ||
| + | The globally unique identifier for this alert. | ||
| + | ==<code>BOLOID</code>== | ||
| + | The BOLO that caused this Alert to be created. | ||
| + | This corresponds to the <code>ID</code> column of the <code>[BOLO]</code> table. | ||
| + | |||
| + | ==<code>FileID</code>== | ||
| + | The globally unique identifier of the File that contains the text of the alert. | ||
| + | This corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table. | ||
| + | |||
| + | ==<code>InvestigatorID</code>== | ||
| + | The globally unique identifier of the Investigator that owns the BOLO that generated this alert. | ||
| + | This corresponds to the <code>ID</code> column of the <code>[Investigator]</code> table. | ||
| + | |||
| + | ==<code>AlertStatusID</code>== | ||
| + | The status ID of this alert. This corresponds to the <code>ID</code> column of the <code>[AlertStatus]</code> table. | ||
| + | |||
| + | ==<code>Added</code>== | ||
| + | When this alert was added to the database. | ||
| + | |||
| + | ==<code>LastUpdate</code>== | ||
| + | When this alert record was last updated. | ||
Latest revision as of 06:11, 25 January 2024
The [Alert] table holds holds alerts generated by BOLOs.
Contents
SQL
CREATE TABLE "Alert" (
"ID" uuid NOT NULL,
"BOLOID" uuid NOT NULL,
"FileID" uuid NOT NULL,
"InvestigatorID" uuid NOT NULL,
"AlertStatusID" int NOT NULL,
"Added" timestamp with time zone DEFAULT clock_timestamp() NOT NULL,
"LastUpdate" timestamp with time zone DEFAULT clock_timestamp() NOT NULL
);
Columns
ID
The globally unique identifier for this alert.
BOLOID
The BOLO that caused this Alert to be created.
This corresponds to the ID column of the [BOLO] table.
FileID
The globally unique identifier of the File that contains the text of the alert.
This corresponds to the ID column of the [File] table.
InvestigatorID
The globally unique identifier of the Investigator that owns the BOLO that generated this alert.
This corresponds to the ID column of the [Investigator] table.
AlertStatusID
The status ID of this alert. This corresponds to the ID column of the [AlertStatus] table.
Added
When this alert was added to the database.
LastUpdate
When this alert record was last updated.
