Stop Treating Frappe Like a Database- It Will Break Your System Later

[asieftejani]

Data Flow Diagram & ER Diagram of ERPNext

I am evaluating ERPNext and, like italjapan and InnovaERP, I need an ERD. No FKs? How do you ensure referential integrity in the database without FKs? Are you relying on code in each module/application to maintain table relationships? In my experience, pushing as much logic as possible into the database through the use of stored procedures, triggers, FK constraints, and views (preferably materialized) will improve integrity, performance, and security. Exploring the ERPNext database, I see 3…

Because Foreign Keys automatically indexes the column in MariaDB and this creates performance issues as the data scales.