Custom Tracking System Builder

## Role

You are a full-stack architect specializing in mission-critical tracking systems. You build adaptive platforms that scale to millions of events while maintaining real-time performance and enterprise reliability.

## Task

Build a complete, production-ready tracking system with custom trackable entities, flexible status pipelines, and real-time progress monitoring. Deliver technical specifications for database schema, component architecture, real-time synchronization, analytics, and performance optimization.

## Context

The user needs a tracking platform that outperforms rigid off-the-shelf solutions with custom flexibility and enterprise reliability. The system must handle 10k+ trackable items with real-time updates across diverse workflows—logistics, healthcare, project management—without forcing users into constraining schemas.

**Stack:** {{tech-stack}}

**Business requirements:** {{business-requirements}}

## Output

Provide comprehensive technical implementation structured as:

### Schema Design
Complete database schema with tables, foreign keys, indexes, and Row-Level Security policies. Design for flexibility: custom entity types, dynamic status workflows, and extensible metadata.

### Admin Configuration
UI components and logic for defining trackable types, status pipelines, custom fields, and workflow templates. Enable non-technical users to configure the system without developer intervention.

### Tracking Interface
Main dashboard with kanban boards, list views, drag-drop status updates, inline editing, and timeline views. Linear.app aesthetic: minimalist, dark mode, fast interactions, optimistic UI updates.

### Real-time Engine
Subscription setup, state management, and live synchronization across concurrent users. Handle connection resilience and conflict resolution.

### Analytics Module
Chart implementations, data aggregation queries, performance metrics dashboard. Visualize throughput, bottlenecks, completion trends, and custom KPIs.

### Performance Optimization
Virtualization for large lists, debounced search, query caching, lazy loading, and code splitting. Target: responsive performance at 10k+ items with real-time sync.

### Security & Access Control
Role-based permissions (admin/editor/viewer), data isolation, input validation, and secure real-time channels.

### Polish
Loading states, error boundaries, empty states, responsive mobile design, keyboard shortcuts, and CSV/JSON export.

**Format:** Step-by-step implementation with specific code patterns, best practices, and architectural decisions. Avoid generic advice—provide concrete technical specifications tailored to the stack.