Interactive visualization of 422 PostgreSQL tables + 51 MongoDB collections (473 total) with foreign key relationships for the Unified Enterprise Platform (ProKure + Engineering + Project + Admin + Analytics & AI + Reconciliation + CLM + SLM + Sourcing + Services + Compliance + TReDS + GeM + E-Invoicing + ESG + CRM + Rewards + ReqVise Suthradhaari)
Detailed step-by-step documentation explaining how different business logic flows work with the database schema.
Role-Based Access Control with user-level overrides, ALLOW/DENY resolution logic
9 TablesMulti-level approval matrix, delegation, auto-approval, and escalation logic
8 TablesEvent-driven notifications, email templates, triggers, and user preferences
5 TablesPO-GRN-Invoice matching, tolerance configuration, variance handling, and automatic reconciliation
8 TablesPerformance metrics, weighted scoring, classification, and MSME compliance
8 TablesPR to PO conversion, RFQ workflow, status transitions, and audit trail
12 TablesHybrid PostgreSQL + MongoDB architecture for API request/response logging and analytics
3 Tables + MongoDBGeneric audit trail for all entity changes, user actions, and SOX/GDPR compliance
5 TablesContract lifecycle, amendments, milestones, compliance tracking, and auto-renewal
6 TablesStock levels, batch/serial tracking, GRN processing, movements, and adjustments
11 TablesPR creation, budget validation, approval workflow, item tracking, and conversion to RFQ/PO
10 TablesPO lifecycle, delivery scheduling, revisions, schedule lines, receiving, and completion tracking
18 TablesAmendment types, approval matrix, vendor consent, partial receipt rules, impact assessment, lock periods
5 TablesGoods receipt, quality inspection, checklist results, evidence tracking, rejections, and stock updates
10 TablesRFQ workflow, vendor invitations, bid scoring templates, shortlisting, clarifications, and comparison matrix
27 TablesPayment methods, multi-invoice allocation, credit/debit notes, and voiding
5 TablesBank statements, vendor AP statements, physical inventory counts, and payment clearance tracking
9 TablesBudget master, GL line items, change requests, multi-level approval, commitment tracking, and variance analysis
9 TablesReal-time bidding with SignalR, auto-extension, vendor ranking, and bid validation
5 Tables + SignalRPre-negotiated vendor pricing from awarded RFQs, quick PO creation at agreed rates
2 TablesLINQ-first approach with EF Core, trigger functions, and document number generation
LINQ + TriggersUdyam verification, 45-day payment SLA, interest calculation (3× RBI rate), statutory reporting
6 TablesSelf-registration, compliance document upload, verification workflow, group management
12 TablesManual negotiation rounds, counter-offers, comparison matrix, and final award selection
5 TablesTenant-level module enable/disable, feature flags, field-level configuration, UI customization
8 TablesKPI dashboards, spend analysis, price prediction, vendor recommendation, anomaly detection, NLP query
13 Tables + 6 MongoDBFlutter cross-platform app, offline-first sync, push notifications, biometric auth, mobile approvals
Phase 2 · 3 MongoDBRxJS subscription cleanup, NgRx store optimization, virtual scrolling, Web Workers, Chrome memory limits, SignalR connection management
Angular 21 · NgRx · RxJSRate limiting, circuit breaker, bulkhead isolation, retry with backoff, request queuing for 500+ concurrent users
.NET 10 · Polly · Azure Service BusTable partitioning, index optimization, read replicas, connection pooling, materialized views, data archival for 10M+ records
PostgreSQL 18 · PgBouncer · PITRRedis cluster, cache invalidation patterns, cache-aside, write-through caching, CDN for static assets, session storage
Redis 8.x · Azure CDN · ETagHangfire optimization, message queuing, batch processing, email batching, report generation, webhook retry logic
Hangfire · Azure Service Bus · QueuesFull CLM with versioning, clause library, negotiations, amendments, compliance monitoring, and dispute resolution
8 TablesOnboarding tasks, requalification, PIP milestones, suspensions, reactivation requests, deregistration, risk assessment
9 TablesRFI/RFP workflows, supplier awards, spend analysis, category management, and sourcing optimization
6 TablesInvoice disputes, dispute communications, credit/debit notes, advance payments, retentions, recalls, and self-billing
7 TablesRMA processing, return shipments, vendor chargebacks, scrap management, and reverse supply chain
5 TablesApproval delegation, escalation chains, budget exceptions, emergency POs, and approval withdrawals
5 TablesCatalog items, approval workflows, price change requests, and punchout catalog integration
4 TablesAudit reviews, segregation of duties violations, policy exceptions, and compliance certifications
4 TablesSOW management, service entry sheets, timesheet tracking, and milestone-based payments
4 TablesAnnual plans, demand forecasting, MRP integration, and budget commitment tracking
4 TablesScoring templates, weighted criteria, vendor shortlisting, clarification Q&A, and bid comparison
4 TablesProject phases, milestones, risk register, team assignment, CRM integration, and closure workflow
6 TablesMulti-type tax rates, HSN/SAC ranges, GL account mapping, rate history, reverse charge, and ITC eligibility
3 TablesTReDS invoice financing, GeM marketplace, E-Invoicing IRP for GST compliance
15 Tables + 3 MongoDBScope 3 emissions tracking, supplier ESG scoring, carbon footprint, GHG Protocol
7 Tables + 1 MongoDB| Module | Table Name | Primary Key | Key Foreign Keys | Description |
|---|