System File Type

raw

Image

Overview

A camera-raw image file whose exact encoding depends on the camera or software.

Characteristics

Usually preserves minimally processed sensor samples plus camera metadata, previews, and calibration information.

Common Uses

High-quality photography, nondestructive editing, color grading, and archival capture.

Compatible Programs

Adobe Lightroom Classic
Adobe Photoshop
RawTherapee
Windows Photos

Sources

raw Available by Year Taken/Created

raw — Live from Microsoft

Secure, read-only view focused directly on the raw file-type folder.

Camera Fields

These 72 columns in [AUROS].[DZFILESYSFILES].[FILETYPE RAW] preserve camera, device, lens, source, software, capture, location, and format-specific metadata embedded in RAW files. Values are copied from the file; they are not inferred.

RAW metadata: RAW is an extension rather than one metadata standard. TIFF/EXIF-based camera RAW files may expose camera fields; headerless or application-specific RAW files may expose none. A NULL value means the source file did not contain a readable value for that field.

Device Identity

SQL column	What it records
`Camera - Make`	Manufacturer recorded for the capture device.
`Camera - Model`	Model recorded for the capture device.
`Camera - Unique Model`	Globally unique camera-model name, primarily used by DNG.
`Camera - Localized Model`	Localized display name for the camera model.
`Camera - Serial Number`	Camera or device serial number.
`Camera - Owner Name`	Owner name written by the camera.
`Camera - Body Serial Number`	Serial number of the camera body.
`Camera - Internal Serial Number`	Manufacturer-specific internal camera serial number.
`Camera - Sensor Serial Number`	Manufacturer-specific image-sensor serial number.
`Camera - ID`	Manufacturer-specific camera identifier.
`Camera - Type`	Manufacturer-specific camera or device type.
`Camera - Firmware Version`	Firmware version recorded by the device.
`Camera - Shutter Count`	Camera shutter or image-actuation count when recorded.
`Camera - Maker Note`	Manufacturer-specific EXIF MakerNote payload or its recorded presence.

Lens

SQL column	What it records
`Camera - Lens - Specification`	Minimum/maximum focal length and aperture specification.
`Camera - Lens - Make`	Lens manufacturer.
`Camera - Lens - Model`	Lens model.
`Camera - Lens - Serial Number`	Lens serial number.
`Camera - Lens - Type`	Manufacturer-specific lens type.
`Camera - Lens - ID`	Manufacturer-specific lens identifier.

Source

SQL column	What it records
`Camera - Source - File Source`	EXIF source type, such as digital still camera.
`Camera - Source - Scene Type`	Whether the image was directly photographed.
`Camera - Source - Sensing Method`	Type and arrangement of the image sensor.
`Camera - Source - Device Setting Description`	Device configuration recorded for the capture.
`Camera - Source - Digital Source Type`	XMP/IPTC classification of camera, scan, composite, or generated source.
`Camera - Source - Composite Image`	Whether the image is a composite of multiple captures.
`Camera - Source - Composite Source Image Count`	Number of source images in a composite.
`Camera - Source - Composite Source Exposure Times`	Exposure times of images used in a composite.

Software

SQL column	What it records
`Camera - Software - Name`	Software recorded as writing or processing the image.
`Camera - Software - Processing Software`	Processing software recorded in TIFF/EXIF metadata.
`Camera - Software - Host Computer`	Computer recorded as writing or processing the image.
`Camera - Software - Creator Tool`	XMP tool that created or last authored the image.
`Camera - Software - History Software Agent`	Software agents recorded in XMP edit history.

Capture

SQL column	What it records
`Camera - Capture - Date Time Original`	Original capture date and time.
`Camera - Capture - Offset Time Original`	Time-zone offset for the original capture time.
`Camera - Capture - Subsecond Time Original`	Subsecond component of the original capture time.
`Camera - Capture - Exposure Time`	Exposure duration.
`Camera - Capture - Shutter Speed`	APEX or calculated shutter speed.
`Camera - Capture - F Number`	Lens f-number used for the exposure.
`Camera - Capture - Aperture`	APEX or calculated aperture value.
`Camera - Capture - ISO`	ISO or photographic sensitivity.
`Camera - Capture - Sensitivity Type`	EXIF interpretation of recorded sensitivity values.
`Camera - Capture - Standard Output Sensitivity`	Standard output sensitivity reported by the device.
`Camera - Capture - Recommended Exposure Index`	Recommended exposure index reported by the device.
`Camera - Capture - Exposure Program`	Automatic or manual exposure program.
`Camera - Capture - Exposure Mode`	Automatic, manual, or bracketed exposure mode.
`Camera - Capture - Metering Mode`	Camera light-metering mode.
`Camera - Capture - Light Source`	Recorded light source or illumination type.
`Camera - Capture - Flash`	Flash status and mode.
`Camera - Capture - Focal Length`	Lens focal length used for the capture.
`Camera - Capture - Focal Length 35mm`	35mm-equivalent focal length.
`Camera - Capture - Digital Zoom Ratio`	Digital zoom ratio.
`Camera - Capture - Subject Distance`	Recorded subject distance.
`Camera - Capture - White Balance`	Automatic or manual white-balance mode.
`Camera - Capture - Scene Capture Type`	Standard, landscape, portrait, night, or another scene mode.
`Camera - Capture - Gain Control`	Camera gain adjustment.
`Camera - Capture - Contrast`	Camera contrast-processing setting.
`Camera - Capture - Saturation`	Camera saturation-processing setting.
`Camera - Capture - Sharpness`	Camera sharpness-processing setting.
`Camera - Capture - Subject Distance Range`	Macro, close, or distant subject range.
`Camera - Capture - Orientation`	Recorded sensor/image orientation.

GPS and Location

SQL column	What it records
`Camera - GPS - Latitude`	Capture latitude.
`Camera - GPS - Longitude`	Capture longitude.
`Camera - GPS - Altitude`	Capture altitude.
`Camera - GPS - Time Stamp`	GPS capture time.
`Camera - GPS - Date Stamp`	GPS capture date.

Color Profile

SQL column	What it records
`Camera - Color Profile - Class`	ICC profile class, such as input, display, or output device.
`Camera - Color Profile - Device Manufacturer`	Manufacturer identifier in the embedded ICC profile.
`Camera - Color Profile - Device Model`	Device-model identifier in the embedded ICC profile.
`Camera - Color Profile - Device Attributes`	ICC device attributes.
`Camera - Color Profile - Device Technology`	ICC device-technology classification.
`Camera - Color Profile - Description`	Human-readable embedded color-profile description.

Location Fields

These 33 columns in [AUROS].[DZFILESYSFILES].[FILETYPE RAW] preserve location metadata embedded in RAW files. Values are copied from the file and are not inferred from its folder or filename.

RAW location metadata: RAW is not one universal format. Camera-RAW containers may expose EXIF GPS and proprietary MakerNote location data; a headerless RAW raster exposes none. A NULL value means the source file did not contain a readable value for that field.

GPS

SQL column	What it records
`Location - GPS - Version ID`	Version of the EXIF GPS information block.
`Location - GPS - Latitude Reference`	North or south latitude reference.
`Location - GPS - Latitude`	Latitude recorded for the image.
`Location - GPS - Longitude Reference`	East or west longitude reference.
`Location - GPS - Longitude`	Longitude recorded for the image.
`Location - GPS - Altitude Reference`	Whether altitude is above or below the reference level.
`Location - GPS - Altitude`	Altitude recorded for the image.
`Location - GPS - Time Stamp`	UTC time reported by the GPS receiver.
`Location - GPS - Satellites`	GPS satellites used for the measurement.
`Location - GPS - Status`	Status of the GPS receiver measurement.
`Location - GPS - Measure Mode`	Two-dimensional or three-dimensional GPS measurement mode.
`Location - GPS - DOP`	GPS dilution of precision.
`Location - GPS - Speed Reference`	Unit used for GPS speed.
`Location - GPS - Speed`	Speed recorded by the GPS receiver.
`Location - GPS - Track Reference`	True or magnetic reference for movement direction.
`Location - GPS - Track`	Direction of movement recorded by GPS.
`Location - GPS - Image Direction Reference`	True or magnetic reference for camera direction.
`Location - GPS - Image Direction`	Direction in which the camera was pointing.
`Location - GPS - Map Datum`	Geodetic survey datum used for the coordinates.
`Location - GPS - Destination Latitude Reference`	North or south reference for destination latitude.
`Location - GPS - Destination Latitude`	Latitude of the recorded destination.
`Location - GPS - Destination Longitude Reference`	East or west reference for destination longitude.
`Location - GPS - Destination Longitude`	Longitude of the recorded destination.
`Location - GPS - Destination Bearing Reference`	True or magnetic reference for destination bearing.
`Location - GPS - Destination Bearing`	Bearing to the recorded destination.
`Location - GPS - Destination Distance Reference`	Unit used for destination distance.
`Location - GPS - Destination Distance`	Distance to the recorded destination.
`Location - GPS - Processing Method`	Method used to determine the GPS position.
`Location - GPS - Area Information`	Name or description of the GPS area.
`Location - GPS - Date Stamp`	UTC date reported by the GPS receiver.
`Location - GPS - Differential`	Whether differential GPS correction was applied.
`Location - GPS - Horizontal Positioning Error`	Estimated horizontal positioning error.

RAW

SQL column	What it records
`Location - RAW - Maker Notes`	Manufacturer-specific MakerNote data that may contain proprietary location information.

Time and Date Fields

These 74 columns in [AUROS].[DZFILESYSFILES].[FILETYPE RAW] preserve date, time, duration, time-code, and animation-timing values available in RAW files. Values are copied from the source file and are not inferred from its filename or folder.

RAW time and date metadata: RAW is a family of camera formats. In addition to common EXIF, GPS, IPTC, XMP, ICC, and composite values, manufacturer-specific MakerNote time fields are preserved as JSON. A NULL value means the source file did not contain a readable value for that field.

File

SQL column	What it records
`Time - File - Access Date`	Filesystem date and time when the file was last accessed.
`Time - File - Create Date`	Filesystem date and time when the file was created.
`Time - File - Inode Change Date`	Filesystem date and time when the file record or metadata last changed, when the filesystem exposes it.
`Time - File - Modify Date`	Filesystem date and time when the file content was last modified.

EXIF

SQL column	What it records
`Time - EXIF - Modify Date`	EXIF date and time when the image metadata or image was modified.
`Time - EXIF - Date Time Original`	EXIF date and time when the original image data was generated.
`Time - EXIF - Create Date`	EXIF date and time when the digital image data was created.
`Time - EXIF - Offset Time`	UTC offset associated with EXIF Modify Date.
`Time - EXIF - Offset Time Original`	UTC offset associated with EXIF Date Time Original.
`Time - EXIF - Offset Time Digitized`	UTC offset associated with EXIF Create Date.
`Time - EXIF - Sub Second Time`	Fractional seconds associated with EXIF Modify Date.
`Time - EXIF - Sub Second Time Original`	Fractional seconds associated with EXIF Date Time Original.
`Time - EXIF - Sub Second Time Digitized`	Fractional seconds associated with EXIF Create Date.
`Time - EXIF - GPS Date Stamp`	UTC calendar date reported by the GPS receiver.
`Time - EXIF - GPS Time Stamp`	UTC time of day reported by the GPS receiver.
`Time - EXIF - Preview Date Time`	Date and time stored for an embedded preview image.
`Time - EXIF - Thumbnail Date Time`	Date and time stored for an embedded thumbnail image.
`Time - EXIF - Time Zone Offset`	Legacy EXIF time-zone offset associated with image timestamps.
`Time - EXIF - Exposure Time`	Length of time the camera sensor was exposed.

EXIF Motion

SQL column	What it records
`Time - EXIF Motion - Frame Delay`	Delay between frames recorded by the image metadata.
`Time - EXIF Motion - Frame Rate`	Frame rate recorded by the image metadata.
`Time - EXIF Motion - Time Codes`	One or more time codes stored in the image metadata.
`Time - EXIF Motion - MD Prep Date`	Metadata-preparation date stored by the source device or software.
`Time - EXIF Motion - MD Prep Time`	Metadata-preparation time stored by the source device or software.

IPTC Legacy

SQL column	What it records
`Time - IPTC Legacy - Date Created`	Legacy IPTC calendar date when the intellectual content was created.
`Time - IPTC Legacy - Time Created`	Legacy IPTC time when the intellectual content was created.
`Time - IPTC Legacy - Digital Creation Date`	Legacy IPTC calendar date when the digital representation was created.
`Time - IPTC Legacy - Digital Creation Time`	Legacy IPTC time when the digital representation was created.
`Time - IPTC Legacy - Release Date`	Legacy IPTC date on or after which the image may be released.
`Time - IPTC Legacy - Release Time`	Legacy IPTC time on or after which the image may be released.
`Time - IPTC Legacy - Expiration Date`	Legacy IPTC date after which the image should not be used.
`Time - IPTC Legacy - Expiration Time`	Legacy IPTC time after which the image should not be used.
`Time - IPTC Legacy - Date Sent`	Legacy IPTC date when the image was sent.
`Time - IPTC Legacy - Time Sent`	Legacy IPTC time when the image was sent.
`Time - IPTC Legacy - Reference Date`	Legacy IPTC reference date associated with the image.

XMP Core

SQL column	What it records
`Time - XMP Core - Create Date`	XMP date and time when the resource was created.
`Time - XMP Core - Modify Date`	XMP date and time when the resource was last modified.
`Time - XMP Core - Metadata Date`	XMP date and time when the metadata was last changed.

XMP EXIF

SQL column	What it records
`Time - XMP EXIF - Date Time Original`	XMP EXIF date and time when the original image was captured.
`Time - XMP EXIF - Date Time Digitized`	XMP EXIF date and time when the image was digitized.
`Time - XMP EXIF - GPS Date Time`	Combined UTC GPS date and time stored in XMP EXIF metadata.

XMP Photoshop

SQL column	What it records
`Time - XMP Photoshop - Date Created`	XMP Photoshop date and time when the intellectual content was created.

XMP Dublin Core

SQL column	What it records
`Time - XMP Dublin Core - Date`	Dublin Core date or dates associated with the resource.

XMP IPTC

SQL column	What it records
`Time - XMP IPTC - Time Created`	IPTC Core time associated with creation of the image content.
`Time - XMP IPTC - IPTC Last Edited`	Date and time when IPTC metadata was last edited.
`Time - XMP IPTC - Metadata Last Edited`	Date and time when the extended IPTC metadata was last edited.
`Time - XMP IPTC - Metadata Modification Date`	Date and time when the metadata record was modified.
`Time - XMP IPTC - Modification Date`	Modification date and time stored in IPTC Extension metadata.
`Time - XMP IPTC - Original Create Date Time`	Original creation date and time recorded in IPTC Extension metadata.
`Time - XMP IPTC - Publication Event Date`	Date or dates associated with a publication event.
`Time - XMP IPTC - Temporal Coverage From`	Beginning of the time period covered by the image.
`Time - XMP IPTC - Temporal Coverage To`	End of the time period covered by the image.

XMP History

SQL column	What it records
`Time - XMP History - History When`	Date and time of each recorded XMP history event.
`Time - XMP History - Versions Event When`	Date and time of a version event.
`Time - XMP History - Versions Modify Date`	Modification date and time recorded for a version.

XMP Lineage

SQL column	What it records
`Time - XMP Lineage - Derived From Last Modify Date`	Last modification date of the source from which this image was derived.
`Time - XMP Lineage - Ingredients Last Modify Date`	Last modification date of an ingredient used to create the image.
`Time - XMP Lineage - Managed From Last Modify Date`	Last modification date of the managed source resource.
`Time - XMP Lineage - Manifest Reference Last Modify Date`	Last modification date of a resource referenced by a manifest.
`Time - XMP Lineage - Rendition Of Last Modify Date`	Last modification date of the resource of which this is a rendition.

XMP Rights

SQL column	What it records
`Time - XMP Rights - License Start Date`	Beginning of the licensed-use period.
`Time - XMP Rights - License End Date`	End of the licensed-use period.
`Time - XMP Rights - License Transaction Date`	Date and time of the licensing transaction.

ICC

SQL column	What it records
`Time - ICC - Profile Date Time`	Date and time when the embedded ICC color profile was created.
`Time - ICC - Calibration Date Time`	Date and time of the calibration described by the embedded color profile.

Composite

SQL column	What it records
`Time - Composite - Sub Second Create Date`	Composite EXIF Create Date including fractional seconds and UTC offset when available.
`Time - Composite - Sub Second Date Time Original`	Composite original-capture date including fractional seconds and UTC offset when available.
`Time - Composite - Sub Second Modify Date`	Composite EXIF Modify Date including fractional seconds and UTC offset when available.
`Time - Composite - Date Time Created`	Composite IPTC date and time when the image content was created.
`Time - Composite - Digital Creation Date Time`	Composite IPTC date and time when the digital image was created.
`Time - Composite - GPS Date Time`	Composite UTC date and time calculated from GPS date and time fields.

RAW

SQL column	What it records
`Time - RAW - Maker Note Date Time Fields`	All manufacturer-specific MakerNote fields whose names describe dates or times, stored as JSON.
`Time - RAW - Sequence Time Fields`	All manufacturer-specific sequence timestamp fields, stored as JSON.
`Time - RAW - Camera Clock Fields`	All manufacturer-specific camera-clock fields, stored as JSON.

System File Type – raw