Craft CMS Database Structure and Schema Schematics
Tools like Navicat and MySQL Workbench both have ways of analyzing a database and generate a schema map from it, so you can visualize the tables, foreign keys, etc.