Very new to sql and thus new to sqlite3. I'm setting up a relational database and need a visual for peer review prior to populating with actual data. (That is, I am setting up all the tables and fields, with primary and foreign keys, but there are no records for now.)
Is there a way to make a figure that visually shows the relationships between the tables? (Example internet grab below--or maybe linked because I am new user.) Using sqlite3 and python. Bonus points if it looks better than the crummy Access visual!
one possible solution to making relational diagrams in Python is ERAlchemy. As of the time of this posting, I did not see any other pure Python solution.
https://pypi.org/project/ERAlchemy/
update from comment below from G: https://github.com/maurerle/eralchemy2/