Event Table

From truxwiki.com
Revision as of 13:48, 21 May 2020 by Sam (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This table holds the different events that Truxton finds.

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
);