Depot Table

The [Depot] table holds information about the location of depots. The Depot is where file contents are stored.

SQL

CREATE TABLE "Depot" (
  "ID" uuid NOT NULL,
  "Filename" text DEFAULT ''::text NOT NULL,
  "URI" text DEFAULT ''::text NOT NULL,
  "DepotTypeID" smallint DEFAULT 0 NOT NULL,
  "MaximumSize" bigint DEFAULT 0 NOT NULL,
  "Size" bigint DEFAULT 0 NOT NULL,
  "IsLongTerm" boolean DEFAULT false NOT NULL,
  "CryptoKey" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL,
  "DepotStatusID" smallint DEFAULT 0 NOT NULL
);

Columns

ID

The globally unique identifier for this Depot.

Filename

The name of the file.

URI

The Uniform Resource Identifier of the Depot file.

DepotTypeID

The ID of the type of depot. This corresponds to the [ID] column of the [DepotType] table. It should contain one of these values.

MaximumSize

The maximum size of the file in bytes.

Size

The number of bytes in the depot.

IsLongTerm

True if this depot is long term storage.

CryptoKey

The key required to decrypt the contents of the depot.

DepotStatusID

The ID of the status of the depot. This corresponds to the [ID] column of the [DepotStatus] table. It should contain one of these values.