FileType Table - Revision history

Sam: /* ParentFileTypeID */

2025-12-18T14:57:15Z

ParentFileTypeID

Sam: /* ID */

2024-08-29T11:19:25Z

Sam at 16:33, 24 January 2024

2024-01-24T16:33:05Z

Sam at 16:29, 24 January 2024

2024-01-24T16:29:16Z

Sam: Created page with "The `[FileType]` table holds the information about a type of file. CREATE TABLE "FileType" ( "ID" smallint DEFAULT 0 NOT NULL, "ShortName"..."

2023-02-20T16:04:58Z

Created page with "The <code>[FileType]</code> table holds the information about a type of file. <source lang="SQL"> CREATE TABLE "FileType" ( "ID" smallint DEFAULT 0 NOT NULL, "ShortName"..."

New page

The <code>[FileType]</code> table holds the information about a type of file.

<source lang="SQL">
CREATE TABLE "FileType" (
"ID" smallint DEFAULT 0 NOT NULL,
"ShortName" text DEFAULT ''::text NOT NULL,
"LongName" text DEFAULT ''::text NOT NULL,
"Extension" text DEFAULT ''::text NOT NULL,
"MIME" text DEFAULT ''::text NOT NULL,
"ParentFileTypeID" smallint DEFAULT 0 NOT NULL,
"Carve" boolean DEFAULT false NOT NULL,
"Capabilities" text DEFAULT ''::text NOT NULL,
"Details" text DEFAULT ''::text NOT NULL,
"MinimumCarveFileSize" bigint DEFAULT 0 NOT NULL,
"MaximumCarveFileSize" bigint DEFAULT 0 NOT NULL,
"AverageFileSize" bigint DEFAULT 0 NOT NULL
);
</source>

@@ Line 37: / Line 37: @@
 ==<code>ParentFileTypeID</code>==
-The more primitive type of this file. For example, XML is the parent type of KML.
+The more primitive type of this file. For example, [[Type_XML|XML]] is the parent type of [[Type_KML|KML]].
 ==<code>Carve</code>==

@@ Line 21: / Line 21: @@
 =Columns=
 ==<code>ID</code>==
-The identifier for this type. These values come primarily from the constants defined in the filetypes.txt file.
+The identifier for this type.
 ==<code>ShortName</code>==

← Older revision		Revision as of 16:33, 24 January 2024
Line 18:		Line 18:
	);		);
	</source>		</source>
		+
		+	=Columns=
		+	==<code>ID</code>==
		+	The identifier for this type. These values come primarily from the constants defined in the filetypes.txt file.
		+
		+	==<code>ShortName</code>==
		+	The short name for this type of file.
		+
		+	==<code>LongName</code>==
		+	The long name or description of this type of file.
		+
		+	==<code>Extension</code>==
		+	The file name extension normally associated with this type of file.
		+
		+	==<code>MIME</code>==
		+	The MIME type associated with this type of file.
		+
		+	==<code>ParentFileTypeID</code>==
		+	The more primitive type of this file. For example, XML is the parent type of KML.
		+
		+	==<code>Carve</code>==
		+	True if Truxton can carve this type of file out of free space.
		+
		+	==<code>Capabilities</code>==
		+	What Truxton can do with this file.
		+
		+	==<code>Details</code>==
		+	Where you can find details about this file format.
		+
		+	==<code>MinimumCarveFileSize</code>==
		+	When carving for files of this type, this is the smallest valid length of the file.
		+
		+	==<code>MaximumCarveFileSize</code>==
		+	When carving for files of this type, this is the largest valid length of the file.
		+
		+	==<code>AverageFileSize</code>==
		+	This is the average length of a file of this type.