Difference between revisions of "FileType Table"
| 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. | ||
Revision as of 12:33, 24 January 2024
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 primarily from the constants defined in the filetypes.txt file.
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.
