documentation of the Lemmy database tables - the lemmy_server Rust code dynamically generates them, so they seem hard to find?

[RocketDerp]

As I understand it, the code goes through all the history of 'migrations' and alter tables to dynamically get to the final version-specific database structure.

I think for each release it would be nice to have a fully published readable version of the CREATE TABLE statements as they end up in the running release of that version.

Given the ongoing performance scaling issues of the 0.18 era of Lemmy, I think it is important that developers see the resulting table structures that the app is generating.

If this already exists and I'm confused, please excuse my oversight and share a link where it's published by the project.

[Nutomic]

You can use diesel cli to execute the migrations against a local database, and then dump the db schema using backup instructions