I know that Firefox saves the bookmarks and history in the “places.sqlite”.
I know it is an SQLite database and I wanted to know how the tables are related to each other.
After searching the internet I found SchemaSpy.
SchemaSpy is a Java-based command line program for database analysis and visualization.
When done, open a terminal and run:
java -jar schemaspy-6.1.0.jar -t sqlite-xerial -dp sqlite-jdbc-22.214.171.124.jar -db places.sqlite -u root -o output -cat % -s database
That generates a website into
output\index.html and explore the site.
Some screenshots of the result:
A quite interesting article with a broader use of SchemeSpy can be found here.