Does ERPNext provide any ERD / data model diagram for database tables?

1

Hi everyone,

I’m working with ERPNext and trying to understand the database data model, especially for the Stock / Inventory module (e.g. Stock Ledger Entry, Item, Warehouse, Bin).

I understand that ERPNext is built on Frappe and mainly uses Link fields instead of database-level foreign keys, so an ERD may not be enforced at SQL level.

However, I would like to ask:

  • Is there any official ERD / data model diagram published by the ERPNext or Frappe team?

  • If not official, has anyone in the community already created or maintained ERD diagrams (especially for Stock / Inventory) that could be shared?

  • Any recommended documentation, repo, or tool to generate a logical ERD from DocTypes would also be very helpful.

My use case is reporting / BI integration (Power BI) and better understanding of how core stock tables are logically related.

Thanks a lot in advance :folded_hands:

2

Hey, you can try Commit (commit.frappe.cloud) - it has an ERD viewer for all Frappe apps and an API Explorer.

3

For BI check out Open Source Business Analytics Tool | Frappe Insights