Difference between revisions of "File Table"
Jump to navigation
Jump to search
(Created page with "The <code>File</code> table holds the meta data information about a file. <syntaxhighlight lang="SQL"> CREATE TABLE "File" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU...") |
|||
| Line 1: | Line 1: | ||
| − | The <code>File</code> table holds the meta data information about a file. | + | The <code>[File]</code> table holds the meta data information about a file. |
| − | < | + | <source lang="SQL"> |
CREATE TABLE "File" ( | CREATE TABLE "File" ( | ||
"ID" uuid NOT NULL, | "ID" uuid NOT NULL, | ||
| Line 22: | Line 22: | ||
"FullPathID" bigint DEFAULT 0 NOT NULL | "FullPathID" bigint DEFAULT 0 NOT NULL | ||
); | ); | ||
| − | </ | + | </source> |
Revision as of 14:58, 3 November 2020
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
);
