Difference between revisions of "Event Table"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 36: | Line 36: | ||
==<code>MediaID</code>== | ==<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>== | ==<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. | ||
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.
