Content Table

The [Content] table holds information about the location of contents.

SQL

CREATE TABLE "Content" (
    "Hash" uuid NOT NULL,
    "DepotID" uuid NOT NULL,
    "Offset" bigint DEFAULT 0 NOT NULL,
    "Length" bigint DEFAULT 0 NOT NULL,
    "IsContainer" boolean DEFAULT false NOT NULL,
    "IsResident" boolean DEFAULT false NOT NULL
);

Columns

Hash

The hash of the contents of the file.

DepotID

The globally unique identifier for the depot that hold this content. This corresponds to the ID column of the [Depot] table.

Offset

The offset into the depot where this content begins.

Length

The number of bytes in this content.

IsContainer

True if this content blob contains other content blobs contiguously.

IsResident

True if this content exists contiguously within another content.