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.