Event Table

This table holds the different events that Truxton finds in the media.

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.