Re:DrawERD makes it easy to visualize your database structure
by thisisbrians on Thursday September 24, 2020 @01:31PM
(#24581109)
I have been thinking along these same lines as our architecture has gotten more complex over the years. I've toyed with the idea of adding some sort of comment syntax into our codebases that would allow some level of automation around this idea. Auto-generation might work quite well given the limited context, to your point.
This approach also provides metadata that can be used to figure out which tables are being used where in the code, and vice versa.
Context is king!