Difference between revisions of "Event Table"
Jump to navigation
Jump to search
(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...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| 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. |
| − | < | + | =SQL= |
| − | CREATE TABLE "Event" ( | + | <source 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 | ||
); | ); | ||
| − | </ | + | </source> |
| + | |||
| + | =Columns= | ||
| + | ==<code>ID</code>== | ||
| + | The globally unique identifier for this event. | ||
| + | |||
| + | ==<code>Start</code>== | ||
| + | The date/time when this event began. | ||
| + | |||
| + | ==<code>End</code>== | ||
| + | The date/time when this event ended (if ever). | ||
| + | |||
| + | ==<code>Title</code>== | ||
| + | The short name of this event. | ||
| + | |||
| + | ==<code>Description</code>== | ||
| + | The longer form of details. | ||
| + | |||
| + | ==<code>FileID</code>== | ||
| + | The <code>ID</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table. | ||
| + | |||
| + | ==<code>MediaID</code>== | ||
| + | Corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table. | ||
| + | |||
| + | ==<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. | ||
| + | It should contain one of [[Event_Types|these]] values. | ||
Latest revision as of 07:19, 3 February 2024
This table holds the different events that Truxton finds in the media.
Contents
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
);
Columns
ID
The globally unique identifier for this event.
Start
The date/time when this event began.
End
The date/time when this event ended (if ever).
Title
The short name of this event.
Description
The longer form of details.
FileID
The ID column of the [File] table.
MediaID
Corresponds to the [ID] column of the [Media] table.
EventTypeID
The identifier of the type of event this is.
This corresponds to the [ID] column of the [EventType] table.
It should contain one of these values.
