Depot Table - Revision history

Sam: /* DepotStatusID */

2026-01-15T23:44:34Z

DepotStatusID

Sam: /* DepotTypeID */

2026-01-15T23:44:19Z

DepotTypeID

Sam: /* DepotStatusID */

2024-01-25T11:04:53Z

DepotStatusID

Sam: /* DepotTypeID */

2024-01-25T10:46:05Z

DepotTypeID

Sam at 10:31, 25 January 2024

2024-01-25T10:31:16Z

Sam: Created page with "The `[Depot]` table holds information about the location of depots. CREATE TABLE "Depot" ( "ID" uuid NOT NULL, "Filename" text DEFAULT ''::..."

2023-02-20T12:43:40Z

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 ''::..."

New page

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 ''::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
);
</source>

@@ Line 46: / Line 46: @@
 ==<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.
+This corresponds to the <code>[ID]</code> column of the <code>[DepotStatus]</code> table.
 It should contain one of [[Depot_Status|these]] values.

@@ Line 29: / Line 29: @@
 ==<code>DepotTypeID</code>==
 The ID of the type of depot.
-This corresponds to the <code>ID</code> column of the <code>[DepotType]</code> table.
+This corresponds to the <code>[ID]</code> column of the <code>[DepotType]</code> table.
 It should contain one of [[Depot_Types|these]] values.

← Older revision		Revision as of 11:04, 25 January 2024
Line 45:		Line 45:

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

@@ Line 28: / Line 28: @@
 ==<code>DepotTypeID</code>==
-The ID of the type of depot. This corresponds to the <code>ID</code> column of the <code>[DepotType]</code> table.
+The ID of the type of depot.
 ==<code>MaximumSize</code>==

@@ Line 1: / Line 1: @@
 The <code>[Depot]</code> table holds information about the location of depots.
 <source lang="SQL">
 CREATE TABLE "Depot" (
@@ Line 14: / Line 16: @@
 );
 </source>

Depot Table - Revision history

Sam: /* DepotStatusID */

Sam: /* DepotTypeID */

Sam: /* DepotStatusID */

Sam: /* DepotTypeID */

Sam at 10:31, 25 January 2024

Sam: Created page with "The [Depot] table holds information about the location of depots. CREATE TABLE "Depot" ( "ID" uuid NOT NULL, "Filename" text DEFAULT ''::..."

Sam: Created page with "The `[Depot]` table holds information about the location of depots. CREATE TABLE "Depot" ( "ID" uuid NOT NULL, "Filename" text DEFAULT ''::..."