documentation of the Lemmy database tables - the lemmy_server Rust code dynamically generates them, so they seem hard to find? about lemmy-docs HOT 2 OPEN

I firmly identify the lack of clear to read documentation and focus upon the SQL TRIGGER (FUNCTION) statements in lemmy_server lead to taking months to close/resolve LemmyNet/lemmy#2910

PostgreSQL has forensically been identified to be the cause of constant sever-crashing problems across the entire Lemmy server network, with easy to fix problems 'out of sight, out of mind'. At the time of my June 24 documentation issue raised here, issue 2910 PostgreSQL TRIGGER call-out had been open for 20 days, any action to emphasize the importance of project developers putting eyes to study the logic of TRIGGER (FUNCTION) for that problem.

from lemmy-docs.

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

from lemmy-docs.