Alert Table

The [Alert] table holds information gleaned from exploited media.

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
);