Free Table
This table holds information about the unused space on a piece of media.
Contents
SQL
CREATE TABLE "Free" (
"ID" uuid NOT NULL,
"MediaID" uuid NOT NULL,
"MediaOffset" bigint DEFAULT 0 NOT NULL,
"DepotID" uuid NOT NULL,
"Offset" bigint DEFAULT 0 NOT NULL,
"Length" bigint DEFAULT 0 NOT NULL,
"EndingOffset" bigint DEFAULT 0 NOT NULL,
"FileID" uuid NOT NULL
);
Columns
ID
The globally unique identifier for this chunk of free space.
MediaID
The globally unique identifier of the media from whence this free space chunk came.
This corresponds to the [ID]
column of the [Media]
table.
MediaOffset
The offset into the media where this free space chunk began.
DepotID
The globally unique identifier for the depot where the free space is stored.
This corresponds to the [ID]
column of the [Depot]
table.
Offset
The offset into the depot file where this chunk of free space begins.
Length
The number of bytes in this free space chunk.
EndingOffset
The last valid depot offset of the data in this block. It should be equal to [Offset]
+ [Length]
- 1.
FileID
The globally unique identifier of the file this free space came from.
This happens when disk image files are found in loaded Media.
This corresponds to the [ID]
column of the [File]
table.