File Table - Revision history

Sam: /* Columns */

2024-02-03T11:23:36Z

Columns

Sam: /* ContentStatusID */

2024-02-03T11:18:05Z

ContentStatusID

Sam: /* MediaID */

2024-02-03T11:17:42Z

MediaID

Sam: /* ContentStatusID */

2024-01-29T10:03:26Z

ContentStatusID

Sam: /* OriginID */

2024-01-29T10:02:32Z

OriginID

Sam at 16:24, 24 January 2024

2024-01-24T16:24:44Z

Sam at 12:53, 8 December 2020

2020-12-08T12:53:10Z

Sam at 18:58, 3 November 2020

2020-11-03T18:58:27Z

Sam: Created page with "The `File` table holds the meta data information about a file. CREATE TABLE "File" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU..."

2020-05-21T17:42:02Z

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

New page

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

@@ Line 31: / Line 31: @@
 ==<code>MediaID</code>==
-The globally unique identifier of the Media this file came from. It corresponds to the ID column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
+The globally unique identifier of the Media this file came from.
 ==<code>ParentFileID</code>==
-The globally unique identifier that is the parent of this file. This corresponds to the ID column of the <code>[File]</code> table.
+The globally unique identifier that is the parent of this file.
 ==<code>Attributes</code>==
@@ Line 40: / Line 42: @@
 ==<code>RawEntropy</code>==
-The [https://en.wikipedia.org/wiki/Entropy_(information_theory) Shannon's Raw Entropy] value representing the roughness of the data contained in the file's contents.;
+The [https://en.wikipedia.org/wiki/Entropy_(information_theory) Shannon's Raw Entropy] value representing the roughness of the data contained in the file's contents.
 ==<code>OSLength</code>==
@@ Line 53: / Line 55: @@
 ==<code>OriginID</code>==
 Where this file came from. Normal, Deleted, Carved, etc.
-It corresponds to the <code>ID</code> column of the <code>[Origin]</code> table.
+It corresponds to the <code>[ID]</code> column of the <code>[Origin]</code> table.
 It should contain one of [[Origin|these]] values.
@@ Line 72: / Line 74: @@
 ==<code>FilenameID</code>==
-Links the name of this file to a record in the Filename table with this <code>ID</code> value. It corresponds to the <code>ID</code> column of the <code>[Filename]</code> table.
+Links the name of this file to a record in the Filename table with this <code>[ID]</code> value.
 ==<code>FileTypeID</code>==
-The type of the file. This column corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[FileType Table|FileType]]<nowiki>]</nowiki></code> table.
+The type of the file.
 ==<code>PhysicalDiskOffset</code>==
@@ Line 81: / Line 85: @@
 ==<code>NumberOfChildren</code>==
-This field is greater than zero if there are other records whose <code>ParentFileID</code> matches this record's <code>ID</code> field.
+This field is greater than zero if there are other records whose <code>[ParentFileID]</code> matches this record's <code>[ID]</code> field.
 ==<code>FullPathID</code>==
-Links the full path of this file to a record in the Filename table with this ID value. It corresponds to the <code>ID</code> column of the <code>[Filename]</code> table.
+Links the full path of this file to a record in the <code>[Filename]</code> table with this <code>[ID]</code> value.

@@ Line 58: / Line 58: @@
 ==<code>ContentStatusID</code>==
 The identifier of the content status.
-This corresponds to the <code>ID</code> column of the <code>[ContentStatus]</code> table.
+This corresponds to the <code>[ID]</code> column of the <code>[ContentStatus]</code> table.
 - Unknown, 1 - Original (present), 4 - eliminated by hash, 5 - duplicate eliminated.
 It should contain one of [[Content_Status|these]] values.

@@ Line 31: / Line 31: @@
 ==<code>MediaID</code>==
-The globally unique identifier of the Media this file came from. It corresponds to the ID column of the <code>[Media]</code> table.
+The globally unique identifier of the Media this file came from. It corresponds to the ID column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
 ==<code>ParentFileID</code>==

@@ Line 57: / Line 57: @@
 ==<code>ContentStatusID</code>==
-The identifier of the content status. This corresponds to the <code>ID</code> column of the <code>[ContentStatus]</code> table. 0 - Unknown, 1 - Original (present), 4 - eliminated by hash, 5 - duplicate eliminated.
+The identifier of the content status.
 ==<code>Created</code>==

@@ Line 52: / Line 52: @@
 ==<code>OriginID</code>==
-Where this file came from. Normal, Deleted, Carved, etc. It corresponds to the <code>ID</code> column of the <code>[Origin]</code> table.
+Where this file came from. Normal, Deleted, Carved, etc.
 ==<code>ContentStatusID</code>==

@@ Line 1: / Line 1: @@
 The <code>[File]</code> table holds the meta data information about a file.
 <source lang="SQL">
 CREATE TABLE "File"
@@ Line 24: / Line 25: @@
 );
 </source>

@@ Line 2: / Line 2: @@
 <source lang="SQL">
-CREATE TABLE "File" (
+CREATE TABLE "File"
-    "ID" uuid NOT NULL,
-    "MediaID" uuid NOT NULL,
+  "ID" uuid NOT NULL,
-    "ParentFileID" uuid NOT NULL,
+  "MediaID" uuid NOT NULL,
-    "Attributes" integer DEFAULT 0 NOT NULL,
+  "ParentFileID" uuid NOT NULL,
-    "RawEntropy" smallint DEFAULT 0 NOT NULL,
+  "Attributes" integer DEFAULT 0 NOT NULL,
-    "OSLength" bigint DEFAULT 0 NOT NULL,
+  "RawEntropy" smallint DEFAULT 0 NOT NULL,
-    "HashID" uuid NOT NULL,
+  "OSLength" bigint DEFAULT 0 NOT NULL,
-    "Signature" integer DEFAULT 0 NOT NULL,
+  "HashID" uuid NOT NULL,
-    "OriginID" smallint DEFAULT 0 NOT NULL,
+  "Signature" integer DEFAULT 0 NOT NULL,
-    "ContentStatusID" smallint DEFAULT 0 NOT NULL,
+  "OriginID" smallint DEFAULT 0 NOT NULL,
-    "Created" timestamp without time zone NOT NULL,
+  "ContentStatusID" smallint DEFAULT 0 NOT NULL,
-    "LastAccess" timestamp without time zone NOT NULL,
+  "Created" timestamp without time zone NOT NULL,
-    "LastWrite" timestamp without time zone NOT NULL,
+  "LastAccess" timestamp without time zone NOT NULL,
-    "FilenameID" bigint DEFAULT 0 NOT NULL,
+  "LastWrite" timestamp without time zone NOT NULL,
-    "FileTypeID" smallint DEFAULT 0 NOT NULL,
+  "FilenameID" bigint DEFAULT 0 NOT NULL,
-    "PhysicalDiskOffset" bigint DEFAULT 0 NOT NULL,
+  "FileTypeID" smallint DEFAULT 0 NOT NULL,
-    "NumberOfChildren" integer DEFAULT 0 NOT NULL,
+  "PhysicalDiskOffset" bigint DEFAULT 0 NOT NULL,
-    "FullPathID" bigint DEFAULT 0 NOT NULL
+  "NumberOfChildren" integer DEFAULT 0 NOT NULL,
 );
 </source>

File Table - Revision history

Sam: /* Columns */

Sam: /* ContentStatusID */

Sam: /* MediaID */

Sam: /* ContentStatusID */

Sam: /* OriginID */

Sam at 16:24, 24 January 2024

Sam at 12:53, 8 December 2020

Sam at 18:58, 3 November 2020

Sam: Created page with "The File table holds the meta data information about a file. CREATE TABLE "File" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU..."

Sam: Created page with "The `File` table holds the meta data information about a file. CREATE TABLE "File" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NU..."