Construction Data Tracking Dashboard

I need a streamlined tracking and archiving system that lets my construction team capture three critical data streams—employee activity, project status, and equipment usage—and roll them into a single, at-a-glance dashboard. Think of it as our daily command center: supervisors should be able to log in, see real-time updates, and drill down to historical records without shuffling through spreadsheets or paper logs. Core expectations • A structured back-end (SQL, PostgreSQL, or another reliable database you recommend) where those three data categories live in clearly separated tables but can be cross-referenced quickly. • A web-based dashboard—desktop first, mobile responsive—showing live summaries, colour-coded alerts, and simple filters for date range, project site, or crew. • Archiving that keeps every record searchable indefinitely; I never want to lose a history trail when a project closes. • User roles so foremen can update data, managers can approve or edit, and admins control settings. • Delivery, testing, and deployment wrapped up within one month. • archive system for project documents, that stores them a database Tech stack is flexible as long as the final result is lightweight, secure, and easy for us to maintain. If you have existing templates or frameworks that speed up development, great—just outline them in your bid.