Difference between revisions of "Entity Table"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
<source lang="SQL"> | <source lang="SQL"> | ||
| − | CREATE TABLE "Entity" ( | + | CREATE TABLE "Entity" |
| − | + | ( | |
| − | + | "ID" uuid NOT NULL, | |
| − | + | "MediaID" uuid NOT NULL, | |
| − | + | "FileID" uuid NOT NULL, | |
| − | + | "EntityTypeID" smallint NOT NULL, | |
| − | + | "EntityStringID" uuid NOT NULL, | |
| − | + | "Offset" bigint DEFAULT (-1) NOT NULL, | |
| − | + | "ObjectID" uuid NOT NULL, | |
| − | + | "ObjectTypeID" smallint DEFAULT 0 NOT NULL, | |
| − | + | "Length" bigint DEFAULT 0 NOT NULL, | |
| + | "DataTypeID" int NOT NULL | ||
); | ); | ||
</source> | </source> | ||
Revision as of 08:51, 8 December 2020
The [Entity] table holds information gleaned from exploited media.
CREATE TABLE "Entity"
(
"ID" uuid NOT NULL,
"MediaID" uuid NOT NULL,
"FileID" uuid NOT NULL,
"EntityTypeID" smallint NOT NULL,
"EntityStringID" uuid NOT NULL,
"Offset" bigint DEFAULT (-1) NOT NULL,
"ObjectID" uuid NOT NULL,
"ObjectTypeID" smallint DEFAULT 0 NOT NULL,
"Length" bigint DEFAULT 0 NOT NULL,
"DataTypeID" int NOT NULL
);
