Difference between revisions of "FileType Table"
(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"...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The <code>[FileType]</code> table holds the information about a type of file. | The <code>[FileType]</code> table holds the information about a type of file. | ||
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "FileType" ( | CREATE TABLE "FileType" ( | ||
| Line 17: | Line 18: | ||
); | ); | ||
</source> | </source> | ||
| + | |||
| + | =Columns= | ||
| + | ==<code>ID</code>== | ||
| + | The identifier for this type. | ||
| + | These values come from the Truxton development team. | ||
| + | |||
| + | ==<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, [[Type_XML|XML]] is the parent type of [[Type_KML|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. | ||
Latest revision as of 10:57, 18 December 2025
The [FileType] table holds the information about a type of file.
Contents
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
);
Columns
ID
The identifier for this type. These values come from the Truxton development team.
ShortName
The short name for this type of file.
LongName
The long name or description of this type of file.
Extension
The file name extension normally associated with this type of file.
MIME
The MIME type associated with this type of file.
ParentFileTypeID
The more primitive type of this file. For example, XML is the parent type of KML.
Carve
True if Truxton can carve this type of file out of free space.
Capabilities
What Truxton can do with this file.
Details
Where you can find details about this file format.
MinimumCarveFileSize
When carving for files of this type, this is the smallest valid length of the file.
MaximumCarveFileSize
When carving for files of this type, this is the largest valid length of the file.
AverageFileSize
This is the average length of a file of this type.
