EXIF Table

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.

SQL

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

Columns

ID

The globally unique identifier for this record.

FileID

The ID of the file from which this information came. This corresponds to the [ID] column of the [File] table.

MediaID

The ID of the media this data comes from. This corresponds to the [ID] column of the [Media] table.

HashID

The hash of the contents of the file this EXIF data came from. This corresponds to the [ID] column of the [MD5Hash] table.

Make

The maker of the imager/camera.

Model

The model of the imager/camera.

SerialNumber

The serial number of the imager.

Latitude

The latitude portion of the WGS84 coordinate.

Longitude

The longitude portion of the WGS84 coordinate.

Altitude

The altitude of the coordinate in meters.

Heading

The compass heading.

FocalLength

The 35mm focal length of the image.

ShutterCount

The number of shutter releases on the camera.

GPSTime

The timestamp from the GPS in the imaging device.

CameraTime

The timestamp from the clock in the imager/camera.

Offset

The byte offset into the file where the EXIF data block began.