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