File Table

The [File] table holds the meta data information about a file.

CREATE TABLE "File"
(
  "ID" uuid NOT NULL,
  "MediaID" uuid NOT NULL,
  "ParentFileID" uuid NOT NULL,
  "Attributes" integer DEFAULT 0 NOT NULL,
  "RawEntropy" smallint DEFAULT 0 NOT NULL,
  "OSLength" bigint DEFAULT 0 NOT NULL,
  "HashID" uuid NOT NULL,
  "Signature" integer DEFAULT 0 NOT NULL,
  "OriginID" smallint DEFAULT 0 NOT NULL,
  "ContentStatusID" smallint DEFAULT 0 NOT NULL,
  "Created" timestamp without time zone NOT NULL,
  "LastAccess" timestamp without time zone NOT NULL,
  "LastWrite" timestamp without time zone NOT NULL,
  "FilenameID" bigint DEFAULT 0 NOT NULL,
  "FileTypeID" smallint DEFAULT 0 NOT NULL,
  "PhysicalDiskOffset" bigint DEFAULT 0 NOT NULL,
  "NumberOfChildren" integer DEFAULT 0 NOT NULL,
  "FullPathID" bigint DEFAULT 0 NOT NULL
);