Erpnext's mysql tables

I am creating reports for which sql queries requires a lot of database table joins. Since I am not having database description of erpnext, its very difficult to search for tables for a specific requirement.

Is there any database documentation of erpnext?


just append the tab before the DocType name to get the table name

e.g. Doctype : Sales Invoice Table Name: tabSales Invoice

Run bench mysql, it will open sql console. Here you can use mariaDB commands.

I have no problem with basic doctype tables.

There are few things about which I am not aware, like where are the values of select docfield stored in database, where is the field tracking history getting stored (Lead assignment … ) , where are doc-properties like section and column break getting stored etc.