Alert Table

The [Alert] table holds holds alerts generated by BOLOs.

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.