Next.js compliance dashboard with Drizzle ORM and auto-refresh polling

Building a real-time compliance dashboard that shows worker equipment scan status with stats cards, filterable/sortable table, and auto-refresh polling requires careful data aggregation from scan records against worker and equipment type tables.

Create a compliance API endpoint that joins workers, teams, scans, and equipmentTypes tables, builds a scan map per worker using a Map/Set pattern, then computes compliance status. On the client side, use useCallback + useEffect with setInterval for 30-second polling, extract filter options (teams) from the initial unfiltered API response, and pass structured data to reusable StatsCards and WorkerTable components. The WorkerTable handles sorting via local state without re-fetching.