Yes, OCC is magic (and well documented), but yet far from the solution in this case. I have the same issue and it is a well known “problem”. In my case I believe i have done things the wrong way (like sharing something, then deleting in the backend. I have this when i check the oc_storage table:
So my guess is that i will need to have numeric_id 77 and 63 deleted. It is on my to do list (but i suck with db and are a bit scared to pull triggers)
The only real share here is the 84 (i share files as “External storage, local”