System File Type

heic

Image

Overview

A High Efficiency Image Container file, commonly carrying HEVC-compressed images.

Characteristics

ISO-base-media container that can store high-quality images, sequences, thumbnails, depth data, and metadata efficiently.

Common Uses

Phone photography, image sequences, Live Photos components, and space-efficient photo storage.

Compatible Programs

Apple Photos
Apple Preview
Windows Photos
Adobe Photoshop

Sources

heic Available by Year Taken/Created

heic — Live from Microsoft

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

Camera Fields

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

HEIC metadata: HEIC can carry EXIF, XMP, HEIF/QuickTime keys, and manufacturer MakerNotes, including phone/camera, lens, software, capture, and location information. 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.

HEIC

SQL column	What it records
`Camera - HEIC - QuickTime Make`	HEIF/QuickTime manufacturer value.
`Camera - HEIC - QuickTime Model`	HEIF/QuickTime device-model value.
`Camera - HEIC - QuickTime Software`	HEIF/QuickTime software value.
`Camera - HEIC - QuickTime Creation Date`	HEIF/QuickTime creation date.
`Camera - HEIC - QuickTime Location`	ISO 6709 location stored in HEIF/QuickTime metadata.
`Camera - HEIC - Encoder`	HEIF encoder or writing library.
`Camera - HEIC - Handler Description`	Description of the HEIF metadata or image handler.
`Camera - HEIC - Major Brand`	Primary HEIF container brand.
`Camera - HEIC - Compatible Brands`	Compatible HEIF container brands.
`Camera - HEIC - Content Identifier`	Apple/vendor identifier linking related image assets.

Location Fields

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

HEIC location metadata: HEIC can retain EXIF GPS, XMP/IPTC location structures, and HEIF/QuickTime location keys such as ISO 6709 coordinates, name, note, role, body, and date. 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.

HEIC QuickTime

SQL column	What it records
`Location - HEIC QuickTime - ISO 6709`	QuickTime/HEIF geographic coordinates encoded using ISO 6709.
`Location - HEIC QuickTime - Name`	Name assigned to the location.
`Location - HEIC QuickTime - Note`	Note describing the location.
`Location - HEIC QuickTime - Role`	Role of the location, such as shooting, real, or fictional.
`Location - HEIC QuickTime - Body`	Astronomical body associated with the location.
`Location - HEIC QuickTime - Date`	Date associated with the location metadata.

IPTC Legacy

SQL column	What it records
`Location - IPTC Legacy - Sublocation`	Legacy IPTC location or sublocation shown in the image.
`Location - IPTC Legacy - City`	Legacy IPTC city shown in the image.
`Location - IPTC Legacy - Province or State`	Legacy IPTC province or state shown in the image.
`Location - IPTC Legacy - Country Name`	Legacy IPTC country name shown in the image.
`Location - IPTC Legacy - Country Code`	Legacy IPTC ISO country code shown in the image.

Created

SQL column	What it records
`Location - Created - Structure`	Complete IPTC structured location describing where the image was created.
`Location - Created - City`	City of the location. This structure describes where the image was created.
`Location - Created - Country Code`	ISO country code of the location. This structure describes where the image was created.
`Location - Created - Country Name`	Country name of the location. This structure describes where the image was created.
`Location - Created - GPS Altitude`	Altitude of the location. This structure describes where the image was created.
`Location - Created - GPS Altitude Reference`	Reference indicating whether the altitude is above or below WGS84. This structure describes where the image was created.
`Location - Created - GPS Latitude`	Latitude of the location. This structure describes where the image was created.
`Location - Created - GPS Longitude`	Longitude of the location. This structure describes where the image was created.
`Location - Created - Identifier`	Identifier recorded for the location structure. This structure describes where the image was created.
`Location - Created - Location ID`	Globally unique identifier for the location. This structure describes where the image was created.
`Location - Created - Location Name`	Full human-readable name of the location. This structure describes where the image was created.
`Location - Created - Province or State`	Province or state of the location. This structure describes where the image was created.
`Location - Created - Sublocation`	Sublocation or named site within the location. This structure describes where the image was created.
`Location - Created - World Region`	World region containing the location. This structure describes where the image was created.

Shown

SQL column	What it records
`Location - Shown - Structure`	Complete IPTC structured location describing a place depicted in the image.
`Location - Shown - City`	City of the location. This structure describes a place depicted in the image.
`Location - Shown - Country Code`	ISO country code of the location. This structure describes a place depicted in the image.
`Location - Shown - Country Name`	Country name of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Altitude`	Altitude of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Altitude Reference`	Reference indicating whether the altitude is above or below WGS84. This structure describes a place depicted in the image.
`Location - Shown - GPS Latitude`	Latitude of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Longitude`	Longitude of the location. This structure describes a place depicted in the image.
`Location - Shown - Identifier`	Identifier recorded for the location structure. This structure describes a place depicted in the image.
`Location - Shown - Location ID`	Globally unique identifier for the location. This structure describes a place depicted in the image.
`Location - Shown - Location Name`	Full human-readable name of the location. This structure describes a place depicted in the image.
`Location - Shown - Province or State`	Province or state of the location. This structure describes a place depicted in the image.
`Location - Shown - Sublocation`	Sublocation or named site within the location. This structure describes a place depicted in the image.
`Location - Shown - World Region`	World region containing the location. This structure describes a place depicted in the image.

Time and Date Fields

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

HEIC time and date metadata: HEIC can preserve EXIF and XMP dates plus extensive HEIF/QuickTime creation, modification, recording, release, time-zone, duration, frame-rate, and time-code values. 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.

QuickTime

SQL column	What it records
`Time - QuickTime - Acquisition Time`	HEIF/QuickTime acquisition time value stored by the source device or software.
`Time - QuickTime - Acquisition Time Day`	HEIF/QuickTime acquisition time day value stored by the source device or software.
`Time - QuickTime - Acquisition Time Month`	HEIF/QuickTime acquisition time month value stored by the source device or software.
`Time - QuickTime - Acquisition Time Year`	HEIF/QuickTime acquisition time year value stored by the source device or software.
`Time - QuickTime - Acquisition Time Year Month`	HEIF/QuickTime acquisition time year month value stored by the source device or software.
`Time - QuickTime - Acquisition Time Year Month Day`	HEIF/QuickTime acquisition time year month day value stored by the source device or software.
`Time - QuickTime - Android Time Zone`	HEIF/QuickTime android time zone value stored by the source device or software.
`Time - QuickTime - Camera Date Time`	HEIF/QuickTime camera date time value stored by the source device or software.
`Time - QuickTime - Content Create Date`	HEIF/QuickTime content create date value stored by the source device or software.
`Time - QuickTime - Create Date`	HEIF/QuickTime create date value stored by the source device or software.
`Time - QuickTime - Creation Date`	HEIF/QuickTime creation date value stored by the source device or software.
`Time - QuickTime - Creation Time`	HEIF/QuickTime creation time value stored by the source device or software.
`Time - QuickTime - Date`	HEIF/QuickTime date value stored by the source device or software.
`Time - QuickTime - Date Accessed`	HEIF/QuickTime date accessed value stored by the source device or software.
`Time - QuickTime - Date Acquired`	HEIF/QuickTime date acquired value stored by the source device or software.
`Time - QuickTime - Date Archived`	HEIF/QuickTime date archived value stored by the source device or software.
`Time - QuickTime - Date Completed`	HEIF/QuickTime date completed value stored by the source device or software.
`Time - QuickTime - Date Created`	HEIF/QuickTime date created value stored by the source device or software.
`Time - QuickTime - Date Imported`	HEIF/QuickTime date imported value stored by the source device or software.
`Time - QuickTime - Date Last Saved`	HEIF/QuickTime date last saved value stored by the source device or software.
`Time - QuickTime - Date Modified`	HEIF/QuickTime date modified value stored by the source device or software.
`Time - QuickTime - Date Picture Taken`	HEIF/QuickTime date picture taken value stored by the source device or software.
`Time - QuickTime - Date Received`	HEIF/QuickTime date received value stored by the source device or software.
`Time - QuickTime - Date Released`	HEIF/QuickTime date released value stored by the source device or software.
`Time - QuickTime - Date Sent`	HEIF/QuickTime date sent value stored by the source device or software.
`Time - QuickTime - Date Time`	HEIF/QuickTime date time value stored by the source device or software.
`Time - QuickTime - Date Time Original`	HEIF/QuickTime date time original value stored by the source device or software.
`Time - QuickTime - Date Time Stamp`	HEIF/QuickTime date time stamp value stored by the source device or software.
`Time - QuickTime - Date Visited`	HEIF/QuickTime date visited value stored by the source device or software.
`Time - QuickTime - Encoding Time`	HEIF/QuickTime encoding time value stored by the source device or software.
`Time - QuickTime - GPS Date Time`	HEIF/QuickTime gps date time value stored by the source device or software.
`Time - QuickTime - GPS Time Stamp`	HEIF/QuickTime gps time stamp value stored by the source device or software.
`Time - QuickTime - Location Date`	HEIF/QuickTime location date value stored by the source device or software.
`Time - QuickTime - Media Create Date`	HEIF/QuickTime media create date value stored by the source device or software.
`Time - QuickTime - Media Modify Date`	HEIF/QuickTime media modify date value stored by the source device or software.
`Time - QuickTime - Media Original Broadcast Date Time`	HEIF/QuickTime media original broadcast date time value stored by the source device or software.
`Time - QuickTime - Modify Date`	HEIF/QuickTime modify date value stored by the source device or software.
`Time - QuickTime - Preview Date`	HEIF/QuickTime preview date value stored by the source device or software.
`Time - QuickTime - Production Date`	HEIF/QuickTime production date value stored by the source device or software.
`Time - QuickTime - Recording Time`	HEIF/QuickTime recording time value stored by the source device or software.
`Time - QuickTime - Recording Time Day`	HEIF/QuickTime recording time day value stored by the source device or software.
`Time - QuickTime - Recording Time Month`	HEIF/QuickTime recording time month value stored by the source device or software.
`Time - QuickTime - Recording Time Year`	HEIF/QuickTime recording time year value stored by the source device or software.
`Time - QuickTime - Recording Time Year Month`	HEIF/QuickTime recording time year month value stored by the source device or software.
`Time - QuickTime - Recording Time Year Month Day`	HEIF/QuickTime recording time year month day value stored by the source device or software.
`Time - QuickTime - Release Date`	HEIF/QuickTime release date value stored by the source device or software.
`Time - QuickTime - Release Date Day`	HEIF/QuickTime release date day value stored by the source device or software.
`Time - QuickTime - Release Date Month`	HEIF/QuickTime release date month value stored by the source device or software.
`Time - QuickTime - Release Date Year`	HEIF/QuickTime release date year value stored by the source device or software.
`Time - QuickTime - Release Date Year Month`	HEIF/QuickTime release date year month value stored by the source device or software.
`Time - QuickTime - Release Date Year Month Day`	HEIF/QuickTime release date year month day value stored by the source device or software.
`Time - QuickTime - Sample Date Time`	HEIF/QuickTime sample date time value stored by the source device or software.
`Time - QuickTime - Start Time`	HEIF/QuickTime start time value stored by the source device or software.
`Time - QuickTime - Time And Date`	HEIF/QuickTime time and date value stored by the source device or software.
`Time - QuickTime - Time Stamp`	HEIF/QuickTime time stamp value stored by the source device or software.
`Time - QuickTime - Time Zone`	HEIF/QuickTime time zone value stored by the source device or software.
`Time - QuickTime - Time Zone DST`	HEIF/QuickTime time zone dst value stored by the source device or software.
`Time - QuickTime - Track Create Date`	HEIF/QuickTime track create date value stored by the source device or software.
`Time - QuickTime - Track Modify Date`	HEIF/QuickTime track modify date value stored by the source device or software.
`Time - QuickTime - Year`	HEIF/QuickTime year value stored by the source device or software.

QuickTime Timing

SQL column	What it records
`Time - QuickTime Timing - Duration`	Overall duration stored in the HEIF/QuickTime container.
`Time - QuickTime Timing - Media Duration`	Duration of a media stream.
`Time - QuickTime Timing - Track Duration`	Duration of a media track.
`Time - QuickTime Timing - Preview Duration`	Duration assigned to a preview.
`Time - QuickTime Timing - Selection Duration`	Duration assigned to a selected range.
`Time - QuickTime Timing - Total Duration`	Total duration reported by the container.
`Time - QuickTime Timing - Frame Rate`	Frame rate reported by the container.
`Time - QuickTime Timing - Start Time Code`	Time code at the start of the media.
`Time - QuickTime Timing - Time Code`	Time code recorded by the media container.

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.

System File Type – heic