Difference between revisions of "Location Table"

From truxwiki.com
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.
  
−
<syntaxhighlight lang="SQL">
+
<source lang="SQL">
−
CREATE TABLE "Location" (
+
CREATE TABLE "Location"
−
    "ID" uuid NOT NULL,
+
(
−
    "FileID" uuid NOT NULL,
+
  "ID" uuid NOT NULL,
−
    "MediaID" uuid NOT NULL,
+
  "FileID" uuid NOT NULL,
−
    "Latitude" double precision DEFAULT 0 NOT NULL,
+
  "MediaID" uuid NOT NULL,
−
    "Longitude" double precision DEFAULT 0 NOT NULL,
+
  "Latitude" double precision DEFAULT 0 NOT NULL,
−
    "Altitude" double precision DEFAULT 0 NOT NULL,
+
  "Longitude" double precision DEFAULT 0 NOT NULL,
−
    "LocationTypeID" smallint DEFAULT 0 NOT NULL,
+
  "Altitude" double precision DEFAULT 0 NOT NULL,
−
    "When" timestamp without time zone NOT NULL,
+
  "LocationTypeID" smallint DEFAULT 0 NOT NULL,
−
    "Label" text DEFAULT ''::text NOT NULL
+
  "When" timestamp without time zone NOT NULL,
 +
  "Label" text DEFAULT ''::text NOT NULL
 
);
 
);
−
</syntaxhighlight>
+
</source>

Revision as of 07: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
);