The latest articles on DEV Community by wael ezzat (@wael_ezzat_hafez). https://dev.to/wael_ezzat_hafez https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4178867%2F0cc9a0c4-1a45-4579-b6a8-c05aa937d20d.jpeg https://dev.to/wael_ezzat_hafez en wael ezzat Mon, 12 Oct 2026 11:34:11 +0000 https://dev.to/wael_ezzat_hafez/i-built-and-100-tested-an-enterprise-sql-server-database-foundation-for-erp-systems-apexledger-57kn https://dev.to/wael_ezzat_hafez/i-built-and-100-tested-an-enterprise-sql-server-database-foundation-for-erp-systems-apexledger-57kn <p>Hi everyone,After seeing many devs rebuild inventory triggers and accounting ledger structures from scratch for every new client project, I decided to build a battle-tested foundation: ApexLedger ERP v1.2.0. What’s inside?21 Tables &amp; 55 Indexes covering Inventory, Sales/Purchases, General Ledger, and RBAC. DML Triggers for real-time stock sync and negative stock protection. Audit Logging tracking INSERT/UPDATE/DELETE operations with user stamps[cite: 6, 11].48/48 Passed Validation Tests across functionality, hardening, and security. You can check the repository and Arabic/English documentation here:🔗 GitHub: <a href="https://github.com/waelezzat/ApexLedger-ERP%F0%9F%94%97" rel="noopener noreferrer">https://github.com/waelezzat/ApexLedger-ERP🔗</a> Gumroad: <a href="https://waelezzat.gumroad.com/l/apexledger-erp-v120%5Bcite:" rel="noopener noreferrer">https://waelezzat.gumroad.com/l/apexledger-erp-v120[cite:</a> 9]Would love to get your thoughts or suggestions on the database architecture!<br> <a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fstb8ydtmuyklwqzf907w.jpg" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fstb8ydtmuyklwqzf907w.jpg" alt=" " width="800" height="534"></a><br> <a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1tik587cbpq7m4bvzqym.jpg" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F1tik587cbpq7m4bvzqym.jpg" alt=" " width="800" height="534"></a><br> <a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fgdwwjqoc9p5ns0l1mcio.jpg" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fgdwwjqoc9p5ns0l1mcio.jpg" alt=" " width="800" height="534"></a></p> sql database architecture showdev wael ezzat Mon, 12 Oct 2026 09:10:04 +0000 https://dev.to/wael_ezzat_hafez/how-i-designed-tested-a-production-ready-sql-server-database-schema-for-erp-systems-1m96 https://dev.to/wael_ezzat_hafez/how-i-designed-tested-a-production-ready-sql-server-database-schema-for-erp-systems-1m96 <p>Hello Devs! 👋When starting a new ERP project, software teams often spend weeks—if not months—designing, normalizing, and debugging the database structure. Handling concurrent stock movements, preventing negative inventory, and maintaining balanced double-entry accounting records can easily become a headache. To solve this repetitive challenge, I engineered ApexLedger ERP v1.2.0—a fully validated SQL Server database foundation designed for modern enterprise software. ⚙️ Core Architecture HighlightsThe schema covers 21 Tables, 8 DML Triggers, and 55 Indexes split into 4 core modules: Inventory &amp; Stock Protection: Real-time stock movement tracking via automated triggers with built-in negative stock prevention. Finance &amp; General Ledger: Hierarchical Chart of Accounts supporting double-entry Journal Entries with strict Debit/Credit validation. Commercial Trading: Full Sales &amp; Purchase Invoices handling with VAT and discount calculations. Security &amp; Auditability: Fine-grained RBAC paired with an Audit Logging engine that captures user operations and old/new states. 🧪 100% Test Validation (48/48 Passed)To ensure reliability before deployment, the foundation went through 48 automated tests: 15 Functional Tests (Sales/Purchases/Stock) 12 Hardening Tests 21 Security &amp; Integrity Tests Concurrency &amp; Clean Installation Validations 📌 Check out the project on GitHub: <a href="https://github.com/waelezzat/ApexLedger-ERP%F0%9F%9B%92" rel="noopener noreferrer">https://github.com/waelezzat/ApexLedger-ERP🛒</a> Commercial License on Gumroad: <a href="https://waelezzat.gumroad.com/l/apexledger-erp-v120%5Bcite:" rel="noopener noreferrer">https://waelezzat.gumroad.com/l/apexledger-erp-v120[cite:</a> 9]I'd love to hear your feedback on the schema design and trigger logic!<br> <a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9gitk0qlj4uabes99gsz.jpg" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9gitk0qlj4uabes99gsz.jpg" alt=" " width="800" height="533"></a></p> architecture backend database sql