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