Files and thumbnails within OS X’s Quicklook Cache.

Table schema

Name Type Description
path TEXT Path of file
rowid INTEGER Quicklook file rowid key
fs_id TEXT Quicklook file fs_id key
volume_id INTEGER Parsed volume ID from fs_id
inode INTEGER Parsed file ID (inode) from fs_id
mtime INTEGER Parsed version date field
size BIGINT Parsed version size field
label TEXT Parsed version ‘gen’ field
last_hit_date INTEGER Apple date format for last thumbnail cache hit
hit_count TEXT Number of cache hits on thumbnail
icon_mode BIGINT Thumbnail icon mode
cache_path TEXT Path to cache data