Sam: Created page with "The `[Media]` table holds information about the Media that was loaded. =SQL= CREATE TABLE "Media" ( "ID" uuid NOT NULL, "Name" text DEF..."

2024-02-03T11:15:10Z

Created page with "The <code>[Media]</code> table holds information about the Media that was loaded. =SQL= <source lang="SQL"> CREATE TABLE "Media" ( "ID" uuid NOT NULL, "Name" text DEF..."

New page

The <code>[Media]</code> table holds information about the Media that was loaded.

=SQL=
<source lang="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
);
</source>

=Columns=
==<code>ID</code>==
The globally unique identifier for this piece of Media.

==<code>Name</code>==
The name of this media.

==<code>Description</code>==
The long description of this media.

==<code>MediaTypeID</code>==
A field that represents the type of Media. Captured media, analyst notes, etc.
It corresponds to the <code>[ID]</code> column of the <code>[MediaType]</code> table.
It should contain one of [[Media_Types|these]] values.

==<code>Latitude</code>==
The [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] latitude portion of the GPS coordinates of where this piece of media was taken into custody.

==<code>Longitude</code>==
The [https://en.wikipedia.org/wiki/World_Geodetic_System#WGS84 WGS84] longitude portion of the GPS coordinates of where this piece of media was taken into custody.

==<code>CaseNumber</code>==
An identifier that has meaning to you.

==<code>Size</code>==
The number of bytes in the media before loading begins.

==<code>MediaStatusID</code>==
The identifier of the status of the media.
It corresponds to the <code>[ID]</code> column of the <code>[MediaStatus]</code> table.
It should contain one of [[Media_Status|these]] values.

==<code>Created</code>==
When this record was created.

==<code>CalculatedID</code>==
This value is calculated from the contents of the media if possible.
It is used to detect identical pieces of media.

==<code>Originator</code>==
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.

==<code>PercentComplete</code>==
The percentage of media that has been loaded.

==<code>EvidenceBag</code>==
The label on the evidence bag where this media came from.
This will be blank if one does not exist.

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

==<code>LastUpdated</code>==
When the status of this media last changed.

==<code>Expires</code>==
When Truxton will automatically purge this media.
When this date is reached, Truxton will delete the media without human intervention.

Media Table - Revision history

Sam: Created page with "The [Media] table holds information about the Media that was loaded. =SQL= CREATE TABLE "Media" ( "ID" uuid NOT NULL, "Name" text DEF..."

Sam: Created page with "The `[Media]` table holds information about the Media that was loaded. =SQL= CREATE TABLE "Media" ( "ID" uuid NOT NULL, "Name" text DEF..."