Entity Table - Revision history

Sam at 14:12, 3 April 2024

2024-04-03T14:12:49Z

Sam: /* EntityStringID */

2024-02-03T11:19:03Z

EntityStringID

Sam: /* MediaID */

2024-02-03T11:18:50Z

MediaID

Sam at 10:42, 25 January 2024

2024-01-25T10:42:54Z

Sam at 12:51, 8 December 2020

2020-12-08T12:51:07Z

Sam at 12:50, 8 December 2020

2020-12-08T12:50:11Z

Sam at 13:12, 8 November 2020

2020-11-08T13:12:31Z

Sam: Created page with "The `Entity` table holds information gleaned from exploited media. CREATE TABLE "Entity" ( "ID" uuid NOT NULL, "MediaID" uuid..."

2020-05-21T17:41:19Z

Created page with "The <code>Entity</code> table holds information gleaned from exploited media. <syntaxhighlight lang="SQL"> CREATE TABLE "Entity" ( "ID" uuid NOT NULL, "MediaID" uuid..."

New page

The <code>Entity</code> table holds information gleaned from exploited media.

<syntaxhighlight lang="SQL">
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
);
</syntaxhighlight>

← Older revision		Revision as of 14:12, 3 April 2024
Line 1:		Line 1:
−	The <code>[Entity]</code> table holds information gleaned from exploited media.	+	The <code>[Entity]</code> table holds artifact information gleaned from exploited media.

	=SQL=		=SQL=

@@ Line 34: / Line 34: @@
 ==<code>EntityStringID</code>==
-The identifier of the string representation of the entity. This corresponds to the <code>ID</code> column of the <code>[EntityString]</code> table.
+The identifier of the string representation of the entity. This corresponds to the <code>[ID]</code> column of the <code>[EntityString]</code> table.
 ==<code>Offset</code>==

@@ Line 23: / Line 23: @@
 ==<code>MediaID</code>==
-The ID of the media from whence this entity came. This corresponds to the <code>ID</code> column of the <code>[Media]</code> table.
+The ID of the media from whence this entity came. This corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
 ==<code>FileID</code>==

@@ Line 1: / Line 1: @@
 The <code>[Entity]</code> table holds information gleaned from exploited media.
 <source lang="SQL">
 CREATE TABLE "Entity"
@@ Line 16: / Line 17: @@
 );
 </source>

← Older revision		Revision as of 13:12, 8 November 2020
Line 1:		Line 1:
−	The <code>Entity</code> table holds information gleaned from exploited media.	+	The <code>[Entity]</code> table holds information gleaned from exploited media.

	<syntaxhighlight lang="SQL">		<syntaxhighlight lang="SQL">

@@ Line 2: / Line 2: @@
 <source lang="SQL">
-CREATE TABLE "Entity" (
+CREATE TABLE "Entity"
-    "ID" uuid NOT NULL,
-    "MediaID" uuid NOT NULL,
+  "ID" uuid NOT NULL,
-    "FileID" uuid NOT NULL,
+  "MediaID" uuid NOT NULL,
-    "EntityTypeID" smallint NOT NULL,
+  "FileID" uuid NOT NULL,
-    "EntityStringID" uuid NOT NULL,
+  "EntityTypeID" smallint NOT NULL,
-    "Offset" bigint DEFAULT (-1) NOT NULL,
+  "EntityStringID" uuid NOT NULL,
-    "ObjectID" uuid NOT NULL,
+  "Offset" bigint DEFAULT (-1) NOT NULL,
-    "ObjectTypeID" smallint DEFAULT 0 NOT NULL,
+  "ObjectID" uuid NOT NULL,
-    "Length" bigint DEFAULT 0 NOT NULL,
+  "ObjectTypeID" smallint DEFAULT 0 NOT NULL,
-    "DataTypeID" int NOT NULL
+  "Length" bigint DEFAULT 0 NOT NULL,
 );
 </source>