Difference between revisions of "Event Table"
Jump to navigation
Jump to search
| (3 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= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "Event" | CREATE TABLE "Event" | ||
| Line 14: | Line 15: | ||
); | ); | ||
</source> | </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.
