Difference between revisions of "EXIF Table"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | The <code>EXIF</code> table holds camera information gleaned from [[Type_JPEGWithExif | JPGs,]] [[Type_TIFFWithExif | TIFFs,]] [[Type_MPEG2Video | MP2s]] and [[Type_MPEG4Video | MP4s.]] | + | The <code>[EXIF]</code> table holds camera information gleaned from [[Type_JPEGWithExif|JPGs,]] [[Type_TIFFWithExif|TIFFs,]] [[Type_MPEG2Video|MP2s]] and [[Type_MPEG4Video|MP4s.]] |
Originally, this information only came from [https://en.wikipedia.org/wiki/Exif Exchangeable image file format] data sections. | Originally, this information only came from [https://en.wikipedia.org/wiki/Exif Exchangeable image file format] data sections. | ||
As Truxton has progressed, camera information is exploited from other formats of meta data. | As Truxton has progressed, camera information is exploited from other formats of meta data. | ||
| − | < | + | <source lang="SQL"> |
| − | CREATE TABLE "EXIF" ( | + | 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 | ||
); | ); | ||
| − | </ | + | </source> |
Revision as of 08:52, 8 December 2020
The [EXIF] table holds camera information gleaned from JPGs, TIFFs, MP2s and MP4s.
Originally, this information only came from Exchangeable image file format data sections.
As Truxton has progressed, camera information is exploited from other formats of meta data.
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
);
