Complete Entity-Relationship diagram for the InfraTraq Construction ERP — covering all modules from Auth & Access to Analytics & BI. Interactive pan/zoom with module filtering, hover highlighting, and relationship line drawing.
5-Layer commitment model — Budget → PO → Accrual → Invoice → Payment
18 tablesMR → PR → RFQ → PO → GRN → Invoice → Payment
22 tablesSuthradhaari multi-level approval engine with routing & escalation
10 tablesWO → DMB → RA Bill → Retention → Settlement
13 tablesRole-based access control, sessions, MFA, and delegation
10 tablesPeriod-end close workflow with validation checks & GL posting
14 tablesAttendance → Overtime → Payroll → Payslip → GL posting
21 tablesUpload → Review → Transmittal → RFI → Archive
10 tablesEarned Value Management — PV, EV, AC, CPI, SPI tracking
7 tablesChange orders, EOT claims, variations, arbitration
14 tablesProject lifecycle, WBS, activities, milestones, DPR & site diary
14 tablesBOQ creation, rate analysis, version control & WBS mapping
10 tablesStore management, stock ledger, issues, returns & IST
9 tablesRegistration, prequalification, AVL & performance rating
7 tablesGRN processing, quality inspection & 3-way match
6 tablesAllocation, fuel tracking, maintenance & utilization
9 tablesVehicle tracking, trips, GPS, drivers & maintenance
8 tablesClauses, amendments, price escalation & milestones
9 tablesRisk register, 5×5 matrix, mitigation & contingency
6 tablesIncidents, PTW, toolbox talks, PPE & safety audits
11 tablesITP, inspection, NCR, CAPA, snag list & commissioning
11 tablesBank accounts, cash forecast, BG, LC & insurance
9 tablesAP invoices, payment vouchers, TDS & bank reconciliation
7 tablesIPA certification, client billing, receipts & ageing
7 tablesAsset register, depreciation, GST returns & TDS
10 tablesBlocks, rooms, occupancy, meals, medical & hygiene
14 tablesLeads, opportunities, bid decisions, EMD & pipeline
13 tables3D models, clash detection, coordination & quantities
6 tablesBatching plants, PM scheduling, breakdowns & spares
8 tablesCarbon emissions, energy, water, waste & GRI reporting
9 tablesCourses, certifications, competency matrix & skill assessment
7 tablesTopographic, setting out, level surveys & as-built
6 tablesPermits, government approvals, licenses & legal cases
6 tablesBenford analysis, duplicate detection, SOD & whistleblower
7 tablesUOM, materials, cost codes, approval matrix & custom fields
11 tablesDocument store design — 35 collections across 10 categories with TTL policies & indexing
35 collectionsEvent-driven notification rules → channel routing → delivery tracking across RDBMS & MongoDB
5 tables + 3 collections| Module | Table Name | Primary Key | Foreign Keys | Description |
|---|