Difference between revisions of "Location Table"
Jump to navigation
Jump to search
(Created page with "This is where Truxton stores geographic coordinates. <syntaxhighlight lang="SQL"> CREATE TABLE "Location" ( "ID" uuid NOT NULL, "FileID" uuid NOT NULL, "MediaID"...") |
|||
| Line 1: | Line 1: | ||
This is where Truxton stores geographic coordinates. | This is where Truxton stores geographic coordinates. | ||
| − | < | + | <source lang="SQL"> |
| − | CREATE TABLE "Location" ( | + | CREATE TABLE "Location" |
| − | + | ( | |
| − | + | "ID" uuid NOT NULL, | |
| − | + | "FileID" uuid NOT NULL, | |
| − | + | "MediaID" uuid NOT NULL, | |
| − | + | "Latitude" double precision DEFAULT 0 NOT NULL, | |
| − | + | "Longitude" double precision DEFAULT 0 NOT NULL, | |
| − | + | "Altitude" double precision DEFAULT 0 NOT NULL, | |
| − | + | "LocationTypeID" smallint DEFAULT 0 NOT NULL, | |
| − | + | "When" timestamp without time zone NOT NULL, | |
| + | "Label" text DEFAULT ''::text NOT NULL | ||
); | ); | ||
| − | </ | + | </source> |
Revision as of 08:53, 8 December 2020
This is where Truxton stores geographic coordinates.
CREATE TABLE "Location"
(
"ID" uuid NOT NULL,
"FileID" uuid NOT NULL,
"MediaID" uuid NOT NULL,
"Latitude" double precision DEFAULT 0 NOT NULL,
"Longitude" double precision DEFAULT 0 NOT NULL,
"Altitude" double precision DEFAULT 0 NOT NULL,
"LocationTypeID" smallint DEFAULT 0 NOT NULL,
"When" timestamp without time zone NOT NULL,
"Label" text DEFAULT ''::text NOT NULL
);
