Media Table

The [Media] table holds information about the Media that was loaded.

SQL

CREATE TABLE "Media" (
    "ID" uuid NOT NULL,
    "Name" text DEFAULT ''::text NOT NULL,
    "Description" text DEFAULT ''::text NOT NULL,
    "MediaTypeID" smallint DEFAULT 0 NOT NULL,
    "Latitude" double precision DEFAULT 0 NOT NULL,
    "Longitude" double precision DEFAULT 0 NOT NULL,
    "CaseNumber" text DEFAULT ''::text NOT NULL,
    "Size" bigint DEFAULT 0 NOT NULL,
    "MediaStatusID" smallint DEFAULT 0 NOT NULL,
    "Created" timestamp without time zone DEFAULT (clock_timestamp() at time zone 'utc') NOT NULL,
    "CalculatedID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL,
    "Originator" text DEFAULT ''::text NOT NULL,
    "PercentComplete" smallint DEFAULT 0 NOT NULL,
    "EvidenceBag" text DEFAULT ''::text,
    "LoadConfigurationID" integer DEFAULT 0 NOT NULL,
    "LastUpdated" timestamp without time zone DEFAULT (clock_timestamp() at time zone 'utc') NOT NULL,
    "Expires" timestamp without time zone DEFAULT (clock_timestamp() at time zone 'utc' + interval '99 years') NOT NULL
);

Columns

ID

The globally unique identifier for this piece of Media.

Name

The name of this media.

Description

The long description of this media.

MediaTypeID

A field that represents the type of Media. Captured media, analyst notes, etc. It corresponds to the [ID] column of the [MediaType] table. It should contain one of these values.

Latitude

The WGS84 latitude portion of the GPS coordinates of where this piece of media was taken into custody.

Longitude

The WGS84 longitude portion of the GPS coordinates of where this piece of media was taken into custody.

CaseNumber

An identifier that has meaning to you.

Size

The number of bytes in the media before loading begins.

MediaStatusID

The identifier of the status of the media. It corresponds to the [ID] column of the [MediaStatus] table. It should contain one of these values.

Created

When this record was created.

CalculatedID

This value is calculated from the contents of the media if possible. It is used to detect identical pieces of media.

Originator

The name of the organization or person who is responsible for this media. For example, if you are a regional center, this column would identify the originating organization that asked you to look at the media.

PercentComplete

The percentage of media that has been loaded.

EvidenceBag

The label on the evidence bag where this media came from. This will be blank if one does not exist.

LoadConfigurationID

The identification of the load configuration used to load data into this media. It corresponds to the [ID] column of the [LoadConfiguration] table. This is also known as Route identifier.

LastUpdated

When the status of this media last changed.

Expires

When Truxton will automatically purge this media. When this date is reached, Truxton will delete the media without human intervention.