Event Table - Revision history

Sam: /* EventTypeID */

2024-02-03T11:19:45Z

EventTypeID

Sam: /* MediaID */

2024-02-03T11:19:32Z

MediaID

Sam at 10:48, 25 January 2024

2024-01-25T10:48:11Z

Sam at 10:19, 25 January 2024

2024-01-25T10:19:54Z

Sam at 12:51, 8 December 2020

2020-12-08T12:51:36Z

Sam: Created page with "This table holds the different events that Truxton finds. CREATE TABLE "Event" ( "ID" uuid NOT NULL, "Start" timestamp without time zone..."

2020-05-21T17:48:35Z

Created page with "This table holds the different events that Truxton finds. <syntaxhighlight lang="SQL"> CREATE TABLE "Event" ( "ID" uuid NOT NULL, "Start" timestamp without time zone..."

New page

This table holds the different events that Truxton finds.

<syntaxhighlight lang="SQL">
CREATE TABLE "Event" (
"ID" uuid NOT NULL,
"Start" timestamp without time zone NOT NULL,
"End" timestamp without time zone NOT NULL,
"Title" text DEFAULT ''::text NOT NULL,
"Description" text DEFAULT ''::text NOT NULL,
"FileID" uuid NOT NULL,
"MediaID" uuid NOT NULL,
"EventTypeID" smallint DEFAULT 0 NOT NULL
);
</syntaxhighlight>

@@ Line 40: / Line 40: @@
 ==<code>EventTypeID</code>==
 The identifier of the type of event this is.
-This corresponds to the <code>ID</code> column of the <code>[EventType]</code> table.
+This corresponds to the <code>[ID]</code> column of the <code>[EventType]</code> table.
 It should contain one of [[Event_Types|these]] values.

@@ Line 36: / Line 36: @@
 ==<code>MediaID</code>==
-Corresponds to the <code>ID</code> column of the <code>[Media]</code> table.
+Corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
 ==<code>EventTypeID</code>==

← Older revision		Revision as of 10:48, 25 January 2024
Line 39:		Line 39:

	==<code>EventTypeID</code>==		==<code>EventTypeID</code>==
−	The identifier of the type of event this is. This corresponds to the <code>ID</code> column of the <code>[EventType]</code> table.	+	The identifier of the type of event this is.
		+	This corresponds to the <code>ID</code> column of the <code>[EventType]</code> table.
		+	It should contain one of [[Event_Types\|these]] values.

@@ Line 1: / Line 1: @@
-This table holds the different events that Truxton finds.
+This table holds the different events that Truxton finds in the media.
 <source lang="SQL">
 CREATE TABLE "Event"
@@ Line 14: / Line 15: @@
 );
 </source>

@@ Line 1: / Line 1: @@
 This table holds the different events that Truxton finds.
-<syntaxhighlight lang="SQL">
+<source lang="SQL">
-CREATE TABLE "Event" (
+CREATE TABLE "Event"
-    "ID" uuid NOT NULL,
-    "Start" timestamp without time zone NOT NULL,
+  "ID" uuid NOT NULL,
-    "End" timestamp without time zone NOT NULL,
+  "Start" timestamp without time zone NOT NULL,
-    "Title" text DEFAULT ''::text NOT NULL,
+  "End" timestamp without time zone NOT NULL,
-    "Description" text DEFAULT ''::text NOT NULL,
+  "Title" text DEFAULT ''::text NOT NULL,
-    "FileID" uuid NOT NULL,
+  "Description" text DEFAULT ''::text NOT NULL,
-    "MediaID" uuid NOT NULL,
+  "FileID" uuid NOT NULL,
-    "EventTypeID" smallint DEFAULT 0 NOT NULL
+  "MediaID" uuid NOT NULL,
 );
-</syntaxhighlight>
+</source>