Difference between revisions of "BOLO Table"
Jump to navigation
Jump to search
(Created page with "The <code>[BOLO]</code> table holds information gleaned from exploited media. <source lang="SQL"> CREATE TABLE "BOLO" ( "ID" uuid NOT NULL, "Criteria" text DEFAULT ''::te...") |
|||
| Line 1: | Line 1: | ||
| − | The <code>[BOLO]</code> table holds | + | The <code>[BOLO]</code> table holds alerts generated by BOLOs. |
| + | BOLO means Be On the Look Out. | ||
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "BOLO" ( | CREATE TABLE "BOLO" ( | ||
| Line 11: | 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 05:57, 29 January 2024
The [BOLO] table holds alerts generated by BOLOs.
BOLO means Be On the Look Out.
Contents
SQL
CREATE TABLE "BOLO" (
"ID" uuid NOT NULL,
"Criteria" text DEFAULT ''::text NOT NULL,
"BOLOStatusID" int NOT NULL,
"NumberOfHits" int NOT NULL,
"InvestigatorID" uuid NOT NULL,
"Added" 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.
