Difference between revisions of "Depot Table"
Jump to navigation
Jump to search
(Created page with "The <code>[Depot]</code> table holds information about the location of depots. <source lang="SQL"> CREATE TABLE "Depot" ( "ID" uuid NOT NULL, "Filename" text DEFAULT ''::...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The <code>[Depot]</code> table holds information about the location of depots. | The <code>[Depot]</code> table holds information about the location of depots. | ||
| + | The Depot is where file contents are stored. | ||
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "Depot" ( | CREATE TABLE "Depot" ( | ||
| Line 14: | Line 16: | ||
); | ); | ||
</source> | </source> | ||
| + | |||
| + | =Columns= | ||
| + | ==<code>ID</code>== | ||
| + | The globally unique identifier for this Depot. | ||
| + | |||
| + | ==<code>Filename</code>== | ||
| + | The name of the file. | ||
| + | |||
| + | ==<code>URI</code>== | ||
| + | The Uniform Resource Identifier of the Depot file. | ||
| + | |||
| + | ==<code>DepotTypeID</code>== | ||
| + | The ID of the type of depot. | ||
| + | This corresponds to the <code>[ID]</code> column of the <code>[DepotType]</code> table. | ||
| + | It should contain one of [[Depot_Types|these]] values. | ||
| + | |||
| + | ==<code>MaximumSize</code>== | ||
| + | The maximum size of the file in bytes. | ||
| + | |||
| + | ==<code>Size</code>== | ||
| + | The number of bytes in the depot. | ||
| + | |||
| + | ==<code>IsLongTerm</code>== | ||
| + | True if this depot is long term storage. | ||
| + | |||
| + | ==<code>CryptoKey</code>== | ||
| + | The key required to decrypt the contents of the depot. | ||
| + | |||
| + | ==<code>DepotStatusID</code>== | ||
| + | The ID of the status of the depot. | ||
| + | This corresponds to the <code>[ID]</code> column of the <code>[DepotStatus]</code> table. | ||
| + | It should contain one of [[Depot_Status|these]] values. | ||
Latest revision as of 19:44, 15 January 2026
The [Depot] table holds information about the location of depots.
The Depot is where file contents are stored.
Contents
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.
