Is there any published database schema or perhaps a way for me to get one. I know that major changes are coming to the library, but I occasionally like to tweak things. It makes it difficult when looking at a bunch of fields labeled c??.
I realize that you may not want to have one available to the general public but I’ve been in IT for a really, really long time. Even before relational databases and SQL 
.
It's all Sqlite ... you can use an app like Sqlite browser to look at the full schema I believe. The relations were (mostly) obvious the last time I took a look in there.
I realize a lot can be discerned from looking at it with sqlite but a lot of the fields are named just as Cxx. It would be nice to see "Watched" instead of "C13" (not sure if that's what C13 is, just arbitrary). So I was wondering if what the actual fields represented was written down and available.
Who knows, I might actually be ambitious and write a program to edit the database.
I completely agree :) The new schema coming in the Plex/Nine series is much, much better.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
