Depot Table

From truxwiki.com
Revision as of 08:43, 20 February 2023 by Sam (talk | contribs) (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 ''::...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The [Depot] table holds information about the location of depots.

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
);