FileType Table

The [FileType] table holds the information about a type of file.

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.