Schema or design docs for jellyfin.db sqlite database? Trying to verify app assumptions on how metadata is stored in db

[numericOverflow]

Are there any ERDs, logical diagrams of the database or docs explaining how metadata is logically stored in the new jellyfin.db database? I'm ultimately trying to accurately identify invalid metadata and purge it from the v10.11+ db.

Obviously, I can and have looked at the table definitions, but need to know what the app assumes will be populated for various types of media, etc. After digging through the tables, my database has a ton of bad paths, duplicate data and that's causing all sorts of timeout issues as the server . Not to mention It's loaded with every single LiveTV episode that's aired, as well as some really old data from when I ran my jellyfin instance on a different server.

I have good SQL knowledge, but would like some docs to make sure I don't delete something the app expects to be there. I think I've deduced how it's working but would like to corroborate my hunch before I start purging data from tables so I don't leave orphan data in them.

I've never used the new EFCore layer (I just write SQL myself), but even those definitions or configuration would probably work as a starting point.