BOLO Table

The [BOLO] table holds alerts generated by BOLOs. BOLO means Be On the Look Out.

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.