Location Table

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

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