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...") |
|||
| Line 1: | Line 1: | ||
This table holds the different events that Truxton finds. | This table holds the different events that Truxton finds. | ||
| − | < | + | <source lang="SQL"> |
| − | CREATE TABLE "Event" ( | + | 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> |
Revision as of 08:51, 8 December 2020
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
);
