Prompt

 

I need a detailed technical specification and architecture plan for an application with two main modules:

1. Uploader
2. Manager/Reviewer.

Functional Overview:

• The uploader module allows users to upload Excel sheets. Each new upload may have a different header structure.
• The system should dynamically read and map the headers during upload.
• The manager/reviewer module allows reviewers to view uploaded records, review them, and comment on each record individually.
• After review, the uploader should see a dashboard displaying the list of records categorized by status: Pending, Removed, and Redirected.
• Each reviewer should only see records assigned to their name.

Technology Stack:

• Backend: ASP.NET Core
• Frontend: Angular
• Database: SQL Server
• Storage: Azure Blob Storage for uploaded files
• Analytics: Linkable to Power BI

Key Requirements:

1. Implement a complete audit trail tracking all record-level changes (who changed what and when).
2. Enable smooth integration with Power BI for reporting and analytics.
3. Efficiently manage dynamic column mapping when headers differ across uploads.
4. Design scalable and secure APIs between Angular frontend and ASP.NET Core backend.
5. Use best practices for Azure Blob integration, including file metadata for version tracking.

Expected Output:

• Proposed database schema supporting dynamic headers and audit tracking.
• API endpoint definitions for uploader and reviewer operations.
• Recommended Angular component structure for dashboards and file review.
• Suggested table relationships and Power BI connection strategy.
• Security and performance considerations for multi-user roles (uploader/reviewer/admin).

Generate this as a system design outline with diagrams, workflow steps, and recommended patterns (like repository pattern or CQRS if applicable).