Detect changes to files (using custom hooks)

I have built a 'hook' into the database of NextCloud and use it for it's cloud-drive capabilities and file management structure.

This is all working quite nicely, but when a file is moved the only way to process that change seems to do a complete database scan and compare the NextCloud tabel 'oc_filecache' to my table.

Detecting a new/newer file is now done using the field 'storage_mtime'

But I can't see a 'file move' nor a 'file rename' in the table. Could it be possible to simply update the 'storage_mtime' to "now"?

Or is there an other way?

Start with the oc_filecache table and the storage_mtime behavior described in the issue, then trace the custom database hook used for file management. Determine how file moves and renames are represented and whether an existing event or metadata field can expose them without a complete table scan. Done means documenting or implementing a confirmed way to detect those changes.