I would like to extract ERD for certain tables. For example the HR ERD, the relationship is not defined in the .sql database, the only relationship definitions that I found are in the Modules in the doctype folder, and each module is connected in the .json file such as
payroll_employee_detail module fetches the department from
or from something as
I’ve read many articles talking about using tools such as MySQL workbench, but it only draws the tables without any relations between them because they are not defined in the database. How can I draw the ERD? should I use mySQL workbench plus other tools? should I somehow figure it out from the .json files? are there any tools or procedurals to achieve the ERD?