EXIF Table

The EXIF table holds camera information gleaned from JPGs, TIFFs, MP2s and MP4s.

CREATE TABLE "EXIF" (
    "ID" uuid NOT NULL,
    "FileID" uuid NOT NULL,
    "MediaID" uuid NOT NULL,
    "HashID" uuid NOT NULL,
    "Make" text DEFAULT ''::text NOT NULL,
    "Model" text DEFAULT ''::text NOT NULL,
    "SerialNumber" text DEFAULT ''::text NOT NULL,
    "Latitude" double precision DEFAULT 0 NOT NULL,
    "Longitude" double precision DEFAULT 0 NOT NULL,
    "Altitude" double precision DEFAULT 0 NOT NULL,
    "Heading" double precision DEFAULT 0 NOT NULL,
    "FocalLength" double precision DEFAULT 0 NOT NULL,
    "ShutterCount" integer DEFAULT 0 NOT NULL,
    "GPSTime" timestamp without time zone NOT NULL,
    "CameraTime" timestamp without time zone NOT NULL,
    "Offset" bigint DEFAULT (-1) NOT NULL
);